Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: skovsgaard on October 23, 2007, 07:13:08 PM

Title: [horde] DB Error: connect failed:
Post by: skovsgaard on October 23, 2007, 07:13:08 PM

Last week I prepaired a new system, installing all needed contribs. Using all the time needed testing all apps working as expected. During the weekend I did a full systembackup to a USB disc (approx 8 hours = 34 GB), and restored this backup to the prepaired system (approx 10 hours), using this trick:

Code: [Select]

config set PasswordSet noand

Code: [Select]

signal-event postupgrade; signal-event reboot
This might not be by the book, but actually the system is running and I only found webmail not functioning. Since only 3 users (including myself) are using this utility, it isn't critical.

The logfile

Code: [Select]

Oct 23 17:08:46 newsystem HORDE[10342]: [horde] DB Error: connect failed:  [nativecode=Access denied for user 'horde'@'localhost' (using password: YES)] ** Array [on line 1627 of "/home/httpd/html/horde/lib/Horde/DataTree/sql.php"]
I guess the system password for the Horde database isn't the same since this restore. If I'm right in this suspicion, I guess I have to syncronise the system password? I found this hint:

Quoting Dan Brown:

Quote

Resetting the root password
Suppose you've already changed the root password, not realizing why it's such a bad idea.  Here's how to set it back to where it belongs:

[root@e-smith /root] # /etc/rc.d/init.d/mysqld stop
[root@e-smith /root] # /etc/e-smith/events/actions/conf-mysql-password
[root@e-smith /root] # /etc/rc.d/init.d/mysqld start

Any advice on this would be nice, my new system went online yesterday, and I definately don't want to break anything at this moment :-)

Title: Re: [horde] DB Error: connect failed:
Post by: mrjhb3 on October 24, 2007, 04:59:38 AM

Try a

Code: [Select]

signal-event post-upgrade ; signal-event reboot again.  The password should get synced up as this script - /etc/e-smith/templates/etc/e-smith/sql/init/21horde.mysql_set_password  is ran on the reboot.  If after the reboot it isn't in sync then

Code: [Select]

config show horde the DbPassword entry should match what is in  /home/httpd/html/horde/config/conf.php.

John

Title: Re: [horde] DB Error: connect failed:
Post by: byte on October 24, 2007, 12:40:05 PM

Quote from: skovsgaard on October 23, 2007, 07:13:08 PM

Any advice on this would be nice, my new system went online yesterday, and I definately don't want to break anything at this moment :-)

Please report bugs and potential bugs in the bug tracker. Thanks.

Title: Re: [horde] DB Error: connect failed:
Post by: skovsgaard on October 24, 2007, 07:46:05 PM

Thank you very much, John

Your advice did the trick - perfect  ;-)

Quote from: mrjhb3 on October 24, 2007, 04:59:38 AM

Try a

Code: [Select]

signal-event post-upgrade ; signal-event reboot
again.  The password should get synced up as this script - /etc/e-smith/templates/etc/e-smith/sql/init/21horde.mysql_set_password  is ran on the reboot.

Byte: I'll report this as a bug. Knowing I was on thin ice migrating this way, I did not evaluate this minor thing as a bug  :cool: