[Seaside] PostgreSQL Client for Squeak 3.9

[Ron Teitelbaum]

Hi Richard,

I had a quick look and notice the comment here.  You changed
defaultPostgreSQLLogin but it is not used unless you execute the code in
quotes below.

defaultPostgreSQLLogin
	"To set the default database login to PostgreSQL, execute the
following statement."
	"DefaultLogin := self defaultPostgreSQLLogin."   <- this code here

I edited 

buildDefaultConnectionArgs

	^ PGConnectionArgs
		hostname: 'localhost'
		portno: 5432
		databaseName: 'MYDBNAME'
		userName: 'aUserName'
		password: 'aPassword'

to point to the database that I created on postreSQL instead.

You could also (and should) leave the MD5 if you load the MD5 code from
www.squeaksource.com/Cryptography

Ron Teitelbaum
Squeak Cryptography Team Leader


> -----Original Message-----
> From: seaside-bounces at lists.squeakfoundation.org [mailto:seaside-
> bounces at lists.squeakfoundation.org] On Behalf Of Richard Eng
> Sent: Thursday, July 19, 2007 2:08 PM
> To: Ron at USMedRec.com, Seaside - general discussion
> Subject: Re: [Seaside] PostgreSQL Client for Squeak 3.9
> 
> I'm having quite a few failures in the Glorp tests. Can anybody help me
> out?
> 
> I installed the PostgresV2 client. Then I installed Glorp Preload, Glorp,
> Glorp Postload, Glorp Test, Glorp Test Postload (all from 0.4.129).
> 
> Following Ramon's suggestion, I edited PostgreSQL's pg_hba.conf and
> changed
> 'md5' to 'password'.
> 
> I applied the fix to PostgreSQL Client as indicated in the post below.
> 
> I modified class method #defaultPostgreSQLLocalLogin to connect with
> 'localhost:5432_test'. (Should I be using 'test'?)
> 
> I even tried creating a PostgreSQL database called 'test'. (Is this
> necessary?)
> 
> But when I run TestRunner, I get some tests passed, some tests failed, and
> a
> really nasty exception (PGConnection>>execute
> SqueakDatabaseAccessor>>basicExecuteSQLString  blah blah blah) on some
> tests.
> 
> I have no idea where to begin looking for the cause. All I want is to pass
> the tests so I can get to the good stuff...
> 
> Thanks,
> Richard
> 
> 
> On 7/18/07 2:43 PM, "Ron Teitelbaum" <Ron at USMedRec.com> wrote:
> 
> > Hi Richard,
> >
> > I use:
> >
> > http://www.squeaksource.com/PostgresV2.html
> >
> > For 3.9.
> >
> > I had to change one thing to get Glorp and PostgreSQL working properly.
> > http://bugs.squeak.org/view.php?id=3834
> >
> > Hope that helps,
> >
> > Ron Teitelbaum
> > President / Principal Software Engineer
> > US Medical Record Specialists
> > www.USMedRec.com
> >
> > ________________________________________
> > From: seaside-bounces at lists.squeakfoundation.org
> > [mailto:seaside-bounces at lists.squeakfoundation.org] On Behalf Of Richard
> K
> > Eng
> > Sent: Wednesday, July 18, 2007 2:03 PM
> > To: Seaside - general discussion
> > Subject: [Seaside] PostgreSQL Client for Squeak 3.9
> >
> > Using SqueakMap Loader in Damien's 2.7 image, the PostgreSQL Client
> package
> > (Version 1.0) apparently has no published release for Squeak 3.9. Is
> there a
> > more recent release? Or can I just install any ol' release for 3.9?
> >
> > Thanks,
> > Richard
> >
> > _______________________________________________
> > Seaside mailing list
> > Seaside at lists.squeakfoundation.org
> > http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside
> 
> 
> _______________________________________________
> Seaside mailing list
> Seaside at lists.squeakfoundation.org
> http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside