Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Guesty on April 09, 2004, 03:24:26 AM

Title: MSQL Error on bootup with new version
Post by: Guesty on April 09, 2004, 03:24:26 AM

Hey guys I installed the latest release and now I get a Mysql error at bootup which also prevents me from loggin into webmail :


mysql: ERROR
Apr  8 17:12:05 matrix mysql:  1064 at line 4: You have an error in your SQL syntax near ''hI\jAKTV\')
Apr  8 17:12:05 matrix mysql:     );
Apr  8 17:12:05 matrix mysql:
Apr  8 17:12:05 matrix mysql: FLUSH PRIVILEGES' at line 5
Apr  8 17:12:05 matrix mysql.init: Loading 21horde.mysql_set_password.sql into mysql failed
Apr  8 17:12:06 matrix 50turba_upgrade_1.1_to_1.2: DBI->connect(horde) failed: Access denied for user: 'horde@localhost' (Using password: YES) at /etc/e-smith/sql/init/50turba_upgrade_1.1_to_1.2 line 43
Apr  8 17:12:06 matrix mysql.init: Loading 50turba_upgrade_1.1_to_1.2 into mysql failed

Title: MSQL Error on bootup with new version
Post by: Guesty on April 09, 2004, 03:25:52 PM

Can anyone shed some light on this? Any ideas?



Thanks

Title: MSQL Error on bootup with new version
Post by: Anonymous on April 09, 2004, 11:02:42 PM

Installed the latest release of what? Mysql?

Quote

Hey guys I installed the latest release and now I get a Mysql error at bootup which also prevents me from loggin into webmail :

Title: MSQL Error on bootup with new version
Post by: Anonymous on April 10, 2004, 02:01:45 AM

What SME verion are you using?

Try the following;

]#/sbin/e-smith/expand-template /home/httpd/html/horde/scripts/db/mysql_set_password.sql

]# mysql < /home/httpd/html/horde/scripts/db/mysql_set_password.sql

]# mysqladmin reload

]#/sbin/e-smith/expand-template /home/httpd/html/horde/config/horde.php

Title: MSQL Error on bootup with new version
Post by: Guesty on April 10, 2004, 05:28:53 PM

This is what fixed it:

/sbin/e-smith/config setprop horde DbPassword <password> dont include the <  >

then type:

/sbin/e-smith/signal-event post-upgrade
wait a few minutes while it's working then type:
 
/sbin/e-smith/signal-event reboot

Worked perfect for me as described by Michael Soulier at post http://forums.contribs.org/index.php?topic=20210.0

Title: This fix worked for my new fresh install!
Post by: mapangojoe on July 30, 2004, 12:01:08 AM

I also did a fresh install of SME 6.0 and had this error come up.  Guesty's (see below) post is what saved me.  

Another SME problem solved by CONTRIBS.ORG.  Thanks again Guesty!

Chris Curtis



 Posted: 10 Apr 2004 07:28    Post subject:    

--------------------------------------------------------------------------------
 
This is what fixed it:

/sbin/e-smith/config setprop horde DbPassword <password> dont include the < >

then type:

/sbin/e-smith/signal-event post-upgrade
wait a few minutes while it's working then type:

/sbin/e-smith/signal-event reboot

Worked perfect for me as described by Michael Soulier at post http://forums.contribs.org/index.php?topic=20210.0