r5 - 28 Aug 2008 - 18:19:08 - HadrianZbarceaYou are here: OSAF >  Documentation Web  >  CosmoAdministrator > CosmoTomcat > CosmoDatabaseSetup

PostgreSQL

PostgreSQL is a on open source SQL database under a BSD licence. It is available on all platforms. You may create a database by the name of 'cosmo', owned by a user called 'cosmo' with password 'cosmo' by typing the following as the admin user in a psql shell

create user cosmo with password 'cosmo';
create database cosmo with owner cosmo encoding='utf8'; 

MySQL

MySQL is an open source SQL database under a GPL licence. It is available on all platforms. You may create a database by the name of 'cosmo', owned by a user called 'cosmo' with password 'cosmo' by typing the following as the admin user in a mysql shell

Login to mysql and create a database and user using the commands below:

$ mysql -u root -p
Enter password: [password not shown] 
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is xx
Server version: 5.0.51a-xxxxxx
mysql> grant all privileges on cosmo.* to 'cosmo' identified by 'cosmo';
Query OK, 0 rows affected (0.00 sec)
mysql> create database cosmo character set utf8;
Query OK, 1 row affected (0.00 sec)
mysql> quit
$

Derby

By default, Cosmo uses an embedded Derby database, which is configured in cosmo.properties. The location of the db is the JDBC connection URL, and will be automatically created for you.

Edit | WYSIWYG | Attach | Printable | Raw View | Backlinks: Web, All Webs | History: r5 < r4 < r3 < r2 < r1 | More topic actions
 
Open Source Applications Foundation
Except where otherwise noted, this site and its content are licensed by OSAF under an Creative Commons License, Attribution Only 3.0.
See list of page contributors for attributions.