[Pdns-users] PDNS 4 0 0-alpha2 Hit and Miss

[Palm Internet]

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:pdns-users-bounces at mailman.powerdns.com] On Behalf Of Alejandro Adroher Mellado
Sent: 22 December 2016 13:14
To: pdns-users at mailman.powerdns.com
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:pdns-users-bounces at mailman.powerdns.com] On Behalf Of Aki Tuomi
Sent: lunes, 19 de diciembre de 2016 20:04
To: pdns-users at mailman.powerdns.com
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
Pdns-users at mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users
_______________________________________________
Pdns-users mailing list
Pdns-users at mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users