psql and md5

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.

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(at)postgresql(dot)org

--
Simon Windsor
Email: simon(dot)windsor(at)cornfield(dot)org(dot)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(at)postgresql(dot)org
--
Markus Bertheau <twanger(at)bluetwanger(dot)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:
> 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(at)postgresql(dot)org

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.