From owner-freebsd-questions@FreeBSD.ORG Mon Aug 11 22:23:56 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id BCC43106567C for ; Mon, 11 Aug 2008 22:23:56 +0000 (UTC) (envelope-from james.johnson@emerald.fiserv.com) Received: from Mail2.Fiserv.com (mail2.fiserv.com [166.73.19.151]) by mx1.freebsd.org (Postfix) with ESMTP id 7F4B88FC14 for ; Mon, 11 Aug 2008 22:23:56 +0000 (UTC) (envelope-from james.johnson@emerald.fiserv.com) X-IronPort-AV: E=Sophos;i="4.32,191,1217826000"; d="scan'208";a="56409608" Received: from unknown (HELO Mail4.Fiserv.com) ([10.3.226.3]) by Mail2.Fiserv.com with ESMTP/TLS/DHE-RSA-AES256-SHA; 11 Aug 2008 17:23:30 -0500 Received: from emrldsdex01.emerald.fiserv.net ([10.24.1.76]) by Mail4.Fiserv.com (Switch-3.3.0/Switch-3.3.0) with ESMTP id m7BMMlbI013115; Mon, 11 Aug 2008 18:22:47 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Date: Mon, 11 Aug 2008 15:23:53 -0700 Message-ID: In-Reply-To: <48A0B763.4020305@oak-wood.co.uk> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: mysql and BIND 9.4.2 Thread-Index: Acj7/jd9VfmpaPb5QAKRza8Q2RurKAAAkiRw References: <48A0B763.4020305@oak-wood.co.uk> From: "Johnson, James" To: "Chris Hastie" Cc: freebsd-questions@freebsd.org Subject: RE: mysql and BIND 9.4.2 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 11 Aug 2008 22:23:56 -0000 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/