Changeset 10312

Timestamp:

2005-07-26T12:03:45+12:00 (19 years ago)

Author:

kjdon

Message:

added notes for external mysql

File:

• trunk/gsdl3/README.txt (modified) (1 diff)

trunk/gsdl3/README.txt

@@ -238 +238 @@
 ------------------------------
 
+Set the mysql.installed.path property in build.xml to be non-empty (its not actually used) before installation.
+
 You will need to add the two greenstone users: gsdl3reader and gsdl3admin. The reader user is only used for accessing the database, the admin user can be used for modification.
 
+Run mysql as the root user.
+
 Commands to add the two users:
-GRANT SELECT,INSERT,DELETE,UPDATE,DROP,CREATE ON *.* TO gsdl3admin@localhost;
-GRANT SELECT ON *.* TO gsdl3reader@localhost;
-
+GRANT SELECT,INSERT,DELETE,UPDATE,DROP,CREATE ON *.* TO gsdl3admin@localhost identified by 'admin-password';
+GRANT SELECT ON *.* TO gsdl3reader@localhost identified by 'reader-password';
+
+You will need to edit the gsdl3/web/WEB-INF/classes/global.properties file and set the two passwords that you used in here:
+mysql.admin.pword and mysql.reader.pword
+
+You should also load up the database for the gs3mgdemo collection:
+create database localsite_gs3mgdemo;
+
+Close mysql, then run
+mysql localsite_gs3mgdemo < <path-to-gsdl3>/sites/localsite/collect/gs3mgdemo/mysqldatadump.sql
+You may need to run this using '--user=root -p'
 
 Notes for Mac OS