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 <[email protected]> > Send Pdns-users mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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? <[email protected]> > Subject: [Pdns-users] [STILL NEED HELP] - PDNS stop suddenly after > every night > To: [email protected] > Message-ID: > <CAHd=_-ogp0ddknxqodjberxtkk3xbmz1v-hsj3ntenhqe8x...@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 <[email protected]> > Subject: Re: [Pdns-users] [STILL NEED HELP] - PDNS stop suddenly after > every night > To: [email protected] > Message-ID: <[email protected]> > 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 > [email protected] > http://mailman.powerdns.com/mailman/listinfo/pdns-users > > > End of Pdns-users Digest, Vol 111, Issue 1 > ****************************************** >
_______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
