Hello everybody,
I'm beginning to use ejabberd to migrate our old server (jabberd 1.4) to ejabberd. We would like use ejabberd with MySQL database to store users's informations. I read some informations but i did't find any answer in development or installation guide. So i'd like to know:
-> How informations are storing in ejabberd ? I read that, when you use MySQL database with ejabberd, some informations stored in MySQL database (Users, Rosters, VCard...) but others stored in Mnesia database. What informations stored where ?
Besides, what is the purpose of the column 'state' in the table 'LAST' in MySQL. Is it to store the users state (online, available, away...) ?
Why in the table VCard-Search are there 2 columns for each informations (username and lusername, birthday and lbirthday ...
-> When i tried to import users accounts (form jabberd 1.4 to ejabberd with Mnesia), it worked very well but when i tried to import to ejabberd with MySQL, it did't ! I read there is one script or file to migrate Mnesia database to ODBC database (ejd2odbc.erl) but there any example to use this. Can i use this and how can i use ?
Thanks a lot
