[horde] Error running mysql_create.sql

horde at martycombs.com horde at martycombs.com
Thu May 30 22:17:26 PDT 2002


While testing a CVS checkout of horde on a RedHat 7.3 system, I kept
getting the following error while attempting to run the mysql_create.sql
script:

  ERROR 1133 at line 52: Can't find any matching row in the user table

This was the line which attempted to grant privileges to
'horde at localhost'. Adding a "FLUSH PRIVILEGES;" after updating the user
and db tables resolved the problem.  Below is a diff of the change.

Thought you might want to know.

marty :-)

----------------------------------------------------------------------
"They that can give up liberty to obtain a little temporary safety
 deserve neither liberty nor safety."          --Ben Franklin

Marty Combs
traveller, geek, cat freak
----------------------------------------------------------------------


Index: mysql_create.sql
===================================================================
RCS file: /repository/horde/scripts/db/mysql_create.sql,v
retrieving revision 1.4
diff -c -r1.4 mysql_create.sql
*** mysql_create.sql    25 Mar 2002 17:32:45 -0000      1.4
--- mysql_create.sql    31 May 2002 05:12:36 -0000
***************
*** 32,37 ****
--- 32,38 ----
          'Y', 'Y', 'Y', 'Y',
          'Y', 'Y'
      );
+ FLUSH PRIVILEGES;

  # MySQL 3.23.x appears to have "CREATE DATABASE IF NOT EXISTS" and
  # "CREATE TABLE IF NOT EXISTS" which would be a nice way to handle




More information about the horde mailing list