[Pdns-users] no content

[Bob Lockie]

On 05/12/04 17:35 Bob Lockie spoke:
> I added one domain to my new PowerDNS installation and I'm getting this 
> error.
> "Not authoritative for...".
> I fixed that, it seems someone else had that so I googled it.
> 
> I have another problem.
> I'm getting a response but no content and the aurority section returns 
> my SOA record...
> 
> This one works (BIND):
> # dig www.lockie.ca @localhost -p 53
> 
> ; <<>> DiG 9.2.3 <<>> www.lockie.ca @localhost -p 53
> ;; global options:  printcmd
> ;; Got answer:
> ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 52821
> ;; flags: qr aa rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 3, ADDITIONAL: 3
> 
> ;; QUESTION SECTION:
> ;www.lockie.ca.                 IN      A
> 
> ;; ANSWER SECTION:
> www.lockie.ca.          86400   IN      A       216.168.107.222
> 
> ;; AUTHORITY SECTION:
> lockie.ca.              86400   IN      NS      ns.lockie.ca.
> lockie.ca.              86400   IN      NS      ns8.zoneedit.com.
> lockie.ca.              86400   IN      NS      ns15.zoneedit.com.
> 
> ;; ADDITIONAL SECTION:
> ns.lockie.ca.           86400   IN      A       216.168.107.222
> ns8.zoneedit.com.       100618  IN      A       216.122.4.151
> ns15.zoneedit.com.      100618  IN      A       69.10.134.195
> 
> ;; Query time: 5 msec
> ;; SERVER: 127.0.0.1#53(localhost)
> ;; WHEN: Wed May 12 17:27:51 2004
> ;; MSG SIZE  rcvd: 161
> 
> 
> This one doesn't (PowerDNS):
> # dig www.lockie.ca @localhost -p 5300
> 
> ; <<>> DiG 9.2.3 <<>> www.lockie.ca @localhost -p 5300
> ;; global options:  printcmd
> ;; Got answer:
> ;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 3578
> ;; flags: qr aa rd; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 0
> 
> ;; QUESTION SECTION:
> ;www.lockie.ca.                 IN      A
> 
> ;; AUTHORITY SECTION:
> .                       3600    IN      SOA     ns.lockie.ca. 
> postmaster.lockie.ca. 2004051101 5400 3540 1209600 86400
> 
> ;; Query time: 39 msec
> ;; SERVER: 127.0.0.1#5300(localhost)
> ;; WHEN: Wed May 12 17:27:58 2004
> ;; MSG SIZE  rcvd: 89
> 
> 
> mysql> select * from records;
> +----+-----------+------+------+----------------------------------------------------------------------+------+------+-------------+ 
> 
> | id | domain_id | name | type | content                               | 
> ttl  | prio | change_date |
> +----+-----------+------+------+----------------------------------------------------------------------+------+------+-------------+ 
> 
> |  1 |         1 |      | A    | 216.168.107.222 
>                               | 3600 |    0 |        NULL |
> |  2 |         1 |      | NS   | ns                               | 3600 
> |    0 |        NULL |
> |  3 |         1 |      | NS   | ns15.zoneedit.com 
>                               | 3600 |    0 |        NULL |
> |  4 |         1 |      | NS   | ns8.zoneedit.com 
>                               | 3600 |    0 |        NULL |
> |  5 |         1 |      | MX   | mx                               | 3600 
> |    1 |        NULL |
> |  6 |         1 | ns   | A    | 216.168.107.222 
>                               | 3600 |    0 |        NULL |
> |  7 |         1 | mx   | A    | 216.168.107.222 
>                               | 3600 |    0 |        NULL |
> |  8 |         1 | www  | A    | 216.168.107.222 
>                               | 3600 |    0 |        NULL |
> |  9 |         1 | mail | A    | 216.168.107.222 
>                               | 3600 |    0 |        NULL |
> | 10 |         1 | sftp | A    | 216.168.107.222 
>                               | 3600 |    0 |        NULL |
> | 11 |         1 | ssh  | A    | 216.168.107.222 
>                               | 3600 |    0 |        NULL |
> | 22 |         1 |      | SOA  | ns.lockie.ca postmaster.lockie.ca 
> 2004051101 5400 3540 1209600 86400 | 3600 |    0 |        NULL |
> +----+-----------+------+------+----------------------------------------------------------------------+------+------+-------------+ 


mysql> select * from domains;
+----+-----------+--------+------------+--------+-----------------+---------+
| id | name      | master | last_check | type   | notified_serial | 
account |
+----+-----------+--------+------------+--------+-----------------+---------+
|  1 | lockie.ca | NULL   |       NULL | MASTER |            NULL | NULL 
    |
+----+-----------+--------+------------+--------+-----------------+---------+
1 row in set (0.00 sec)

Here's the SQL I used, maybe some kind person who uses MySQL could try it.

insert into domains (name,type) values ('lockie.ca','MASTER');
insert into records (domain_id, name,type,content,ttl,prio) values (1, 
'', 'SOA', 'ns.lockie.ca postmaster.lockie.ca 2004051101 5400 3540 
1209600 86400', 3600, 0);
insert into records (domain_id, name,type,content,ttl,prio) values (1, 
'', 'A', '216.168.107.222', 3600, 0);
insert into records (domain_id, name,type,content,ttl,prio) values (1, 
'', 'NS', 'ns', 3600, 0);
insert into records (domain_id, name,type,content,ttl,prio) values (1, 
'', 'NS', 'ns15.zoneedit.com', 3600, 0);
insert into records (domain_id, name,type,content,ttl,prio) values (1, 
'', 'NS', 'ns8.zoneedit.com', 3600, 0);
insert into records (domain_id, name,type,content,ttl,prio) values (1, 
'', 'MX', 'mx', 3600, 1);
insert into records (domain_id, name,type,content,ttl,prio) values (1, 
'ns', 'A', '216.168.107.222', 3600, 0);
insert into records (domain_id, name,type,content,ttl,prio) values (1, 
'mx', 'A', '216.168.107.222', 3600, 0);
insert into records (domain_id, name,type,content,ttl,prio) values (1, 
'www', 'A', '216.168.107.222', 3600, 0);
insert into records (domain_id, name,type,content,ttl,prio) values (1, 
'mail', 'A', '216.168.107.222', 3600, 0);
insert into records (domain_id, name,type,content,ttl,prio) values (1, 
'sftp', 'A', '216.168.107.222', 3600, 0);
insert into records (domain_id, name,type,content,ttl,prio) values (1, 
'ssh', 'A', '216.168.107.222', 3600, 0);