working postgres client?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|

working postgres client?

Randal L. Schwartz

I'm working on a project that requires access to a postgresql database.

The postgres client in Squeakmap seems to fail if md5 password auth is enabled
(or at least that's my best guess so far about why it works on my laptop and
not the server).

I googled for "postgres squeak" and found Jim-Postgresql's client, but it
hangs in my 3.10 image when trying to connect. And by hang, I mean
command-period does nothing, and I have to force quit.

Does anyone have a working pg client that works with modern squeak and modern
postgresql?

Thanks.

--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<[hidden email]> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!

Reply | Threaded
Open this post in threaded view
|

Re: working postgres client?

NorbertHartl

On Fri, 2007-10-12 at 04:23 -0700, Randal L. Schwartz wrote:

> I'm working on a project that requires access to a postgresql database.
>
> The postgres client in Squeakmap seems to fail if md5 password auth is enabled
> (or at least that's my best guess so far about why it works on my laptop and
> not the server).
>
> I googled for "postgres squeak" and found Jim-Postgresql's client, but it
> hangs in my 3.10 image when trying to connect. And by hang, I mean
> command-period does nothing, and I have to force quit.
>
> Does anyone have a working pg client that works with modern squeak and modern
> postgresql?
>

Yes, I'm using postgresql 8.2 on a daily base. My Postgesql client is
from squeaksource (which is also on package universe). My image
is 3.9. I turned off MD5 authentication in postgresql but it is said
that installing the Cryptography package will work, too.

hope that helps,

Norbert


Reply | Threaded
Open this post in threaded view
|

RE: working postgres client?

Ron Teitelbaum
In reply to this post by Randal L. Schwartz
Hi Randal,

You need to use the PostGresV2 client.  You can find it at:
http://www.squeaksource.com/PostgresV2.html 

You should also load the cryptography package at:

http://www.squeaksource.com/Cryptography.html

to support MD5, which works fine.

Also consider using Glorp:
http://www.squeaksource.com/Glorp.html 

to map your Objects to the relational database.

Hope that helps,

Happy coding!

Ron Teitelbaum
Squeak Cryptography Team Leader

> From: Randal L. Schwartz
>
>
> I'm working on a project that requires access to a postgresql database.
>
> The postgres client in Squeakmap seems to fail if md5 password auth is
> enabled
> (or at least that's my best guess so far about why it works on my laptop
> and
> not the server).
>
> I googled for "postgres squeak" and found Jim-Postgresql's client, but it
> hangs in my 3.10 image when trying to connect. And by hang, I mean
> command-period does nothing, and I have to force quit.
>
> Does anyone have a working pg client that works with modern squeak and
> modern
> postgresql?
>
> Thanks.
>



Reply | Threaded
Open this post in threaded view
|

Re: working postgres client?

Randal L. Schwartz
>>>>> "Ron" == Ron Teitelbaum <[hidden email]> writes:

Ron> You should also load the cryptography package at:

Ron> http://www.squeaksource.com/Cryptography.html

Ron> to support MD5, which works fine.

Ahh, this might be the piece I was missing.

Ron> Also consider using Glorp:
Ron> http://www.squeaksource.com/Glorp.html 

Ron> to map your Objects to the relational database.

Oooh, that could be neat as well.

Thanks for the pointers, everyone.

--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<[hidden email]> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!

Reply | Threaded
Open this post in threaded view
|

Re: working postgres client?

Travis Kay
In reply to this post by Randal L. Schwartz
Randal,

The postgresql client from squeak map / package universes should work,
but you also need to load the cryptography package for MD5 support.

Travis

Randal L. Schwartz wrote:

> I'm working on a project that requires access to a postgresql database.
>
> The postgres client in Squeakmap seems to fail if md5 password auth is enabled
> (or at least that's my best guess so far about why it works on my laptop and
> not the server).
>
> I googled for "postgres squeak" and found Jim-Postgresql's client, but it
> hangs in my 3.10 image when trying to connect. And by hang, I mean
> command-period does nothing, and I have to force quit.
>
> Does anyone have a working pg client that works with modern squeak and modern
> postgresql?
>
> Thanks.
>
>  


Reply | Threaded
Open this post in threaded view
|

Re: working postgres client?

Ramiro Diaz Trepat
Another important bit of information:  the cryptography package should
be loaded into the image before you install the PostgreSQL driver.
It works like a charm with MD5.



On 10/12/07, Travis Kay <[hidden email]> wrote:

> Randal,
>
> The postgresql client from squeak map / package universes should work,
> but you also need to load the cryptography package for MD5 support.
>
> Travis
>
> Randal L. Schwartz wrote:
> > I'm working on a project that requires access to a postgresql database.
> >
> > The postgres client in Squeakmap seems to fail if md5 password auth is enabled
> > (or at least that's my best guess so far about why it works on my laptop and
> > not the server).
> >
> > I googled for "postgres squeak" and found Jim-Postgresql's client, but it
> > hangs in my 3.10 image when trying to connect. And by hang, I mean
> > command-period does nothing, and I have to force quit.
> >
> > Does anyone have a working pg client that works with modern squeak and modern
> > postgresql?
> >
> > Thanks.
> >
> >
>
>
>

Reply | Threaded
Open this post in threaded view
|

RE: working postgres client?

Gary Chambers-4
In reply to this post by Ron Teitelbaum
If there's any interest we have developed plgins for Windows and Linux for
using the native MD5 functions, at least on Linux it is 100X quicker...

> -----Original Message-----
> From: [hidden email]
> [mailto:[hidden email]]On Behalf Of Ron
> Teitelbaum
> Sent: 12 October 2007 2:35 PM
> To: 'The general-purpose Squeak developers list'
> Subject: RE: working postgres client?
>
>
> Hi Randal,
>
> You need to use the PostGresV2 client.  You can find it at:
> http://www.squeaksource.com/PostgresV2.html
>
> You should also load the cryptography package at:
>
> http://www.squeaksource.com/Cryptography.html
>
> to support MD5, which works fine.
>
> Also consider using Glorp:
> http://www.squeaksource.com/Glorp.html
>
> to map your Objects to the relational database.
>
> Hope that helps,
>
> Happy coding!
>
> Ron Teitelbaum
> Squeak Cryptography Team Leader
>
> > From: Randal L. Schwartz
> >
> >
> > I'm working on a project that requires access to a postgresql database.
> >
> > The postgres client in Squeakmap seems to fail if md5 password auth is
> > enabled
> > (or at least that's my best guess so far about why it works on my laptop
> > and
> > not the server).
> >
> > I googled for "postgres squeak" and found Jim-Postgresql's
> client, but it
> > hangs in my 3.10 image when trying to connect. And by hang, I mean
> > command-period does nothing, and I have to force quit.
> >
> > Does anyone have a working pg client that works with modern squeak and
> > modern
> > postgresql?
> >
> > Thanks.
> >
>
>
>


Reply | Threaded
Open this post in threaded view
|

Re: working postgres client?

Randal L. Schwartz
In reply to this post by Ron Teitelbaum
>>>>> "Ron" == Ron Teitelbaum <[hidden email]> writes:

Ron> Hi Randal,
Ron> You need to use the PostGresV2 client.  You can find it at:
Ron> http://www.squeaksource.com/PostgresV2.html 

Ron> You should also load the cryptography package at:

Ron> http://www.squeaksource.com/Cryptography.html

Ron> to support MD5, which works fine.

Yes, and this did work!  Demonstrated it for $client this morning.
THANK YOU for that piece of advice.

By the way, I'm getting paid to hack squeak.  This is cool.  I've
popped my "commercial smalltalk consultant" cherry!

--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<[hidden email]> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!

Reply | Threaded
Open this post in threaded view
|

RE: working postgres client?

Ron Teitelbaum
You are quite welcome!  

I wish you much success,

Ron

> From: Randal L. Schwartz
>
> >>>>> "Ron" == Ron Teitelbaum <[hidden email]> writes:
>
> Ron> Hi Randal,
> Ron> You need to use the PostGresV2 client.  You can find it at:
> Ron> http://www.squeaksource.com/PostgresV2.html
>
> Ron> You should also load the cryptography package at:
>
> Ron> http://www.squeaksource.com/Cryptography.html
>
> Ron> to support MD5, which works fine.
>
> Yes, and this did work!  Demonstrated it for $client this morning.
> THANK YOU for that piece of advice.
>
> By the way, I'm getting paid to hack squeak.  This is cool.  I've
> popped my "commercial smalltalk consultant" cherry!
>
> --
> Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777
> 0095
> <[hidden email]> <URL:http://www.stonehenge.com/merlyn/>
> Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
> See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl
> training!


Reply | Threaded
Open this post in threaded view
|

RE: working postgres client?

Ron Teitelbaum
In reply to this post by Gary Chambers-4
Hi Gary,

I'm not really interested in calling native functions, but I am interested
in getting plugins developed.  We have a plugin for SHA1 and for
(SecureHashAlgroithm) DES (3DES).  Which works well for 3DES-SHA1 SSL.

The most important plugins for me would be SHA256, Rijndael (AES), and MD5.

So far nobody in the Cryptography Team has had the time to get it done.  Any
volunteers are definitely welcome!!

Ron Teitelbaum
Squeak Cryptography Team Leader


> From: Gary Chambers
>
> If there's any interest we have developed plgins for Windows and Linux for
> using the native MD5 functions, at least on Linux it is 100X quicker...
>
> > -----Original Message-----
> > From: [hidden email]
> > [mailto:[hidden email]]On Behalf Of Ron
> > Teitelbaum
> > Sent: 12 October 2007 2:35 PM
> > To: 'The general-purpose Squeak developers list'
> > Subject: RE: working postgres client?
> >
> >
> > Hi Randal,
> >
> > You need to use the PostGresV2 client.  You can find it at:
> > http://www.squeaksource.com/PostgresV2.html
> >
> > You should also load the cryptography package at:
> >
> > http://www.squeaksource.com/Cryptography.html
> >
> > to support MD5, which works fine.
> >
> > Also consider using Glorp:
> > http://www.squeaksource.com/Glorp.html
> >
> > to map your Objects to the relational database.
> >
> > Hope that helps,
> >
> > Happy coding!
> >
> > Ron Teitelbaum
> > Squeak Cryptography Team Leader
> >
> > > From: Randal L. Schwartz
> > >
> > >
> > > I'm working on a project that requires access to a postgresql
> database.
> > >
> > > The postgres client in Squeakmap seems to fail if md5 password auth is
> > > enabled
> > > (or at least that's my best guess so far about why it works on my
> laptop
> > > and
> > > not the server).
> > >
> > > I googled for "postgres squeak" and found Jim-Postgresql's
> > client, but it
> > > hangs in my 3.10 image when trying to connect. And by hang, I mean
> > > command-period does nothing, and I have to force quit.
> > >
> > > Does anyone have a working pg client that works with modern squeak and
> > > modern
> > > postgresql?
> > >
> > > Thanks.
> > >
> >
> >
> >
>



Reply | Threaded
Open this post in threaded view
|

RE: working postgres client?

Gary Chambers-4
Well, I have the code for Windos, not yet compiled. The Linux plugin does
perform > 100x.
Next week...

> -----Original Message-----
> From: [hidden email]
> [mailto:[hidden email]]On Behalf Of Ron
> Teitelbaum
> Sent: 13 October 2007 12:36 AM
> To: 'The general-purpose Squeak developers list'
> Cc: 'Cryptography Team Development List'
> Subject: RE: working postgres client?
>
>
> Hi Gary,
>
> I'm not really interested in calling native functions, but I am interested
> in getting plugins developed.  We have a plugin for SHA1 and for
> (SecureHashAlgroithm) DES (3DES).  Which works well for 3DES-SHA1 SSL.
>
> The most important plugins for me would be SHA256, Rijndael
> (AES), and MD5.
>
> So far nobody in the Cryptography Team has had the time to get it
> done.  Any
> volunteers are definitely welcome!!
>
> Ron Teitelbaum
> Squeak Cryptography Team Leader
>
>
> > From: Gary Chambers
> >
> > If there's any interest we have developed plgins for Windows
> and Linux for
> > using the native MD5 functions, at least on Linux it is 100X quicker...
> >
> > > -----Original Message-----
> > > From: [hidden email]
> > > [mailto:[hidden email]]On Behalf Of Ron
> > > Teitelbaum
> > > Sent: 12 October 2007 2:35 PM
> > > To: 'The general-purpose Squeak developers list'
> > > Subject: RE: working postgres client?
> > >
> > >
> > > Hi Randal,
> > >
> > > You need to use the PostGresV2 client.  You can find it at:
> > > http://www.squeaksource.com/PostgresV2.html
> > >
> > > You should also load the cryptography package at:
> > >
> > > http://www.squeaksource.com/Cryptography.html
> > >
> > > to support MD5, which works fine.
> > >
> > > Also consider using Glorp:
> > > http://www.squeaksource.com/Glorp.html
> > >
> > > to map your Objects to the relational database.
> > >
> > > Hope that helps,
> > >
> > > Happy coding!
> > >
> > > Ron Teitelbaum
> > > Squeak Cryptography Team Leader
> > >
> > > > From: Randal L. Schwartz
> > > >
> > > >
> > > > I'm working on a project that requires access to a postgresql
> > database.
> > > >
> > > > The postgres client in Squeakmap seems to fail if md5
> password auth is
> > > > enabled
> > > > (or at least that's my best guess so far about why it works on my
> > laptop
> > > > and
> > > > not the server).
> > > >
> > > > I googled for "postgres squeak" and found Jim-Postgresql's
> > > client, but it
> > > > hangs in my 3.10 image when trying to connect. And by hang, I mean
> > > > command-period does nothing, and I have to force quit.
> > > >
> > > > Does anyone have a working pg client that works with modern
> squeak and
> > > > modern
> > > > postgresql?
> > > >
> > > > Thanks.
> > > >
> > >
> > >
> > >
> >
>
>
>