ejabberd - Comments for "Getting ejabberd to work with an already set database of users."

Thank you very much,

dS_Jeffrey — Thu, 07 Sep 2006 19:48:58 +0000

Thank you very much, compiling with --enable-odbc worked, it still gave me warnings and i still had to get the mysql beam files from https://support.process-one.net/doc/display/MESSENGER/Using+ejabberd+wit...

but i got the authentication to work with our database.

somethings dont completely work tho, such as the web interface, but thats another monster.

Thanks,
Jeffrey R. | dS

--enable-odbc?

legoscia — Tue, 05 Sep 2006 20:13:48 +0000

dS_Jeffrey wrote:

=ERROR REPORT==== 5-Sep-2006::15:44:30 ===
** State machine <0.292.0> terminating
** Last event in was {xmlstreamelement,
...
** Reason for termination =
** {'module could not be loaded',[{ejabberd_odbc,escape,["jeffrey"]},
{ejabberd_auth_odbc,get_password,2},
{lists,foldl,3},
{cyrsasl_digest,mech_step,2},
{cyrsasl,server_step,2},
{ejabberd_c2s,wait_for_sasl_response,2},
{gen_fsm,handle_msg,7},
{proc_lib,init_p,5}]}

=CRASH REPORT==== 5-Sep-2006::15:44:30 ===
crasher:
pid: <0.292.0>
registered_name: []
error_info: {undef,[{ejabberd_odbc,escape,["jeffrey"]},
...

We see that the function ejabberd_odbc:escape is undefined (undef), as the module ejabberd_odbc could not be loaded.

Did you configure ejabberd with --enable-odbc? It's not enabled by default. Or is there any other reason why the file ejabberd_odbc.beam is missing among the other beam files?

Well, it compiles cleanly

dS_Jeffrey — Tue, 05 Sep 2006 19:45:04 +0000

Well, it compiles cleanly without the modifications, it seems as tho the variables are getting mixed up somewhere thus it starts throwing warnings.

These are the errors i get when i try to authenticate a user.

---------------------------------------------------------------------------------

ejabberd.log wrote:

=ERROR REPORT==== 5-Sep-2006::15:44:30 ===
** State machine <0.292.0> terminating
** Last event in was {xmlstreamelement,
{xmlelement,"response",
[{"xmlns",
"urn:ietf:params:xml:ns:xmpp-sasl"}],
[{xmlcdata,
<<"dXNlcm5hbWU9ImplZmZyZXkiLHJlYWxtPSJ kaWdzYnkwNC5yaXQuZWR1Iixub25jZT0iMTI2OTYxMTkwNyIsY25vbmNlPSJkNTgyOTU3YWQ4MzQ4YjR iMjY4OTlmY2NjNmYxNzhhNTFiOWMwMTY0IixuYz0wMDAwMDAwMSxxb3A9YXV0aCxkaWdlc3QtdXJpPSJ 4bXBwL2RpZ3NieTA0LnJpdC5lZHUiLGNoYXJzZXQ9dXRmLTgscmVzcG9uc2U9YTFmN2ZiZTRiMDhlODI yNjUwY2I1YjY1NTIwMDE3ODU=">>}]}}
** When State == wait_for_sasl_response
** Data == {state,#Port<0.313>,
<0.293.0>,
gen_tcp,
"2996843388",
{sasl_state,"jabber",
"MYDOMAIN.COM",
[],
#Fun,
#Fun,
cyrsasl_digest,
{state,
3,
"1269611907",
undefined,
undefined,
#Fun}},
c2s,
c2s_shaper,
false,
false,
false,
false,
[],
false,
undefined,
[],
"MYDOMAIN.COM",
[],
undefined,
{0,nil},
{0,nil},
{0,nil},
{0,nil},
undefined,
undefined,
undefined,
false,
none,
[],
false}
** Reason for termination =
** {'module could not be loaded',[{ejabberd_odbc,escape,["jeffrey"]},
{ejabberd_auth_odbc,get_password,2},
{lists,foldl,3},
{cyrsasl_digest,mech_step,2},
{cyrsasl,server_step,2},
{ejabberd_c2s,wait_for_sasl_response,2},
{gen_fsm,handle_msg,7},
{proc_lib,init_p,5}]}

=CRASH REPORT==== 5-Sep-2006::15:44:30 ===
crasher:
pid: <0.292.0>
registered_name: []
error_info: {undef,[{ejabberd_odbc,escape,["jeffrey"]},
{ejabberd_auth_odbc,get_password,2},
{lists,foldl,3},
{cyrsasl_digest,mech_step,2},
{cyrsasl,server_step,2},
{ejabberd_c2s,wait_for_sasl_response,2},
{gen_fsm,handle_msg,7},
{proc_lib,init_p,5}]}
initial_call: {gen,init_it,
[gen_fsm,
<0.171.0>,
<0.171.0>,
ejabberd_c2s,
[{gen_tcp,#Port<0.313>},
[{access,c2s},{shaper,c2s_shaper}]],
[]]}
ancestors: [ejabberd_c2s_sup,ejabberd_sup,<0.40.0>]
messages: [{'$gen_event',closed}]
links: [<0.171.0>]
dictionary: []
trap_exit: false
status: running
heap_size: 1597
stack_size: 21
reductions: 14358
neighbours:

=SUPERVISOR REPORT==== 5-Sep-2006::15:44:30 ===
Supervisor: {local,ejabberd_c2s_sup}
Context: child_terminated
Reason: {undef,[{ejabberd_odbc,escape,["jeffrey"]},
{ejabberd_auth_odbc,get_password,2},
{lists,foldl,3},
{cyrsasl_digest,mech_step,2},
{cyrsasl,server_step,2},
{ejabberd_c2s,wait_for_sasl_response,2},
{gen_fsm,handle_msg,7},
{proc_lib,init_p,5}]}
Offender: [{pid,<0.292.0>},
{name,undefined},
{mfa,{ejabberd_c2s,start_link,
[{gen_tcp,#Port<0.313>},
[{access,c2s},{shaper,c2s_shaper}]]}},
{restart_type,temporary},
{shutdown,brutal_kill},
{child_type,worker}]

---------------------------------------------------------------------------------

Warnings from where?

legoscia — Tue, 05 Sep 2006 18:51:32 +0000

dS_Jeffrey wrote:

The only thing modified were the SQL queries, but i even made it keep the same column names. unfortunately this made the "make" command when compiling dump errors glore giving me about 50+ errors such as the following.

Warning: variable 'Extra' is unused

That's not an error, it's just a warning ;)

Are you sure that those lines come from the ejabberd_auth_odbc module? There are many ejabberd modules that do produce many such warnings, but it seems that ejabberd_auth_odbc from ejabberd 1.1.1 compiles without warnings. If your changes have increased the number of warnings, you should pay attention, otherwise it will probably work anyway.