<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Query should be: <tt>SELECT name FROM
domains WHERE type = 'MASTER'</tt><br>
<br>
On 08/14/2013 01:09 PM, Tom van Leeuwen wrote:<br>
</div>
<blockquote cite="mid:520B6563.1040409@saasplaza.com" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<div class="moz-cite-prefix">On your MASTER:<tt><br>
</tt>
<blockquote><tt>#!/bin/bash</tt><br>
<br>
<tt>PASS='secret'</tt><br>
<tt>USER='pdns'</tt><br>
<tt>DB='pdns'</tt><br>
<br>
<tt>DOMAINS=$(echo "SELECT name FROM domains p WHERE type =
'MASTER'" | mysql -N -u$USER -p$PASS $DB)</tt><br>
<br>
<tt>for DOMAIN in $DOMAINS; do</tt><br>
<tt> echo "Sending notifies for: $DOMAIN"</tt><br>
<tt> pdns_control notify $DOMAIN</tt><br>
<tt>done</tt><br>
</blockquote>
<br>
Regards,<br>
Tom<br>
<br>
On 08/14/2013 12:58 PM, ymicromed wrote:<br>
</div>
<blockquote cite="mid:1376477935986-10223.post@n7.nabble.com"
type="cite">
<pre wrap="">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: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://powerdns.13854.n7.nabble.com/Manual-AXFR-command-tp10121p10223.html">http://powerdns.13854.n7.nabble.com/Manual-AXFR-command-tp10121p10223.html</a>
Sent from the PowerDNS mailing list archive at Nabble.com.
_______________________________________________
Pdns-users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Pdns-users@mailman.powerdns.com">Pdns-users@mailman.powerdns.com</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.powerdns.com/mailman/listinfo/pdns-users">http://mailman.powerdns.com/mailman/listinfo/pdns-users</a>
</pre>
</blockquote>
<br>
</blockquote>
<br>
</body>
</html>