LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (http://www.linuxquestions.org/questions/linux-server-73/)
-   -   BIND9 Issue (http://www.linuxquestions.org/questions/linux-server-73/bind9-issue-902268/)

whit3fir3 09-10-2011 06:12 AM

BIND9 Issue
 
The short version of what I am trying to do is get BIND to use a MySQL database for its zone files. I have a fresh install of Fedora 15 that I am using to test this and I have installed bind-sdb-9.8.0-9.P4.fc15.x86_64.

When BIND starts up I can see it register all the drivers, specifically the MySQL DB Drivers:

Code:

10-Sep-2011 04:02:46.389 Registering DLZ postgres driver.
10-Sep-2011 04:02:46.389 Registering SDLZ driver 'postgres'
10-Sep-2011 04:02:46.389 Registering DLZ driver 'postgres'
10-Sep-2011 04:02:46.389 Registering DLZ mysql driver.
10-Sep-2011 04:02:46.389 Registering SDLZ driver 'mysql'
10-Sep-2011 04:02:46.389 Registering DLZ driver 'mysql'
10-Sep-2011 04:02:46.389 Registering DLZ filesystem driver.
10-Sep-2011 04:02:46.389 Registering SDLZ driver 'filesystem'
10-Sep-2011 04:02:46.389 Registering DLZ driver 'filesystem'
10-Sep-2011 04:02:46.389 Registering DLZ ldap driver.
10-Sep-2011 04:02:46.389 Registering SDLZ driver 'ldap'
10-Sep-2011 04:02:46.389 Registering DLZ driver 'ldap'
10-Sep-2011 04:02:46.389 SDB ldap zone database module loaded.
10-Sep-2011 04:02:46.389 SDB postgreSQL DB zone database module loaded.
10-Sep-2011 04:02:46.389 SDB sqlite3 DB zone database module loaded.
10-Sep-2011 04:02:46.389 SDB directory DB zone database module loaded.
10-Sep-2011 04:02:46.390 decrement_reference: delete from rbt: 0x7fccee647068 .
10-Sep-2011 04:02:46.393 loading configuration from '/etc/named.conf'

Once all that completes I get the following error for the one zone file that I have loaded up in my named.conf file and in the MySQL database:

Code:

10-Sep-2011 04:02:46.409 zone example.com/IN: starting load
10-Sep-2011 04:02:46.409 unsupported database type 'mysqldb'
10-Sep-2011 04:02:46.409 zone example.com/IN: loading zone: creating database: not found

What I have in my named.conf file for this zone is as follows:
Code:

zone "example.com" {
  type master;
  notify no;
  database "mysqldb DATABASE_NAME TABLE_NAME localhost MYSQL_USER_NAME MYSQL_PASSWORD";
};

I am out of ideas as to why this refuses to work and am looking for any suggestions that would assist me in making this function properly.

Thanks,

whit3fir3

kbp 09-10-2011 09:11 AM

'yum info bind-sdb' doesn't mention mysql support and from this output:

Quote:

10-Sep-2011 04:02:46.389 SDB ldap zone database module loaded.
10-Sep-2011 04:02:46.389 SDB postgreSQL DB zone database module loaded.
10-Sep-2011 04:02:46.389 SDB sqlite3 DB zone database module loaded.
10-Sep-2011 04:02:46.389 SDB directory DB zone database module loaded.
.. I would have expected to see an equivalent mysql entry. Are you sure it's supported?

<edit> just in case you need to build it yourself: http://mysql-bind.sourceforge.net/docs.php</edit>

CaptTofu 10-12-2012 02:18 PM

mysql-bind status
 
Hi all,

How did your efforts to use mysql-bind go? I do have it working with the latest version of bind 9.8.2 but haven't done much with it yet. Is anyone here using it much?


All times are GMT -5. The time now is 10:47 AM.