Hi,
I am having some trouble to use a mysql database connected via ODBC on a Linux FC4 installation. Very sorry to disturb you all, but i really need help on this subject.
I will describe what i have done so far.
** Windows
1 – Downloaded the file mysql.sql
2 – Created the database ejabberd using the the above sql script
3 – Created a new user on mysql named ejabberd with password ejabberd
4 – Created a System ODBC connection named ejabberd ( tested ok)
5 - Downloaded and run the binary file with graphical installation procedure from:
6 – Altered the ejabberd.cfg file
%{auth_method, internal}. ( commented with percent sign)
{auth_method, odbc}. ( uncommented )
{odbc_server, "DSN=ejabberd;UID=ejabberd;PWD=ejabberd"}. ( uncommented )
7 – Started the service perfectly
*** Linux
The same except for the link on step 5 that is
The system works fine with internal auth but with mysql just doesn’t do it.
The DSN ODBC connection was tested within UNIXODBC and even used with another application, but not with ejabberd.
Any help is welcome,
Regards,
John
Mysql via ODBC on Linux
Same here
Linux, with unixODBC, mysql.
ejabberd throws the following error:
=ERROR REPORT==== 7-Jul-2006::18:24:53 ===
E(<0.247.0>:ejabberd_hooks:187): {undef,
[{ejabberd_odbc,escape,["bah"]},
{ejabberd_auth_odbc,is_user_exists,2},
{lists,any,2},
{ejabberd_auth,try_register,3},
{mod_register,try_register,3},
{mod_register,process_iq,3},
{mod_register,
unauthenticated_iq_register,
3},
{ejabberd_hooks,run_fold1,4}]}
running hook: {c2s_unauthenticated_iq,["localhost",
{iq,"aab0a",
set,
"jabber:iq:register",
[],
{xmlelement,
"query",
[{"xmlns","jabber:iq:register"}],
[{xmlcdata,<<"\n">>},
{xmlelement,
"username",
[],
[{xmlcdata,<<"bah">>}]},
{xmlcdata,<<"\n">>},
{xmlelement,
"password",
[],
[{xmlcdata,<<"aaaa">>}]},
{xmlcdata,<<"\n">>}]}}]}
[solved] (for me)
OK,it was a problem in erlang installation (should have enabled odbc ;)).
Thanks anyway,
Pedro
Erlang odbc
how can i enable erlang odbc if i installed ejabberd from linux binary? There was no such question?
Is it necessary to install odbc erlang module to use native mysql driver?
Re: Erlang odbc
how can i enable erlang odbc if i installed ejabberd from linux binary? There was no such question?
Is it necessary to install odbc erlang module to use native mysql driver?
I'm not sure, but it might be a bug in the latest version of the installer. Ask Mickaël Rémond.
Re: Erlang odbc
Hello
I have tried to setup ejabberd with mysql via ODBC on Linux.The DSN ODBC connection was tested within UNIXODBC.It's connected successfully.
So There is no issue in odbc configuration.
Also configured the ejabberd according to given steps.The problem is authentication failed in login prompt of ejabberd in browser?
Can anyone please post the steps to achieve it? Actually i am facing same problem.
Any help would be appreciated.
Thank you