Consider using mod_mam together with mod_readonly instead.
This module logs messages to a SQL database.
SQL connection options are configured in a
message_log_sql
option, which has the same syntax as the
sql
option for mod_storage_sql.
You will need to create the following table in the configured database:
CREATE TABLE `prosodyarchive` (
`host` TEXT,
`user` TEXT,
`store` TEXT,INTEGER PRIMARY KEY AUTOINCREMENT,
`id` INTEGER,
`when`
`with` TEXT,
`resource` TEXT, `stanza` TEXT);
Does NOT work with 0.10 due to a conflict with the new
archiving support in mod_storage_sql
ยท
With the plugin installer in Prosody 0.12 you can use:
sudo prosodyctl install --server=https://modules.prosody.im/rocks/ mod_log_messages_sql
For earlier versions see the documentation for installing 3rd party modules