|
1782
|
1 #summary SQL Database authentication module
|
|
|
2 #labels Type-Auth,Stage-Stable
|
|
|
3
|
|
|
4 = Introduction =
|
|
|
5
|
|
|
6 Allow client authentication to be handled by an SQL database query.
|
|
|
7
|
|
|
8 Unlike mod_storage_sql (which is supplied with Prosody) this module allows for custom schemas (though currently it is required to edit the source).
|
|
|
9
|
|
|
10 = Configuration =
|
|
|
11
|
|
|
12 As with all auth modules, there is no need to add this to modules_enabled. Simply add in the global section, or for the relevant hosts:
|
|
|
13
|
|
|
14 {{{
|
|
|
15 authentication = "sql"
|
|
|
16 }}}
|
|
|
17
|
|
|
18 This module reuses the database configuration of [http://prosody.im/doc/modules/mod_storage_sql mod_storage_sql] (the 'sql' option), which you can set even if you are not using SQL as Prosody's primary storage backend.
|
|
|
19
|
|
|
20 The query is currently hardcoded in the module, so you will need to edit the module to change it. The default query is compatible with jabberd2 DB schema.
|
|
|
21
|
|
|
22 = Compatibility =
|
|
|
23 ||0.8||Works|| |
