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
Post a Comment