[ejabberd] mod_last_odbc with PostgreSQL

Felix GV felix at mate1inc.com
Tue Nov 6 23:06:52 MSK 2012


Actually, it's working now...

I'm not sure what went wrong the first time around...

So then, regarding the OP's problem, is it possible that it's a
pgsql-specific issue?

--
Felix



On Tue, Nov 6, 2012 at 1:56 PM, Felix GV <felix at mate1inc.com> wrote:

> Hello,
>
> I don't know if you solved your issue (?), but I have a similar one!
>
> I am using the binary distribution of ejabberd 2.1.11 that's available on
> the process-one website.
>
> I configured ejabberd to use the MySQL native driver and created the
> tables for all of the ejabberd modules in a MySQL DB (by executing the
> mysql.sql file).
>
> I tested out mod_roster_odbc and that seemed to work fine (it's inserting
> and updating rows in the rosterusers table and not adding any new records
> to the roster Mnesia table).
>
> When I try to use mod_last_odbc, however, the MySQL table named last
> remains empty. Also, in the admin interface, I see new records being
> created in the last_activity Mnesia table, as if the non-ODBC version of
> mod_last was still running...
>
> It seems clear that the MySQL database and native driver are properly
> installed and configured, since mod_roster_odbc is able to write into the
> DB. Is it possible that mod_last_odbc is not behaving correctly?
>
> I can provide any other info (configs, logs, etc...) if needed.
>
> Thanks :) !
>
> --
> Felix
>
>
>
>
> On Tue, Oct 30, 2012 at 6:47 PM, Alex Favaro <afavaro at omnihours.com>wrote:
>
>> 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
>>>
>>
>>
>> _______________________________________________
>> 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/20121106/4b6a41c6/attachment.html>


More information about the ejabberd mailing list