| From: | "Andy Shellam (Mailing Lists)" <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk> |
|---|---|
| To: | patrimith <paddysmith(at)gmail(dot)com> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: pgAdmin III 1.6.2 sends plaintext password |
| Date: | 2007-02-15 21:20:38 |
| Message-ID: | 45D4CEA6.8090002@mailnetwork.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
patrimith wrote:
> Greetings List!
>
> I'm trying get remote management of postrgesql on Ubuntu 5.10 set up.
>
> I am hoping to set up authentication in pg_hba.conf as
>
> host all all 192.168.0.0/0 md5
>
> but I wasn't successful. When I relaxed it to:
>
> host all all 192.168.0.0/0 password
>
> everything worked fine.
>
> Can someone let me know how to configure pgAdmin so that it sends the
> password md5 encrypted?
>
> Thanks,
>
> Patrick Smith
> http://www.openengagement.com
>
>
I currently talk to a PostgreSQL 8.2.3 server using PgAdmin 1.6.2 with
MD5 encrypted passwords just fine.
What is the value of "password_encryption" in your PostgreSQL server's
postgresql.conf file?
[root(at)byron ~]# cat /endeavour/dbstore/postgresql.conf|grep
'password_encryption'
password_encryption = on
[root(at)byron ~]#
Try setting it to 'on' and restarting your server.
Regards,
Andy.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | patrimith | 2007-02-15 21:32:09 | Re: pgAdmin III 1.6.2 sends plaintext password |
| Previous Message | Andy Shellam (Mailing Lists) | 2007-02-15 21:14:58 | Re: pgadmin3 and fc6 |