help with bind

[Agnello George]

>
>
> 1: Adam didn't tell OP that his is the only 9.4.1-P1 srpm available for
> Red Hat-derived systems, nor where to find it:
> http://people.redhat.com/atkac/bind/;
>
> 2: If OP doesn't know what an srpm is, what to do with it (including
> modifying the spec file) then he has a serious problem which is beyond the
> scope of this list.


HI Again !!

I  have fianlly installed the source rpm package thanks for the link.


[root at bind i386]# rpm -qa |grep bind
bind-libs-9.5.0-16.3.a6.fc7
bind-devel-9.5.0-16.3.a6.fc7
bind-9.5.0-16.3.a6.fc7
bind-debuginfo-9.5.0-16.3.a6.fc7
bind-utils-9.5.0-16.3.a6.fc7
bind-chroot-9.5.0-16.3.a6.fc7
[root at bind i386]#

In the named.conf i have added the following lines :
( do i need to comment out the rest of the text )

dlz "Mysql zone" {
   database "mysql
   {host=localhost dbname=binddlzdb user=binddlzuser pass=binddlzpassword}
   {select zone from dns_records where zone = '%zone%'}
   {select ttl, type, mx_priority, case when lower(type)='txt' then
concat('\"', data, '\"')
        else data end from dns_records where zone = '%zone%' and host =
'%record%'
        and not (type = 'SOA' or type = 'NS')}
   {select ttl, type, mx_priority, data, resp_person, serial, refresh,
retry, expire, minimum
        from dns_records where zone = '%zone%' and (type = 'SOA' or
type='NS')}
   {select ttl, type, host, mx_priority, data, resp_person, serial, refresh,
retry, expire,
        minimum from dns_records where zone = '%zone%' and not (type = 'SOA'
or type = 'NS')}
   {select zone from xfr_table where zone = '%zone%' and client =
'%client%'}
   {update data_count set count = count + 1 where zone ='%zone%'}";
};



##############################################################

Here is the steps i followed to create the database layout :

mysqladmin -u root password password_passwd

mysqladmin -u root -p create binddlzdb

Change to the MySQL database administration and add the bind-dlz user and
password:

USE mysql;
INSERT INTO user (Host, User, Password) VALUES
('localhost','binddlzuser',password('binddlzpassword'));
INSERT INTO db (Host, Db, User, Select_priv) VALUES
('localhost','binddlzdb','binddlzuser','Y');

Setup the rights for the just created users:

FLUSH PRIVILEGES;
GRANT USAGE ON binddlzdb.* TO binddlzuser at localhost;
GRANT SELECT, INSERT, DELETE, UPDATE ON binddlzdb.* TO binddlzuser at localhost
;

Following is the table layout

CREATE TABLE `records` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `zone` varchar(255) NOT NULL,
  `ttl` int(11) NOT NULL default '86400',
  `type` varchar(255) NOT NULL,
  `host` varchar(255) NOT NULL default '@',
  `mx_priority` int(11) default NULL,
  `data` text,
  `primary_ns` varchar(255) default NULL,
  `resp_contact` varchar(255) default NULL,
  `serial` bigint(20) default NULL,
  `refresh` int(11) default NULL,
  `retry` int(11) default NULL,
  `expire` int(11) default NULL,
  `minimum` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `type` (`type`),
  KEY `host` (`host`),
  KEY `zone` (`zone`)
);

CREATE TABLE `xfr` (
  `zone` varchar(255) NOT NULL,
  `client` varchar(255) NOT NULL,
  KEY `zone` (`zone`),
  KEY `client` (`client`)
);

quit;

But now  if i try to start named it fails and i get  the following error
logs :  ( /var/log/messages )

[root at bind i386]# tail -f /var/log/messages
Nov 12 22:59:06 bind named[25300]: SDB directory DB zone database module
loaded.
Nov 12 22:59:06 bind named[25300]: loading configuration from
'/etc/named.conf'
Nov 12 22:59:06 bind named[25300]: listening on IPv6 interface lo, ::1#53
Nov 12 22:59:06 bind named[25300]: listening on IPv4 interface lo,
127.0.0.1#53
Nov 12 22:59:06 bind named[25300]: Loading 'Mysql zone' using driver mysql
Nov 12 22:59:06 bind named[25300]: mysql driver failed to create database
connection after 4 attempts
Nov 12 22:59:06 bind named[25300]: SDLZ driver failed to load.
Nov 12 22:59:06 bind named[25300]: DLZ driver failed to load.
Nov 12 22:59:06 bind named[25300]: loading configuration: failure
Nov 12 22:59:06 bind named[25300]: exiting (due to fatal error)

###################################################################
 Can some one tell me what need to be done here ... am i on track ? or
totally off track ?

Thanks again :-)


-- 
>
> Agnello . G .Dsouza