Re: [Pdns-users] Duplicate SOA while using dig and zone2sql

Ton van Rosmalen Wed, 23 Apr 2008 00:38:53 -0700

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: [email protected]
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
[email protected]
http://mailman.powerdns.com/mailman/listinfo/pdns-users

Re: [Pdns-users] Duplicate SOA while using dig and zone2sql

Reply via email to