Date: Mon, 11 Aug 2008 23:15:28 +0100 From: Chris Hastie <lists@oak-wood.co.uk> To: freebsd-questions@freebsd.org Subject: Re: mysql and BIND 9.4.2 Message-ID: <48A0BA00.7050407@oak-wood.co.uk> In-Reply-To: <A649D807B7293E4B8FEE66605F84E7AD028AEE4C@emrldsdex01.emerald.fiserv.net> References: <A649D807B7293E4B8FEE66605F84E7AD028AEE4C@emrldsdex01.emerald.fiserv.net>
next in thread | previous in thread | raw e-mail | index | archive | help
On 11/08/08 19:17, Johnson, James wrote: > Does any know how to make mysql and BIND work together. > > > Configure bind with --with-dlz-mysql. I seem to recall that using --disable-threads is also recommended with MySql. Lots of info at http://bind-dlz.sourceforge.net/ There is an issue with bind giving up if the MySQL server goes away, which is helped by this patch: --- contrib/dlz/drivers/dlz_mysql_driver.c.orig 2007-11-15 09:08:05.000000000 +0000 +++ contrib/dlz/drivers/dlz_mysql_driver.c 2007-11-15 09:10:49.000000000 +0000 @@ -923,6 +923,13 @@ pass = getParameterValue(argv[1], "pass="); socket = getParameterValue(argv[1], "socket="); + if(mysql_options((MYSQL *) dbi->dbconn, MYSQL_OPT_RECONNECT,"1")) { + isc_log_write(dns_lctx, DNS_LOGCATEGORY_DATABASE, + DNS_LOGMODULE_DLZ, ISC_LOG_ERROR, + "Could not set database reconnect option"); + } + + for (j=0; dbc == NULL && j < 4; j++) dbc = mysql_real_connect((MYSQL *) dbi->dbconn, host, user, pass, dbname, port, socket, -- Chris Hastie Find tree care advice at http://www.tree-care.info/
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?48A0BA00.7050407>