[cvs] [Wiki] changed: CentOS5InstallationNotes

[Wiki Guest]

guest [201.6.83.105]  Sat, 03 Nov 2007 20:46:42 -0700

Modified page: http://wiki.horde.org/CentOS5InstallationNotes
New Revision:  1.11
Change log:  Fix about horde user and perms in MySQL

@@ -143,9 +143,9 @@

 * Extract files and rename folder

 <code>
-tar zxf horde-webmail-1.0.3.tar.gz -C /var/www/html/
+tar zxf horde-webmail-*.tar.gz -C /var/www/html/
 mv /var/www/html/horde-*/ /var/www/html/horde/
 </code>


@@ -161,26 +161,47 @@
 If asked, choose /horde.

 Press 1; choose mysql; Persistent connection 0; Username horde; Choose a
password for mysql-user horde; Unix sockets; Locatio null; DB name horde;

-Press 3; specify an existing IMAP user to have horde administration
permissions (i.e. your current linux user)
+Press 2; yes; root; root-mysql-password.

-**Do not execute option 2 (database creation).** It's best to create the
databases by the groupware script, because it sets up db permissions and
horde user (while step 2 doesn't).
+Press 3; specify an existing IMAP user to have horde administration
permissions (i.e. your current linux user).

-* Edit /var/www/html/horde/scripts/sql/groupware.mysql.sql and change the
password to the same you've choosen in previus step 1 at setup.php:
+* Create user horde in MySQL and grant horde DB permissions
+
+PS: Apparently, this should be done by ./setup.php script. So it's better
to check out if the user and permission already exists. If not:
+
+Edit a text file and change the password for the same as in Step 1 above:

 <code>
+USE mysql;
+
+REPLACE INTO user (host, user, password)
+    VALUES (
+        'localhost',
+        'horde',
 -- IMPORTANT: Change this password!
-        PASSWORD('passwordformysql-userhorde')
-</code>
+        PASSWORD('passwordformysquserhorde')
+);

-Save the file and exit.
+REPLACE INTO db (host, db, user, select_priv, insert_priv, update_priv,
+                 delete_priv, create_priv, drop_priv, index_priv)
+    VALUES (
+        'localhost',
+        'horde',
+        'horde',
+        'Y', 'Y', 'Y', 'Y',
+        'Y', 'Y', 'Y'
+);
+
+-- Make sure that priviliges are reloaded.
+FLUSH PRIVILEGES;
+</code>

-Run the script into mysql:
+Save the file as createuser.mysql (or something else) and load it as mysql
stdin:

 <code>
-cd /var/www/html/horde/scripts/sql
-mysql --user=root --password=mysqlrootpassword < groupware.mysql.sql
+mysql --user=root --password=mysqlrootpassword < createuser.mysql
 </code>


 ++ Configure Apache and PHP