Finally, problem spotted

mfoss — Mon, 28 Jan 2008 11:44:22 +0000

sbsbessa wrote:

I have Ejabberd 1.1.4 installed and working with internal authentication, however, when trying to use PostgreSQL 8.2 I always get "Failed legacy authentication for user@hostname/resource" (when using flash client) or "" (using Exodus)

The strange thing is that I can create users (using Exodus) and I can see the data being stored in the DB, however I cannot login...

I tried using MySQL instead, replacing the configuration line as follows and it worked (with both Flash client or Exodus):
%{odbc_server, {pgsql, "127.0.0.1", "DB_NAME", "USER", "PASSWORD"}}.
{odbc_server, {mysql, "127.0.0.1", "DB_NAME", "USER", "PASSWORD"}}.

I followed the steps in http://www.process-one.net/docs/ejabberd/guide_en.html during the installation
and got the native PostgreSQL driver from http://jungerl.sourceforge.net/ which I compiled and copied the 'beam' files into /var/lib/ejabberd/ebin/

Could this be a problem with the driver?
Does anyone have this problem?
Any hints on how to debug this problem?

It seems the problem is in the pgsql-erlang driver. I got it from ejabberd-modules SVN, and had exactly the same problem than you.

Then I got a slightly older version of the pgsql from SVN:
$ svn up -r 412
Compiled, installed and ejabberd now allows me to login correctly!

You can compile the modified file yourself, or get it here:
http://tkabber.jabber.ru/files/badlop/pgsql_util.beam
If you try, tell me if it solves your problem or not, and also what exact version of PostgreSQL did you try.

This bug is tracked here:
Authentication with pgsql driver is broken

Same here...

Anonymous — Sat, 05 Jan 2008 18:57:46 +0000

Same here...

i have the same problemm. in

Anonymous — Thu, 13 Dec 2007 19:58:55 +0000

i have the same problemm. in postgresql 8.2.1 there wasn't such problemm. I think that problemm will be with backend pgsql. system show that ejabber is connected with database. I can connect to ejabberd serwer, but I can't authorize. when I run ejabberdctl I can add new user.

ejabberd - Comments for "Ejabberd 1.1.4 + PostgreSQL 8.2"

Finally, problem spotted

Same here...

i have the same problemm. in