From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | 'Ivan Horvath' <i(dot)horvath(at)alco(dot)co(dot)hu> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: password encyption |
Date: | 2002-03-19 09:25:26 |
Message-ID: | FED2B709E3270E4B903EB0175A49BCB10476CD@dogbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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(at)postgresql(dot)org
<mailto:pgsql-php(at)postgresql(dot)org> list - why not ask there, or try
pgsql-interfaces(at)postgresql(dot)org <mailto:pgsql-interfaces(at)postgresql(dot)org> .
Regards, Dave.
-----Original Message-----
From: Ivan Horvath [mailto:i(dot)horvath(at)alco(dot)co(dot)hu]
Sent: 18 March 2002 09:08
To: Dave Page; 'Peter E. Chen'
Cc: pgadmin-support(at)postgresql(dot)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 <mailto:dpage(at)vale-housing(dot)co(dot)uk>
To: 'Peter E. Chen' <mailto:pchen3(at)jhmi(dot)edu> ; Ivan
<mailto:i(dot)horvath(at)alco(dot)co(dot)hu> Horvath
Cc: pgadmin-support(at)postgresql(dot)org <mailto:pgadmin-support(at)postgresql(dot)org>
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
<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
<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(at)jhmi(dot)edu]
Sent: 13 March 2002 16:09
To: Ivan Horvath
Cc: pgadmin-support(at)postgresql(dot)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(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org]On Behalf Of Ivan Horvath
Sent: Wednesday, March 13, 2002 5:53 AM
To: pgadmin-support(at)postgresql(dot)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: <mailto:i(dot)horvath(at)alco(dot)co(dot)hu> i(dot)horvath(at)alco(dot)co(dot)hu
Check my Web Page <http://www.extra.hu/pillesoft>
Anyone who has never made a mistake has never tried anything new.
/Albert Einstein/
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond Chui | 2002-03-20 16:06:44 | ERROR: fmgr_info: function 1296284: cache lookup failed |
Previous Message | Dave Page | 2002-03-18 21:13:07 | Re: Does not report ODBC installation correctly |