1. Getting all the domain account information from Plesk
————————————————————————

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -D psa -e “select
login,password,home from sys_users INNER JOIN accounts on
accounts.id=sys_users.account_id;”

2. Get client login details from Plesk.
———————————————–

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -D psa -e “select
login,password from clients INNER JOIN accounts on
accounts.id=clients.account_id;”

3. Getting all mail account login information
——————————————————–

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -D psa -e “SELECT
CONCAT_WS(‘@’,mail.mail_name,domains.name) as email ,accounts.password
FROM domains,mail,accounts WHERE domains.id=mail.dom_id AND
accounts.id=mail.account_id ORDER BY domains.name ASC,mail.mail_name ASC;”

4. Creating/deleting/updating mail accounts using command line
———————————————————————————

create mail account

/usr/local/psa/bin/mail -c USER@DOMAIN.COM -passwd PASSWORD -mailbox
true -cp-access true

update mail account

/usr/local/psa/bin/mail -u USER@DOMAIN.COM -passwd NEWPASS

remove mail account

/usr/local/psa/bin/mail –remove USER@DOMAIN.COM

5. Mailing list management
———————————-

creating mailing list

/usr/local/psa/bin/maillist –create MYLIST -domain DOMAIN.COM
-passwd_type plain -passwd PASS -notify false -email LISTADMIN@DOMAIN.COM

Adding/removing members to the mailing list.

/usr/local/psa/bin/maillist -u MYLIST -domain DOMAIN.COM -members
add:NEW@DOMAIN.COM

/usr/local/psa/bin/maillist -u MYLIST -domain DOMAIN.COM -members
del:NEW@DOMAIN.COM

Getting list members

/usr/local/psa/bin/maillist -i MYLIST -domain DOMAIN.COM

Removing list

/usr/local/psa/bin/maillist -r MYLIST -domain DOMAIN.COM

6. Managing databases.
——————————

create database

/usr/local/psa/bin/database –create DBNAME -domain DOMAIN.COM -server
localhost:3306 -add_user DBUSER -passwd PASS

remove database

/usr/local/psa/bin/database -r DBNAME

Leave a Reply