[Pdns-users] Pdns-users Digest, Vol 111, Issue 1

[Đức Vinh Hồ]

i think that is not the main reason, because my pdns server work good in
workingday, the problem only happen after workingday - when noone using
pdns to query to mysql database. So i thinks the main cause is timeout of
mysql refuse pdns connection.
I tried to increase mysql timeout to unlimitted, but nothing better
How can i config pdns to increase timeout - not mysql timeout !

2012/4/2 <pdns-users-request at mailman.powerdns.com>

> Send Pdns-users mailing list submissions to
>        pdns-users at mailman.powerdns.com
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        http://mailman.powerdns.com/mailman/listinfo/pdns-users
> or, via email, send a message with subject or body 'help' to
>        pdns-users-request at mailman.powerdns.com
>
> You can reach the person managing the list at
>        pdns-users-owner at mailman.powerdns.com
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Pdns-users digest..."
>
>
> Today's Topics:
>
>   1. [STILL NEED HELP] - PDNS stop suddenly after every        night
>      (??c Vinh H?)
>   2. Re: [STILL NEED HELP] - PDNS stop suddenly after every night
>      (Brielle Bruns)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 2 Apr 2012 08:02:16 +0700
> From: ??c Vinh H? <vinh.ho2110 at gmail.com>
> Subject: [Pdns-users] [STILL NEED HELP] - PDNS stop suddenly after
>        every   night
> To: pdns-users at mailman.powerdns.com
> Message-ID:
>        <CAHd=_-OGP0DDKNXqoDjBerXTkK3xBmZ1v-HSj3nTenhQe8XBxA at mail.gmail.com
> >
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi all,
> I successfully install & using PDNS. That's good for me
> But i face to stupid problem that after 5-8hours working, PDNS suddenly
> stop working. And i have to start PDNS manually.
> And the loop continued, after 5-8 hour, it stop working again. What's wrong
> with that ?
> Any idea to solve that ?
>
> p/s : i compile pdns from source and i start/stop pdns by using :
>
> # killall pdns_server
> #/usr/local/pdns/sbin/pdns_server &
>
> and i add the command *"/usr/local/pdns/sbin/pdns_server &"* to rc.local as
> well
>
> Here is the log :
>
> *Mar 29 14:41:24 slv21 pdns[25327]: gmysql Connection failed: Unable to
> connect to database: Access denied for user 'power_admin'@'127.0.0.1'
> (using password: YES)
> Mar 29 14:41:24 slv21 pdns[25327]: Caught an exception instantiating a
> backend, cleaning up
> Mar 29 14:41:24 slv21 pdns[25327]: TCP server is unable to launch backends
> - will try again when questions come in: Unable to launch gmysql
> connection: Unable to connect to database: Access denied for user
> 'power_admin'@'127.0.0.1' (using password: YES)*
>
> I had check mysql timeout and i want to say that pdns was successfully
> connected to mysqld at the time i started pdns.
> The log error only existed after few long hours pdns not queried to mysqld
> I try to set mysql timeout = 0 - that mean mysql timeout is unlimitted
> But the problem still existed.
> I want to set timeout to pdns. Is that pdns had some timeout config ?
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://mailman.powerdns.com/pipermail/pdns-users/attachments/20120402/f83b5c3a/attachment.html
> >
>
> ------------------------------
>
> Message: 2
> Date: Sun, 01 Apr 2012 21:13:13 -0600
> From: Brielle Bruns <bruns at 2mbit.com>
> Subject: Re: [Pdns-users] [STILL NEED HELP] - PDNS stop suddenly after
>        every night
> To: pdns-users at mailman.powerdns.com
> Message-ID: <4F791949.8090801 at 2mbit.com>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> On 4/1/12 7:02 PM, ??c Vinh H? wrote:
> >
> > /Mar 29 14:41:24 slv21 pdns[25327]: gmysql Connection failed: Unable to
> > connect to database: Access denied for user 'power_admin'@'127.0.0.1'
> > (using password: YES)
> > Mar 29 14:41:24 slv21 pdns[25327]: Caught an exception instantiating a
> > backend, cleaning up
> > Mar 29 14:41:24 slv21 pdns[25327]: TCP server is unable to launch
> > backends - will try again when questions come in: Unable to launch
> > gmysql connection: Unable to connect to database: Access denied for user
> > 'power_admin'@'127.0.0.1' (using password: YES)/
>
>
>
> Your mysql server is refusing the password you are giving it with the
> power_admin user.
>
> Sounds like there may be a problem with the mysql server/database?
>
> --
> Brielle Bruns
> The Summit Open Source Development Group
> http://www.sosdg.org    /     http://www.ahbl.org
>
>
> ------------------------------
>
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> http://mailman.powerdns.com/mailman/listinfo/pdns-users
>
>
> End of Pdns-users Digest, Vol 111, Issue 1
> ******************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20120402/24f1a03a/attachment.html>