Re: Password authentification failed after Quicklis update

Ryan Davis <[email protected]> Thu, 07 Mar 2013 12:37:30 -0500
Newsgroups gmane.lisp.clsql.general
Message-ID <[email protected]>
On 03/07/2013 11:54 AM, Ryan Davis wrote:
> On 03/07/2013 09:15 AM, Nicolas Neuss wrote:
>> Hi,
>>
>> I am using clsql/postgresql and after doing a (ql:update-all-dists) I
>> cannot connect anymore to my databases with clsql.
>>
>> While trying to connect to database localhost/noten/neuss
>>     using database-type POSTGRESQL-SOCKET:
>>     Error POSTGRESQL-LOGIN-ERROR / FATAL:  password authentication failed for user "neuss"
>>
>>     has occurred.
>>      [Condition of type SQL-CONNECTION-ERROR]
>>
>> I searched the web and found that in December last year a change in MD5
>> broke authentification.  Is this bug still active?  Does anyone have a
>> fix?
> I think the MD5 issue has been resolved, I think this might be a clsql bug.
This is a bug between the postgresql-socket backend and the recent MD5 
changes. It's the same bug you saw in your google searches, just in a 
different bit of code.

I've committed a fix: 
http://git.b9.com/?p=clsql.git;a=commitdiff;h=906d7a71b35ee1cd6d281623694bc90ced22c339

It'll be some time before that makes it into quicklisp, but you can 
check out clsql from git into your local-projects directory to get the 
fix sooner. There are no other parts of clsql vulnerable to this issue.

Thanks,
Ryan
>
> Can you try using database type postgresql-socket3?
>
> Thanks,
> Ryan
> _______________________________________________
> CLSQL mailing list
> [email protected]
> http://lists.b9.com/cgi-bin/mailman/listinfo/clsql