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:[EMAIL PROTECTED] 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/ _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"