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.

> > 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: [hidden email]
> [mailto:[hidden email]] 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.

> -----Mensaje original-----
> De: [hidden email]
> [mailto:[hidden email]] 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.

> -----Mensaje original-----
> De: [hidden email]
> [mailto:[hidden email]] 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 <[hidden email]>:
> >
> > > -----Mensaje original-----
> > > De: [hidden email]
> > > [mailto:[hidden email]] 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
> > >
> > >
> >
> >
> >
>

> From: Sebastian Sastre
>
>
> > -----Mensaje original-----
> > De: [hidden email]
> > [mailto:[hidden email]] 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.
>
> Cheers,
>
> Sebastian Sastre
>
>
> >
> > Ramon Leon
> > http://onsmalltalk.com
> >
> >
>
>

> 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.
>
>

> 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.
> >
> >
>
>
>
>