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. ,...