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...
[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...
[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
module
{
#name = "db_sql"
name = "db_sql_live"
engine = "mysql/main"
prefix = "anope_db_"
import = false
}
modules.conf
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@"
}