<sqlauth dbid="1"
        query="SELECT username FROM testusers WHERE username='$nick' AND password='$md5pass' LIMIT 1"
        killreason="Access denied"
        allowpattern="Guest*"
        verbose="1">

The variables in the tag have the following meanings:

• dbid - The database id which this module is to use. Please see the documentation of the m_sql module for more details.
• killreason - The reason to give when disconnecting a user who provides invalid credentials. You should usually place a url to your registration system here so that users may register, or contact details of who to gain access from.
• allowpattern - If defined, this is a pattern which if matched will automatically allow the nick onto irc without checking it against the database.
• verbose - This variable if set to 'yes' will notify opers of failed connections to the server if they have the usermode +s.

For a list of settings which are known to work with certain popular software, please see our Integrating m_sqlauth.so with other software page.

• query - This contains a freeform query, which can be used to match a user. The SQL query may return any of the variables below, which are replaced in the query before dispatching it to the SQL provider module. If the query returns one or more rows, the user is considered to be authenticated. If the query errors, or contains no result rows the user is considered to not be authenticated.

<tr><td>$ident</td><td>This is replaced with the user's ident (username) string. Do not use the m_ident module if you use this variable to authenticate users, otherwise you will be unable to determine if you are checking the ident string returned by the user's ident server, or the one sent by the USER command.</td></tr></table> <tr><td>$gecos</td><td>This is replaced with the user's GECOS (Real name).</td></tr></table> <tr><td>$server</td><td>This is replaced with name of the server the user connected to.</td></tr></table> <tr><td>$uuid</td><td>This is replaced with the user's UUID. This is of limited and specialist use as the user's UUID changes upon every connection.</td></tr></table>

PASS :password

The user will not be prompted for their password, if this is not clear enough to your users, you should place it into the kill message. It is highly recommended that if you are using a system such as this, you should disable nick changing once users are connected with the following syntax in your configuration file:

<disabled commands="NICK">

With such a setting in place, you can be sure that everyone who connects is registered, and they cannot possibly impersonate others. Beware of mixing this system with other systems which may force user nickchanges. If a users nick is changed when such a system is in place, they will be unable to change it back without reconnecting!

• m_mysql.so - The MySQL Database module
• m_sqlite3.so - The SQLite3 Database module
• m_pgsql.so - The PostgreSQL Database module
• m_mssql.so - The MSSQL Database module