Hotlink Protection in Plesk panel

[nijina]

I know that Plesk provides an option to protect the websites from hotlinking through Plesk panel. But I need to enable this for all domains. I was writing a script to do the same but unfortunately I was not able to complete. To complete the same I need to have a MySQL query or a file which contains the complete list of domains and its associated document root. I know that the below command will provide the list of domains but I need the document root associated with these domains.


mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -Ns -e "select name from domains"


Any help will be highly appreciated.

 

[Sergey L]

If you are on PLesk 11.5, do
# plesk db "select d.name, h.www_root from domains d, hosting h where h.dom_id = d.id;"

 

[nijina]

Wow! that works great. Is there any commands for older versions of Plesk

 

[Sergey L]

for older versions just replace "plesk db" with "mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa -Ns -e" like you did in the first post of the thread
"plesk db" is a convenience alias