[ejabberd] mod_last_odbc with PostgreSQL

Alex Favaro afavaro at omnihours.com
Wed Oct 31 02:47:53 MSK 2012


I did compile from the 2.1.x branch - I was just referencing that file to
set up the schema for my database. In particular, I used the 2.1.x / odbc
schema from the comments section (a table named "last" with columns
"username", "seconds", and "state").

On Tue, Oct 30, 2012 at 3:33 PM, Badlop <badlop at gmail.com> wrote:

> 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
> _______________________________________________
> ejabberd mailing list
> ejabberd at jabber.ru
> http://lists.jabber.ru/mailman/listinfo/ejabberd
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.jabber.ru/pipermail/ejabberd/attachments/20121030/41773951/attachment.html>


More information about the ejabberd mailing list