Hello all,
I've try to install anope with mysql support, everything works fine in db_flatfile but I can't send the anope.db into my anope remote database.
module
{
#name = "db_sql"
name = "db_sql_live"
/*
* The SQL service db_sql(_live) should use, these are configured in modules.conf.
* For MySQL, this should probably be mysql/main.
*/
engine = "mysql/main"
/*
* An optional prefix to prepended to the name of each created table.
* Do not use the same prefix for other programs.
*/
prefix = "anope_db_"
/* Whether or not to import data from another database module in to SQL on startup.
* If you enable this, be sure that the database services is configured to use is
* empty and that another database module to import from is loaded before db_sql.
* After you enable this and do a database import you should disable it for
* subsequent restarts.
*
* Note that you can not import databases using db_sql_live. If you want to import
* databases and use db_sql_live you should import them using db_sql, then shut down
* and start services with db_sql_live.
*/
import = false
}
/*
* m_mysql [EXTRA]
*
* This module allows other modules to use MySQL.
*/
module
{
name = "m_mysql"
mysql
{
/* The name of this service. */
name = "mysql/main"
database = "anope"
server = "localhost"
username = "root"
password = "root_password"
port = 3306
}
}
and when I'm in phpmyadmin, the anope database still empty. I've try to setup with db_flatfile & db_sql with the import set to true, but nothing came up even if I do /os update. Of course, in ./extras I've enable the mysql.cpp option. So each time that my anope's services restart, I loose all the conf (chan, nick registered, botlist, ...)
If anybody have to solution at this problem, it will be really kind to share.
The -debug output with a grep on sql
./services/bin/services -nofork -debug | grep sql
[Jul 05 21:10:48.972805 2014] Debug: ln 829 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'
[Jul 05 21:10:48.990278 2014] Debug: ln 1126 EOL: s='module' 'name' set to 'db_sql_live'
[Jul 05 21:10:48.991793 2014] Debug: ln 1132 EOL: s='module' 'engine' set to 'mysql/main'
[Jul 05 21:10:48.997989 2014] Debug: ln 1254 EOL: s='include' 'name' set to 'irc2sql.conf'
[Jul 05 21:10:49.554378 2014] Debug: ln 75 EOL: s='module' 'sqlineexpiry' set to '30d'
[Jul 05 21:10:49.557092 2014] Debug: ln 100 EOL: s='module' 'killonsqline' set to 'yes'
[Jul 05 21:10:49.671421 2014] Debug: ln 690 EOL: s='command' 'command' set to 'operserv/sqline'
[Jul 05 21:10:49.672888 2014] Debug: ln 690 EOL: s='command' 'permission' set to 'operserv/sqline'
[Jul 05 21:10:49.702605 2014] Debug: Start to read conf irc2sql.conf
[Jul 05 21:10:49.706711 2014] Debug: ln 53 EOL: s='module' 'name' set to 'irc2sql'
[Jul 05 21:10:49.709140 2014] Debug: ln 65 EOL: s='module' 'engine' set to 'mysql/main'
[Jul 05 21:10:49.710652 2014] Debug: ln 71 EOL: s='module' 'prefix' set to 'anope_irc2_sql'
[Jul 05 21:10:49.898908 2014] Debug: Trying to load module: db_sql_live
[Jul 05 21:10:49.904446 2014] Debug: Module db_sql_live loaded.
[Jul 05 21:10:50.761334 2014] Debug: Trying to load module: irc2sql
[Jul 05 21:10:50.768843 2014] Debug: IRC2SQL: no database connection to mysql/main
[Jul 05 21:10:50.783554 2014] Debug: Module irc2sql loaded.
regards,
tiphergane
