I'm taking a wild guess here since it's been a long time since I've used
dbiproxy and/or PostgreSQL - going by the error message
failed: FATAL: IDENT authentication failed for user "mason"
I'd say that your connection string user name/password was rejected by
Postgres. I've found PostgreSQL's authentication can be rather tricky
to get working right.
Hardy Merrill
>>> Mason Loring Bliss <[EMAIL PROTECTED]> 9/12/2005 12:40:35 PM >>>
On Mon, Sep 12, 2005 at 12:14:07PM -0400, Mason Loring Bliss wrote:
> I can connect to the database using $dsn directly, and I can connect
using
> psql, but dbiproxy logs this when I try to connect using it:
FWIW, I get more when I log to the terminal, instead of syslog:
Mon Sep 12 12:37:03 2005 err, 1, Error while connecting to
DBI:Pg:dbname=oracle as mason: DBI::ProxyServer
connect('dbname=oracle','mason',...) failed: FATAL: IDENT
authentication failed for user "mason"
[err=1,state=S1000] at /usr/lib/perl5/DBI.pm line 604 thread 1
DBI::__ANON__('undef', 'undef') called at /usr/lib/perl5/DBI.pm
line 660 thread 1
DBI::connect('DBI::ProxyServer', 'DBI:Pg:dbname=oracle',
'mason', 'testing', 'HASH(0x85947e8)') called at
/usr/lib/perl5/DBI/ProxyServer.pm line 200 thread 1
eval {...} called at /usr/lib/perl5/DBI/ProxyServer.pm line 189
thread 1
DBI::ProxyServer::AcceptUser('DBI::ProxyServer=HASH(0x839f69c)',
'mason', 'testing') called at /usr/share/perl5/RPC/PlServer.pm line 171
thread 1
RPC::PlServer::Accept('DBI::ProxyServer=HASH(0x839f69c)')
called at /usr/share/perl5/Net/Daemon.pm line 506 thread 1
eval {...} called at /usr/share/perl5/Net/Daemon.pm line 505
thread 1
Net::Daemon::HandleChild('DBI::ProxyServer=HASH(0x839f69c)')
called at /usr/share/perl5/Net/Daemon.pm line 466 thread 1
Net::Daemon::__ANON__('DBI::ProxyServer=HASH(0x839f69c)',
'HandleChild') called at /usr/share/perl5/Net/Daemon.pm line 468 thread
1
eval {...} called at /usr/share/perl5/Net/Daemon.pm line 468
thread 1
Mon Sep 12 12:37:03 2005 err, 1, Refusing client
Thanks in advance for clues!
--
/\
Mason Loring Bliss /()\ http://blisses.org/
Squeak to me of love! / \ [EMAIL PROTECTED]
