If it helps here are the entries in the records table that PowerAdmin has 
inserted

        id      domain_id       name    type    content         ttl     prio    
change_date     disabled        ordername       auth
        12      11      kimboscakes.co.uk       SOA     dns1.palminternet.co.uk 
 2016122108 28800 7200 604...   300     0       1482326379      0       NULL    
1
        13      11      www.kimboscakes.co.uk   A       109.224.219.146         
300     0       1482326619      0       NULL    1
        14      12      derbyshireweddingevents.co.uk   SOA     
dns1.palminternet.co.uk  2016122108 28800 7200 604...   300     0       
1482326464      0       NULL    1
        15      12      www.derbyshireweddingevents.co.uk       A       
109.224.219.146         300     0       1482327120      0       NULL    1
        16      12      derbyshireweddingevents.co.uk   MX      
mail2.palmsecure.biz    300     10      1482326513      0       NULL    1
        17      11      kimboscakes.co.uk       MX      mail2.palmsecure.biz    
300     10      1482326539      0       NULL    1
        18      11      ftp.kimboscakes.co.uk   A       109.224.219.146         
300     0       1482326666      0       NULL    1
        19      11      kimboscakes.co.uk       NS      dns1.palminternet.co.uk 
        300     0       1482337593      0       NULL    1
        20      11      kimboscakes.co.uk       NS      dns2.palminternet.co.uk 
        300     0       1482326723      0       NULL    1
        21      12      ftp.derbyshireweddingevents.co.uk       A       
109.224.219.146         300     0       1482327120      0       NULL    1
        22      12      derbyshireweddingevents.co.uk   NS      
dns1.palminternet.co.uk         300     0       1482327120      0       NULL    
1
        23      12      derbyshireweddingevents.co.uk   NS      
dns2.palminternet.co.uk         300     0       1482327120      0       NULL    
1
        24      12      derbyshireweddingevents.co.uk   TXT     v=spf1 
ip4:109.224.219.158 ip4:109.224.219.157 mx ...   300     0       1482327120     
 0       NULL    1
        25      11      kimboscakes.co.uk       TXT     v=spf1 
ip4:109.224.219.158 ip4:109.224.219.157 mx ...   300     0       1482326880     
 0       NULL    1

-----Original Message-----
From: Pdns-users [mailto:[email protected]] On Behalf Of 
Alejandro Adroher Mellado
Sent: 22 December 2016 13:14
To: [email protected]
Subject: Re: [Pdns-users] PDNS 4 0 0-alpha2 Hit and Miss

Hi all, 

Following this mails ... I can see that on my Auth Server

Ubuntu 14.04 and Pdns Auth 4.0.1-1pdns.trusty

pdnsutil check-zone test.omniaccess.com
Dec 22 08:45:38 Reading random entropy from '/dev/urandom'
Dec 22 08:45:38 gmysql Connection successful. Connected to database 'pdns' on 
'127.0.0.1'.
Dec 22 08:45:38 gmysql Connection successful. Connected to database 'pdns' on 
'127.0.0.1'.
Dec 22 08:45:38 Query: SELECT 
content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE 
disabled=0 and type=? and name=?
Dec 22 08:45:38 Query: SELECT 
content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE 
disabled=0 and type=? and name=?
Dec 22 08:45:38 Query: SELECT 
content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE 
disabled=0 and name=? and domain_id=?
[Error] No delegation for zone 'test.omniaccess.com' in parent 'omniaccess.com'
Dec 22 08:45:38 Query: SELECT 
content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE 
(disabled=0 OR ?) and domain_id=? order by name, type Checked 12 records of 
'test.omniaccess.com', 1 errors, 0 warnings.


What it means  " SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM 
records WHERE disabled=0 and type=? and name=?"

Anything wrong?

Thanks a lot.

Ale


-----Original Message-----
From: Pdns-users [mailto:[email protected]] On Behalf Of 
Aki Tuomi
Sent: lunes, 19 de diciembre de 2016 20:04
To: [email protected]
Subject: Re: [Pdns-users] PDNS 4 0 0-alpha2 Hit and Miss

On 2016-12-19 11:00 AM, Palm Internet wrote:
> Hi Brian
>
> Here is the result
>
> pdnsutil check-zone derbyshireweddingevents.co.uk
> Error: stou
>

This error usually means that your domains table has NULL where number is 
expected, or the number cannot be represented as 2^32 integer, or is negative. 
It might also mean similar issue with SOA record.

Aki

_______________________________________________
Pdns-users mailing list
[email protected]
https://mailman.powerdns.com/mailman/listinfo/pdns-users
_______________________________________________
Pdns-users mailing list
[email protected]
https://mailman.powerdns.com/mailman/listinfo/pdns-users

_______________________________________________
Pdns-users mailing list
[email protected]
https://mailman.powerdns.com/mailman/listinfo/pdns-users

Reply via email to