Hi Ton, This is almost exactly what I do with shell and utilities. My script looks like this:
#!/bin/bash DNSSERVER=xxx.xxx.xxx.xxx DOMAINARRAY=`cat /dist/importlist` for DOMAIN in $DOMAINARRAY; do dig @$DNSSERVER $DOMAIN AXFR > /dist/list/$DOMAIN; zone2sql --zone=/dist/list/$DOMAIN --gmysql --zone-name=$DOMAIN | mysql -D pdns -u root done exit 0 The problem is inherent to zone2sql. Like Bert mentioned AXFR ends its output with one more SOA RR. I hoped that zone2sql takes care about this duplicate but in vain. May I ask you a question, Ton? Why do you append the process ID to the zone file in your script? Just to make it more verbose? Eugene From: Ton van Rosmalen [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 23, 2008 12:39 AM To: Eugene Pefti Cc: pdns-users@mailman.powerdns.com Subject: Re: [Pdns-users] Duplicate SOA while using dig and zone2sql Eugene, I'd suggest some shell-scripting to do the trick Create a file containing the zones the check. One zone per line, in the sample below I've used the name 'zonelist'. Then execute the following script: for zone in `cat zonelist`; do dig @xxx.xxx.xxx.xxx $zone AXFR > /tmp/$zone.$$; zone2sql --gmysql --zone=/tmp/$zone.$$; rm /tmp/$zone.$$; done This dumps all sql-commands to your tty. Redirecting output to a file gives you the possibility to execute the sql-script using mysql. If you want to keep the dig-output just remove the 'rm /tmp/$zone.$$'. Beware, running the script again creates all zone-files again in /tmp! Ton Eugene Pefti schreef: Thanks Ton, I figured it too. How would you suggest to use zone2sql to get rid of the second SOA RR? Eugene -----Original Message----- From: Ton van Rosmalen [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 23, 2008 12:08 AM To: Eugene Pefti Cc: pdns-users@mailman.powerdns.com Subject: Re: [Pdns-users] Duplicate SOA while using dig and zone2sql Hi Eugene, Eugene Pefti schreef: Can anybody tell me why this doesn't work: #dig axfr domain.tld @xxx.xxx.xxx.xxx | zone2sql --gmysql --zone=- | mysql -u root -D pdns I do exactly what is said in pdns documentation, my problem is --zone=- is not understood just because "-" option doesn't work. ---------------------------------------------------------------------------- - died because of STL error: Unable to open file '-': No such file or directory ---------------------------------------------------------------------------- - I've checked the source-code (latest svn-version and the one I use myself) and as far as I can tell no code is available to handle the special case of 'zone=-'. Zone2sql just tries to 'fopen' the filename and throws an error because it can't open '-'. Perhaps STL should handle the special filename but I'm not familiar enough with STL to answer that question. <snip> So it looks like the documentation is ahead of the code in this case. Kind regards, Ton
_______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users