[Pdns-users] Postgresql errors
powerdns at safepoint.nl
powerdns at safepoint.nl
Thu Feb 12 17:06:25 UTC 2004
Hi,
I've just installed PowerDNS on SUSE 9.0 with a postgresql backend.
Powerdns is configured as a slave server with supermasters.
Everything seems to be working fine (it takes up zones where it gets notifies
for and not know yet to pdns), except for 2 things;
1. I see disturbing error messages in my postgresql logfile when powerdns is
started and stopped.
2. It seems the last_notified field in the domain table is not used and also
zones with changes for which notifies are sent are not being updated until
the next 'slave-cycle-interval' is passed.
For problem 2 I'am not sure this an error, but I would expect pdns to act on
the notify for zones it already has.
For problem 1 my only gues is that the RPM is compiled with postgresql 7.4
client code. I recall that the postgresql 7.4 has a new client protocol.
Problem 2 not a showstopper for putting pdns in production, but I would like
to know what the cause for problem 1.
Can somebody give me some advise on how to solve this?
TIA
Patrick Hoogendijk
My setup:
master: bind 9.2.2 (on Redhat Linux ES 2.1) dns1.safepoint.nl
slave: pdns 2.1.19 (on SUSE 9.0) installed with static RPM.
dns2.safepoint.nl
Postgresql 7.3.4 (the version that comes with SUSE 9.0)
LOGFILE: postgresql
# these messages come up after starting pdns
FATAL: unsupported frontend protocol
FATAL: unsupported frontend protocol
FATAL: unsupported frontend protocol
FATAL: unsupported frontend protocol
FATAL: unsupported frontend protocol
# these messages come up after stopping pdns
LOG: pq_recvbuf: unexpected EOF on client connection
LOG: pq_recvbuf: unexpected EOF on client connection
LOG: pq_recvbuf: unexpected EOF on client connection
LOG: pq_recvbuf: unexpected EOF on client connection
LOG: pq_recvbuf: unexpected EOF on client connection
The are no error messages when new zones (and therefor database interaction)
are transfered to powerdns.
LOGFILE: pdns.err
Feb 12 17:16:54 pelxB01 pdns[1629]: Guardian is launching an instance
Feb 12 17:16:54 pelxB01 pdns[1629]: UDP server bound to 212.203.21.107:53
Feb 12 17:16:54 pelxB01 pdns[1629]: TCP server bound to 212.203.21.107:53
Feb 12 17:16:54 pelxB01 pdns[1632]: Launched webserver on 212.203.21.107:8081
Feb 12 17:16:54 pelxB01 pdns[1634]: Master/slave communicator launching
Feb 12 17:16:54 pelxB01 pdns[1629]: Creating backend connection for TCP
Feb 12 17:17:05 pelxB01 pdns[1628]: Scheduling exit on remote request
Feb 12 17:17:06 pelxB01 pdns[1626]: Guardian is killed, taking down children
with us
Feb 12 17:17:06 pelxB01 pdns[1631]: Fatal error in control listener: Guardian
exited - going down as well
LOGFILE: pdns.warn
Feb 12 17:16:54 pelxB01 pdns[1626]: Listening on controlsocket in
'/var/run/pdns.controlsocket'
Feb 12 17:16:54 pelxB01 pdns[1629]: Guardian is launching an instance
Feb 12 17:16:54 pelxB01 pdns[1629]: This is a guarded instance of pdns
Feb 12 17:16:54 pelxB01 pdns[1629]: UDP server bound to 212.203.21.107:53
Feb 12 17:16:54 pelxB01 pdns[1629]: TCP server bound to 212.203.21.107:53
Feb 12 17:16:54 pelxB01 pdns[1629]: PowerDNS 2.9.15 (C) 2001-2004 PowerDNS.COM
BV (Jan 18 2004, 10:59:55) starting up
Feb 12 17:16:54 pelxB01 pdns[1629]: PowerDNS comes with ABSOLUTELY NO
WARRANTY. This is free software, and you are welcome to redistribute it
according to the terms of the GPL version 2.
Feb 12 17:16:54 pelxB01 pdns[1632]: Launched webserver on 212.203.21.107:8081
Feb 12 17:16:54 pelxB01 pdns[1634]: Master/slave communicator launching
Feb 12 17:16:54 pelxB01 pdns[1629]: Creating backend connection for TCP
Feb 12 17:16:54 pelxB01 pdns[1634]: gpgsql Connection succesful
Feb 12 17:16:54 pelxB01 pdns[1629]: gpgsql Connection succesful
Feb 12 17:16:54 pelxB01 pdns[1634]: Query: select
content,ttl,prio,type,domain_id,name from records where type='SOA' and
name='jembay.com'
Feb 12 17:16:54 pelxB01 pdns[1629]: About to create 3 backend threads
Feb 12 17:16:54 pelxB01 pdns[1634]: Query: select
content,ttl,prio,type,domain_id,name from records where type='SOA' and
name='matchdate.nl'
Feb 12 17:16:54 pelxB01 pdns[1634]: Query: select
content,ttl,prio,type,domain_id,name from records where type='SOA' and
name='roxenisse.nl'
Feb 12 17:16:54 pelxB01 pdns[1640]: gpgsql Connection succesful
Feb 12 17:16:54 pelxB01 pdns[1634]: All slave domains are fresh
Feb 12 17:16:54 pelxB01 pdns[1643]: gpgsql Connection succesful
Feb 12 17:16:54 pelxB01 pdns[1646]: gpgsql Connection succesful
Feb 12 17:17:05 pelxB01 pdns[1628]: Scheduling exit on remote request
Feb 12 17:17:06 pelxB01 pdns[1626]: Guardian is killed, taking down children
with us
Feb 12 17:17:06 pelxB01 pdns[1631]: Fatal error in control listener: Guardian
exited - going down as well
DATABASE DUMP:--
-- Data for TOC entry 18 (OID 16979)
-- Name: domains; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY domains (id, name, master, last_check, "type", notified_serial, account)
FROM stdin;
1 jembay.com 212.203.21.83 1076598269 SLAVE \N
safepoint
2 matchdate.nl 212.203.21.83 1076598269 SLAVE \N
safepoint
3 roxenisse.nl 212.203.21.83 1076598269 SLAVE \N
safepoint
\.
--
-- Data for TOC entry 19 (OID 16987)
-- Name: records; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY records (id, domain_id, name, "type", content, ttl, prio, change_date)
FROM stdin;
9 1 jembay.com SOA dns1.safepoint.nl
postmaster.safepoint.nl 2004021016 14400 1800 604800 86400 86400 35628
\N
10 1 jembay.com NS dns1.safepoint.nl 86400 35628
\N
11 1 jembay.com NS dns2.safepoint.nl 86400 35628
\N
12 1 jembay.com MX mail.jembay.com 3600 10 \N
13 1 jembay.com MX mailfallback.pelican-ict.nl 3600
20 \N
14 1 dns1.jembay.com A 212.19.214.62 86400 20 \N
15 1 localhost.jembay.com A 127.0.0.1 86400 20
\N
16 1 mail.jembay.com A 212.204.246.222 86400 20 \N
17 1 test.jembay.com A 212.203.21.83 86400 20 \N
18 2 matchdate.nl SOA dns1.safepoint.nl
postmaster.safepoint.nl 2003062111 14400 1800 604800 86400 86400 35628
\N
19 2 matchdate.nl NS dns1.safepoint.nl 86400 35628
\N
20 2 matchdate.nl NS dns2.safepoint.nl 86400 35628
\N
21 2 matchdate.nl MX mail.matchdate.nl 86400 10
\N
22 2 matchdate.nl A 212.203.21.85 86400 10 \N
23 2 localhost.matchdate.nl A 127.0.0.1 86400 10
\N
24 2 mail.matchdate.nl A 212.203.21.85 86400 10
\N
25 2 www.matchdate.nl A 212.203.21.85 86400 10
\N
26 3 roxenisse.nl SOA dns1.safepoint.nl
postmaster.safepoint.nl 2003060826 14400 1800 604800 86400 86400 35628
\N
27 3 roxenisse.nl NS dns1.safepoint.nl 86400 35628
\N
28 3 roxenisse.nl NS dns2.safepoint.nl 86400 35628
\N
29 3 roxenisse.nl MX mail.roxenisse.nl 86400 10
\N
30 3 localhost.roxenisse.nl A 127.0.0.1 86400 10
\N
31 3 mail.roxenisse.nl A 212.203.21.85 3600 10
\N
\.
--
-- Data for TOC entry 20 (OID 16999)
-- Name: supermasters; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY supermasters (ip, nameserver, account) FROM stdin;
212.203.21.83 dns1.safepoint.nl safepoint
\.
More information about the Pdns-users
mailing list