<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">root@ns-01:~# pdnssec check-zone local<br>
Checked 81 records of 'local', 0 errors, 0 warnings.<br>
<br>
mysql> select * from records where content='.';<br>
Empty set (0.00 sec)<br>
<br>
<br>
06.08.2014 22:27, Peter van Dijk пишет:<br>
</div>
<blockquote
cite="mid:38d96be0-6597-4882-aa4c-0eb4d27e08e1@email.android.com"
type="cite">Please provide a database dump for the local zone.
Please run 'pdnssec check-zone local'. Please provide<br>
<br>
select * from records where content='.'<br>
<br>
<br>
<br>
<br>
<div class="gmail_quote">On 6 August 2014 16:09:05 CEST, Matyashov
Andrey <a class="moz-txt-link-rfc2396E"
href="mailto:sysadmin@gorod0k.ru"><sysadmin@gorod0k.ru></a>
wrote:
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
<pre class="k9mail">Package: pdns-server
Version: 3.1-4.1
Severity: normal
Tags: upstream
Dear Maintainer!
I use 2 pdns-servers (master and slave) with mysql-backend.
If in zone 2-level or greater (e. g.: <a moz-do-not-send="true" href="http://myzone.net">myzone.net</a> or <a moz-do-not-send="true" href="http://subzone.zone.net">subzone.zone.net</a>), slave server normal getting updates from master.
If zone - up-level (e. g.: local), transfer zone failed.
Log-records in master:
Aug 6 16:21:24 ns-01 pdns[17538]: gmysql Connection successful
Aug 6 16:21:24 ns-01 pdns[17538]: AXFR of domain 'local' initiated by <a moz-do-not-send="true" href="http://10.10.2.104">10.10.2.104</a>
Aug 6 16:21:24 ns-01 pdns[17538]: AXFR of domain 'local' allowed: client IP <a moz-do-not-send="true" href="http://10.10.2.104">10.10.2.104</a> is in allow-axfr-ips
Aug 6 16:21:24 ns-01 pdns[17538]: gmysql Connection successful
Aug 6 16:21:24 ns-01 pdns[17538]: gmysql Connection successful
Aug 6 16:21:24 ns-01
pdns[17538]: Exception: Unknown record was stored incorrectly, need 3 fields, got 1: .
Aug 6 16:21:24 ns-01 pdns[17538]: TCP Connection Thread died because of STL error: Unknown record was stored incorrectly, need 3 fields, got 1: .
Log-records in slave:
Aug 6 16:23:22 ns-02 pdns[10884]: 1 slave domain needs checking, 0 queued for AXFR
Aug 6 16:23:22 ns-02 pdns[10884]: Received serial number updates for 1 zones, had 0 timeouts
Aug 6 16:23:22 ns-02 pdns[10884]: Domain local is stale, master serial 2014080624, our serial 2014080611
Aug 6 16:23:22 ns-02 pdns[10884]: Initiating transfer of 'local' from remote '<a moz-do-not-send="true" href="http://10.10.2.2">10.10.2.2</a>'
Aug 6 16:23:22 ns-02 pdns[10884]: gmysql Connection successful
Aug 6 16:23:22 ns-02 pdns[10884]: gmysql Connection successful
Aug 6 16:23:22 ns-02 pdns[10884]: gmysql Connection successful
Aug 6 16:23:22 ns-02 pdns[10884]: AXFR started for 'local', transaction
started
Aug 6 16:23:22 ns-02 pdns[10884]: Unable to AXFR zone 'local' from remote '<a moz-do-not-send="true" href="http://10.10.2.2">10.10.2.2</a>' (resolver): Remote nameserver closed TCP connection
Aug 6 16:23:22 ns-02 pdns[10884]: Aborting possible open transaction for domain 'local' AXFR
-- System Information:
Debian Release: 7.6
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 3.2.0-4-amd64 (SMP w/4 CPU cores)
Locale: LANG=ru_RU.UTF-8, LC_CTYPE=ru_RU.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages pdns-server depends on:
ii adduser 3.113+nmu3
ii debconf [debconf-2.0] 1.5.49
ii libboost-program-options1.49.0 1.49.0-3.2
ii libboost-serialization1.49.0 1.49.0-3.2
ii libc6 2.13-38+deb7u3
ii libcrypto++9
5.6.1-6
ii libgcc1 1:4.7.2-5
ii liblua5.1-0 5.1.5-4
ii libpolarssl0 1.2.9-1~deb7u3
ii libsqlite3-0 3.7.13-1+deb7u1
ii libstdc++6 4.7.2-5
ii ucf 3.0025+nmu3
ii zlib1g 1:1.2.7.dfsg-13
pdns-server recommends no packages.
Versions of packages pdns-server suggests:
ii pdns-backend-mysql [pdns-backend] 3.1-4.1
ii pdns-recursor 3.3-3
-- Configuration Files:
/etc/powerdns/pdns.conf
allow-axfr-ips=<a moz-do-not-send="true" href="http://10.10.2.2">10.10.2.2</a>
allow-recursion=<a moz-do-not-send="true" href="http://127.0.0.1">127.0.0.1</a> <a moz-do-not-send="true" href="http://10.0.0.0/8">10.0.0.0/8</a>
cache-ttl=20
config-dir=/etc/powerdns
daemon=yes
default-soa-name=ns-02.local
disable-axfr=no
disable-tcp=no
guardian=yes
local-address=<a moz-do-not-send="true" href="http://10.10.2.104">10.10.2.104</a>
local-port=53
log-dns-details=yes
log-failed-updates=yes
master=no
module-dir=/usr/lib/powerdns
query-cache-ttl=20
queue-limit=1500
recursor=<a moz-do-not-send="true" href="127.0.0.1:53">127.0.0.1:53</a>
setgid=pdns
setuid=pdns
slave=yes
slave-cycle-interval=30
socket-dir=/var/run
webserver=yes
webserver-address=<a moz-do-not-send="true" href="http://10.10.2.104">10.10.2.104</a>
webserver-password=*mypass*
webserver-port=8081
webserver-print-arguments=yes
version-string=powerdns
include=/etc/powerdns/pdns.d
</pre>
</blockquote>
</div>
<br>
-- <br>
Sent from my Android phone with K-9 Mail. Please excuse my
brevity. </blockquote>
<br>
</body>
</html>