Topic: MSQL Error on bootup with new version

[Guesty]

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

[Guesty]

Can anyone shed some light on this? Any ideas?



Thanks

[Anonymous]

Installed the latest release of what? Mysql?

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

[Anonymous]

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

[Guesty]

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

[mapangojoe]

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