How to get a list of domains with mod_perl or mod_python modules enabled in Plesk

Question

How to get a list of domains where mod_perl or mod_python modules are enabled?

Answer

1. Connect to a Plesk server via SSH/RDP.

2. Run the following SQL queries:

   • To get the list of all domains with perl enabled:

     # plesk db “SELECT d.name as ‘Domain Name’, cl.cname as ‘Contact Name’, cl.pname as ‘Company Name’, cl.email as ‘Email’, h.perl FROM domains d JOIN clients cl on d.cl_id=cl.id LEFT JOIN hosting h on d.id = h.dom_id WHERE h.perl=’true'”

     +————-+————–+———————-+——+
     | Domain name | Contact name | Email                | perl |
     +————-+————–+———————-+——+
     | example.com | John Doe     | [email protected] | true |
     +————-+————–+———————-+——+

   • To get the list of domains with python enabled:

     # plesk db “SELECT d.name as ‘Domain Name’, cl.cname as ‘Contact Name’, cl.pname as ‘Company Name’, cl.email as ‘Email’, h.python FROM domains d JOIN clients cl on d.cl_id=cl.id LEFT JOIN hosting h on d.id = h.dom_id WHERE h.python=’true'”

     +————-+————–+———————-+——–+
     | Domain name | Contact name | Email                | python |
     +————-+————–+———————-+——–+
     | example.com | John Doe     | [email protected] | true   |
     +————-+————–+———————-+——–+