-----Mensaje original----- De: squeak-dev-bounces@lists.squeakfoundation.org [mailto:squeak-dev-bounces@lists.squeakfoundation.org] En nombre de Philippe Marschall Enviado el: MiƩrcoles, 28 de Marzo de 2007 15:31 Para: The general-purpose Squeak developers list Asunto: Re: Postgres
2007/3/28, Sebastian Sastre ssastre@seaswork.com:
-----Mensaje original----- De: squeak-dev-bounces@lists.squeakfoundation.org [mailto:squeak-dev-bounces@lists.squeakfoundation.org] En
nombre de
Ramon Leon Enviado el: MiƩrcoles, 28 de Marzo de 2007 14:29 Para: 'The general-purpose Squeak developers list' Asunto: RE: Postgres
Hello, I need to connect to a Postgres database. I've
installed the
PostgresV2, Glorp and Ramon's MagritteGlorp package. First of all, I wanted to test the Postgres package, so
I changed
the connection arguments in TestPGConnection to the server,
userid and
password used that I am using, and then executed the most basic method: testConnection, which coughed at me:
"PGConnection has a
defective state machine" Is there any particular thing I should reset or install
to get the
Postgres package to work? Thanks
r.
Go into pg_hba.config and change the authentication
method from md5
to password, restart postgres. Squeak will connect fine
after that.
The 'trust' option also work at a less(?) secure level.
It's a pity we
don't have md5 for postgres yet because is the
preferred/recommended
method for DB conections.
But we do have md5 auth for postgres. You just need to load Cryptography and MD5 before the PostgresV2 driver.
That's good news! I'll give it a try. Thanks Phillipe. Sebastian
Philippe
Cheers,
Sebastian Sastre
Ramon Leon http://onsmalltalk.com