Erlang/OTP Forums

Author Message

<  Ejabberd mailing list  ~  mysql and roster_odbc

Guest
Posted: Tue Aug 08, 2006 3:36 am Reply with quote
Guest
Hello everybody,

Great thanks for great product ejabberd.
But i have small problem.
After install and configure ejabberd from svn 593 i get great jabberd
server.
First, ejabberd works with Mnesia.
{auth_method, internal}.

{mod_roster, []},
...
{mod_vcard, []},
{mod_offline, []},
...
{mod_last, []},

It works great.
But I want change Mnesia to MySql. I export all data by using ejd2odbc.
I used export_roster, export_vcard, export_vcard_search. passwd i move
manual.
further, i used such scenario for prepare system work with mysql :
http://support.process-one.net/doc/display/MESSENGER/Using+ejabberd+with+MySQL+native+driver

After i changed ejabberd.cfg

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

{mod_roster_odbc, []},
...
{mod_vcard_odbc, []},
{mod_offline_odbc, []},
...
{mod_last_odbc, []},
And restart I have working server, but roster of my users have lost. I back
{mod_roster, []},
and after restart Roster back too.
May be some incompotible in ejd2odbc work with mysql or schema of mysql
tables wrong.
May be all harder using JIT. in base exists much records for icq gateway.

Slav Agafonov

_______________________________________________
ejabberd mailing list
ejabberd@jabber.ru
http://lists.jabber.ru/mailman/listinfo/ejabberd
Post recived from mailinglist

Display posts from previous:  

All times are GMT
Page 1 of 1
This forum is locked: you cannot post, reply to, or edit topics.

Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum