Mercurial > prosody-modules
annotate mod_log_messages_sql/README.md @ 6319:04c3273cb81f
mod_auth_cyrus: Add empty 'profile' table to SASL handler objects
This is for compatibility with Prosody's built-in util.sasl objects.
A SASL profile table usually includes methods supported by the backend, which
can be used by SASL mechanism handlers to perform operations (such as testing
the password). It also optionally contains a 'cb' field with channel binding
method handlers.
The Cyrus backend doesn't support channel binding, and doesn't have the same
concept of auth backend methods (it handles all that internally, and Prosody
has no insight or control over it).
Thus, we create an empty profile which informs Prosody that the SASL handler
does not support any of the auth or channel binding methods. Some features
will not work, but they didn't work anyway. This just makes it explicit.
This fixes a traceback in mod_sasl2_fast, which expected SASL handlers to
always contain a 'profile' field.
| author | Matthew Wild <mwild1@gmail.com> |
|---|---|
| date | Thu, 04 Sep 2025 10:14:46 +0100 |
| parents | fe081789f7b5 |
| children |
| rev | line source |
|---|---|
|
2406
a216be9b1d6e
mod_log_messages_sql/README: Point out incompatibility with 0.10
Kim Alvefur <zash@zash.se>
parents:
2323
diff
changeset
|
1 # Introduction |
|
a216be9b1d6e
mod_log_messages_sql/README: Point out incompatibility with 0.10
Kim Alvefur <zash@zash.se>
parents:
2323
diff
changeset
|
2 |
|
3438
b74c86d137c9
mod_log_messages_sql/README: Add pointer towards mod_mam + mod_readonly
Kim Alvefur <zash@zash.se>
parents:
2406
diff
changeset
|
3 ::: {.alert .alert-danger} |
|
b74c86d137c9
mod_log_messages_sql/README: Add pointer towards mod_mam + mod_readonly
Kim Alvefur <zash@zash.se>
parents:
2406
diff
changeset
|
4 Consider using [mod_mam][doc:modules:mod_mam] together with |
|
b74c86d137c9
mod_log_messages_sql/README: Add pointer towards mod_mam + mod_readonly
Kim Alvefur <zash@zash.se>
parents:
2406
diff
changeset
|
5 [mod_readonly] instead. |
|
b74c86d137c9
mod_log_messages_sql/README: Add pointer towards mod_mam + mod_readonly
Kim Alvefur <zash@zash.se>
parents:
2406
diff
changeset
|
6 ::: |
|
b74c86d137c9
mod_log_messages_sql/README: Add pointer towards mod_mam + mod_readonly
Kim Alvefur <zash@zash.se>
parents:
2406
diff
changeset
|
7 |
| 2323 | 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 | |
|
2406
a216be9b1d6e
mod_log_messages_sql/README: Point out incompatibility with 0.10
Kim Alvefur <zash@zash.se>
parents:
2323
diff
changeset
|
14 # Usage |
|
a216be9b1d6e
mod_log_messages_sql/README: Point out incompatibility with 0.10
Kim Alvefur <zash@zash.se>
parents:
2323
diff
changeset
|
15 |
| 2323 | 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 ``` | |
|
2406
a216be9b1d6e
mod_log_messages_sql/README: Point out incompatibility with 0.10
Kim Alvefur <zash@zash.se>
parents:
2323
diff
changeset
|
29 |
|
a216be9b1d6e
mod_log_messages_sql/README: Point out incompatibility with 0.10
Kim Alvefur <zash@zash.se>
parents:
2323
diff
changeset
|
30 # Compatibility |
|
a216be9b1d6e
mod_log_messages_sql/README: Point out incompatibility with 0.10
Kim Alvefur <zash@zash.se>
parents:
2323
diff
changeset
|
31 |
|
a216be9b1d6e
mod_log_messages_sql/README: Point out incompatibility with 0.10
Kim Alvefur <zash@zash.se>
parents:
2323
diff
changeset
|
32 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:
2323
diff
changeset
|
33 support in `mod_storage_sql`ยท |
