database - ejabberd PostgreSQL chat persistence table -


i using odbc auth_method in ejabberd , using postgres database. need see chat history (messages) made between 2 users in database.

followed these steps:

1) createdb myejabberd;

2) psql myejabberd < /path/to/my/pg.sql

3) create user ejabberduser;

4) commented auth_method: odbc , enabled auth_method: odbc.

5) odbc configuration, use postgres enabled

odbc_type: pgsql odbc_server: "localhost" odbc_database: "myejabberd" odbc_username: "ejabberduser" odbc_password: "ejabberd"

6) tried run admin http://localhost:5280/admin. works fine , made between 2 users using adium.

i can see registered users in users table cant able find out table chat history stored.

please help.

as default, message history not stored in database.

you may want message archive management (xep-0313, aka mam) xmpp extension, supported in ejabberd 15.06.

you can use mod_mam (message archive management - xep-0313) module. works perfect. , dont forget add default option always or roster. default never


Comments

Popular posts from this blog

python - No exponential form of the z-axis in matplotlib-3D-plots -

php - Best Light server (Linux + Web server + Database) for Raspberry Pi -

c# - "Newtonsoft.Json.JsonSerializationException unable to find constructor to use for types" error when deserializing class -