Date: Mon, 11 Aug 2008 15:23:53 -0700 From: "Johnson, James" <james.johnson@emerald.fiserv.com> To: "Chris Hastie" <lists@oak-wood.co.uk> Cc: freebsd-questions@freebsd.org Subject: RE: mysql and BIND 9.4.2 Message-ID: <A649D807B7293E4B8FEE66605F84E7AD028AEEA4@emrldsdex01.emerald.fiserv.net> In-Reply-To: <48A0B763.4020305@oak-wood.co.uk> References: <A649D807B7293E4B8FEE66605F84E7AD028AEE4C@emrldsdex01.emerald.fiserv.net> <48A0B763.4020305@oak-wood.co.uk>
next in thread | previous in thread | raw e-mail | index | archive | help
Thanks Chris, I'll look into this. Have you or anyone you know ever set something like this before? What I'm trying to do is replace our name servers, they will be Virtualized. James Johnson -----Original Message----- From: Chris Hastie [mailto:lists@oak-wood.co.uk]=20 Sent: Monday, August 11, 2008 3:04 PM To: Johnson, James Subject: Re: mysql and BIND 9.4.2 On 11/08/08 19:17, Johnson, James wrote: > Does any know how to make mysql and BIND work together. > > =20 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 =3D getParameterValue(argv[1], "pass=3D"); socket =3D getParameterValue(argv[1], "socket=3D"); + 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=3D0; dbc =3D=3D NULL && j < 4; j++) dbc =3D mysql_real_connect((MYSQL *) dbi->dbconn, host, user, pass, dbname, port, socket, --=20 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?A649D807B7293E4B8FEE66605F84E7AD028AEEA4>