LinuxHostingSupport

You may receive the following error message while accessing Webmail on a Plesk server:

A fatal error has occurred
DB Error: connect failed

You need to make sure the ‘horde’ user is able to connect to the ‘horde’ database using the password mentioned in the file “/etc/psa/.webmail.shadow”. You have to create the file and specify a random password if the file is missing.

To set the password for user ‘horde’ , go to the mysql prompt.

#mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql

On the mysql prompt, execute:

mysql> update user set password=password(password-from-.webmail.shadow) where user=’horde’;

Also make sure sql.safe_mode is set to off in /etc/php.ini file:

sql.safe_mode=Off

Restart Apache server once you save the file.

If the problem persists, use the password from “/etc/psa/webmail/horde/.horde.shadow” file. Go through the following steps:

#cp /etc/psa/webmail/horde/.horde.shadow /etc/psa/.webmail.shadow

#mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql

mysql> update user set password=password(password-from-/etc/psa/webmail/horde/.horde.shadow) where user=’horde’;

You should now be able to access Webmail client.

In order to increase memory limit for Java, perform the following steps, edit the file:

/var/cpanel/tomcat.options

Insert the following 2 lines:

Xmx200M
Xms100M

where, Xmx is the upper limit and Xms is the lower limit. You have to replace the values as per your requirement. Save the file and restart the tomcat service:

root@server [~]#/scripts/restartsrv tomcat

Problem: Not able to list more than 2000 files in a directory using Ftp.

Solution:

The pure-ftp by default limit maximum number of # files to be displayed to 2000.

So edit your pureftpd configuration file which is at /etc/pure-ftpd.conf and change the line

LimitRecursion 2000 8

to

LimitRecursion 5000 8

Save the file and restart the service.

service pure-ftpd restart

It will display 5000 files from a directory now.

Error Message:

Remote host said: 553 sorry, that domain isn’t in my list of allowed rcpthosts

You may see the above error message in the mail logs of Qmail. Follow the below steps:

1. Make sure the domain name is present in the file “/var/qmail/control/rcpthosts”, if it doesn’t, turn off mail for that domain and then turn it back on.

You can turn Off/On mails for a domain from Plesk >> Domains >> domainname.tld  >>  “Web Hosting Settings” >> Enable/Disable button at the top.

2. If it doesn’t, then run,

/usr/local/psa/admin/bin/mchk -a

It will look like it finishes quickly, but it will actually run in the background. It rebuilds direcories, files, permissions on all mail accounts based on the information in the plesk db.

Qmhandle is a 3rd party application to manage mail queue of Qmail. Though Qmail has it’s own commands but it’s worth using Qmhandle.

1) Download the package in a temporary directory:

# cd /usr/local/src

# wget http://sourceforge.net/projects/qmhandle/files/qmhandle-1.3/qmhandle-\
1.3.0/qmhandle-1.3.0.tar.gz/download

2) Unpack it and goto the directory

# tar -zxf qmhandle-1.3.0.tar.gz
# cd qmhandle-1.3.0

You will notice a “qmHandle” file inside the directory using which you can manage the Qmail mail queue.

1. To check the number of emails in the queue

 # ./qmHandle -s

2. Force Qmail to process the mail queue

 # ./qmHandle -a

3. List emails with all the details like, Subject, From and To address

 # ./qmHandle -l

4. List emails sorted by Subject, From address etc

 # ./qmHandle -l | grep Subject | sort
 # ./qmHandle -l | grep From | sort 

5. Delete all emails having a specific subject, for example ‘test’

 # ./qmHandle -Stest

6. Delete all messages

 # ./qmHandle -D

Note: The 1.3 version of Qmhandle have problems deleting emails, in such a case download an older version i.e. qmhandle-1.2.3 to delete the emails.