http://hg.omfa.de/prosody-modules/ en-us prosody-modules: mod_auth_sql/mod_auth_sql.lua history mod_auth_sql/mod_auth_sql.lua revision history all the things: Remove trailing whitespace http://hg.omfa.de/prosody-modules/log/7dbde05b48a9/mod_auth_sql/mod_auth_sql.lua Florian Zeitz <florob@babelmonkeys.de> Tue, 11 Mar 2014 18:44:01 +0100 mod_auth_{external,internal_yubikey,ldap,ldap2,sql}: No need to nodeprep in SASL handler. http://hg.omfa.de/prosody-modules/log/490cb9161c81/mod_auth_sql/mod_auth_sql.lua Waqas Hussain <waqas20@gmail.com> Sat, 26 Jan 2013 04:34:05 +0500 mod_auth_sql: Add users iterator http://hg.omfa.de/prosody-modules/log/cdc67f4efde2/mod_auth_sql/mod_auth_sql.lua Kim Alvefur <zash@zash.se> Fri, 05 Oct 2012 19:34:53 +0200 mod_auth_*: Use module:provides(), and don't explicitly specify provider.name. http://hg.omfa.de/prosody-modules/log/881ec9919144/mod_auth_sql/mod_auth_sql.lua Waqas Hussain <waqas20@gmail.com> Thu, 13 Sep 2012 00:08:29 +0500 mod_auth_sql: Read option 'auth_sql' (thanks rdnzlc) http://hg.omfa.de/prosody-modules/log/bd08727378be/mod_auth_sql/mod_auth_sql.lua Matthew Wild <mwild1@gmail.com> Thu, 08 Dec 2011 08:17:36 +0000 Revert various changes accidentally included in previous commit http://hg.omfa.de/prosody-modules/log/bbea8081c865/mod_auth_sql/mod_auth_sql.lua Kim Alvefur <zash@zash.se> Sat, 29 Oct 2011 13:34:15 +0200 mod_default_vcard: Sets initial vCard from data enterd on registration http://hg.omfa.de/prosody-modules/log/52f2188ec47d/mod_auth_sql/mod_auth_sql.lua Kim Alvefur <zash@zash.se> Sat, 15 Oct 2011 13:43:37 +0200 mod_auth_sql: More cleanup. http://hg.omfa.de/prosody-modules/log/4e0d36941ba1/mod_auth_sql/mod_auth_sql.lua Waqas Hussain <waqas20@gmail.com> Wed, 10 Aug 2011 05:30:08 +0500 mod_auth_sql: Cleanup. http://hg.omfa.de/prosody-modules/log/fdd4f5ab029a/mod_auth_sql/mod_auth_sql.lua Waqas Hussain <waqas20@gmail.com> Wed, 10 Aug 2011 04:42:50 +0500 Do not run in transaction. http://hg.omfa.de/prosody-modules/log/c416db434e5b/mod_auth_sql/mod_auth_sql.lua Code cleanup.
Changed logging to module logging.
Properly count SQL result rows.]]> Tomasz Sterna <tomek@xiaoka.com> Tue, 26 Apr 2011 19:28:08 +0200 Implemented password and user existence check in mod_auth_sql http://hg.omfa.de/prosody-modules/log/a6dee73a11e7/mod_auth_sql/mod_auth_sql.lua Tomasz Sterna <tomek@xiaoka.com> Wed, 13 Apr 2011 20:41:53 +0200 Reconnect on DB disconnection. http://hg.omfa.de/prosody-modules/log/c2554fee5c21/mod_auth_sql/mod_auth_sql.lua Tomasz Sterna <tomek@xiaoka.com> Wed, 13 Apr 2011 15:37:26 +0200 Implemented basic SQL authentication module. http://hg.omfa.de/prosody-modules/log/f24998ec7f8d/mod_auth_sql/mod_auth_sql.lua
This module implements authentication against plaintext password stored in SQL database.
You wil definitely need to edit the Lua code and put a query working with your database.
The example query works against jabberd2 database schema.

P.S. This module is just some code glued together from other modules. ;-)]]> Tomasz Sterna <tomek@xiaoka.com> Tue, 12 Apr 2011 00:30:53 +0200