password encyption

2002-03-13 Thread Ivan Horvath
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áthChief Programmer Alcatel NSDPMS 2000 Product Team H-1116, BudapestKondo

No Subject

2002-03-13 Thread rose . coil
HIGH QUALITY SCREW THREAD INSERTS Dear esteemed customer, RoseCoil Company has been a dependable supplier of high quality screw thread inserts for over 15 years, and we are pleased to introduce our products to you. We are looking for professional Agent who has interesting about our pro

Re: password encyption

2002-03-13 Thread Peter E. Chen
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. 

Re: password encyption

2002-03-13 Thread Ivan Horvath
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 w

Re: password encyption

2002-03-13 Thread Dave Page
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.

Re: password encyption

2002-03-13 Thread Dave Page
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:[EMAIL PROTECTED]] Sent: 13 March 2002 10:53To: [EMAIL PROTECTE

Re: password encyption

2002-03-13 Thread Dave Page
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";>http://www.pgadmin.org/pgadmin2.php?ContentID=19.   SSH connections are slightly different to the en