Anope IRC Services

Anope Support => 2.0.x/1.9.x Support => Topic started by: Juan c on September 12, 2014, 10:04:21 PM

Title: MySql not working but loaded?
Post by: Juan c on September 12, 2014, 10:04:21 PM
I fresh installed the anope 2, and it is working well, I try to setup the mysql, but even that LOG says everithing is ok .. If I register a Nick/chanel no data (or tables) are created in the MySql database... cand you help me??

This happens in the LOG when I register a Nick/Channel...
Code: [Select]
[Sep 12 14:32:49.923262 2014] Debug: Received: :My_Nick PRIVMSG NickServ :REGISTER A12345678B my_email@hotmail.com
[Sep 12 14:32:49.924091 2014] Debug: Extend for nonexistent type MEMO_SIGNON on 0x24177e8
[Sep 12 14:32:49.924126 2014] Debug: Extend for nonexistent type MEMO_RECEIVE on 0x24177e8
[Sep 12 14:32:49.924191 2014] COMMAND: My_Nick!MyNick@my.isp.ip.address (MyNick) used REGISTER to register My_Nick (email: my_email@hotmail.com)
[Sep 12 14:32:49.925105 2014] Debug: Sent: :NickServ NOTICE My_Nick :Nickname My_Nick registered under your user@host-mask: MyNick@my.isp.ip.address
[Sep 12 14:32:49.925200 2014] Debug: Sent: :NickServ NOTICE My_Nick :Your password is A12345678B - remember this for later use.
[Sep 12 14:32:49.925414 2014] Debug: Sent: :NickServ SVS2MODE My_Nick +d My_Nick
[Sep 12 14:32:49.925814 2014] Debug: Sent: :NickServ NOTICE My_Nick :Your email address is not confirmed. To confirm it, follow the instructions that were emailed to you.
[Sep 12 14:32:49.925901 2014] Debug: Sent: :NickServ NOTICE My_Nick :Your account will expire, if not confirmed, in 12 hours.
[Sep 12 14:32:49.926079 2014] Debug: Unable to find SQL engine
[Sep 12 14:32:49.942544 2014] Debug: Successfully delivered mail for My_Nick (my_email@hotmail.com)
[Sep 12 14:33:41.125238 2014] Debug: Received: :My_Nick PRIVMSG NickServ :CONFIRM Zmq36gLqQ
[Sep 12 14:33:41.125402 2014] COMMAND: My_Nick!MyNick@my.isp.ip.address (My_Nick) used CONFIRM to confirm their email
[Sep 12 14:33:41.125516 2014] Debug: Sent: :NickServ NOTICE My_Nick :Your email address of my_email@hotmail.com has been confirmed.
[Sep 12 14:33:41.125565 2014] Debug: Sent: :NickServ SVS2MODE My_Nick +d My_Nick
[Sep 12 14:33:41.125722 2014] Debug: Sent: :NickServ SVS2MODE My_Nick +r

this is what says in the log of the services...
Code: [Select]
[ircadmin@server bin]$ cat log | grep sql
[Sep 12 15:47:31.773992 2014] Debug: ln 833 EOL: s='opertype' 'commands' set to 'chanserv/list chanserv/suspend chanserv/topic memoserv/staff nickserv/list nickserv/suspend operserv/mode operserv/chankill operserv/akill operserv/session operserv/modinfo operserv/sqline operserv/oper operserv/kick operserv/ignore operserv/snline'
[Sep 12 15:47:31.789865 2014] Debug: ln 75 EOL: s='module' 'sqlineexpiry' set to '30d'
[Sep 12 15:47:31.789930 2014] Debug: ln 100 EOL: s='module' 'killonsqline' set to 'yes'
[Sep 12 15:47:31.794251 2014] Debug: ln 690 EOL: s='command' 'command' set to 'operserv/sqline'
[Sep 12 15:47:31.794270 2014] Debug: ln 690 EOL: s='command' 'permission' set to 'operserv/sqline'
[Sep 12 15:47:31.794486 2014] Debug: ln 8 EOL: s='module' 'name' set to 'm_mysql'
[Sep 12 15:47:31.794507 2014] Debug: ln 12 EOL: s='mysql' 'name' set to 'mysql/main'
[Sep 12 15:47:31.794528 2014] Debug: ln 13 EOL: s='mysql' 'database' set to 'anope_db'
[Sep 12 15:47:31.794548 2014] Debug: ln 14 EOL: s='mysql' 'server' set to '127.0.0.1'
[Sep 12 15:47:31.794568 2014] Debug: ln 15 EOL: s='mysql' 'username' set to 'anope_usr'
[Sep 12 15:47:31.794589 2014] Debug: ln 16 EOL: s='mysql' 'password' set to 'passs'
[Sep 12 15:47:31.794617 2014] Debug: ln 17 EOL: s='mysql' 'port' set to '3306'
[Sep 12 15:47:31.794665 2014] Debug: ln 24 EOL: s='module' 'name' set to 'm_sql_oper'
[Sep 12 15:47:31.829143 2014] Debug: Trying to load module: m_mysql
[Sep 12 15:47:31.834498 2014] Debug: Successfully connected to MySQL service mysql/main at 127.0.0.1:3306
[Sep 12 15:47:31.834539 2014] Debug: MySQL: Successfully connected to server mysql/main (127.0.0.1)
[Sep 12 15:47:31.834567 2014] Debug: Module m_mysql loaded.
[Sep 12 15:47:31.834940 2014] Debug: Trying to load module: m_sql_oper
[Sep 12 15:47:31.835213 2014] Debug: Module m_sql_oper loaded.
[Sep 12 15:47:42.889148 2014] Debug: Unloading module m_mysql
[Sep 12 15:47:42.890043 2014] Debug: Unloading module m_sql_oper

services.conf
Code: [Select]
module
{
#name = "db_sql"
name = "db_sql_live"
engine = "mysql/main"
prefix = "anope_db_"
import = false
}

modules.conf
Code: [Select]
module
{
        name = "help"
}

module
{
        name = "m_mysql"

        mysql
        {
                name = "mysql/main"
                database = "anope_db"
                server = "127.0.0.1"
                username = "anope_usr"
                password = "password"
                port = 3306
        }
}
module { name = "m_regex_posix" }

module
{
        name = "m_sql_oper"
        query = "SELECT `opertype` FROM `my_users` WHERE `user_name` = @a@"
}
Title: Re: MySql not working but loaded?
Post by: Adam on September 12, 2014, 10:06:57 PM
You probably did not first enable m_mysql with ./extras
Title: Re: MySql not working but loaded?
Post by: Juan c on September 13, 2014, 02:27:32 PM
sorry yes I run ./extras first and selected this...

Code: [Select]
m_ldap.cpp                = disabled
m_ldap_authentication.cpp = disabled
m_ldap_oper.cpp           = disabled
m_mysql.cpp               = enabled
m_regex_pcre.cpp          = disabled
m_regex_posix.cpp         = enabled
m_regex_tre.cpp           = disabled
m_sasl_dh-aes.cpp         = disabled
m_sasl_dh-blowfish.cpp    = disabled
m_sql_authentication.cpp  = enabled
m_sql_log.cpp             = enabled
m_sql_oper.cpp            = enabled
m_sqlite.cpp              = disabled
m_ssl_gnutls.cpp          = disabled
m_ssl_openssl.cpp         = disabled
stats                     = disabled

Is there any .SQL with tables to populate the DB? that I need to install first?? or the anope creates the databases by it self? the problem is that the database is empy, and when "it tries to save" in the mysql database It just says this in the log...

[Sep 12 14:32:49.926079 2014] Debug: Unable to find SQL engine

How ever it says that is conected to Mysql and everithing whent fine...
Title: Re: MySql not working but loaded?
Post by: Charles Kingsley on October 08, 2014, 07:50:18 AM
Paste up a new set of logs and the whole config please.