[Pdns-users] Power DNS & MySQL Versions 5

[bert hubert]

I'll look into the mysql 5 issue soonest. It is supposed to work fine.

Thanks for reporting the problem.

On Tue, May 30, 2006 at 03:57:13PM -0400, Garland, Ken R wrote:
> Jeremy May wrote:
> >
> >AJ McKee wrote:
> >>Hi All,
> >>
> >>I am considering updating the database servers to MySQL version 5.0 (Or 
> >>5.1
> >>which is in beta now but should be production by the time we get around to
> >>it.). Currently we use Red Hat Enterprise 4, MySQL 4 and source built PDNS
> >>instances configured with the gmysql backend.
> >>
> >>Has anyone had any problems running Power DNS with MySQL 5, or would you
> >>care to share your experience.
> >>
> >>Thanks in advance
> >>AJ
> >>
> >>
> >>_______________________________________________
> >>Pdns-users mailing list
> >>Pdns-users at mailman.powerdns.com
> >>http://mailman.powerdns.com/mailman/listinfo/pdns-users
> >>
> >>
> >>
> >>
> >>
> >i currently use mysql 5 (backports on debian) with powerdns and the
> >gmysql backend and it works great!.
> 
> I have this setup as well, but it works poorly. Sorry to hijack the
> thread here, I recently wrote in but I think it was regected as I was
> not signed up as a member yet.
> 
> The problem I am having is:
> 
> May 30 09:13:53 HOSTNAME pdns[6621]: Backend error: Failed to execute
> mysql_query, perhaps connection died? Err=1: MySQL server has gone
> away
> 
> I've set wait_timeout = 60000 in my.cnf but still getting this error.
> The last successful query was well over 16 hours (60000, roughly) so
> it was past the timeout period. However, in production this is just
> not acceptable. What if there are no queries in that time, do I have
> to manually reset the server everytime or set the timeout to infinity.
> How to bypass this timeout feature and what is the point of it. It
> really makes no sense as you want a service available 24/7, that is
> the point of running these services. I've never had to deal with this
> problem, shouldn't the pdns daemon have some sort of refresh
> rec-connect switch built-in that allows it to establish a connection
> when needed, or just connect without timeout.
> 
> I'm running Ubuntu Dapper 6.06 with MySQL 5.
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> http://mailman.powerdns.com/mailman/listinfo/pdns-users
> 
> 
> !DSPAM:447ca3b0315261635413018!

-- 
http://www.PowerDNS.com      Open source, database driven DNS Software 
http://netherlabs.nl              Open and Closed source services