Re: dlz ignores connection to postgres database
data tanger <[email protected]> Thu, 22 Mar 2012 17:29:38 +0100
| Newsgroups | gmane.network.dns.bind9.dlz |
|---|---|
| Message-ID | <[email protected]> |
--===============3712704951442081831== Content-Type: multipart/alternative; boundary="_e0668fe2-4199-4664-b987-16611932da73_" --_e0668fe2-4199-4664-b987-16611932da73_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable This the output of the command you showed me: # strings /usr/sbin/named | grep -i DLZ'--build=3Dx86_64-redhat-linux-gnu' = '--host=3Dx86_64-redhat-linux-gnu' '--target=3Dx86_64-redhat-linux-gnu' '--= program-prefix=3D' '--prefix=3D/usr' '--exec-prefix=3D/usr' '--bindir=3D/us= r/bin' '--sbindir=3D/usr/sbin' '--sysconfdir=3D/etc' '--datadir=3D/usr/shar= e' '--includedir=3D/usr/include' '--libdir=3D/usr/lib64' '--libexecdir=3D/u= sr/libexec' '--sharedstatedir=3D/usr/com' '--mandir=3D/usr/share/man' '--in= fodir=3D/usr/share/info' '--with-libtool' '--localstatedir=3D/var' '--enabl= e-threads' '--enable-ipv6' '--with-pic' '--disable-static' '--disable-opens= sl-version-check' '--with-pkcs11=3D/usr/lib64/pkcs11/PKCS11_API.so' '--with= -dlz-ldap=3Dyes' '--with-dlz-postgres=3Dyes' '--with-dlz-mysql=3Dyes' '--wi= th-dlz-filesystem=3Dyes' '--with-gssapi=3Dyes' '--disable-isc-spnego' 'CFLA= GS=3D -O2 -g -pipe -Wall -Wp=2C-D_FORTIFY_SOURCE=3D2 -fexceptions -fstack-p= rotector --param=3Dssp-buffer-size=3D4 -m64 -mtune=3Dgeneric' 'CPPFLAGS=3D = -DDIG_SIGCHASE' 'CXXFLAGS=3D-O2 -g -pipe -Wall -Wp=2C-D_FORTIFY_SOURCE=3D2 = -fexceptions -fstack-protector --param=3Dssp-buffer-size=3D4 -m64 -mtune=3D= generic' 'FFLAGS=3D-O2 -g -pipe -Wall -Wp=2C-D_FORTIFY_SOURCE=3D2 -fexcepti= ons -fstack-protector --param=3Dssp-buffer-size=3D4 -m64 -mtune=3Dgeneric' = 'build_alias=3Dx86_64-redhat-linux-gnu' 'host_alias=3Dx86_64-redhat-linux-g= nu' 'target_alias=3Dx86_64-redhat-linux-gnu' I think the binaries I installed were built with dlz support. I have this v= ersion # named -versionBIND 9.7.3-RedHat-9.7.3-1.el5 > Date: Thu=2C 22 Mar 2012 06:29:12 -0700 > From: [email protected] > To: [email protected] > Subject: Re: [Bind-dlz-testers] dlz ignores connection to postgres databa= se >=20 > 2012/3/22 data tanger <[email protected]>: > > My problem is not with queries but with the connection to the database.= For > > instance with postgresql=2C I connect with user postgres and type the f= ollwing > > command to list current connections: > > > > select * from pg_stat_activity=3B > > > > the result only displays one connection while it had to display at leas= t two > > as one mut be used by named (a permanent connection according to the > > documentation). > > > > The same thing happens with mysql=2C when I type: > > > > show provcesslist=3B > > > > I only get one connection. I believe that named does not connect to the > > database=2C but it does not diplsay any error message so that I can deb= ug the > > issue. >=20 > See if your binary actually has DLZ built into it: >=20 > [root@ivdns51 ~]# strings /usr/sbin/named | grep DLZ > Unregistering DLZ mysql driver. > Registering DLZ mysql driver. >=20 > On an older system=2C the binary was actually called named-sdb instead > of just named=2C but it hasn't been that way for a while now. >=20 > ...Todd > --=20 > Always code as if the guy who ends up maintaining your code will be a > violent psychopath who knows where you live. -- Martin Golding >=20 > -------------------------------------------------------------------------= ----- > This SF email is sponsosred by: > Try Windows Azure free for 90 days Click Here=20 > http://p.sf.net/sfu/sfd2d-msazure > _______________________________________________ > Bind-dlz-testers mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers = --_e0668fe2-4199-4664-b987-16611932da73_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <html> <head> <style><!-- .hmmessage P { margin:0px=3B padding:0px } body.hmmessage { font-size: 10pt=3B font-family:Tahoma } --></style></head> <body class=3D'hmmessage'><div dir=3D'ltr'> This the output of the command you showed me:<div><br></div><div><div># str= ings /usr/sbin/named | grep -i DLZ</div><div>'--build=3Dx86_64-redhat-linux= -gnu' '--host=3Dx86_64-redhat-linux-gnu' '--target=3Dx86_64-redhat-linux-gn= u' '--program-prefix=3D' '--prefix=3D/usr' '--exec-prefix=3D/usr' '--bindir= =3D/usr/bin' '--sbindir=3D/usr/sbin' '--sysconfdir=3D/etc' '--datadir=3D/us= r/share' '--includedir=3D/usr/include' '--libdir=3D/usr/lib64' '--libexecdi= r=3D/usr/libexec' '--sharedstatedir=3D/usr/com' '--mandir=3D/usr/share/man'= '--infodir=3D/usr/share/info' '--with-libtool' '--localstatedir=3D/var' '-= -enable-threads' '--enable-ipv6' '--with-pic' '--disable-static' '--disable= -openssl-version-check' '--with-pkcs11=3D/usr/lib64/pkcs11/PKCS11_API.so' '= <font color=3D"#ff0000">--with-dlz-ldap=3Dyes</font>' '<font color=3D"#ff00= 00">--with-dlz-postgres=3Dyes</font>' '<font color=3D"#ff0000">--with-dlz-m= ysql=3Dyes</font>' '<font color=3D"#ff0000">--with-dlz-filesystem=3Dyes</fo= nt>' '--with-gssapi=3Dyes' '--disable-isc-spnego' 'CFLAGS=3D -O2 -g -pipe -= Wall -Wp=2C-D_FORTIFY_SOURCE=3D2 -fexceptions -fstack-protector --param=3Ds= sp-buffer-size=3D4 -m64 -mtune=3Dgeneric' 'CPPFLAGS=3D -DDIG_SIGCHASE' 'CXX= FLAGS=3D-O2 -g -pipe -Wall -Wp=2C-D_FORTIFY_SOURCE=3D2 -fexceptions -fstack= -protector --param=3Dssp-buffer-size=3D4 -m64 -mtune=3Dgeneric' 'FFLAGS=3D-= O2 -g -pipe -Wall -Wp=2C-D_FORTIFY_SOURCE=3D2 -fexceptions -fstack-protecto= r --param=3Dssp-buffer-size=3D4 -m64 -mtune=3Dgeneric' 'build_alias=3Dx86_6= 4-redhat-linux-gnu' 'host_alias=3Dx86_64-redhat-linux-gnu' 'target_alias=3D= x86_64-redhat-linux-gnu'</div><div><br></div><div>I think the binaries I in= stalled were built with dlz support. I have this version</div><div><br></di= v><div><div># named -version</div><div>BIND 9.7.3-RedHat-9.7.3-1.el5</div><= /div><div><br></div><div><br></div><div><br></div><br><div><div id=3D"SkyDr= ivePlaceholder"></div>>=3B Date: Thu=2C 22 Mar 2012 06:29:12 -0700<br>>= =3B From: [email protected]<br>>=3B To: [email protected]= e.net<br>>=3B Subject: Re: [Bind-dlz-testers] dlz ignores connection to p= ostgres database<br>>=3B <br>>=3B 2012/3/22 data tanger <=3Bdatatange= [email protected]>=3B:<br>>=3B >=3B My problem is not with queries but wit= h the connection to the database. For<br>>=3B >=3B instance with postgr= esql=2C I connect with user postgres and type the follwing<br>>=3B >=3B= command to list current connections:<br>>=3B >=3B<br>>=3B >=3B sel= ect * from pg_stat_activity=3B<br>>=3B >=3B<br>>=3B >=3B the result= only displays one connection while it had to display at least two<br>>= =3B >=3B as one mut be used by named (a permanent connection according to= the<br>>=3B >=3B documentation).<br>>=3B >=3B<br>>=3B >=3B The= same thing happens with mysql=2C when I type:<br>>=3B >=3B<br>>=3B &= gt=3B show provcesslist=3B<br>>=3B >=3B<br>>=3B >=3B I only get one= connection. I believe that named does not connect to the<br>>=3B >=3B = database=2C but it does not diplsay any error message so that I can debug t= he<br>>=3B >=3B issue.<br>>=3B <br>>=3B See if your binary actually= has DLZ built into it:<br>>=3B <br>>=3B [root@ivdns51 ~]# strings /usr= /sbin/named | grep DLZ<br>>=3B Unregistering DLZ mysql driver.<br>>=3B = Registering DLZ mysql driver.<br>>=3B <br>>=3B On an older system=2C th= e binary was actually called named-sdb instead<br>>=3B of just named=2C b= ut it hasn't been that way for a while now.<br>>=3B <br>>=3B ...Todd<br= >>=3B -- <br>>=3B Always code as if the guy who ends up maintaining you= r code will be a<br>>=3B violent psychopath who knows where you live. -- = Martin Golding<br>>=3B <br>>=3B ---------------------------------------= ---------------------------------------<br>>=3B This SF email is sponsosr= ed by:<br>>=3B Try Windows Azure free for 90 days Click Here <br>>=3B h= ttp://p.sf.net/sfu/sfd2d-msazure<br>>=3B ________________________________= _______________<br>>=3B Bind-dlz-testers mailing list<br>>=3B Bind-dlz-= [email protected]<br>>=3B https://lists.sourceforge.net/lists= /listinfo/bind-dlz-testers<br></div></div> </div></body> </html>= --_e0668fe2-4199-4664-b987-16611932da73_-- --===============3712704951442081831== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline ------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure --===============3712704951442081831== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Bind-dlz-testers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers --===============3712704951442081831==--