[Pdns-users] pdns mysql backend on Ubuntu server 14.04

[Palm Internet]

Hi Guys

I am having major issues getting PDNS-server with mysql backend to run on
Ubuntu server 16.04 <tel:16.04> 

I am using a 64 bit op system 

Installing is fine and I can get the server to run. However it keeps failing
to answer queries

Using gmysql and connecting to the database on a separate server or even
having the database on the local server pdns starts and distributes the
threads with no issues but it always fails when testing to retrieve the
records

I am using the database from the earlier version of PDNS database, I have
also imported all the records into the new version of the pdns database

Still it fails to answer queries

Pdns local conf is straight forward and as follows

launch=gmysql

gmysql-host=*********

gmysql-dbname=*******

gmysql-user=**********

gmysql-password=*******  

 

 

Status shows

 

Dec 11 10:24:28 dns2 pdns[13132]: Unable to enable timestamp reporting for
socket

Dec 11 10:24:28 dns2 pdns[13132]: UDPv6 server bound to [::]:53

Dec 11 10:24:28 dns2 pdns[13132]: TCP server bound to 0.0.0.0:53

Dec 11 10:24:28 dns2 pdns[13132]: TCPv6 server bound to [::]:53

Dec 11 10:24:28 dns2 pdns[13132]: PowerDNS Authoritative Server 4.0.0-alpha2
(C) 2001-2016 PowerDNS.COM BV

Dec 11 10:24:28 dns2 pdns[13132]: Using 64-bits mode. Built using gcc 5.3.1
20160330.

Dec 11 10:24:28 dns2 pdns[13132]: PowerDNS comes with ABSOLUTELY NO
WARRANTY. This is free software, and you are welcome to red

Dec 11 10:24:28 dns2 pdns[13132]: Creating backend connection for TCP

Dec 11 10:24:28 dns2 pdns[13132]: About to create 3 backend threads for UDP

Dec 11 10:24:28 dns2 pdns[13132]: Done launching threads, ready to
distribute questions

 

Doing a dig I get

 

dig @localhost kimboscakes.co.uk

 

; <<>> DiG 9.10.3-P4-Ubuntu <<>> @localhost kimboscakes.co.uk

; (2 servers found)

;; global options: +cmd

;; Got answer:

;; ->>HEADER<<- opcode: QUERY, status: SERVFAIL, id: 45118

;; flags: qr aa rd; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 1

;; WARNING: recursion requested but not available

 

;; OPT PSEUDOSECTION:

; EDNS: version: 0, flags:; udp: 1680

;; QUESTION SECTION:

;kimboscakes.co.uk.             IN      A

 

;; Query time: 0 msec

;; SERVER: ::1#53(::1)

;; WHEN: Sun Dec 11 10:27:51 GMT 2016

;; MSG SIZE  rcvd: 46

 

 

Any help appreciated

Patrick

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20161211/6b947da7/attachment-0001.html>