Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Francesco]

Hi all.
I have a problem with the irc2sql module.
Using Anope 2.0.1, I properly configured MySQL and enabled irc2sql. In my database, however, the tables related to statistics (chan, ison, user, etc.) do not contain any data, but remain empty. I may have been wrong or forget something? What could be the problem to this?
Thanks to all for the answers

[Jens Voss]

Hi Francesco,

what mysql version do you use?
Anope creates some stored procedures on startup.
Your mysql user probably needs some more permissions.

http://dev.mysql.com/doc/refman/5.0/en/stored-routines-privileges.html

If you start anope in debug mode it should give you some error messages from the mysql server.

[Francesco]

Hi,
my MySQL version is 5.5.38 and MySQL user that anope uses has all the necessary permissions for stored procedures.
I tried to start Anope in debug mode and so I've seen some error messages for various tables, saying "Cannot load from mysql.proc. The table is probably corrupted". What does it mean? How can I solve that?
Thanks

[Jens Voss]

My good old friend google suggests running "mysql_upgrade" to fix it. (you probably upgraded from an older mysql version)

[Francesco]

Yeah, thanks to friend Google
Now everything works correctly, thanks for your help