r6523 - trunk/gnue-appserver

[johannes]

Author: johannes
Date: 2004-10-20 09:09:20 -0500 (Wed, 20 Oct 2004)
New Revision: 6523

Modified:
   trunk/gnue-appserver/INSTALL
Log:
Added some hints about privileges


Modified: trunk/gnue-appserver/INSTALL
===================================================================
--- trunk/gnue-appserver/INSTALL        2004-10-20 13:40:21 UTC (rev 6522)
+++ trunk/gnue-appserver/INSTALL        2004-10-20 14:09:20 UTC (rev 6523)
@@ -105,7 +105,7 @@
 Before you can start gnue-appserver, you have to create a database and populate
 it with the class repository.
 
-For PostgreSQL, Interbase/Firebird or SQLite:
+For PostgreSQL, Interbase/Firebird, MySQL or SQLite:
 * execute the script 'gnue-setupdb'
 
 All other backends:
@@ -117,6 +117,56 @@
   this will create and populate all tables needed for the classrepository
 
 
+NOTE:
+
+If you're using PostgreSQL, Interbase/Firebird or MySQL you have to make sure
+your account has enough privileges to create a new database in order to use
+gnue_setupdb. Please contact your database administrator or consult your
+database documentation for further details.
+
+How to gain privileges (the quick and dirty way)
+
+PostgreSQL:     
+  edit /etc/postgresql/pg_hba.conf and set host, db or user to 'trust'
+  To grant 'trusted' (full) access from the local host add a line like:
+
+    host  all  all  127.0.0.1     255.255.255.255  trust
+
+  To grant 'trusted' (full) acces from the LAN 192.168.32.*
+
+    host  all  all  192.168.32.0  255.255.255.0    trust
+
+
+MySQL:
+  enter the mysql database using the 'mysql' tool and create a privileged
+  account for your user:
+
+    GRANT ALL PRIVILEGES ON *.* TO 'foobar'@'%' IDENTIFIED BY 'fred';
+    GRANT ALL PRIVILEGES ON *.* TO 'foobar'@'localhost' IDENTIFIED BY 'fred';
+
+  (the second grant will be needed for local access). To automate access
+  control add a file "~/.my.cnf" with the following contents:
+
+    [mysqladmin]
+    username = foobar
+    password = fred
+
+    [mysql]
+    username = foobar
+    password = fred
+
+  Please make sure this file has mode 0600 :)
+
+
+Interbase/Firebird:
+
+  In order to create a new database one will need the password of 'SYSDBA'. On
+  creation of a database gnue-schema will prompt for this password
+
+
+
+
+
 Populate the database with sample classes and data
 --------------------------------------------------