Bind 9.4.1-P1 fails to compile with the --with-dlz-mysql flag

[JPHein]

Binary package hint: bind9

The idea was to install bind with MySQL database support.
I am using an updated 7.10 installation. of Ubuntu
Here is what I did:
1. apt-get install build-essential
2. apt-get source bind9
3. apt-get build-dep bind9
4. apt-get source mysql
5.cd bind9-9.4.1-P1
6../configure --with-dlz-mysql=../mysql-dfsg-5.0-5.0.45
7.make

Here is the end of the compile with the error:
gcc -I/root/bind9-9.4.1-P1 -I./include -I./unix/include -I/root/bind9-9.4.1-P1/lib/lwres/include -I../../lib/lwres/unix/include -I../../lib/lwres/include -I/root/bind9-9.4.1-P1/lib/dns/include -I../../lib/dns/include -I/root/bind9-9.4.1-P1/lib/bind9/include -I../../lib/bind9/include -I/root/bind9-9.4.1-P1/lib/isccfg/include -I../../lib/isccfg/include -I/root/bind9-9.4.1-P1/lib/isccc/include -I../../lib/isccc/include -I/root/bind9-9.4.1-P1/lib/isc/include -I../../lib/isc -I../../lib/isc/include -I../../lib/isc/unix/include -I../../lib/isc/nothreads/include -I../../lib/isc/x86_32/include -I../../contrib/dlz/drivers/include -I../mysql-dfsg-5.0-5.0.45/include/mysql -DDLZ -DDLZ_MYSQL -g -O2 -W -Wall -Wmissing-prototypes -Wcast-qual -Wwrite-strings -Wformat -Wpointer-arith -fno-strict-aliasing -c ../../contrib/dlz/drivers/dlz_mysql_driver.c
../../contrib/dlz/drivers/dlz_mysql_driver.c:76:19: error: mysql.h: No such file or directory
../../contrib/dlz/drivers/dlz_mysql_driver.c:103: error: expected ')' before '*' token
../../contrib/dlz/drivers/dlz_mysql_driver.c:135: error: expected declaration specifiers or '...' before 'MYSQL_RES'
../../contrib/dlz/drivers/dlz_mysql_driver.c: In function 'mysql_get_resultset':
../../contrib/dlz/drivers/dlz_mysql_driver.c:145: error: 'rs' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:145: error: (Each undeclared identifier is reported only once
../../contrib/dlz/drivers/dlz_mysql_driver.c:145: error: for each function it appears in.)
../../contrib/dlz/drivers/dlz_mysql_driver.c:233: warning: implicit declaration of function 'mysqldrv_escape_string'
../../contrib/dlz/drivers/dlz_mysql_driver.c:233: error: 'MYSQL' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:233: error: expected expression before ')' token
../../contrib/dlz/drivers/dlz_mysql_driver.c:234: warning: assignment makes pointer from integer without a cast
../../contrib/dlz/drivers/dlz_mysql_driver.c:248: error: expected expression before ')' token
../../contrib/dlz/drivers/dlz_mysql_driver.c:249: warning: assignment makes pointer from integer without a cast
../../contrib/dlz/drivers/dlz_mysql_driver.c:263: error: expected expression before ')' token
../../contrib/dlz/drivers/dlz_mysql_driver.c:264: warning: assignment makes pointer from integer without a cast
../../contrib/dlz/drivers/dlz_mysql_driver.c:324: warning: implicit declaration of function 'mysql_query'
../../contrib/dlz/drivers/dlz_mysql_driver.c:324: error: expected expression before ')' token
../../contrib/dlz/drivers/dlz_mysql_driver.c:327: warning: implicit declaration of function 'mysql_ping'
../../contrib/dlz/drivers/dlz_mysql_driver.c:327: error: expected expression before ')' token
../../contrib/dlz/drivers/dlz_mysql_driver.c:334: warning: implicit declaration of function 'mysql_store_result'
../../contrib/dlz/drivers/dlz_mysql_driver.c:334: error: expected expression before ')' token
../../contrib/dlz/drivers/dlz_mysql_driver.c: At top level:
../../contrib/dlz/drivers/dlz_mysql_driver.c:377: error: expected declaration specifiers or '...' before 'MYSQL_RES'
../../contrib/dlz/drivers/dlz_mysql_driver.c: In function 'mysql_process_rs':
../../contrib/dlz/drivers/dlz_mysql_driver.c:380: error: 'MYSQL_ROW' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:380: error: expected ';' before 'row'
../../contrib/dlz/drivers/dlz_mysql_driver.c:388: error: 'row' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:388: warning: implicit declaration of function 'mysql_fetch_row'
../../contrib/dlz/drivers/dlz_mysql_driver.c:388: error: 'rs' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:389: warning: implicit declaration of function 'mysql_num_fields'
../../contrib/dlz/drivers/dlz_mysql_driver.c:448: warning: implicit declaration of function 'mysql_free_result'
../../contrib/dlz/drivers/dlz_mysql_driver.c: In function 'mysql_findzone':
../../contrib/dlz/drivers/dlz_mysql_driver.c:509: error: 'MYSQL_RES' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:509: error: 'rs' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:510: error: 'my_ulonglong' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:510: error: expected ';' before 'rows'
../../contrib/dlz/drivers/dlz_mysql_driver.c:515: error: too many arguments to function 'mysql_get_resultset'
../../contrib/dlz/drivers/dlz_mysql_driver.c:527: error: 'rows' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:527: warning: implicit declaration of function 'mysql_num_rows'
../../contrib/dlz/drivers/dlz_mysql_driver.c:533: error: too many arguments to function 'mysql_get_resultset'
../../contrib/dlz/drivers/dlz_mysql_driver.c: In function 'mysql_allowzonexfr':
../../contrib/dlz/drivers/dlz_mysql_driver.c:547: error: 'MYSQL_RES' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:547: error: 'rs' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:548: error: 'my_ulonglong' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:548: error: expected ';' before 'rows'
../../contrib/dlz/drivers/dlz_mysql_driver.c:566: error: too many arguments to function 'mysql_get_resultset'
../../contrib/dlz/drivers/dlz_mysql_driver.c:581: error: 'rows' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c: In function 'mysql_allnodes':
../../contrib/dlz/drivers/dlz_mysql_driver.c:603: error: 'MYSQL_RES' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:603: error: 'rs' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:604: error: 'MYSQL_ROW' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:604: error: expected ';' before 'row'
../../contrib/dlz/drivers/dlz_mysql_driver.c:615: error: too many arguments to function 'mysql_get_resultset'
../../contrib/dlz/drivers/dlz_mysql_driver.c:632: error: 'row' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c: In function 'mysql_authority':
../../contrib/dlz/drivers/dlz_mysql_driver.c:717: error: 'MYSQL_RES' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:717: error: 'rs' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:722: error: too many arguments to function 'mysql_get_resultset'
../../contrib/dlz/drivers/dlz_mysql_driver.c:740: error: too many arguments to function 'mysql_process_rs'
../../contrib/dlz/drivers/dlz_mysql_driver.c: In function 'mysql_lookup':
../../contrib/dlz/drivers/dlz_mysql_driver.c:749: error: 'MYSQL_RES' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:749: error: 'rs' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:754: error: too many arguments to function 'mysql_get_resultset'
../../contrib/dlz/drivers/dlz_mysql_driver.c:769: error: too many arguments to function 'mysql_process_rs'
../../contrib/dlz/drivers/dlz_mysql_driver.c: In function 'mysql_create':
../../contrib/dlz/drivers/dlz_mysql_driver.c:791: error: 'MYSQL' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:791: error: 'dbc' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:887: warning: implicit declaration of function 'mysql_init'
../../contrib/dlz/drivers/dlz_mysql_driver.c:887: warning: assignment makes pointer from integer without a cast
../../contrib/dlz/drivers/dlz_mysql_driver.c:902: error: 'CLIENT_COMPRESS' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:909: error: 'CLIENT_SSL' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:916: error: 'CLIENT_IGNORE_SPACE' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:927: warning: implicit declaration of function 'mysql_real_connect'
../../contrib/dlz/drivers/dlz_mysql_driver.c:927: error: expected expression before ')' token
../../contrib/dlz/drivers/dlz_mysql_driver.c: In function 'mysql_destroy':
../../contrib/dlz/drivers/dlz_mysql_driver.c:986: warning: implicit declaration of function 'mysql_close'
../../contrib/dlz/drivers/dlz_mysql_driver.c:986: error: 'MYSQL' undeclared (first use in this function)
../../contrib/dlz/drivers/dlz_mysql_driver.c:986: error: expected expression before ')' token
make[2]: *** [dlz_mysql_driver.o] Error 1
make[2]: Leaving directory `/root/bind9-9.4.1-P1/bin/named'
make[1]: *** [subdirs] Error 1
make[1]: Leaving directory `/root/bind9-9.4.1-P1/bin'
make: *** [subdirs] Error 1

[JPHein (jp-jphein)]

Ok I figured it out.
I installed the wrong mysql package.
This is the right process:
apt-get install build-essential
apt-get source bind9
apt-get build-dep bind9
apt-get libmysqlclient15-dev, needed for mysql headers and libraries for the dlz-mysql driver.
cd bind9-9.4.1-P1
export DEB_BUILD_OPTIONS="--with-dlz-mysql". This does not work as it shoud so: nano -w debian/rules, add --with-dlz-mysql to ./configure line
dpkg-buildpackage -b
dpkg -i ../bind9_9.4.1-P1-3ubuntu1_i386.deb

[Iulian Udrea (iulian)]

'Fix Committed' is not the right status to use in this case. I will change it to 'Invalid'. Please take a look at https://wiki.ubuntu.com/Bugs/Status for more details. Thank you