#2 import function problems

[Aendu Fuchs]

i have big trouples importing my existing zone files:

first i had to delete all comets and the option stuff
from named.conf

now it fails on the SOA record of my zone files which
are all looking like this:

$TTL 2D
@ IN SOA ns1.tcnet.ch info.tcnet.ch (
2001010102 ;
serial YYYYMMDD## INCREMENT AFTER CHANGE
1D ;
refresh
2H ; retry
1W ;
expiry
2D ) ;
minimum

@ IN NS ns1.tcnet.ch.
@ IN NS ns2.tcnet.ch.

@ IN MX 10 mail.tcnet.ch.

www IN CNAME tschuggen.tcnet.ch.

so i think also here it's a problem with the comments.

any help ?

[Paul Zirnik]

Logged In: YES
user_id=240880

hi, the import-function is not very good :( this is only a
dirty fast hack IMHO

better way is to dump configuration (kill -SIGINT named) of
your
running named and convert this (normed output)

i want to implement this .... if i only have enouth time
...mybee next holiday ?

[Nobody/Anonymous]

Logged In: NO

In my case, the import script fails updating the SOA record
of the first zone saying:

--
'UPDATE zones SET serial = (, refresh = 1002089635, retry =
28800, expire = 7200, zonefile = '/var/named/x.ch.db',
updated = 1 WHERE id = 7' failed with this SQL error:<P>
You have an error in your SQL syntax near ' refresh =
1002089635, retry = 28800, expire = 7200, zonefile
= '/var/named/acid' at line 1<P>
--

I didn't get, how this "dump configuration"-solution was
meant. Tami, could you explain this in detail?

thank you,
Markus