mod_log_messages_sql

Introduction

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.

Usage

You will need to create the following table in the configured database:

CREATE TABLE `prosodyarchive` (
        `host` TEXT,
        `user` TEXT,
        `store` TEXT,
        `id` INTEGER PRIMARY KEY AUTOINCREMENT,
        `when` INTEGER,
        `with` TEXT,
        `resource` TEXT,
        `stanza` TEXT);

Compatibility

Does NOT work with 0.10 due to a conflict with the new archiving support in mod_storage_sqlยท


Installation

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