I would like to integrate ejabberd in my chat application. I have configured the Ejabberd in my windows system and which is working fine. I would like to use the external database (Microsoft SQL Server) instead of internal database.
I have done the below changes in config files. C:\Program Files\ejabberd-2.1.1\conf\ejabberd.cfg and C:\Program Files\ejabberd-2.1.11\lib\ejabberd-2.1.11\priv\cfg\ejabberd.cfg, but it doesn't make any difference - it still uses the internal Mnesia database. I have restarted the ejabberd server and no luck.
I have installed the ejabberd by using Windows installer and I haven't used any source.
{odbc_server, "DSN=Ejabberd;UID=sa;PWD=Windows1234"}.
{auth_method, odbc}.
Looking for ejabberd docs?
To access the most up-to-date ejabberd documentation, please visit docs.ejabberd.im »
How to connect SQL Server database with ejabberd
Submitted by senthil on Sat, 2013-11-23 04:56
Adding that information about
Adding that information about your database is the first step. Now you can configure some ejabberd modules to store their tables in SQL instead of Mnesia. Notice, however, that those modules will store in tables named as they want, with the table format they want. The tables names, fields, etc... are not configurable.
Where should I change the
Where should I change the configuration for ejabberd modules to store their tables in SQL? Could you please explain me in more detail and let me know that I can make it work by using the windows installer?