mysql and BIND 9.4.2

[Johnson, James]

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 at oak-wood.co.uk] 
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.
>
>   

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/