no errors now: [Pdns-users] failed connections to gmysql

[Bob Lockie]

On 05/16/04 15:07 Bob Lockie spoke:
> 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

  /etc/init.d/pdns monitor
May 16 15:10:38 This is a standalone pdns
May 16 15:10:38 It is advised to bind to explicit addresses with the 
--local-address option
May 16 15:10:38 UDP server bound to 0.0.0.0:5300
May 16 15:10:38 TCP server bound to 0.0.0.0:5300
May 16 15:10:38 PowerDNS 2.9.16 (C) 2001-2004 PowerDNS.COM BV (May 12 
2004, 09:31:59) starting up
May 16 15:10:38 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:10:39 DNS Proxy launched, local port 39937, remote 127.0.0.2:53
% May 16 15:10:39 Launched webserver on 0.0.0.0:8081
May 16 15:10:39 Master/slave communicator launching
May 16 15:10:39 gmysql Connection succesful
May 16 15:10:39 All slave domains are fresh
May 16 15:10:39 No master domains need notifications
May 16 15:10:39 Creating backend connection for TCP
May 16 15:10:39 gmysql Connection succesful
May 16 15:10:39 About to create 3 backend threads
May 16 15:10:39 gmysql Connection succesful
May 16 15:10:39 gmysql Connection succesful
May 16 15:10:39 gmysql Connection succesful
May 16 15:10:39 Done launching threads, ready to distribute questions