diff options
| -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; |