Hi,
I’ve got a Postgres database setup, with ODBC drivers on Windows 2003, and ejabber configuration file using the ODBC modules. All the ODBC modules is working correctly, but the presence is not automatically send if a user logs on, it is however sent when the user is initially added as a contact. But there after, if the user logs off and back on, his status remain offline. When using the normal roster module it works as expected.
Has anyone experienced a similar problem?
using ODBC Roster Module ?
Is anyone using the ODBC Roster Module ?
Tiaan
Roster
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
ODBC
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.
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
So does your MSSQL patch work?
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.
Just wondering about the MSSQL Patch...
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
There is a thread about
There is a which might interest you.
--
sander