How to retrieve the email account password ?

How to retrieve the email account password (Plesk + Qmail) ?

We can reset the password of the accounts from Plesk panel easily as follows.

Plesk Control Panel >> Domains >> Select the domain >> Mail Accounts >> Click on the account >> Change the password >> Save

You can retrieve the current password of an email account in plesk, from the psa database as follows.

1. Login to mysql
mysql -u admin -p`cat /etc/psa/.psa.shadow`

2. select the psa database
use psa;

3. list the accounts (Its a one line command do not split)

SELECT mail.mail_name, accounts.password, domains.name FROM mail, accounts,
domains WHERE domains.id=mail.dom_id AND mail.account_id=accounts.id;

#2002 – The server is not responding (or local MySQL server’s socket is not correctly configured).

Issue : -

While accessing PhpMyAdmin getting the following error.

ERROR
#2002 – The server is not responding (or local MySQL server’s socket is not correctly configured).

Reason :-

The  mysql socket file is missing from the /tmp directory

Fix :-

1. Create a symbolic link from the original mysql socket file to /tmp

[root@test ~]# ln -s /var/lib/mysql/mysql.sock /tmp

OR

2. Restart MySQL service from WHM

WHM Login >> Main >> Restart Services >>SQL Server (MySQL)

OR

3.  Edit the PhpMyAdmin configuration file to use the original MySQL socket file.

vi /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php

Make sure, the correct mysql socket file is mentioned there.
~~~~~~~~~~~~~~~~
$cfg['Servers'][$i]['socket'] = ‘/var/lib/mysql/mysql.sock’;
$cfg['Servers'][$i]['connect_type'] = ’socket’;
~~~~~~~~~~~~~~~~