ejabberd - Comments for "ejabberd 2.0.1 (solved: mod_*_odbc) and (unsolved: roster status updates)"

Are you using the original

mfoss — Mon, 03 Aug 2009 10:39:35 +0000

Are you using the original configuration, or you changed anything in it? Try with the default config, or at least show here what lines you have added/changed/removed.

It's client-independent

drakedevel — Sat, 01 Aug 2009 02:04:25 +0000

It behaves the same on Pidgin, Psi, and other random clients.

I created test accounts; when I add them to each others' rosters, authorization requests are not received on either account. This tells us the next-to-root cause at least.

The following appears in the logs after every auth request:

D(<0.348.0>:ejabberd_c2s:1352) : Send XML on stream = "<iq from='test1@[redacted]' to='test1@[redacted]/476843264124990176606330' type='error' id='purple61be4e8b'><ping xmlns='urn:xmpp:ping'/><error code='503' type='cancel'><service-unavailable xmlns='urn:ietf:params:xml:ns:xmpp-stanzas'/></error></iq>"

Some ideas to try

mfoss — Thu, 30 Jul 2009 08:00:09 +0000

If you just replaced in ejabberd.cfg mod_roster by mod_roster_odbc, then roster/subscriptions/presence should work correctly using ODBC (in your case MySQL) storage.

Try with other Jabber clients (well known are Psi, Gajim, Tkabber or Jabbim).

Try also creating two more accounts: test1 and test2. Login to each one with a different client. Add between them as contacts, then login to both, and let's see if presence is displayed correctly.

MySQL Problem Fixed

drakedevel — Thu, 30 Jul 2009 02:19:37 +0000

It was from Debian. I installed the relevant odbc packages, and built the mysql module from SVN. MySQL works grand now.

Presence is still messed up. My roster appears fine, even with MySQL, but every contact gets re-marked "Not Authorized" every time I re-login. I do not get any status information on them at all unless they change status at some point (i.e. to away) (but when they do change their status, I do see it. It goes away when I log out/in again though).

Is there a module responsible for this that I can peek at?

Thanks!

2. remember to do: ./configure --enable-odbc

mfoss — Wed, 22 Jul 2009 19:21:57 +0000

1. No idea of your problem. Presence should work as usual.

2. If you compiled ejabberd from source code, remember to do: ./configure --enable-odbc
Also, if you installed ejabberd from source code or from some OS package (like Debian, Ubuntu), remember to also install the mysql erlang library. You will find some links in the ejabberd Guide.