[Seaside] Accessing PostgresSQL or MySQL with Squeak

[Benjamin Pollack]

On 11/10/06, Chang Sau Sheong <cssheong at pacific.net.sg> wrote:
> Hi,
>
> I'm quite new in Smalltalk and Squeak (a few days only) though I've been
> doing Java and Ruby for some time now. One of the things I wanted to do
> is to try to access to a relational DB through Squeak, either
> PostgresSQL or MySQL. I've tried the following:
>
> 1. Jim Maynard's Squeak-PosgresSQL client -- can't seem to connect
> 2. Yanni Chiu's PostgreSQL Client for Squeak -- downloaded it but not
> sure how to use it

Both PostgreSQL drivers only do password (i.e., plain-text)
authentication, which is disabled by default in PostgreSQL for
security reasons. You will need to go edit your database's pg_hba.conf
and add a line that looks something like

host   all     127.0.0.1    255.255.255.255     password

and then set up users and passwords using the normal PostgreSQL tools.
For more information, please read
http://www.postgresql.org/docs/8.1/static/client-authentication.html .

--Benjamin