Skip to content

Instantly share code, notes, and snippets.

@agarzon
Created October 6, 2014 21:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save agarzon/37b6eac3f31a5017ffb2 to your computer and use it in GitHub Desktop.
Save agarzon/37b6eac3f31a5017ffb2 to your computer and use it in GitHub Desktop.
Plesk, DNS Bulk Apply Settings
#!/bin/sh
ADMIN_PASS=`cat /etc/psa/.psa.shadow`
MYSQL_BIN_D=`grep MYSQL_BIN_D /etc/psa/psa.conf | awk '{print $2}'`
PRODUCT_ROOT_D=`grep PRODUCT_ROOT_D /etc/psa/psa.conf | awk '{print $2}'`
mysql="${MYSQL_BIN_D}/mysql -N -uadmin -p${ADMIN_PASS} psa"
query="select name from domains;"
domains=`echo $query | $mysql `
for i in ${domains}; do
${PRODUCT_ROOT_D}/bin/dns --off $i
${PRODUCT_ROOT_D}/bin/dns --on $i
done
@h9k
Copy link

h9k commented Sep 5, 2016

SELECT name FROM dns_zone WHERE id > 1 AND status = 0

Might be a more reliable query, as you don't want to re-enable DNS for domains for which it was disabled already.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment