Mercurial > prosody-modules

comparison mod_log_messages_sql/README.md @ 5975:fe081789f7b5

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
comparison
equal deleted inserted replaced
5974:5a65a632d5b9 5975:fe081789f7b5
1 # Introduction
2
3 ::: {.alert .alert-danger}
4 Consider using [mod_mam][doc:modules:mod_mam] together with
5 [mod_readonly] instead.
6 :::
7
8 This module logs messages to a SQL database.
9
10 SQL connection options are configured in a `message_log_sql` option,
11 which has the same syntax as the `sql` option for
12 [mod_storage_sql][doc:modules:mod_storage_sql].
13
14 # Usage
15
16 You will need to create the following table in the configured database:
17
18 ``` sql
19 CREATE TABLE `prosodyarchive` (
20 `host` TEXT,
21 `user` TEXT,
22 `store` TEXT,
23 `id` INTEGER PRIMARY KEY AUTOINCREMENT,
24 `when` INTEGER,
25 `with` TEXT,
26 `resource` TEXT,
27 `stanza` TEXT);
28 ```
29
30 # Compatibility
31
32 Does *NOT* work with 0.10 due to a conflict with the new archiving
33 support in `mod_storage_sql`ยท