Nethence Documentation Lab Webmail Your IP BBDock  


Those documents are obsolete, please use the Nethence Documentation instead.

HomeUnixWindowsOracleObsoleteHardwareDIYMechanicsScriptsConfigsPrivate

Binding Bind to MySQL... On RHEL5
 
Introduction
Note. The MySQL Bind SDB Driver works only with Bind 9, not Bind 8.
 
Requirements
Make sure those packages are installed,
rpm -q \
mysql \
mysql-server \
mysql-devel \
openssl \
openssl-devel \
gcc \
make \
| grep ^package
 
Make sure MySQL is running and secured,
service mysqld restart
chkconfig mysqld on
mysql_secure_installation
 
Restrict the MySQL daemon to localhost,
cd /etc/
cp my.cnf my.cnf.dist
vi my.cnf
add this to the [mysql] section,
bind-address=127.0.0.1...
apply,
service mysqld restart
Ref. http://www.greensql.com/articles/mysql-security-best-practices
 
Create a database and grant write access to e.g. DBUSER with the DBPASS passwod,
mysql -uroot -p
create database DBNAME;
create user DBUSER identified by 'DBPASS';
grant all privileges on DBNAME.* to DBUSER;
 
Make sure BIND server is NOT installed,
rpm -qa | grep bind
Note. bind-libs and bind-utils packages are just fine
Note. bind, bind-chroot and bind-sdb pkgs should NOT be installed
 
Installation
Get latest BIND tarball (ftp://ftp.isc.org/isc/bind9/cur/),
wget ftp://ftp.isc.org/isc/bind9/cur/9.7/bind-9.7.7.tar.gz
 
Get the BIND/MySQL SDB driver (http://sourceforge.net/projects/mysql-bind/),
wget http://sourceforge.net/projects/mysql-bind/files/latest/download
 
Extract the archives,
tar xzf bind-9.7.7.tar.gz
tar xzf mysql-bind.tar.gz
 
Deploy the driver,
cp mysql-bind/mysqldb.c bind-9.7.7/bin/named/
cp mysql-bind/mysqldb.h bind-9.7.7/bin/named/include/
 
Edit the makefile,
cd bind-9.7.7/bin/named/
cp Makefile.in Makefile.in.dist
vi Makefile.in
change,
DBDRIVER_OBJS = mysqldb.@O@
DBDRIVER_SRCS = mysqldb.c
also see MySQL's compile flags,
mysql_config --cflags
and copy/paste to,
DBDRIVER_INCLUDES = ...(paste)...
also see MySQL's libraries,
mysql_config --libs
and copy/paste to,
DBRIVER_LIBS = ...(paste)...
 
Add driver's include into Bind's code,
(same directory bin/named)
cp main.c main.c.dist
vi main.c
add,
/*
* Include header files for database drivers here.
*/
/* #include "xxdb.h" */
#include "mysqldb.h"
also search for 'ns_server_create' and add mysqldb_init just before,
mysqldb_init();
ns_server_create(ns_g_mctx, &ns_g_server);
also search for 'ns_server_destroy' and add mysqldb_clear just after,
ns_server_destroy(&ns_g_server);
mysqldb_clear();
 
Fix driver's own include path (named/),
(same directory bin/named)
cp mysqldb.c mysqldb.c.dist
vi mysqldb.c
change,
#include <named/mysqldb.h>,
by,
#include "include/mysqldb.h"
Note. otherwise you'll get this error at compile time,
mysqldb.c:41:27: error: named/mysqldb.h: No such file or directory
 
Now compile Bind,
cd ../../
./configure --help
./configure
#./configure --disable-openssl-version-check
make clean
make
make install
 
Configuration
Let's proceed with the Bind configuration (new file),
cd /etc/
vi named.conf
like,
zone "example.local" {
type master;
notify no;
database "mysqldb DBNAME example_local 127.0.0.1 DBUSER DBPASS";
};
note. Change DBNAME, DBUSER and DBPASS accordingly.
note. Use underscores instead of a dot for table name as domain name, change example_local accordingly.
check,
named-checkconf
Note. also just in case (optional, it reads /etc/named.conf anyway),
cd /usr/local/etc/
ln -s ../../../etc/named.conf
 
Connect to MySQL as DBUSER,
mysql -uDBUSER -p
use DBNAME;
create a table per domain in that database,
create table example_local (
name varchar(255) default NULL,
ttl int(11) default NULL,
rdtype varchar(255) default NULL,
rdata varchar(255) default NULL
) type=MyISAM;
inject some data e.g.,
insert into example_local values ('example.local', 259200, 'SOA', 'example.local. postmaster.example.local. 1358628703 28800 7200 86400 28800');
insert into example_local values ('example.local', 259200, 'NS', 'ns.example.local.');
insert into example_local values ('example.local', 259200, 'MX', '5 mx.example.local.');
insert into example_local values ('ns.example.local', 259200, 'A', '10.0.0.253');
insert into example_local values ('example.local', 259200, 'A', '10.1.1.1');
insert into example_local values ('mail.example.local', 259200, 'A', '10.1.1.1');
insert into example_local values ('www.example.local', 259200, 'Cname', 'example.local.');
Note. change 1358628703 by the serial you want.
 
Ready go go
Start the daemon and enable it at boot time,
/usr/local/sbin/named
cat >> /etc/rc.local <<EOF9
echo -n Starting named-mysql...
/usr/local/sbin/named && echo \ done
EOF9
 
Check that everything's fine,
netstat -an --inet | grep :53
host example.local localhost
host www.example.local localhost
 
In case you need to reload named.conf,
ps aux | grep named
kill -HUP XXXX
and you should seem something like this in the logs,
Jan 19 22:03:57 named-mysql named[1400]: reloading zones succeeded
 
Installing some GUI
Well phpMyAdmin will do just fine, even the old version (2.x),
cd ~/
yum -y install httpd php php-mysql php-mcrypt
service httpd start
chkconfig httpd on
wget http://www.oldapps.com/phpmyadmin.php?app=ee2c1b8fffbed9f3c3a1121c30cb5ba4
#wget http://www.oldapps.com/phpmyadmin.php?app=b8ef0a2e18e08c1e533116a2b1fa4ebf
unzip phpMyAdmin-2.11.9.3-english.zip
#unzip phpMyAdmin-2.11.11.3-all-languages.zip
mv phpMyAdmin-2.11.9.3-english/ /var/www/htdocs/SOMEFOLDER/
cd /var/www/htdocs/SOMEFOLDER/
ls -l config.inc.php
sed '/^\//d; /^ \*/d; /^$/d' config.sample.inc.php > config.inc.php
vi config.inc.php
note. Just php-mcrypt is additionally needed by this version of phpmyadmin.:
change,
$cfg['blowfish_secret'] = 'ANYTHING HERE';
$cfg['Servers'][$i]['extension'] = 'mysqli';
and point your browser to,
http://NAMED_SERVER/SOMEFOLDER/
login as DBUSER/DBPASS.
 
Convertion script
Be careful this is only usable for a small home network, not production systems, as it causes a little service interruption (the appropriate word should rather be "corruption" as no host name resolution will be provided in that small amount of time) while recreating the table. Convert a hosts file (having fqdn at the end of lines) to sql queries,
copy/paste your hosts file to hosts.input
then,
vi schosts
like,
#!/bin/ksh
set -e

dbname=DBNAME
dbuser=DBUSER

serial=`date +%s`

cat <<EOF9
mysql -u$dbuser -p

use $dbname;
truncate table example_local;
insert into example_local values ('example.local', 259200, 'SOA', 'example.local. postmaster.example.local. $serial 28800 7200 86400 28800');
insert into example_local values ('example.local', 259200, 'NS', 'ns.example.local.');
insert into example_local values ('example.local', 259200, 'MX', '5 mx.example.local.');

EOF9

sed '/^$/d; /^#/d;' hosts.input | while read line; do
ip=`echo "$line" | awk '{print $1}'`
long=`echo "$line" | awk '{print $NF}'`
cat <<EOF9
insert into example_local values ('$long', 259200, 'A', '$ip');
EOF9
unset ip long
done
note. Change DBNAME and DBUSER accordingly.
note. if you need to add CNAME you'll have to tune that script for,
  insert into example_local values ('some.host.example.local', 259200, 'CNAME', 'some.other.host.example.local.');
note. assuming the ns.example.local host is defined within your hosts file.
enable the script,
chmod +x schosts
 
The changes are immediate, no need to reload named with kill -HUP.
 
References
mysql-bind/README
bind-9.7.1-P2/README
bind-9.7.1-P2/doc/misc/SDB
http://mysql-bind.sourceforge.net/
http://goes-gsoc.zerothree.net/2009/05/09/mysql-bind-sdb-driver/
 

Last update: Aug 31, 2014