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