Authentication Failed

Hi All,

I am facing a fairly urgent problem. Any help is highly appreciated.

Configurations is below:
Using latest version of Ubuntu 14.04, ejabberd, erlang OTP, iODBC, FreeTDS, Microsoft SQL Server on a separate server.

I configured ejabberd to use "external auth" using "odbc". I am using MS SQL server for the database. I am able to establish the connection. Using the "ctl" tool, I can register users. I checked the database and all users are entered which I created using command line.

Upon trying to connect using a client, I get the following error (see detailed message below). I tried using plain authentication, using SSL certificate (self signed and StartTLS free certificate as well), but I get the same error.

If I use the internal database for auth method, everything works just fine.

I am not able to make any headway, please help me with this issue.

Additional info: I can directly connect via the erl shell to the MS SQL database and do all kinds o queries against it.

2015-08-10 04:41:57.465 [debug] <0.653.0>@ejabberd_receiver:process_data:338 Received XML on stream = ""
2015-08-10 04:41:57.466 [debug] <0.653.0>@shaper:update:69 State: {maxrate,1000,0,1439181717432884}, Size=51
M=25.5, I=33.14
2015-08-10 04:41:57.466 [debug] <0.653.0>@ejabberd_receiver:process_data:338 Received XML on stream = ""
2015-08-10 04:41:57.466 [debug] <0.653.0>@shaper:update:69 State: {maxrate,1000,769.4628847314424,1439181717466024}, Size=0
M=0.0, I=0.398
2015-08-10 04:41:57.499 [debug] <0.653.0>@ejabberd_receiver:process_data:338 Received XML on stream = ""
2015-08-10 04:41:57.499 [debug] <0.653.0>@shaper:update:69 State: {maxrate,1000,384.7314423657212,1439181717466422}, Size=0
M=0.0, I=32.951
2015-08-10 04:41:57.555 [debug] <0.653.0>@ejabberd_receiver:process_data:338 Received XML on stream = ""
2015-08-10 04:41:57.556 [debug] <0.653.0>@shaper:update:69 State: {maxrate,1000,192.3657211828606,1439181717499373}, Size=0
M=0.0, I=56.666
2015-08-10 04:41:57.620 [debug] <0.653.0>@ejabberd_receiver:process_data:338 Received XML on stream = ""
2015-08-10 04:41:57.620 [debug] <0.653.0>@shaper:update:69 State: {maxrate,1000,96.1828605914303,1439181717556039}, Size=0
M=0.0, I=64.307
2015-08-10 04:41:57.653 [debug] <0.653.0>@ejabberd_receiver:process_data:338 Received XML on stream = ""
2015-08-10 04:41:57.653 [debug] <0.653.0>@shaper:update:69 State: {maxrate,1000,48.09143029571515,1439181717620346}, Size=114
M=58.40437496376742, I=33.148
2015-08-10 04:41:57.653 [debug] <0.654.0>@ejabberd_c2s:send_text:1453 Send XML on stream = <<"<?xml version='1.0'?>">>
2015-08-10 04:41:57.654 [debug] <0.654.0>@ejabberd_c2s:send_text:1453 Send XML on stream = <<"PLAIN
DIGEST-MD5SCRAM-SHA-1">>
2015-08-10 04:41:57.685 [debug] <0.653.0>@ejabberd_receiver:process_data:338 Received XML on stream = ""
2015-08-10 04:41:57.686 [debug] <0.653.0>@shaper:update:69 State: {maxrate,1000,0,1439181717653900}, Size=162
M=81.0, I=32.187
2015-08-10 04:41:57.686 [debug] <0.654.0>@ejabberd_c2s:send_text:1453 Send XML on stream = <<"bm9uY2U9IjI5ODYwMzU3ODAiLHFvcD0iYXV0aCIsY2hhcnNldD11dGYtO
CxhbGdvcml0aG09bWQ1LXNlc3M=">>
2015-08-10 04:41:57.736 [debug] <0.653.0>@ejabberd_receiver:process_data:338 Received XML on stream = "dXNlcm5hbWU9InRlc3R1c2VyNSIscmVhbG09ImxvY2FsaG9zd
CIsbm9uY2U9IjI5ODYwMzU3ODAiLGNub25jZT0iODcyYmUxMTYxNDM5MTgxNzIxZTk1OWMxYTkiLG5jPTAwMDAwMDAxLHFvcD1hdXRoLGRpZ2VzdC11cmk9InhtcHAvbG9jYWxob3N0IixyZXNwb25zZT0yYzEyM2FhOTBjMGVlOGI0NGMxM2MwZTlmMjgxOGViNixjaGFy
c2V0PXV0Zi04"
2015-08-10 04:41:57.736 [debug] <0.653.0>@shaper:update:69 State: {maxrate,1000,997.696675576139,1439181717735087}, Size=326
M=325.25084179221864, I=1.443
2015-08-10 04:41:57.757 [info] <0.654.0>@ejabberd_c2s:handle_sasl_step:2885 ({socket_state,ejabberd_tls,{tlssock,#Port<0.5720>,#Port<0.5722>},<0.653.0>}) Failed authentication for testuser5@localhost fro
m IP 97.81.71.188 ({{97,81,71,188},56810})
2015-08-10 04:41:57.757 [debug] <0.654.0>@ejabberd_c2s:send_text:1453 Send XML on stream = <<"">>
2015-08-10 04:41:58.061 [debug] <0.653.0>@ejabberd_receiver:process_data:338 Received XML on stream = ""
2015-08-10 04:41:58.061 [debug] <0.653.0>@shaper:update:69 State: {maxrate,1000,999.7040944028992,1439181718060530}, Size=16
M=15.995266910993916, I=1.065