Re: sb-md5 and postgresql-socket

Kevin Rosenberg <kevin-HJRc7zDS/[email protected]> Mon, 20 Mar 2006 12:57:53 -0700
Newsgroups gmane.lisp.clsql.devel
Message-ID <[email protected]>
Alan Caulkins wrote:
> I think I found a problem with md5 authentication in postgresql-socket.
> I don't remember seeing anything about it on the mailing lists or in the
> docs, but it seems like it would be a show-stopper, so I'm not sure if
> my setup is wierd, or if people just don't like to use md5 with PostgreSQL.

Hi Alan,

Thanks for the info. I haven't used MD5 with Postgresql, so I don't
know if the original MD5 code used to work or not. But your
report clearly indicates that md5sum-string is required for SBCL
rather than md5sum-sequence. 

> 	(:use #:cl #-sbcl md5 #+sbcl sb-md5)
> 
> So, am I correct in concluding that when running under sbcl, pg-sock
> doesn't require cl-md5, but uses sbcl's md5 package instead? They're both
> written by Pierre Mai, and md5sum-sequence barfs in both, only sb-md5
> [...]

Well, both sbcl's md5 and cl-md5 are based on code from Pierre. I
happen to maintain cl-md5 only because CLSQL depends upon it and I
wanted md5 to be able to be downloaded with asdf-install.

Are you saying that you tried using cl-md5 with CLSQL and that it
(like sb-md5) does not work correctly with md5sum-sequence? If that's
the case, I can add a md5sum-string function to cl-md5 and modify
CLSQL to use md5sum-string rather than md5sum-sequence.

Kevin