revrsedev/anope_sqlauth

External SQL DB auth module for Anope IRC Services v2.0.5

m_deedsqlauth.cpp

2016-2017 Mattia "DeederVel" Dui

Module for Anope IRC Services v2.0.5, lets users authenticate with credentials stored in a pre-existing SQL server instead of the internal Anope database.

Licence

This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program. If not, see http://www.gnu.org/licenses/

Configuration

Add this configuration block in your conf/modules.conf file

    module
    {
        name = "m_deedsqlauth"

        /* SQL engine to use. */
        engine = "mysql/main"

        /* Query to send
         *
         * @a@ -> user's account name
         * @p@ -> user's password 
         * @n@ -> user's nickname
         * @i@ -> user's IP
         *
         */
        query = "SELECT `pass`,`email` FROM `users` WHERE `nickname` = @n@"

        /*
         * If set, the reason to give the users who try to "/msg NickServ REGISTER". If not set, then registration is not blocked. 
         */
        disable_reason = "To register a new account navigate to http://www.dummy.com"

        /*
         * If set, the reason to give the users who try to "/msg NickServ SET EMAIL". If not set, then email changing is not blocked.
         */
        disable_email_reason = "To change your e-mail address navigate to http://www.dummy.com"
    }

Remember to edit the query field with your specific query and change the column names in the module file to match the ones retrieved with the SQL query in the configuration file:

    /* ... */
    Anope::string hash;
    Anope::string email;

    try
    {
        hash = r.Get(0, "password");
        email = r.Get(1, "email");
    }
    catch (const SQL::Exception &) { }

Also DO NOT FORGET to configure your SQL engine in your conf/modules.conf file to connect to your SQL server!