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.
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.
Ramon Leon http://onsmalltalk.com
Thank you Ramón !! That did it. All 21 tests are green now.
On 3/28/07, Ramon Leon ramon.leon@allresnet.com wrote:
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.
Ramon Leon http://onsmalltalk.com
-----Original Message----- From: squeak-dev-bounces@lists.squeakfoundation.org [mailto:squeak-dev-bounces@lists.squeakfoundation.org] On Behalf Of Ramiro Diaz Trepat Sent: Wednesday, March 28, 2007 10:39 AM To: The general-purpose Squeak developers list Subject: Re: Postgres
Thank you Ramón !! That did it. All 21 tests are green now.
No problem, but be warned, that MagritteGlorp package is alpha. It doesn't deal with inheritance at all, and if it can't decipher your Magritte descriptions well enough, you may see some confusing errors. See the wiki page SqueakMap for some more info.
It's a good start on an automatic persistence solution, but I haven't had time to deal with the inheritance issue, or polish it up at all.
Ramon Leon http://onsmalltalk.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 dont have md5 for postgres yet because is the preferred/recommended method for DB conections.
Cheers,
Sebastian Sastre
Ramon Leon http://onsmalltalk.com
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.
Philippe
Cheers,
Sebastian Sastre
Ramon Leon http://onsmalltalk.com
-----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
Hi All,
We do have MD5 and it works great. You can load MD5 from the Cryptograpy repository at SqueakSource. Also see http://bugs.squeak.org/view.php?id=3834 .
With those two changes PostgreSQL works great!
Ron Teitelbaum Squeak Cryptography Team Leader
From: Sebastian Sastre
-----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 dont have md5 for postgres yet because is the preferred/recommended method for DB conections.
Cheers,
Sebastian Sastre
Ramon Leon http://onsmalltalk.com
Ramiro Diaz Trepat wrote:
... which coughed at me: "PGConnection has a defective state machine"
I wish I'd chosen different wording. The "defect" is that the state machine was supposed to be improved, and eventually account for all error conditions, and be able to recover from lost connections and such like. Oh well, if PostgresV3 ever gets built, that'll be the first change.
Yanni,
Your client is great! Thanks for building it. Without your work we would have fallen way behind supporting PostgreSQL for Squeak.
Ron Teitelbaum Squeak Cryptography Team Leader.
From: Yanni Chiu
Ramiro Diaz Trepat wrote:
... which coughed at me: "PGConnection has a defective state machine"
I wish I'd chosen different wording. The "defect" is that the state machine was supposed to be improved, and eventually account for all error conditions, and be able to recover from lost connections and such like. Oh well, if PostgresV3 ever gets built, that'll be the first change.
Yes, certainly. It's already working perfectly. I just did not know were to start looking after that error message. Thanks and I hope V3 is on the way with the integration of the Criptography MD5 package too :) By the way, the cryptography package really rocks ;)
On 3/28/07, Ron Teitelbaum Ron@usmedrec.com wrote:
Yanni,
Your client is great! Thanks for building it. Without your work we would have fallen way behind supporting PostgreSQL for Squeak.
Ron Teitelbaum Squeak Cryptography Team Leader.
From: Yanni Chiu
Ramiro Diaz Trepat wrote:
... which coughed at me: "PGConnection has a defective state machine"
I wish I'd chosen different wording. The "defect" is that the state machine was supposed to be improved, and eventually account for all error conditions, and be able to recover from lost connections and such like. Oh well, if PostgresV3 ever gets built, that'll be the first change.
From: Ramiro Diaz Trepat
By the way, the cryptography package really rocks ;)
Thanks Ramiro, please come and join the team! http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/cryptography
We are just getting started, just wait!
Ron Teitelbaum Squeak Cryptography Team Leader
squeak-dev@lists.squeakfoundation.org