Mercurial > prosody-modules
diff mod_log_messages_sql/README.md @ 5975:fe081789f7b5
All community modules: Unify file extention of Markdown files to .md
| author | Menel <menel@snikket.de> |
|---|---|
| date | Tue, 22 Oct 2024 10:26:01 +0200 |
| parents | mod_log_messages_sql/README.markdown@b74c86d137c9 |
| children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/mod_log_messages_sql/README.md Tue Oct 22 10:26:01 2024 +0200 @@ -0,0 +1,33 @@ +# 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`ยท
