FreeBSD全能服务器安装手册之域名服务器篇之DNS(数据库)篇.doc

FreeBSD全能服务器安装手册之域名服务器篇之DNS(数据库)篇 #################################下载并解压缩安装包################################ cd /usr/ports/dns/bind9 //下载bind9.3.1 make fetch cd /usr/ports/distfiles/ //解压缩bind9.3.* tar zxvf bind-9.3.*.tar.gz chown -R root:wheel bind-9.3.* ###############################生成mysqldb.c文件################################## cd /usr/ports/distfiles/bind-9.3.*/bin/named/ //生成mysqldb.c 注意：必须采用touch命令生成文件，因为有些时候用其他命令生成的文件是不能被程序识别的。 touch mysqldb.c //编辑mysqldb.c /* 增加以下内容（此为mysqldb.c的原版文档亦可从以下连接直*/sourceforge/mysql-bind/mysql-bind-0-1.tgz）*/ #include config.h #include stdio.h #include string.h #include stdlib.h #include mysql.h #include isc/mem.h #include isc/print.h #include isc/result.h #include isc/util.h #include dns/sdb.h #include dns/result.h #include named/globals.h #include mysqldb.h static dns_sdbimplementation_t *mysqldb = NULL; struct dbinfo { MYSQL *mysql; char *database; char *table; char *host; char *user; char *passwd; }; static void mysqldb_destroy(const char *zone, void *driverdata, void **dbdata); /* * Canonicalize a string before writing it to the database. * dest must be an array of at least size 2*strlen(source) + 1. */ static void quotestring(const char *source, char *dest) { while (*source != 0) { if (*source == \) *dest++ = \; *dest++ = *source++; } *dest++ = 0; } /* * Connect to the database. */ static isc_result_t db_connect(struct dbinfo *dbi) { dbi-mysql = mysql_init(0); if (!mysql_real_connect(dbi-mysql, dbi-host, dbi-user, dbi-passwd, dbi-database, 0, NULL, 0)) return (ISC_R_FAILURE); return (ISC_R_SUCCESS); } /* * Check to see if the connection is still valid. If not, attempt to * reconnect. */ static isc_result_t maybe_reconnect(struct dbinfo *dbi) { if (dbi-mysql != NULL) return (ISC_R_SUCCESS); return (db_connect(dbi)); } /* * This database operates on absolute names. * * Queries are converted into SQL queries and issued synchronously. Errors * are handled really ba