Webmail problem after upgrading plesk

[RooMeat]

Hi guys.
I have a issue that I hope you can help me with.
I upgraded to the latest Plesk control panel.
This seemed to correct a issue I was having with webmail.. but not completely.
I can now use atmail and everything seems OK. But if I switch to Horde I get a "Could not connect to DB" error

Now if I take a look in my error logs I see number of lines like the following:

[Sat Feb 20 07:08:57 2010] [warn] Init: SSL server IP/port conflict: atmail.webmail:443 (/etc/httpd/conf.d/zzz_atmail_vhost.conf:48) vs. horde.webmail:443 (/etc/httpd/conf.d/zzz_horde_vhost.conf:41)
[Sat Feb 20 07:08:57 2010] [warn] Init: SSL server IP/port conflict: alchemyautoart.com:443 (/var/www/vhosts/alchemyautoart.com/conf/httpd.include:12) vs. horde.webmail:443 (/etc/httpd/conf.d/zzz_horde_vhost.conf:41)
[Sat Feb 20 07:08:57 2010] [warn] Init: SSL server IP/port conflict: oztowtrucks.com:443 (/var/www/vhosts/oztowtrucks.com/conf/httpd.include:12) vs. horde.webmail:443 (/etc/httpd/conf.d/zzz_horde_vhost.conf:41)
[Sat Feb 20 07:08:57 2010] [warn] Init: SSL server IP/port conflict: akarhandicraft.com.au:443 (/var/www/vhosts/akarhandicraft.com.au/conf/httpd.include:12) vs. horde.webmail:443 (/etc/httpd/conf.d/zzz_horde_vhost.conf:41)


Any help would be appreciated

[BruceLee]

maybe this helps:


I can not login to Webmail receiving error: "A fatal error has occurred DB Error: connect failed"
Article ID: 940
Last Review: Dec,17 2009
Author: Bezborodova Anastasiya
Last updated by: Bezborodova Anastasiya APPLIES TO:

* Plesk 9.x for Linux/Unix
* Plesk 8.x for Linux/Unix

Symptoms

You get the following error during attempting to login into Webmail:

A fatal error has occurred
DB Error: connect failed
Details have been logged for the administrator.

Resolution

Please make sure that the following line exist in /etc/my.cnf:

socket=/var/lib/mysql/mysql.sock

Also check that Mysql service is running and /var/lib/mysql/mysql.sock socket exists.

Make sure that the 'horde' user is able to connect to the 'horde' database with a password from /etc/psa/.webmail.shadow in Parallels Panel 8.x or /etc/psa-webmail/horde/.horde.shadow in Parallels Panel 9.x. You may use the following commands to verify login is possible:

Parallels Panel 8.x:

~# mysql -uhorde -p`cat /etc/psa/.webmail.shadow` -D horde

Parallels Panel 9.x:

~# mysql -uhorde -p`cat /etc/psa-webmail/horde/.horde.shadow` -D horde

If file /etc/psa-webmail/horde/.horde.shadow (or /etc/psa/.webmail.shadow for Panel 8.x) is missing, put some password into this file and change the password for the 'horde' user in the 'mysql' database using the query listed below.

If you get the error, make sure that the only one 'horde' MySQL user exists in the 'user' table in 'mysql' database and try to change it's password with mysql query like:

~# mysql -uadmin -p`cat /etc/psa/.psa.shadow` -D mysql
mysql> update user set password=password("THE_PASSWORD_FROM_WEBMAIL.SHADOW") where user="horde";
mysql> FLUSH PRIVILEGES;

Look into "psa-horde" log (by default: /var/log/psa-horde). If you see something like:

Nov 02 12:55:06 HORDE [emergency] [horde] DB Error: connect failed: [nativecode=Access denied for user: 'root@localhost' (Using password: NO)] ** Array [on line 1329 of "/usr/share/psa-horde/lib/Horde/DataTree/sql.php"]

make sure that sql.safe_mode is disabled in php.ini, it should be like:

sql.safe_mode=Off

Restart Apache after changes in php.ini have been made.


source: http://kb.parallels.com/en/940

@scott or mike: post things like that as "backup" or just link to it?
thanks