diff options
| author | Boris Kolpackov <boris@codesynthesis.com> | 2013-06-27 12:26:29 +0200 |
|---|---|---|
| committer | Boris Kolpackov <boris@codesynthesis.com> | 2013-06-27 12:26:29 +0200 |
| commit | e78193d6848f9c61b8c8eabffef08c58a3bf64cb (patch) | |
| tree | 2a521c47e1f0d588201be28b0eea22cc51f3818a /db | |
| parent | 08d65d4442d63a6b68c4e86fc97e19feb2be1b02 (diff) | |
Update database setup instructions
Diffstat (limited to 'db')
| -rw-r--r-- | db/mysql/setup | 3 | ||||
| -rw-r--r-- | db/oracle/setup | 2 | ||||
| -rw-r--r-- | db/pgsql/setup | 9 |
3 files changed, 13 insertions, 1 deletions
diff --git a/db/mysql/setup b/db/mysql/setup index 90044b0..3c4fb0a 100644 --- a/db/mysql/setup +++ b/db/mysql/setup @@ -4,6 +4,9 @@ bind-address = 0.0.0.0 You may also need to open the 3306 port in the firewall (system-control-firewall on Fedora). +From root login: + +mysql -p CREATE USER odb_test@'%'; CREATE USER odb_test@'localhost'; diff --git a/db/oracle/setup b/db/oracle/setup index 32af879..b3d9502 100644 --- a/db/oracle/setup +++ b/db/oracle/setup @@ -1,6 +1,8 @@ $ su oracle $ sqlplus / as sysdba +EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE); + alter profile DEFAULT limit password_life_time UNLIMITED; CREATE USER odb_test diff --git a/db/pgsql/setup b/db/pgsql/setup index bb872ac..69beff1 100644 --- a/db/pgsql/setup +++ b/db/pgsql/setup @@ -16,6 +16,13 @@ host odb_test odb_test 192.168.0.0/24 trust create database odb_test; grant all privileges on database odb_test to odb_test; -* If need to add hstore support: +* If need to add hstore support (postgresql-contrib-X.Y package): + + For 8.x: psql odb_test -f /usr/share/postgresql/8.4/contrib/hstore.sql + + For 9.x: + + psql odb_test + CREATE EXTENSION hstore; |