From owner-freebsd-questions@FreeBSD.ORG Mon Aug 11 22:15:30 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 69D49106567C for ; Mon, 11 Aug 2008 22:15:30 +0000 (UTC) (envelope-from lists@oak-wood.co.uk) Received: from ash.oak-wood.co.uk (ash.oak-wood.co.uk [62.3.200.116]) by mx1.freebsd.org (Postfix) with ESMTP id 173A68FC15 for ; Mon, 11 Aug 2008 22:15:30 +0000 (UTC) (envelope-from lists@oak-wood.co.uk) Received: from localhost (localhost [127.0.0.1]) by ash.oak-wood.co.uk (Postfix) with ESMTP id F319ABB8EC for ; Mon, 11 Aug 2008 22:15:28 +0000 (GMT) Received: from ash.oak-wood.co.uk ([127.0.0.1]) by localhost (ash.oak-wood.co.uk [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 18046-20 for ; Mon, 11 Aug 2008 22:15:28 +0000 (GMT) Received: from [192.168.37.233] (bluebell.thegrove.oak-wood.co.uk [192.168.37.233]) by ash.oak-wood.co.uk (Postfix) with ESMTPA id 4B493B944C for ; Mon, 11 Aug 2008 22:15:28 +0000 (GMT) Message-ID: <48A0BA00.7050407@oak-wood.co.uk> Date: Mon, 11 Aug 2008 23:15:28 +0100 From: Chris Hastie User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.8.1.16) Gecko/20080724 Thunderbird/2.0.0.16 Mnenhy/0.7.5.666 MIME-Version: 1.0 To: freebsd-questions@freebsd.org References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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:15:30 -0000 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/