Hi, all! I'm not finding anything on the web about this, so I'm hoping
someone here can help.
I'm trying to use dbiproxy with PostgreSQL. I'm running Debian Sarge/i386,
and the Perl, DBI, and PostgreSQL that come with it. (Perl 5.8.4, DBI 1.46,
PostgreSQL 7.4.7)
My test script looks like this:
use DBI;
my $dsn = "DBI:Pg:dbname=decks";
my $proxy = "hostname=goliath;port=3333";
my $dbh = DBI->connect("DBI:Proxy:$proxy;dsn=$dsn", 'mason', 'test');
$dbh and $dbh->disconnect();
print "Connecting directly.\n";
$dbh = DBI->connect("$dsn", "mason", "test");
$dbh and $dbh->disconnect();
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:
Sep 9 16:50:27 goliath DBI::ProxyServer[17108]: Error while connecting to DBI:P
g:dbname=decks as mason: DBI::ProxyServer connect('dbname=decks','mason',...)
failed: FATAL: IDENT authentication failed for user "mason" [err=1,state=S1000
] at /usr/bin/dbiproxy line 24
Sep 9 16:50:27 goliath DBI::ProxyServer[17108]: Refusing client
Can someone suggest to me what's happening to cause this?
FWIW, I've got identd running through inetd, in case that's what it wanted.
Here's my proxy config:
{
facility => 'daemon',
pidfile => '/tmp/dbiproxy.pid',
user => 'nobody',
group => 'nogroup',
localport => '3333',
mode => 'fork',
clients => [
{
mask => '.*',
accept => 1,
users => [ 'mason' ]
}
]
}
Thanks in advance for clues!
--
Mason Loring Bliss [EMAIL PROTECTED] http://blisses.org/
All which is forgotten need not necessarily be dead... H.P. Lovecraft
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
