[Pdns-users] bind 9 zone to gmysql conversion problems

[Imre Gergely]

i have a test zone like this:

$TTL 7200
$ORIGIN 1.1.in-addr.arpa.
1               IN      SOA     ns1.hr.astral.ro. hostmaster.hr.astral.ro. (
                2006011201 3600 900 1209600 86400 )
                IN      NS      ns1.hr.astral.ro.
                IN      NS      ns2.hr.astral.ro.

$TTL 7200
$ORIGIN 1.1.1.in-addr.arpa.
18              IN      PTR     jucus.nextra.ro.
                IN      TXT     "X-IPsec-Server(10)=1.1.1.1 foo foo"


if i try to convert it with zone2sql:
[root at imi etc]# zone2sql --gmysql --zone=test.rev --verbose=no --slave=yes
--on-error-resume-next=no
Second SOA in zone, raised domain_id
insert into domains (name,type) values ('1.1.1.in-addr.arpa','NATIVE');
Parsed 4 records
insert into records (domain_id, name,type,content,ttl,prio) select id
,'1.1.1.in-addr.arpa', 'SOA', 'ns1.hr.astral.ro hostmaster.hr.astral.ro
2006011201 3600 900 1209600 86400', 7200, 0 from domains where
name='1.1.1.in-addr.arpa';
insert into records (domain_id, name,type,content,ttl,prio) select id
,'1.1.1.in-addr.arpa', 'NS', 'ns1.hr.astral.ro', 7200, 0 from domains where
name='1.1.1.in-addr.arpa';
insert into records (domain_id, name,type,content,ttl,prio) select id
,'1.1.1.in-addr.arpa', 'NS', 'ns2.hr.astral.ro', 7200, 0 from domains where
name='1.1.1.in-addr.arpa';
insert into records (domain_id, name,type,content,ttl,prio) select id
,'18.1.1.1.in-addr.arpa', 'PTR', 'jucus.nextra.ro', 7200, 0 from domains where
name='1.1.1.in-addr.arpa';


the TXT record doesn't even appear in the output. if i remove the curly
brackets, "(" and ")", the line is now:


                IN      TXT     "X-IPsec-Server10=1.1.1.1 foo foo"

it gets converted correctly, into this:

[root at imi etc]# zone2sql --gmysql --zone=test.rev --verbose=no --slave=yes
--on-error-resume-next=no
Second SOA in zone, raised domain_id
insert into domains (name,type) values ('1.1.1.in-addr.arpa','NATIVE');
Parsed 5 records
insert into records (domain_id, name,type,content,ttl,prio) select id
,'1.1.1.in-addr.arpa', 'SOA', 'ns1.hr.astral.ro hostmaster.hr.astral.ro
2006011201 3600 900 1209600 86400', 7200, 0 from domains where
name='1.1.1.in-addr.arpa';
insert into records (domain_id, name,type,content,ttl,prio) select id
,'1.1.1.in-addr.arpa', 'NS', 'ns1.hr.astral.ro', 7200, 0 from domains where
name='1.1.1.in-addr.arpa';
insert into records (domain_id, name,type,content,ttl,prio) select id
,'1.1.1.in-addr.arpa', 'NS', 'ns2.hr.astral.ro', 7200, 0 from domains where
name='1.1.1.in-addr.arpa';
insert into records (domain_id, name,type,content,ttl,prio) select id
,'18.1.1.1.in-addr.arpa', 'PTR', 'jucus.nextra.ro', 7200, 0 from domains where
name='1.1.1.in-addr.arpa';
insert into records (domain_id, name,type,content,ttl,prio) select id
,'18.1.1.1.in-addr.arpa', 'TXT', 'X-IPsec-Server10=1.1.1.1 foo foo', 7200, 0
from domains where name='1.1.1.in-addr.arpa';

see the last mysql statement. it looks like the curly brackets in the TXT
record mess up somehow the conversion.
any help appreciated.

thanks


-- 
Imre Gergely
SysAdmin NOCS-CJ
Astral Telecom S.A.
Plugarilor 28, Cluj-Napoca
http://www.astral.ro