ejabberd - Comments for "ODBC Roster Module"

There is a thread about

sander — Thu, 17 Nov 2005 22:44:20 +0000

There is a thread about MSSQL and ejabberd which might interest you.
--
sander

Just wondering about the MSSQL Patch...

aussieman9 — Thu, 17 Nov 2005 14:12:47 +0000

Hi,

I am new to ejabberd, but have a test server up and running in a virtual PC runing Windows 2003.

I would like to explore storage using MS SQL Server, and I was wondering if there had been any progress, and well i am still learning, i would offer help too.

Thanks
AM

So does your MSSQL patch work?

mfoss — Fri, 14 Oct 2005 22:41:22 +0000

If you want to use an MSSQL database, a few changes need to be made to the modules, if you want these files, just ask.

Did you finally got ejabberd to work correctly with MSSQL? If so, you could make a patch and submit it to Bugzilla and/or the Contributions page.

If you are too busy now, just send me the modified files and I'll make everything else.

ODBC

tiaan — Fri, 14 Oct 2005 20:29:29 +0000

You need to comment,

%{auth_method, internal}.

and uncommend,

{auth_method, odbc}.
{odbc_server, "DSN=ejabberd;UID=ejabberd;PWD=ejabberd"}.

and change the module section as below.

% Used modules:
{modules,
[
{mod_register, [{access, register}]},
{mod_roster_odbc, []},
{mod_shared_roster, []},
{mod_privacy, []},
{mod_configure, []},
{mod_disco, []},
{mod_stats, []},
{mod_vcard, []},
{mod_offline_odbc, []},
{mod_announce, [{access, announce}]},
{mod_private, []},
{mod_irc, []},
{mod_pubsub, []},
{mod_time, []},
{mod_last_odbc, []},
{mod_version, []}
]}.

There is an bug in the roster_odbc module, the fixed file can be downloaded from, it need to be compiled.

http://svn.process-one.net/ejabberd/trunk/src/mod_roster_odbc.erl

If you want to use an MSSQL database, a few changes need to be made to the modules, if you want these files, just ask.

Tiaan

Roster

yeyo — Fri, 14 Oct 2005 12:23:03 +0000

I don't use because i can't configure it correctly.. Could You post here your
%{odbc_server, "DSN=ejabberd;UID=ejabberd;PWD=ejabberd"}.
section from ejabberd.cfg?

Of course i need proper syntax, not real data :)

Andrzej

using ODBC Roster Module ?

tiaan — Wed, 12 Oct 2005 06:55:30 +0000

Is anyone using the ODBC Roster Module ?

Tiaan