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 wants,
but I'm guessing it's not.
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!
PS: This isn't an issue with the database itself. I can connect to that, and
in fact I get my error message even if the database is not actually running.
--
Mason Loring Bliss [EMAIL PROTECTED] http://blisses.org/
"I am a brother of jackals, and a companion of ostriches." (Job 30 : 29)
