Question
How to get a list of domains where mod_perl
or mod_python
modules are enabled?
Answer
-
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  |
+————-+————–+———————-+——–+
-