Some Plesk API Commands

Plesk API stuff

Enable spam assassin on all accounts on server

mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -Ns -e "SELECT CONCAT_WS('@',mail.mail_name,domains.name)FROM domains,mail,accounts WHERE domains.id=mail.dom_id AND accounts.id=mail.account_id" | xargs -I {} ./spamassassin -u {} -status true -hits 7 -action move

Setup customer/domain, I have setup an excel spreadsheet to automatically generate the red fields.

/usr/local/psa/bin/./customer --create username -name 'name' -passwd 'password' -country US -phone 123456 -email hosting@domain.com
 
/usr/local/psa/bin/./subscription --create domain.com  -owner 'sellyourmotor' -service-plan 'planyouwanttouse' -login username -passwd 'password' -ip ip to put the site on
 

adding forwarding domain

/usr/local/psa/bin/./subscription --create domain.com -owner 'username' -service-plan 'planyouwanttouse' -login username -passwd 'password' -hosting true -ip ip to put the site on -hst_type std -target_url http://www.domaintoforwardto.com

Change all sites to ATmail(horde)

mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -Ns -e "select name from domains" | xargs -I {} /usr/local/psa/bin/./subscription_settings -u {} -webmail atmail


Switch all sites service plan

mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -Ns -e "select name from domains" | xargs -I {} /usr/local/psa/bin/./subscription --switch-subscription {} -service-plan "planyouwanttouse"

Change all sites rotation logs
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -Ns -e "select name from domains" | xargs -I {} /usr/local/psa/bin/./site -u {} -log_bysize 10M -log-max-num-files 2

Change all sites to awstats
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -Ns -e "select name from domains" | xargs -I {} /usr/local/psa/bin/./site -u {} -webstat awstats

add google apps DNS to domain

/usr/local/psa/bin/./dns -a domain.com -mx '' -mailexchanger ASPMX.L.GOOGLE.COM -priority 1
/usr/local/psa/bin/./dns -a domain.com -mx '' -mailexchanger ALT1.ASPMX.L.GOOGLE.COM -priority 5
/usr/local/psa/bin/./dns -a domain.com -mx '' -mailexchanger ALT2.ASPMX.L.GOOGLE.COM -priority 5
/usr/local/psa/bin/./dns -a domain.com -mx '' -mailexchanger ASPMX2.GOOGLEMAIL.COM -priority 10
/usr/local/psa/bin/./dns -a domain.com -mx '' -mailexchanger ASPMX3.GOOGLEMAIL.COM -priority 10
/usr/local/psa/bin/./dns --add domain.com -cname mail -canonical ghs.google.com
/usr/local/psa/bin/./dns --add domain.com -cname docs -canonical ghs.google.com
/usr/local/psa/bin/./dns --add domain.com -cname calendar -canonical ghs.google.com
/usr/local/psa/bin/./dns --add domain.com -cname webmail -canonical ghs.google.com 


Email create/update
/usr/local/psa/bin/./mail --create/update email@address.com.au -passwd abc123 -mailbox true