ejabberd - Comments for "LDAP auth, does MySQL storage get used?"

Thanks for coming up with

shaunheatheridge — Thu, 05 Jan 2017 14:46:10 +0000

Thanks for coming up with this. It's just what I need currently, But the link you shares ( https://support.process-one.net/doc/display/MESSENGER/Using+ejabberd+wit... ) looks like its broken. Im heading in to configuring storage in my linux based storage machine (http://www.spectra.com/EMC/used-system/171/index.htm
) hope I can get some good insights. Thanks!

Ok brilliant. Thanks for the

batfastad — Thu, 05 Apr 2012 14:11:39 +0000

Ok brilliant. Thanks for the info.

I will leave it with mod_vcard_ldap for the time being.
People are more likely to keep their details updated in their LDAP directory record (Zimbra).

I'll look into mod_pubsub and post a separate thread if I need info on how to get started with it.

Cheers, B

batfastad wrote: Does the

mikekaganski — Wed, 04 Apr 2012 02:54:48 +0000

batfastad wrote:

Does the MySQL database get "cleaned"? So if an LDAP user is deleted any associated records get removed from the MySQL storage?
I guess not - with LDAP ejabberd won't know when a user will no longer be logging on.

You are right.

batfastad wrote:

Is there a way to store presence changes/history in MySQL?
I'd love to be able to build RSS feeds of user status changes for our intranet.

mod_pubsub(_odbc) implements the XEP-0060 that had been designed to "serve as the foundation for a wide variety of applications, including news feeds, content syndication, rich presence, geolocation, workflow systems, network management systems, and any other application that requires event notifications".

batfastad wrote:

mod_vcard_odbc doesn't seem to be storing the additional info I enter using Pidgin "Set User Info".
I have mod_vcard_ldap also enabled to map the few limited bits of info from LDAP into a user's vcard so that could be the reason. Looking at ejabberd.log and the XMPP console it shows an "error code 405 not allowed" when I try and change that info.
But it would be great if a user could store additional vcard info in MySQL that's not able to be written to LDAP.

You have enabled two different modules that handle the same iq requests. Most possibly only one of them can only work in a time, and you can tell which one yourself if you change the order of them in your config. The functionality you need is not implemented, and you may need to make your custom vcard module to make it possible, or enable only the ODBC one and fill the ODBC database from LDAP using another means.

Ok that's excellent - it's

batfastad — Tue, 03 Apr 2012 11:51:31 +0000

Ok that's excellent - it's much easier for me to keep an eye on that information in MySQL and access it on our intranet.

After a quick test I can confirm that mod_last_odbc has started storing the last seen times of LDAP users in MySQL.
And rostergroups / rosterusers is updated when buddy requests are sent to external s2s users that aren't in our LDAP directory. And those DB records are removed when the buddy is removed from the client. Very cool!

Is there a way to store presence changes/history in MySQL?
I'd love to be able to build RSS feeds of user status changes for our intranet.

batfastad wrote: ...do the

mikekaganski — Tue, 03 Apr 2012 04:59:26 +0000

batfastad wrote:

...do the _odbc modules (eg: mod_last_odbc etc) only work if you are using MySQL for the storage of users?

batfastad wrote:

Could I store any data in MySQL if my users are all stored in LDAP?

Yes