pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedDBD::Pg and .pgpass
2+ messages / 2 participants
[nested] [flat]
* DBD::Pg and .pgpass
@ 2005-04-13 19:04 Brian Trammell <bht@cert.org>
2005-05-05 01:10 ` Re: [INTERFACES] DBD::Pg and .pgpass Greg Sabino Mullane <greg@turnstep.com>
0 siblings, 1 reply; 2+ messages in thread
From: Brian Trammell @ 2005-04-13 19:04 UTC (permalink / raw)
To: psql-interfaces@postgresql.org
Greetings,
I'm trying to run a Perl script connecting to a PostgreSQL database via
DBI and DBD::Pg as a cron job. I'm already using the .pgpass mechanism
for managing md5 passwords on the client side and would like to use the
same mechanism for connecting from the Perl script. This does not,
however, appear to work. Passing either "" or undef for the password
yields "no password supplied at <script> line <line>".
Though I could (and probably will, as I'm under some time pressure
here) easily hack in a .pgpass parser to the Perl script, this strikes
me as unconscionably inelegant. Is there some magic I'm missing to get
DBD::Pg to play nice with .pgpass, or is this a bug in DBD::Pg (1.21)
or the Postgres (8.0.1) client side itself?
Regards,
Brian
--
Brian H. Trammell / MTS, CERT/NetSA / <bht@cert.org> / 412.268.9748
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] DBD::Pg and .pgpass
2005-04-13 19:04 DBD::Pg and .pgpass Brian Trammell <bht@cert.org>
@ 2005-05-05 01:10 ` Greg Sabino Mullane <greg@turnstep.com>
0 siblings, 0 replies; 2+ messages in thread
From: Greg Sabino Mullane @ 2005-05-05 01:10 UTC (permalink / raw)
To: pgsql-interfaces; +Cc: pgsql-hackers@postgresql.org
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> I'm trying to run a Perl script connecting to a PostgreSQL database via
> DBI and DBD::Pg as a cron job. I'm already using the .pgpass mechanism
> for managing md5 passwords on the client side and would like to use the
> same mechanism for connecting from the Perl script. This does not,
> however, appear to work. Passing either "" or undef for the password
> yields "no password supplied at <script> line <line>".
I know that this was a libpq bug in the past (circa 2002) but I thought it
had been fixed. I am ccing this to the hackers list to see if anyone can
verify this.
- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200505040905
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iD8DBQFCeMjQvJuQZxSWSsgRAhLjAKDwVc1nIHPaAQIME6XpRfQv9uif4wCgjk51
xGLEKTOf0S157j5halCHKNg=
=T3wQ
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-05-05 01:10 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-13 19:04 DBD::Pg and .pgpass Brian Trammell <bht@cert.org>
2005-05-05 01:10 ` Greg Sabino Mullane <greg@turnstep.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox