howto's

1. Log in as root in SSH.
2. Type mysql -uadmin -p`cat /etc/psa/.psa.shadow`, and then press Enter.
3. Type use psa;, and then press Enter.
4. Type select * from sys_users;, and then press Enter.
5. Type select * from accounts where id = 2;, and then press Enter.
A table displays that shows the id, type, and password for accounts where the ID = 2.

SELECT accounts.id, mail.mail_name, accounts.password, domains.name FROM domains LEFT JOIN mail ON domains.id = mail.dom_id LEFT JOIN accounts ON mail.account_id = accounts.id

Qmail queue is growing. How can I speed up process of sending mail?
Article ID: 1414
Last Review: Oct,6 2008
Author:
Last updated by: system
Resolution

Usually Qmail queue is growing due to too many messages in remote queue, because sending mail to remote servers takes
much more time than delivering the message to the local mailbox.

By default Qmail uses up to 20 ‘qmail-remote’ processes to deliver mail to remote servers. This value can be not enough
if the server has heavy mail traffic. In this case you can increase number of simultaneously running ‘qmail-remote’
processes by creating /var/qmail/control/concurrencyremote file with needed value, for example:

# echo 50 > /var/qmail/control/concurrencyremote

Then restart Qmail. See “man qmail-control” for more information. Also, see the articles about SPAM issue 766.
Keywords: big queue stuck mail slow delivery

How do I rebuild qmail queue if it is damaged or consists of a lot of spam messages?
Article ID: 252
Last Review: Mar,5 2009
Author: Vitaly Malakhov
Last updated by: Vitaly Malakhov APPLIES TO:

* Plesk 8.x for Linux/Unix
* Plesk 7.5.x Reloaded

Resolution

This instruction is written for RPM-based systems (RedHat, Fedora, CentOS, etc…).

Please perform the following steps to recreate Qmail`s queue.

Attention!

All current messages will be removed from the queue in this case and cannot be restored.

1. Stop Qmail and xinetd.

/etc/init.d/qmail stop
/etc/init.d/xinetd stop

2. Move current queue to another location.

mv /var/qmail/queue /var/qmail/queue_old

3 Reinstall ‘psa-qmail’ RPM to recreate qmail queue structure with the command like:

rpm -Uvh --force psa-qmail....

4.(Optional).Reinstall drweb-qmail RPM if you use DrWeb antivirus feature which comes with Plesk.

rpm -Uvh --force drweb-qmail....

5.Start Qmail and xinetd:

/etc/init.d/qmail start
/etc/init.d/xinetd start
Note: you should get the both psa-qmail and drweb-qmail RPMs from the same Plesk version distributive which is installed
on the server.
You can obtain current psa-qmail, drweb-qmail RPMs and Plesk build versions by running the following commands on Linux
systems:


rpm -q psa-qmail
rpm -q drweb-qmail
rpm -q psa

The server is saturated with SPAM. There are many messages in the queue. The mail is sent slowly.
Article ID: 766
Last Review: Mar,16 2009
Author: Daria Taranova
Last updated by: Daria Taranova APPLIES TO:

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

Resolution
First check that all domains have the option ‘Mail to non-existing user’ set to ‘reject’ but not to ‘forward’. You can
change this setting to all domains using “Group Operations” in the “Domains” tab in Parallels Plesk Control Panel. The
option “Reject mail to nonexistent user” is available since Parallels Plesk Panel 7.5.3.

Also, please, check that all the IPs and networks in the white lists are reliable and familiar to you.

Check how many messages are in the queue with Qmail:

# /var/qmail/bin/qmail-qstat
messages in queue: 27645
messages in queue but not yet preprocessed: 82

If the queue has too many messages, try to discover the source of SPAM.

If mail is being sent by an authorized user but not from the PHP script, you can run the command below to find the user
that has sent the most messages (available since Plesk 8.x). Note that you must have the ‘SMTP authorization’ activated
on the server to see these records:

# cat /usr/local/psa/var/log/maillog |grep -I smtp_auth |grep -I user |awk '{print $11}' |sort |uniq -c |sort -n

The path to ‘maillog’ may differ depending on the OS you are using.

The next step is to use is “qmail-qread”, which can be used to read the message headers:

# /var/qmail/bin/qmail-qread
18 Jul 2005 15:03:07 GMT #2996948 9073 bouncing
done remote user1@domain1.com
done remote user2@domain2.com
done remote user3@domain3.com
....

This shows the senders and recipients of messages. If the message contains too many recipients, probably this is spam.
Now try to find this message in the queue by its ID ( # 2996948 in our example):

# find /var/qmail/queue/mess/ -name 2996948

Examine the message and find the line “Received” to find out from where it was sent for the first time, for example, if
you find:

Received: (qmail 19514 invoked by uid 10003); 13 Sep 2005 17:48:22 +0700

it means that this message was sent via a CGI by user with UID 10003. Using this UID it is possible to find the domain:

# grep 10003 /etc/passwd

If the ‘Received’ line contains a UID of a user ‘apache’ (for example invoked by uid 48) – it means that spam was sent
through a PHP script. In this case, you can try to find the spammer using information from spam email (address from/to
or any other information). It is usually very difficult to discover the source of SPAM. If you are absolutely sure that
this time there is a script which sends SPAM (tail grows rapidly for no apparent reason), you can use the following
script to know what PHP scripts are running at this time:

# lsof +r 1 -p `ps axww | grep httpd | grep -v grep | awk ' { if(!str) { str=$1 } else { str=str","$1}}END{print str}'`
| grep vhosts | grep php

You can also apply KB article which describes the procedure of discovering which domains are sending mail through PHP
scripts.

Lines in Received section like

Received: (qmail 19622 invoked from network); 13 Sep 2005 17:52:36 +0700
Received: from external_domain.com (192.168.0.1)

mean that the message has been accepted and delivered via SMTP, and that the sender is an authorized mail user.