module could not be loaded

Hi,

I have ejabberd running fine when using the internal database but am getting the error below when trying to access MySQL.

Versions i'm using are:

ejabberd v1.1.1
MyQSL v5.0.21

Server: Dual AMD Opteron 250 - 4 Gig memory
Os Fedora Core 5 x86_64

The command line I'm using is:

erl -pa /var/lib/ejabberd/ebin -sname ejabberd -s ejabberd -ejabberd config \"/etc/ejabberd/ejabberd.cfg\" log_path \"/var/log/ejabberd/ejabberd.log\" -sasl sasl_error_logger \{file,\"/var/log/ejabberd/sasl.log\"\} -mnesia dir \"/var/lib/ejabberd/spool\"

This is a quick run-down how I configured MySQL:

I downloaded the latest erl files for MySQL.
Compiled them using the Erl compiler c(module).
Copied the beam files to the same place as ejabberd beam files. (/var/lib/ejabberd/ebin/)

-rw-r--r-- 1 root root 2868 Jun 4 03:18 mysql_auth.beam
-rw-r--r-- 1 root root 6268 Jun 4 03:18 mysql.beam
-rw-r--r-- 1 root root 8176 Jun 4 03:18 mysql_conn.beam
-rw-r--r-- 1 root root 2020 Jun 4 03:18 mysql_recv.beam

Created the tables with the supplied MySQL.sql file.
Added necessary rights ( as per instructions )

Here is a link to the MySQL config page I followed:

http://support.process-one.net/doc/display/MESSENGER/Using+ejabberd+with...

Modified my ejabberd.cfg file with the following entries:

---- ejabberd.cfg entries ----

{auth_method, odbc}.
{odbc_server, {mysql, "localhost", "ejabberd", "ejabberd", "mypass"}}.

added odbc to the following entries:

{mod_roster_odbc, []},
{mod_vcard_odbc, []},
{mod_offline_odbc, []},
{mod_last_odbc, []},

---- ejabberd.cfg entries ----

Forgive me but I don't know much about Erlang. If anyone can shed some light on this I would really appreciate it.

Thank you in advance.

Phil

---- Error ----

=INFO REPORT==== 5-Jun-2006::17:49:33 ===
I(<0.225.0>:ejabberd_listener:90): (#Port<0.335>) Accepted connection {{192,168,68,150},1128} -> {{192,168,68,102},5222}
(ejabberd@zeus)1>
=ERROR REPORT==== 5-Jun-2006::17:49:33 ===
** State machine <0.272.0> terminating
** Last event in was {xmlstreamelement,
{xmlelement,"response",
[{"xmlns",
"urn:ietf:params:xml:ns:xmpp-sasl"}],
[{xmlcdata,
<<"dXNlcm5hbWU9InBoaWwiLHJlYWxtPSIiLG5vbmNlPSIxODYzNzI3MTg0Iixjbm9uY2U9IjM0MDRhWI1Pa1Vjg0ZA1OTRiY2U5NDc2zRlYmMyYTBmNGYzM2UxM2UiLG5jPTAwMDAwMDAxLHFvcD1hdXRoLGRpZ2VzdC11cmk9InhtcHAvY2hhdGluYWJveC5jb20iLGNoYXJzZXQ9dXRmLTgscmVzcG9uc2U9MTdmZGE0ODI0OGE5NzNkOWJmZDJiMjllMTk4NGJkYWQ=">>}]}}
** When State == wait_for_sasl_response
** Data == {state,{tlssock,#Port<0.335>,#Port<0.345>},
<0.273.0>,
tls,
"2367574715",
{sasl_state,"jabber",
"mydomain.com",
[],
#Fun,
#Fun,
cyrsasl_digest,
{state,
3,
"1863727184",
undefined,
undefined,
#Fun}},
c2s,
c2s_shaper,
false,
true,
false,
true,
[{certfile,"/etc/ejabberd/server.pem"}],
false,
undefined,
[],
"chatinabox.com",
[],
undefined,
{0,nil},
{0,nil},
{0,nil},
{0,nil},
undefined,
undefined,
undefined,
false,
none,
"en"}
** Reason for termination =
** {'module could not be loaded',[{ejabberd_odbc,escape,["phil"]},
{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}]}

---- Error ----