We are up and running using ejabberd 16.02 on a Windows 2012 server using MS SQL Server 2012 via ODBC for database. Everything is working as expected except Offline Messages.
From yml:
mod_offline:
access_max_user_messages: max_user_offline_messages
db_type: odbc
database built from latest script
The database spool table is populated when offline messages are sent, and when a user that has offline messages logs in the messages are read from the spool table and then deleted all can be seen real-time via the MSSQL Profiler. . Unfortunately The client itself never displays the messages and no errors in the log files.
If we switch to an internal database for this feature, the client does receive the messages so we know the client is working and this must be related to the odbc/mssql setup.
Can anyone assist us that has this working?
