Re: dlz ignores connection to postgres database

Todd Lyons <[email protected]> Fri, 23 Mar 2012 07:54:55 -0700
Newsgroups gmane.network.dns.bind9.dlz
Message-ID <CAFG21ojwyRu=Cj54kntATP=UJfjipRmV41Mjpr+TTt8MjMe8pA@mail.gmail.com>
2012/3/22 data tanger <[email protected]>
>
> This the output of the command you showed me:
>
> # strings /usr/sbin/named | grep -i DLZ
> '--build=x86_64-redhat-linux-gnu' '--host=x86_64-redhat-linux-gnu'
> '--target=x86_64-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr'
> '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin'
> '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include'
> '--libdir=/usr/lib64' '--libexecdir=/usr/libexec'
> '--sharedstatedir=/usr/com' '--mandir=/usr/share/man'
> '--infodir=/usr/share/info' '--with-libtool' '--localstatedir=/var'
> '--enable-threads' '--enable-ipv6' '--with-pic' '--disable-static'
> '--disable-openssl-version-check'
> '--with-pkcs11=/usr/lib64/pkcs11/PKCS11_API.so' '--with-dlz-ldap=yes'
> '--with-dlz-postgres=yes' '--with-dlz-mysql=yes' '--with-dlz-filesystem=yes'
> '--with-gssapi=yes' '--disable-isc-spnego' 'CFLAGS= -O2 -g -pipe -Wall
> -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector
> --param=ssp-buffer-size=4 -m64 -mtune=generic' 'CPPFLAGS= -DDIG_SIGCHASE'
> 'CXXFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic' 'FFLAGS=-O2
> -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector
> --param=ssp-buffer-size=4 -m64 -mtune=generic'
> 'build_alias=x86_64-redhat-linux-gnu' 'host_alias=x86_64-redhat-linux-gnu'
> 'target_alias=x86_64-redhat-linux-gnu'

That is really weird output, can you verify that you are in fact
looking at the binary and not some kind of compile time script?

[root@ivdns51 ~]# file /usr/sbin/named
/usr/sbin/named: ELF 64-bit LSB executable, AMD x86-64, version 1
(SYSV), for GNU/Linux 2.6.9, dynamically linked (uses shared libs),
for GNU/Linux 2.6.9, stripped

To be honest, I expect to see something like this:
[tlyons@ivwww01 ~/RPM/BUILD/bind-9.7.4-P1/bin/named]$ file named
named: Bourne shell script text executable

> I think the binaries I installed were built with dlz support. I have this
> version
>
> # named -version
> BIND 9.7.3-RedHat-9.7.3-1.el5

Basically the same version as my production system, though I'm rolling
out 9.7.4 next week to bring it current.

You said it doesn't even seem to connect to the database server.  What
happens when you do:

[root@ivdns51 ~]# netstat -t | grep -E ':(mysql|postgres)'
tcp        0      0 ivdns51.ivenue.net:mysql
ivwm51.ivenue.net:42760     ESTABLISHED
tcp        0      0 ivdns51.ivenue.net:37392
ivdb51.ivenue.net:mysql     ESTABLISHED
tcp        0      0 ivdns51.ivenue.net:mysql
ivwm51.ivenue.net:57622     ESTABLISHED
tcp        0      0 ivdns51.ivenue.net:mysql
ivwm51.ivenue.net:59702     ESTABLISHED
tcp        0      0 ivdns51.ivenue.net:42595
ivdns51.ivenue.net:mysql    ESTABLISHED
tcp        0     75 ivdns51.ivenue.net:mysql
ivdns51.ivenue.net:42595    ESTABLISHED
tcp        0      0 ivdns51.ivenue.net:mysql
ivwm51.ivenue.net:33662     ESTABLISHED
tcp        0      0 ivdns51.ivenue.net:mysql
ivwm51.ivenue.net:33651     TIME_WAIT
tcp        0      0 ivdns51.ivenue.net:mysql
ivwm51.ivenue.net:42352     ESTABLISHED
tcp        0      0 ivdns51.ivenue.net:mysql
ivwm51.ivenue.net:44150     ESTABLISHED
tcp        0      0 ivdns51.ivenue.net:mysql
ivwm51.ivenue.net:57243     ESTABLISHED
tcp        0      0 ivdns51.ivenue.net:mysql
ivwm51.ivenue.net:50076     ESTABLISHED
tcp        0      0 ivdns51.ivenue.net:mysql
ivwm51.ivenue.net:57760     ESTABLISHED
tcp        0      0 ivdns51.ivenue.net:mysql
ivwm51.ivenue.net:57530     ESTABLISHED
tcp        0      0 ivdns51.ivenue.net:mysql
ivwm51.ivenue.net:41673     ESTABLISHED
tcp        0      0 ivdns51.ivenue.net:mysql
ivwm51.ivenue.net:34543     ESTABLISHED
tcp        0      0 ivdns51.ivenue.net:mysql
ivwm51.ivenue.net:42747     ESTABLISHED

...Todd
--
Always code as if the guy who ends up maintaining your code will be a
violent psychopath who knows where you live. -- Martin Golding

------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here 
http://p.sf.net/sfu/sfd2d-msazure