Re: dlz ignores connection to postgres database

2012/3/22 data tanger <[email protected]>:
> My problem is not with queries but with the connection to the database. For
> instance with postgresql, I connect with user postgres and type the follwing
> command to list current connections:
>
> select * from pg_stat_activity;
>
> the result only displays one connection while it had to display at least two
> as one mut be used by named (a permanent connection according to the
> documentation).
>
> The same thing happens with mysql, when I type:
>
> show provcesslist;
>
> I only get one connection. I believe that named does not connect to the
> database, but it does not diplsay any error message so that I can debug the
> issue.

See if your binary actually has DLZ built into it:

[root@ivdns51 ~]# strings /usr/sbin/named | grep DLZ
Unregistering DLZ mysql driver.
Registering DLZ mysql driver.

On an older system, the binary was actually called named-sdb instead
of just named, but it hasn't been that way for a while now.

...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