author | Kim Alvefur <zash@zash.se> |
Fri, 16 Feb 2018 07:54:35 +0100 | |
changeset 2886 | 6f289283feb1 |
parent 2410 | a216be9b1d6e |
child 3442 | b74c86d137c9 |
permissions | -rw-r--r-- |
2410
a216be9b1d6e
mod_log_messages_sql/README: Point out incompatibility with 0.10
Kim Alvefur <zash@zash.se>
parents:
2327
diff
changeset
|
1 |
# Introduction |
a216be9b1d6e
mod_log_messages_sql/README: Point out incompatibility with 0.10
Kim Alvefur <zash@zash.se>
parents:
2327
diff
changeset
|
2 |
|
2327 | 3 |
This module logs messages to a SQL database. |
4 |
||
5 |
SQL connection options are configured in a `message_log_sql` option, |
|
6 |
which has the same syntax as the `sql` option for |
|
7 |
[mod_storage_sql][doc:modules:mod_storage_sql]. |
|
8 |
||
2410
a216be9b1d6e
mod_log_messages_sql/README: Point out incompatibility with 0.10
Kim Alvefur <zash@zash.se>
parents:
2327
diff
changeset
|
9 |
# Usage |
a216be9b1d6e
mod_log_messages_sql/README: Point out incompatibility with 0.10
Kim Alvefur <zash@zash.se>
parents:
2327
diff
changeset
|
10 |
|
2327 | 11 |
You will need to create the following table in the configured database: |
12 |
||
13 |
``` sql |
|
14 |
CREATE TABLE `prosodyarchive` ( |
|
15 |
`host` TEXT, |
|
16 |
`user` TEXT, |
|
17 |
`store` TEXT, |
|
18 |
`id` INTEGER PRIMARY KEY AUTOINCREMENT, |
|
19 |
`when` INTEGER, |
|
20 |
`with` TEXT, |
|
21 |
`resource` TEXT, |
|
22 |
`stanza` TEXT); |
|
23 |
``` |
|
2410
a216be9b1d6e
mod_log_messages_sql/README: Point out incompatibility with 0.10
Kim Alvefur <zash@zash.se>
parents:
2327
diff
changeset
|
24 |
|
a216be9b1d6e
mod_log_messages_sql/README: Point out incompatibility with 0.10
Kim Alvefur <zash@zash.se>
parents:
2327
diff
changeset
|
25 |
# Compatibility |
a216be9b1d6e
mod_log_messages_sql/README: Point out incompatibility with 0.10
Kim Alvefur <zash@zash.se>
parents:
2327
diff
changeset
|
26 |
|
a216be9b1d6e
mod_log_messages_sql/README: Point out incompatibility with 0.10
Kim Alvefur <zash@zash.se>
parents:
2327
diff
changeset
|
27 |
Does *NOT* work with 0.10 due to a conflict with the new archiving |
a216be9b1d6e
mod_log_messages_sql/README: Point out incompatibility with 0.10
Kim Alvefur <zash@zash.se>
parents:
2327
diff
changeset
|
28 |
support in `mod_storage_sql`ยท |