Mercurial > prosody-modules
comparison mod_auth_sql/README.md @ 6371:caaa9ea58bec
mod_auth_sql: Document database table in README
| author | Christian Weiske <cweiske@cweiske.de> |
|---|---|
| date | Tue, 27 Jan 2026 21:12:21 +0100 |
| parents | f1743e2c23ba |
| children |
comparison
equal
deleted
inserted
replaced
| 6370:f1743e2c23ba | 6371:caaa9ea58bec |
|---|---|
| 30 | 30 |
| 31 The query is currently hardcoded in the module, so you will need to edit | 31 The query is currently hardcoded in the module, so you will need to edit |
| 32 the module to change it. The default query is compatible with jabberd2 | 32 the module to change it. The default query is compatible with jabberd2 |
| 33 DB schema. | 33 DB schema. |
| 34 | 34 |
| 35 | |
| 36 Database schema | |
| 37 =============== | |
| 38 | |
| 39 `mod_auth_sql` requires a database table `authreg` with the following columns: | |
| 40 | |
| 41 - `username` - First part of the JID, before the `@` | |
| 42 - `realm` - Part of the JID after the `@` | |
| 43 - `password` - Plain text password (insecure!) | |
| 44 | |
| 45 | |
| 35 Compatibility | 46 Compatibility |
| 36 ============= | 47 ============= |
| 37 | 48 |
| 38 ----- ------- | 49 ----- ------- |
| 39 0.8 Works | 50 0.8 Works |
