Thread: 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@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: > 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
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.