Fixing plesk horde webmail

Sometimes you may see horde webmain in plesk windows showing page not found errors or not working properly during sending email via webmail.  Here is the general fix for all the problems.

"%plesk_bin%\websrvmng.exe" --reconfigure-webmail
"%plesk_bin%\defpackagemng.exe" --fix --type=webmail.horde

Hope this helps.

Setting Mail Attachment limits in Plesk Horde – Windows 2008

This article will show you how to set Mail attachment limits in Horde for windows based plesk server.

1.) RDP into the windows server

2.) Edit the php.ini file located under C:\parallels\Plesk\Additional\PleskPHP5\php.ini and change the following variable value accordingly.

upload_max_filesize = 100M

here we are setting 100MB you can change it according to your needs.

3.) Save and Exit from php.ini file , Restart IIS and thats it.

You need to make sure your horde application is using the correct php.ini configuration file as we have C:\parallels\Plesk\Additional\PleskPHP5\php.ini being used. You can always run phpinfo.php under horde directory ( C:\Inetpub\vhosts\webmail\horde\ and check the configuration file being used. As horde does have its own php configuration file under the above given path.

Plesk HORDE [error] [imp] FAILED LOGIN

We had a small issue with Horde webmail on one of our CentOS Plesk 8.6 server. The problem was we were not able to login into Horde Webmail and were getting login failed error. The logs under /var/log/psa-horde/psa-horde.log showed something like this.

HORDE [error] [imp] FAILED LOGIN xxx.xxx.xxx.xxx to localhost:143[imap/notls] as info@domain.co.uk [on line 258 of "/usr/share/psa-horde/imp/lib/Auth/imp.php"]

Solution.

Make sure you can telnet to port 143 from the server itself. For ex.

[root@server] telnet localhost 143

If you receive connection refused error please Check the /etc/hosts file and make sure that it has localhost entry as shown below.

127.0.0.1 localhost
————————————————————–

If the problem is still not resolved and you still get thos errors then just re-install the IMAP Service on the server. Following are the steps used to re-install IMAP Server:

1) You can find the RPMS used by Plesk in /root/psa/PSA_version directory OR you can download the Tar (Not Autoinstaller) containing RPMS from Parallels website

http://www.parallels.com/en/download/ (need registration it’s free)

2) go to the RPM directory which contains courier Imap RPM’s

#cd [path to the PSA RPM Directory]/dist-rpm-CentOS-4.2-i386/base/

3) Re-install courier-imap-3.0.8-cos4.build81070322.16.i586.rpm and psa-courier-imap-add-8.1.1-cos4.build81070322.16.i586.rpm which will automatically restart the services too

[root@server]# pwd
/root/plesk/dist-rpm-CentOS-4.2-i386/base

[root@server]# rpm -Uvh courier-imap-3.0.8-cos4.build81070322.16.i586.rpm psa-courier-imap-add-8.1.1-cos4.build81070322.16.i586.rpm –force

Preparing… ########################################### [100%]
Reloading configuration: [ OK ]
1:courier-imap ########################################### [ 50%]
Stopping Courier-IMAP server:
Stopping imap [ OK ]
Stopping imap-ssl [ OK ]
Stopping pop3 [ OK ]
Stopping pop3-ssl [ OK ]

Starting Courier-IMAP server:
Starting imapd [ OK ]
Starting imap-ssl [ OK ]
Starting pop3 [ OK ]
Starting pop3-ssl [ OK ]

2:psa-courier-imap-add ########################################### [100%]
Stopping Courier-IMAP server:
Stopping imap [ OK ]
Stopping imap-ssl [ OK ]
Stopping pop3 [ OK ]
Stopping pop3-ssl [ OK ]

Starting Courier-IMAP server:
Starting imapd [ OK ]
Starting imap-ssl [ OK ]
Starting pop3 [ OK ]
Starting pop3-ssl [ OK ]

[root@server]# netstat -nap | grep :143
tcp 0 0 0.0.0.0:143 0.0.0.0:* LISTEN 1657/couriertcpd
[root@server]# telnet localhost 143
Trying 127.0.0.1…
Connected to localhost.
Escape character is ‘^]’.

I hope with the above methods you should be able to resolve the horde login failed error on your plesk server.

Webmail error: A fatal error has occurred DB Error: connect failed

While accessing the Webmail URL sometimes 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.

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 using the command:

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

If /etc/psa/.webmail.shadow 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