Postgres Pro
Downloads
Home   >   mailing lists

Thread: password encyption

password encyption

From
Ivan Horvath
Date:
Hi All,
 
i created a user in pgadmin, specified a password of course. the user is created, but the password is encypted somehow., i cannot log in anymore!!!
please help me, what is the problem

Best Regards,

Iván Horváth
Chief Programmer

Alcatel NSD
PMS 2000 Product Team

H-1116, Budapest
Kondorfa u. 10.
Tel.: +36 1 209 9546
Fax.: +36 1 463 7271
Mobil: +36 30 257 0235
E-mail: i.horvath@alco.co.hu
Check my Web Page

Anyone who has never made a mistake has never tried anything new.

/Albert Einstein/

Re: password encyption

From
Dave Page
Date:
Hi,
 
Under Tools -> Options, on the PostgreSQL tab, uncheck the box labelled 'Use Encrypted Passwords', and then alter the password for your user.
 
Regards, Dave.
-----Original Message-----
From: Ivan Horvath [mailto:i.horvath@alco.co.hu]
Sent: 13 March 2002 10:53
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] password encyption

Hi All,
 
i created a user in pgadmin, specified a password of course. the user is created, but the password is encypted somehow., i cannot log in anymore!!!
please help me, what is the problem

Best Regards,

Iván Horváth
Chief Programmer

Alcatel NSD
PMS 2000 Product Team

H-1116, Budapest
Kondorfa u. 10.
Tel.: +36 1 209 9546
Fax.: +36 1 463 7271
Mobil: +36 30 257 0235
E-mail: i.horvath@alco.co.hu
Check my Web Page

Anyone who has never made a mistake has never tried anything new.

/Albert Einstein/

Re: password encyption

From
Ivan Horvath
Date:
Hi Dave,
 
 
ok thank you!
 
but nevertheless the encryption of the user password is not a bad idea, so what encyption method is used by pgadmin?
i mean i create a user with pgadmin, specify a password for the user
if i check the pg_shadow table i see a long text in the pasword field.
if i want to connect this user to the database, what kind encyption method i have to use?
 
Ivan
 
----- Original Message -----
From: Dave Page
Sent: Wednesday, March 13, 2002 12:15 PM
Subject: RE: [pgadmin-support] password encyption

Hi,
 
Under Tools -> Options, on the PostgreSQL tab, uncheck the box labelled 'Use Encrypted Passwords', and then alter the password for your user.
 
Regards, Dave.
-----Original Message-----
From: Ivan Horvath [mailto:i.horvath@alco.co.hu]
Sent: 13 March 2002 10:53
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] password encyption

Hi All,
 
i created a user in pgadmin, specified a password of course. the user is created, but the password is encypted somehow., i cannot log in anymore!!!
please help me, what is the problem

Best Regards,

Iván Horváth
Chief Programmer

Alcatel NSD
PMS 2000 Product Team

H-1116, Budapest
Kondorfa u. 10.
Tel.: +36 1 209 9546
Fax.: +36 1 463 7271
Mobil: +36 30 257 0235
E-mail: i.horvath@alco.co.hu
Check my Web Page

Anyone who has never made a mistake has never tried anything new.

/Albert Einstein/

Re: password encyption

From
Dave Page
Date:
pgAdmin doesn't use encryption itself, that tickbox just makes it use the ENCRYPTED keyword in CREATE/ALTER USER sql statements in PostgreSQL 7.2+. Check out the PostgreSQL 7.2 documentation for details on using the encrypted passwords.
 
BTW. PostgreSQL uses MD5.
 
Regards, Dave.
-----Original Message-----
From: Ivan Horvath [mailto:i.horvath@alco.co.hu]
Sent: 13 March 2002 11:34
To: Dave Page; pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] password encyption

Hi Dave,
 
 
ok thank you!
 
but nevertheless the encryption of the user password is not a bad idea, so what encyption method is used by pgadmin?
i mean i create a user with pgadmin, specify a password for the user
if i check the pg_shadow table i see a long text in the pasword field.
if i want to connect this user to the database, what kind encyption method i have to use?
 
Ivan
 
----- Original Message -----
From: Dave Page
Sent: Wednesday, March 13, 2002 12:15 PM
Subject: RE: [pgadmin-support] password encyption

Hi,
 
Under Tools -> Options, on the PostgreSQL tab, uncheck the box labelled 'Use Encrypted Passwords', and then alter the password for your user.
 
Regards, Dave.
-----Original Message-----
From: Ivan Horvath [mailto:i.horvath@alco.co.hu]
Sent: 13 March 2002 10:53
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] password encyption

Hi All,
 
i created a user in pgadmin, specified a password of course. the user is created, but the password is encypted somehow., i cannot log in anymore!!!
please help me, what is the problem

Best Regards,

Iván Horváth
Chief Programmer

Alcatel NSD
PMS 2000 Product Team

H-1116, Budapest
Kondorfa u. 10.
Tel.: +36 1 209 9546
Fax.: +36 1 463 7271
Mobil: +36 30 257 0235
E-mail: i.horvath@alco.co.hu
Check my Web Page

Anyone who has never made a mistake has never tried anything new.

/Albert Einstein/

Re: password encyption

From
"Peter E. Chen"
Date:
Ivan,
 
I tunnel my pgAdmin connection through an SSH connection to provide security for pgAdmin logins.  You can use the standard SSH port forwarding feature to have your pgAdmin connect to PostgreSQL.  I believe there is now documentation on how to use SSH port forwarding with pgAdmin. 
 
I hope this helps.
 
Peter
-----Original Message-----
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org]On Behalf Of Ivan Horvath
Sent: Wednesday, March 13, 2002 5:53 AM
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] password encyption

Hi All,
 
i created a user in pgadmin, specified a password of course. the user is created, but the password is encypted somehow., i cannot log in anymore!!!
please help me, what is the problem

Best Regards,

Iván Horváth
Chief Programmer

Alcatel NSD
PMS 2000 Product Team

H-1116, Budapest
Kondorfa u. 10.
Tel.: +36 1 209 9546
Fax.: +36 1 463 7271
Mobil: +36 30 257 0235
E-mail: i.horvath@alco.co.hu
Check my Web Page

Anyone who has never made a mistake has never tried anything new.

/Albert Einstein/

Re: password encyption

From
Dave Page
Date:
I have just written a doc about the encrypted passwords which will be in the helpfile for the next release of pgAdmin, and can be found at http://www.pgadmin.org/pgadmin2.php?ContentID=19.
 
SSH connections are slightly different to the encrypted passwords - they encrypt the entire session over the wire, whilst the passwords are encrypted over the wire *and* in pg_shadow. pgAdmin with SSH is outlined here: http://www.pgadmin.org/pgadmin2.php?ContentID=11
 
For the best security,  why not use both?
 
Regards, Dave.
-----Original Message-----
From: Peter E. Chen [mailto:pchen3@jhmi.edu]
Sent: 13 March 2002 16:09
To: Ivan Horvath
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] password encyption

Ivan,
 
I tunnel my pgAdmin connection through an SSH connection to provide security for pgAdmin logins.  You can use the standard SSH port forwarding feature to have your pgAdmin connect to PostgreSQL.  I believe there is now documentation on how to use SSH port forwarding with pgAdmin. 
 
I hope this helps.
 
Peter
-----Original Message-----
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org]On Behalf Of Ivan Horvath
Sent: Wednesday, March 13, 2002 5:53 AM
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] password encyption

Hi All,
 
i created a user in pgadmin, specified a password of course. the user is created, but the password is encypted somehow., i cannot log in anymore!!!
please help me, what is the problem

Best Regards,

Iván Horváth
Chief Programmer

Alcatel NSD
PMS 2000 Product Team

H-1116, Budapest
Kondorfa u. 10.
Tel.: +36 1 209 9546
Fax.: +36 1 463 7271
Mobil: +36 30 257 0235
E-mail: i.horvath@alco.co.hu
Check my Web Page

Anyone who has never made a mistake has never tried anything new.

/Albert Einstein/

Re: password encyption

From
Ivan Horvath
Date:
Dave,
 
thank you the documentation link, i modified teh pg_hba.conf file and i can connect from pgadmin tool.
but i have a problem to connect to the database from php script.
here is my script:
 
$conn = pg_Connect("host=192.168.1.30 port=5432 dbname=PMS2500 user=pms_ivan password=ivan");
i tried also:
$conn = pg_Connect("host=192.168.1.30 port=5432 dbname=PMS2500 user=pms_ivan password=md5('ivan')");
echo $conn;
it is not working, what encryption method i have to use?
 
Ivan
----- Original Message -----
From: Dave Page
Sent: Wednesday, March 13, 2002 9:56 PM
Subject: RE: [pgadmin-support] password encyption

I have just written a doc about the encrypted passwords which will be in the helpfile for the next release of pgAdmin, and can be found at http://www.pgadmin.org/pgadmin2.php?ContentID=19.
 
SSH connections are slightly different to the encrypted passwords - they encrypt the entire session over the wire, whilst the passwords are encrypted over the wire *and* in pg_shadow. pgAdmin with SSH is outlined here: http://www.pgadmin.org/pgadmin2.php?ContentID=11
 
For the best security,  why not use both?
 
Regards, Dave.
-----Original Message-----
From: Peter E. Chen [mailto:pchen3@jhmi.edu]
Sent: 13 March 2002 16:09
To: Ivan Horvath
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] password encyption

Ivan,
 
I tunnel my pgAdmin connection through an SSH connection to provide security for pgAdmin logins.  You can use the standard SSH port forwarding feature to have your pgAdmin connect to PostgreSQL.  I believe there is now documentation on how to use SSH port forwarding with pgAdmin. 
 
I hope this helps.
 
Peter
-----Original Message-----
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org]On Behalf Of Ivan Horvath
Sent: Wednesday, March 13, 2002 5:53 AM
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] password encyption

Hi All,
 
i created a user in pgadmin, specified a password of course. the user is created, but the password is encypted somehow., i cannot log in anymore!!!
please help me, what is the problem

Best Regards,

Iván Horváth
Chief Programmer

Alcatel NSD
PMS 2000 Product Team

H-1116, Budapest
Kondorfa u. 10.
Tel.: +36 1 209 9546
Fax.: +36 1 463 7271
Mobil: +36 30 257 0235
E-mail: i.horvath@alco.co.hu
Check my Web Page

Anyone who has never made a mistake has never tried anything new.

/Albert Einstein/

Re: password encyption

From
Dave Page
Date:
Ivan,
 
I suspect you need to relink php against the 7.2 libpq, but that's way off topic for this list. I *think* there is a pgsql-php@postgresql.org list - why not ask there, or try pgsql-interfaces@postgresql.org.
 
Regards, Dave.
-----Original Message-----
From: Ivan Horvath [mailto:i.horvath@alco.co.hu]
Sent: 18 March 2002 09:08
To: Dave Page; 'Peter E. Chen'
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] password encyption

Dave,
 
thank you the documentation link, i modified teh pg_hba.conf file and i can connect from pgadmin tool.
but i have a problem to connect to the database from php script.
here is my script:
 
$conn = pg_Connect("host=192.168.1.30 port=5432 dbname=PMS2500 user=pms_ivan password=ivan");
i tried also:
$conn = pg_Connect("host=192.168.1.30 port=5432 dbname=PMS2500 user=pms_ivan password=md5('ivan')");
echo $conn;
it is not working, what encryption method i have to use?
 
Ivan
----- Original Message -----
From: Dave Page
Sent: Wednesday, March 13, 2002 9:56 PM
Subject: RE: [pgadmin-support] password encyption

I have just written a doc about the encrypted passwords which will be in the helpfile for the next release of pgAdmin, and can be found at http://www.pgadmin.org/pgadmin2.php?ContentID=19.
 
SSH connections are slightly different to the encrypted passwords - they encrypt the entire session over the wire, whilst the passwords are encrypted over the wire *and* in pg_shadow. pgAdmin with SSH is outlined here: http://www.pgadmin.org/pgadmin2.php?ContentID=11
 
For the best security,  why not use both?
 
Regards, Dave.
-----Original Message-----
From: Peter E. Chen [mailto:pchen3@jhmi.edu]
Sent: 13 March 2002 16:09
To: Ivan Horvath
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] password encyption

Ivan,
 
I tunnel my pgAdmin connection through an SSH connection to provide security for pgAdmin logins.  You can use the standard SSH port forwarding feature to have your pgAdmin connect to PostgreSQL.  I believe there is now documentation on how to use SSH port forwarding with pgAdmin. 
 
I hope this helps.
 
Peter
-----Original Message-----
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org]On Behalf Of Ivan Horvath
Sent: Wednesday, March 13, 2002 5:53 AM
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] password encyption

Hi All,
 
i created a user in pgadmin, specified a password of course. the user is created, but the password is encypted somehow., i cannot log in anymore!!!
please help me, what is the problem

Best Regards,

Iván Horváth
Chief Programmer

Alcatel NSD
PMS 2000 Product Team

H-1116, Budapest
Kondorfa u. 10.
Tel.: +36 1 209 9546
Fax.: +36 1 463 7271
Mobil: +36 30 257 0235
E-mail: i.horvath@alco.co.hu
Check my Web Page

Anyone who has never made a mistake has never tried anything new.

/Albert Einstein/