+
−# Introduction
+
−
+
−::: {.alert .alert-danger}
+
−Consider using [mod_mam][doc:modules: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][doc:modules:mod_storage_sql].
+
−
+
−# Usage
+
−
+
−You will need to create the following table in the configured database:
+
−
+
−``` sql
+
−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`·