Query should be: SELECT name FROM domains WHERE type = 'MASTER'

On 08/14/2013 01:09 PM, Tom van Leeuwen wrote:
On your MASTER:

    #!/bin/bash

    PASS='secret'
    USER='pdns'
    DB='pdns'

    DOMAINS=$(echo "SELECT name FROM domains p WHERE type = 'MASTER'"
    | mysql -N -u$USER -p$PASS $DB)

    for DOMAIN in $DOMAINS; do
      echo "Sending notifies for: $DOMAIN"
      pdns_control notify $DOMAIN
    done


Regards,
Tom

On 08/14/2013 12:58 PM, ymicromed wrote:
Hi,

Is it possible to notify the slaves for all existing domains?
or to retrieve all domain from the master?

Thank you in advance.



--
View this message in 
context:http://powerdns.13854.n7.nabble.com/Manual-AXFR-command-tp10121p10223.html
Sent from the PowerDNS mailing list archive at Nabble.com.

_______________________________________________
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users


_______________________________________________
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users

Reply via email to