psql and md5

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 majordomo@postgresql.org

--
Simon Windsor
Email: simon.windsor@cornfield.org.uk
Tel: 01454 617689
Mob: 07960 321599

В Пнд, 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
----------------------------------
acbd18db4cc2f85cedef654fccc4a4d8
(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 majordomo@postgresql.org

--
Markus Bertheau <twanger@bluetwanger.de>

I guess :

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

select md5('abcdef');
md5
----------------------------------
e80b5017098950fc58aad83c8c14978e
(1 ligne)

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.

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:

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.