[Pdns-users] failed connections to gmysql

[Bob Lockie]

On 05/16/04 14:59 Derrik Pates spoke:
> Bob Lockie wrote:
> 
>> I don't understand the question.
>> I use Gentoo as my Linux distribution and I installed the MySQL-4.0.18 
>> that it has.
>> I downloaded and intalled pdns-2.9.16.
>> There are no servers on this machine, it is my desktop. :-)
> 
> 
> Well, for you to use a MySQL database on _localhost_, you would kind of 
> have to have a MySQL server running there, no? I don't know enough about 
> Gentoo and how its packaging/build process works to know what exactly is 
> going on. Maybe you need to break out strace on it, and see what exactly 
> it's doing.

My mistake, it is Trustix and it works. I'm just concerned about the error.

root at gw ~# /etc/init.d/mysql status
MySQL daemon is running with pid 702.

root at gw ~# uname -a
Linux gw.lockie.ca 2.4.23-2tr #1 Tue Dec 16 13:27:24 UTC 2003 i586 
unknown unknown GNU/Linux

root at gw ~# mysql --version
mysql  Ver 12.22 Distrib 4.0.18, for pc-linux (i686)

root at gw ~# /etc/init.d/mysql status
MySQL daemon is running with pid 702.

root at gw ~# /etc/init.d/pdns monitor
May 16 15:05:03 This is a standalone pdns
May 16 15:05:03 It is advised to bind to explicit addresses with the 
--local-address option
May 16 15:05:03 UDP server bound to 0.0.0.0:5300
May 16 15:05:03 TCP server bound to 0.0.0.0:5300
May 16 15:05:03 PowerDNS 2.9.16 (C) 2001-2004 PowerDNS.COM BV (May 12 
2004, 09:31:59) starting up
May 16 15:05:03 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.
May 16 15:05:03 DNS Proxy launched, local port 26312, remote 127.0.0.2:53
% May 16 15:05:03 Launched webserver on 0.0.0.0:8081
May 16 15:05:03 Master/slave communicator launching
May 16 15:05:03 Creating backend connection for TCP
May 16 15:05:03 gmysql Connection failed: Unable to connect to database: 
Can't connect to MySQL server on 'localhost' (111)
May 16 15:05:03 Caught an exception instantiating a backend, cleaning up
May 16 15:05:03 TCP server is unable to launch backends - will try again 
when questions come in: Unable to launch gmysql connection: Unable to 
connect to database: Can't connect to MySQL server on 'localhost' (111)
May 16 15:05:03 About to create 3 backend threads
May 16 15:05:03 gmysql Connection succesful
May 16 15:05:03 All slave domains are fresh
May 16 15:05:03 No master domains need notifications
May 16 15:05:03 gmysql Connection succesful
May 16 15:05:03 gmysql Connection succesful
May 16 15:05:03 gmysql Connection succesful
May 16 15:05:03 Done launching threads, ready to distribute questions