SELECT password FROM accounts,mail WHERE
mail.mail_name LIKE '%username%' AND accounts.id = mail.account_id

To enable passive mode for FTP connections on your server:
1 Log in as “root” to the server shell over SSH.
2 Edit your ProFTPD configuration file.
a Issue the command vi /etc/proftpd.conf
b Add the following lines anywhere within the <Global> section:
PassivePorts 49152 65534
c Save the file
3 Log in to Parallels Plesk Panel as “admin”, go to Modules > Firewall, and
click Edit Firewall Configuration.
4 Click Add Custom Rule.
5 Specify the following:
a Rule name
b Direction: select Incoming.
c Action: select Allow.
d Ports: in the Add port input box, enter the value 49152-65534. Leave the TCP
option selected, and click Add.

PassivePorts 60000 65535

Mail logs for Plesk are located in /usr/local/psa/var/log/maillog and associated archives

Often Media Temple customers find themselves unable to send mail using the default http://kb.parallels.com/en/3477

For information on how to do this manually please visit http://kb.parallels.com/en/5568

1. Login to SSHSecure Shell or ssh is a network protocol that allows data to be exchanged over a secure channel between two computers.’); return false;” href=”javascript:void(0)”>SSH) for (dv) Dedicated-Virtual 2.0/3.0/3.5 Servers:

    

   STOP:

   This provides a way to get your SMTP server to listen on port 25 and an additional port at the same time. This workaround has been tested with Plesk versions 7.5.2 and 7.5.3. Customers should proceed with caution as this workaround is UNSUPPORTED by Media Temple and Plesk. There is a high probability that this will cease to work or even break your server if you attempt to update Plesk after applying the workaround. You will need AccountCenter.

   You can find additional documentation at http://www.gobdg.com/blog/2009/06/how-to-add-an-additional-outgoing-mail-smtp-port-mediatemple-on-plesk/

   1. Make a copy of /etc/xinetd.d/smtp_psa. For this walkthrough the new filename created is smtp_nonstandard. A command like this should work: �  

      cp /etc/xinetd.d/smtp_psa /etc/xinetd.d/smtp_nonstandard

   2. Add these lines to the copy you just made:

      vi /etc/xinetd.d/smtp_nonstandard type = UNLISTED port = 2525

   3. and change the service name to match the name of the file. A sample smtp_nonstandard looks like this:

      service = smtp_nonstandard type = UNLISTED socket_type = stream protocol = tcp port = 2525 wait = no disable = no user = root instances = UNLIMITED server = /var/qmail/bin/tcp-env server_args = -Rt0 /var/qmail/bin/relaylock /var/qmail/bin/qmail-smtpd /var/qmail/bin/smtp_auth /var/qmail/bin/true /var/qmail/bin/cmd5checkpw /var/qmail/bin/true

   4. Restart xinetd:

      /etc/init.d/xinetd restart

   5. You should now be able to send mail through your server on port 2525. You may pick a different port if you use this method. We suggest choosing a high port number to avoid using commonly used ports on the internet.