summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/mysql/setup3
-rw-r--r--db/oracle/setup2
-rw-r--r--db/pgsql/setup9
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;