psql and md5

[John DeSoi]

Is there a way to provide a md5 password directly to psql? I'm aware of
pgpass but I would like to store a md5 password in some other location
and then use it to execute commands with psql.

Thanks,

John DeSoi, Ph.D.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

[Simon Windsor]

Hi

You can always generate the md5 password using perl/php and store the password
in database. I believe the next version of pgsql will have an internal md5
function.

Simon

On Monday 02 August 2004 15:43, John DeSoi wrote:

Is there a way to provide a md5 password directly to psql? I'm aware of
pgpass but I would like to store a md5 password in some other location
and then use it to execute commands with psql.

Thanks,

John DeSoi, Ph.D.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

--
Simon Windsor
Email: si***********@c ornfield.org.uk
Tel: [phone]
Mob: [phone]

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

[Markus Bertheau]

В Пнд, 02.08.2004, в 19:21, Simon Windsor пишет:

Hi

You can always generate the md5 password using perl/php and store the password
in database. I believe the next version of pgsql will have an internal md5
function.
template1=# select version();

version
---------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 7.4.2 on i386-redhat-linux-gnu, compiled by GCC
i386-redhat-linux-gcc (GCC) 3.3.3 20040216 (Red Hat Linux 3.3.3-2.1)
(1 запи�ь)

template1=# select md5('foo');
md5
----------------------------------
acbd18db4cc2f85 cedef654fccc4a4 d8
(1 запи�ь)


Simon

On Monday 02 August 2004 15:43, John DeSoi wrote:

Is there a way to provide a md5 password directly to psql? I'm aware of
pgpass but I would like to store a md5 password in some other location
and then use it to execute commands with psql.

Thanks,

John DeSoi, Ph.D.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

--
Markus Bertheau <tw*****@bluetw anger.de>
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

[Pierre-Frédéric Caillaud]

I guess :

Bienvenue dans psql 7.4.2, l'interface interactive de PostgreSQL.

select md5('abcdef');
md5
----------------------------------
e80b5017098950f c58aad83c8c1497 8e
(1 ligne)

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

[John DeSoi]

On Aug 2, 2004, at 1:21 PM, Simon Windsor wrote:

You can always generate the md5 password using perl/php and store the
password
in database. I believe the next version of pgsql will have an internal
md5
function.

psql is a client application. It supports md5 as an authentication
method to the server, but the password provided to psql must be plain
text as far as I can tell. My goal here is to store some psql
connection information in something like the pgpass file, but I don't
want to leave passwords without some kind of protection.

Best,
John DeSoi, Ph.D.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Tommi Maekitalo]

Hi,

this would not be very useful. The database you are talking to needs to know
if you know the password and not only the md5-password. If you only need to
tell psql the md5-password, you don't need to know the real one.
Tommi
Am Montag, 2. August 2004 16:43 schrieb John DeSoi:

Is there a way to provide a md5 password directly to psql? I'm aware of
pgpass but I would like to store a md5 password in some other location
and then use it to execute commands with psql.

Thanks,

John DeSoi, Ph.D.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

[John DeSoi]

On Aug 5, 2004, at 7:29 AM, Tommi Maekitalo wrote:

this would not be very useful. The database you are talking to needs
to know
if you know the password and not only the md5-password. If you only
need to
tell psql the md5-password, you don't need to know the real one.

Yes, you are right. I did not think the issues through clearly enough
before posting my question.

I have resolved things by using reversible encryption to store the
passwords (blowfish).

Best,

John DeSoi, Ph.D.
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend