Re: Frustrating mysql problem.

I haven't had a problem like this, but in our setup BIND talks to a
local MySQL via domain socket. Each of our three DNS servers has a local
MySQL daemon which is a replication slave to the master db.  This is
much faster than zone files, and it's really easy to add additional dns
servers and it keeps the load off of our master DB server and it has
security advantages... anyway, i'll stop raving ;)

--Igor

On Mon, Jul 20, 2009 at 03:16:27PM -0400, Erol wrote:
> Im having the oddest and most frustrating problem with mysql.
> 
> Currently when I fire up bind-dlz and mysql all works as it
> should. When I query for zones in the mysql database I get the
> results I should. A dig against the nameserver returns the proper
> results.
> 
> However after an hour or two I start getting the error below when
> I try and run the same query.
> 
> mysql driver unable to return result set for findzone query
> 
> A dig will return a REFUSED.
> 
> The database is not on local disk but it is on the same (internal) network. When this
> happens I am able to use the mysql client , connect to the
> database and run the sql queries.
> 
> I ran a tcpdump on the nameserver. When the error occurs it is not
> attempting to connect to the DB server.
> 
> Ive searched high and low to no avail. This has grown beyond
> frustrating now.
> 
> Has anyone experienced anything like this .... anyone?
> 
> Thanks.
> 
> Best,
> /erol
> 
> -- 
> [email protected]
> Systems Administrator
> easyDNS Technologies Inc.
> 
> ------------------------------------------------------------------------------
> Enter the BlackBerry Developer Challenge  
> This is your chance to win up to $100,000 in prizes! For a limited time, 
> vendors submitting new applications to BlackBerry App World(TM) will have
> the opportunity to enter the BlackBerry Developer Challenge. See full prize  
> details at: http://p.sf.net/sfu/Challenge
> _______________________________________________
> Bind-dlz-testers mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers

------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge  
This is your chance to win up to $100,000 in prizes! For a limited time, 
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize  
details at: http://p.sf.net/sfu/Challenge

_______________________________________________
Bind-dlz-testers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFKZRYlVyVcp2k8D/kRArf9AJ9kdyaj8QczfYprmrR5aCAUn88z4ACfconi
mGr78BvPkzimCmnnTGW3914=
=v7jV
-----END PGP SIGNATURE-----