[ejabberd] mod_last_odbc with PostgreSQL

Badlop badlop at gmail.com
Wed Oct 31 02:33:13 MSK 2012


Try with the stable ejabberd 2.1.x branch, instead of 'master' branch.


On 30 October 2012 22:32, Alex Favaro <afavaro at omnihours.com> wrote:
> Has anybody had any luck configuring mod_last_odbc with the native
> PostgreSQL driver?
>
> I installed ejabberd from source using the instructions here, added the
> table "last" to my database using the schema in mod_last.erl, and added the
> following lines to my ejabberd.cfg:
>
> {modules, [
>   ...
>   {mod_last_odbc, []},
>   ...
> ]}
> ...
> {host_config, "localhost", [
>   {odbc_server, {pgsql, "localhost", "<database>", "<user>", "<password>"}}
> ]}.
>
> But when I run ejabberd and start sending messages between two users I don't
> see any rows in the database table I created. There are no error messages in
> either the ejabberd or PostgreSQL logs so I'm not really sure how to debug
> this. Has anyone successfully configured this? I'm running ejabberd 2.1.11
> with PostgreSQL 9.1
>
> Also, will this module track any kind of activity from users or do I need to
> explicitly send presence stanzas to update the last activity? (I've tried
> doing this but still no luck)
>
> -Alex

---
Badlop
ProcessOne


More information about the ejabberd mailing list