Re: Red Hat Enterprise Linux Server release 5.3

On Thu, Mar 5, 2009 at 1:30 PM, Bradley Giesbrecht <[email protected]> wrote:
> Hello List,
>
> I'm unable to get named to return quires from mysql.
>
> Could someone help me figure if the dlz-mysql driver is actually loaded?
> I'm not very familiar with RHEL.

On your mysql server, add this to the /etc/my.cnf:

log=/var/lib/mysql/query.log

Then restart mysql.  Then do a few queries.  If you don't see any
queries getting put into the (plain text file) query.log, then your
bind is not asking mysql anything.  A double check is to run on the
dns server:

tcpdump -n -p -s 1500 -X port 3306

If you don't see any output, then you've verified that your bind is
not asking the mysql server any information.

Put your named.conf (and any files it includes, obfuscating passwords)
in your next email.  There might be something really obvious wrong
with it.  Also, most bind configurations are configured to use
changeroot by default, which means you should probably be looking at
/var/named/chroot/etc/named.conf (may vary in your configuration)
instead of /etc/named.conf.

-- 
Regards...      Todd
All truth passes through three stages. First, it is ridiculed. Second,
it is violently opposed. Third, it is accepted as being self-evident.

------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H