postmodern ... PostgreSQL error "Database error 28P01: password authentication failed for user ..." ...

[newd...@gmail.com]

Suddenly getting the PostgreSQL error "Database error 28P01: password authentication failed for user ..." when I use postmodern via quicklisp.

Some days ago it was still working like a dream.

If I use in a terminal "psql name_of_database" with the same database, user name, password and host it connects without a problem.

I use:

- SBCL v1.0.57.0.debian
- #<SYSTEM postmodern / postmodern-20121125-git / quicklisp 2012-11-25>
- Postgres v9.1.6-1ubuntu1

The commands I use:

;; Postmodern
;; ==========

;; A Common Lisp interface to PostgreSQL

; Access the database
(asdf:oos 'asdf:load-op :postmodern) ; Load package postmodern for PostgreSQL database
(use-package :postmodern)
(connect-toplevel "name_of_database" "user_name" "password" "localhost") ; Connect to the database name_of_database

Any idea ???

[newd...@gmail.com]

Must have something to do with the MD5 ...

[Zach Beane]

newd...@gmail.com writes:

> Suddenly getting the PostgreSQL error "Database error 28P01: password
> authentication failed for user ..." when I use postmodern via quicklisp.
>
> Some days ago it was still working like a dream.
>
> If I use in a terminal "psql name_of_database" with the same database, user
> name, password and host it connects without a problem.

Yes, unfortunately there were some incompatible API changes that got
into this month's releases. The following message has some links and
info about how to work around:

http://lists.common-lisp.net/pipermail/postmodern-devel/2012-December/001023.html

Sorry for the hassle. It will work properly in the next update, which
should be out in a few days.

Zach

[newd...@gmail.com]

No problem Zach,

Thanks for your feedback and the great work you are doing!

Frederik

[newd...@gmail.com]

And it's OK now with your workaround:

...

In the meantime, you could do something like this to get the update
early:

  cd ~/quicklisp/local-projects
  git clone git://github.com/marijnh/Postmodern.git

That local checkout will override Quicklisp's version of Postmodern.

Zach

...

Thanks again, Frederik

On Tuesday, 11 December 2012 12:05:02 UTC+1, newd...@gmail.com wrote:

[yale....@gmail.com]

I'm also seeing this error.  I tried to update from quicklisp today by running (ql:update-all-dists), but it did not fix the issue.

Any ideas?

On Thursday, May 16, 2013 9:36:03 AM UTC-4, Neverblued wrote:

Today I have the same problem. I cloned the Postmodern as suggested here, tried to fix and recompile md5-password defun, but nevertheless it does not work properly. Any ideas?