Authentication problem which ejabberd using ODBC

[Daniel Bareiro <daniel-listas@gmx.net>]

Hi all.

Some time ago, I decided to migrate from a compiled ejabberd 2.0 to
version 2.1.5 from Debian GNU/Linux repositories.

After that, everything was working, although the weekend I was checking
some things of setup and I noticed that was running with a version of
MySQL modules I compiled at the time (2011).

The idea is that everything is running Debian packages for ease of
administration and security updates. Then I tried the authentication is
done with ODBC.

Then, to achieve this, I commented the lines:

-----------------------------------------------------------------------
{host_config, "sysadminhaiku.com.ar", [
 {odbc_server, {mysql, "localhost", "sysadminhaiku", "ejabberd",
"password"}}
]}.
-----------------------------------------------------------------------

and added these lines:

-----------------------------------------------------------------------
{odbc_server,
"DSN=MySQLEjabberdSysadminHaiku;UID=ejabberd;PWD=password"}.
-----------------------------------------------------------------------

But I get an authentication error:

-----------------------------------------------------------------------
I(<0.568.0>:ejabberd_c2s:649) : ({socket_state,tls,{tlssock,#Port<0.4138>,#Port<0.4140>},<0.567.0>}) Failed authentication for daniel@sysadminhaiku.com.ar

=INFO REPORT==== 2014-02-24 09:38:56 === 
D(<0.568.0>:ejabberd_c2s:1553) : Send XML on stream = <<"<failure xmlns='urn:ietf:params:xml:ns:xmpp-sasl'><not-authorized/></failure>">> 

=INFO REPORT==== 2014-02-24 09:38:57 === 
D(<0.567.0>:ejabberd_receiver:320) : Received XML on stream = "</stream:stream>" 

=INFO REPORT==== 2014-02-24 09:38:57 === 
D(<0.567.0>:shaper:61) : State: {maxrate,1000,999.6358088704133, 
                                    1393245537046358}, Size=16 
M=15.994175063316883, I=5.973


=INFO REPORT==== 2014-02-24 09:38:57 ===
D(<0.568.0>:ejabberd_c2s:1553) : Send XML on stream = "</stream:stream>"
-----------------------------------------------------------------------

Could the authentication error be related to a connection issue? What I
find strange is that I did a test with isql, and the connection is
established. When I undo the change and authentication is back with
Erlang compiled modules, everything returns to normal.

Any idea what could be the problem?


Thanks in advance for your reply.

Regards,
Daniel
-- 
Daniel Bareiro
Fingerprint: BFB3 08D6 B4D1 31B2 72B9  29CE 6696 BF1B 14E6 1D37
Powered by Debian GNU/Linux Squeeze - Linux user #188.598

Attachment: signature.asc
Description: Digital signature