ejabberd - Comments for "Ejabberd with Mysql : user accounts"

Only some

mfoss — Mon, 11 Oct 2010 10:26:21 +0000

Only some tables go to the Mnesia, others to ODBC, depending on what modules you use.

Does ejabberd use Mnesia when using an external database?

Ivan Martinez — Wed, 06 Oct 2010 19:55:11 +0000

Excuse me for my newbie question. When you configure an external database like MySQL, does ejabberd still use Mnesia to store some data?. If yes, which data goes to Mnesia and which to MySQL?. Thanks in advance.
Iván

failed because of conflicting entries

anil_singhal — Fri, 03 Sep 2010 05:53:08 +0000

HI Badlop,
Thanks, it helped. I realised that while I had opted auth_method odbc initially,(global) I later used auth_method as "internal" in my host_config statement. By changing it to : odbc as below, it worked.

{host_config, "localhost", [{auth_method, [odbc, anonymous]},

anil_singhal wrote: once the

mfoss — Thu, 02 Sep 2010 17:57:00 +0000

anil_singhal wrote:

once the auth_method is odbc - the user accounts should go into mysql database.

Right, when you disable internal, and enable this:
{auth_method, odbc}.
The auth information (username, password) should be stored in the ODBC database that you have configured, not in the internal Mnesia.

Maybe you have some conflicting options in your ejabberd.cfg If you find no clue, you can paste all your file here, or in http://paste.jabbim.cz/