Anope IRC Services

Please login or register.

Login with username, password and session length
Advanced search  

News:

Pages: [1]   Go Down

Author Topic: Module irc2sql: Problem with ChanStats  (Read 3662 times)

0 Members and 1 Guest are viewing this topic.

hyper-threader

  • Anope User
  • Offline Offline
  • Posts: 4
    • IceStarIRC - Chat, Fun and many more :)
Module irc2sql: Problem with ChanStats
« on: December 29, 2014, 11:30:34 PM »

Hey to all,

got a strange problem with the module 'ChanStats'. Following the settings on the system:

Unreal 3.2.10.2
Anope 2.0.1
MySQL 5.5

Anope config:

Code: [Select]
#module
{
name = "db_old"
hash = "md5"
}

module
{
name = "db_flatfile"
database = "anope.db"
keepbackups = 3
#nobackupokay = yes
fork = no
}

module
{
name = "db_sql"
#name = "db_sql_live"
engine = "mysql/main"
prefix = "anope_"
import = false
}

module
{
name = "irc2sql"
client = "StatServ"
engine = "mysql/main"
prefix = "anope_"
}


Debug log:
Code: [Select]
Debug: ln 14 EOL: s='module' 'engine' set to 'mysql/main'
Debug: Start to read conf irc2sql.conf
Debug: ln 18 EOL: s='module' 'name' set to 'irc2sql'
Debug: ln 20 EOL: s='module' 'engine' set to 'mysql/main'
Debug: Trying to load module: db_sql
Debug: Module db_sql loaded.
Debug: Trying to load module: m_mysql
Debug: Successfully connected to MySQL service mysql/main at x.x.x.x:xxxx
Debug: MySQL: Successfully connected to server mysql/main (x.x.x.x)
Debug: Module m_mysql loaded.
Debug: Trying to load module: irc2sql
Debug: Module irc2sql loaded.

All modules are loaded successfully and works. As default, 'ChanStats' are activated for new registered channels. I´ve installed anope 2.x after release, used the db-import from denora to anope. The tables are successfully created and the stats are working. But not at all. Looking through the stats I´ve noticed, that not for all channels stats are stored. The summary stats are displayed correctly, but for certain channels no daily, weekly and monthly stats. Reset the stats to off and newly set to on has no effect. Also an restart of the services changes nothing. Don´t know, what the problem is. This is no idle channel, everday a lot of lines were typed in this channel from several users.

Also checked the channel-settings, but found no cause for this problem. It´s not only this one channel with no 'daily, weekly and monthly chanstats' ...
Few channels gives a 403-error reply on the stats-page (with activated ChanStats for the channel). Also checked the rights for the mysql user and the database for any errors with no result.

Maybe anybody can help or have the same problem?


Edit: Can´t upload attachments. Directory is not writeable.
« Last Edit: January 01, 2015, 03:40:17 PM by hyper-threader »
Logged

hyper-threader

  • Anope User
  • Offline Offline
  • Posts: 4
    • IceStarIRC - Chat, Fun and many more :)
Re: Module irc2sql: Problem with ChanStats
« Reply #1 on: March 24, 2015, 09:54:11 PM »

Hey again,

have noticed about the new release of anope. Also want to know, if my problem is now solved or not. Installed new anope with all modules i like and the problem is still the same. Certain chans have no stats for daily, weekly and monthly. New set for stats on the given chan have no effect, these chans still get no stats. Don´t know what the problem is. Other channels with stats are working, but not for certain channels. Tried to compare the differences, but there´s no setting which can be the cause for this.

A look into the database contain only '0' in every row for daily, weekly and monthly stats for the given channel.

Anybody have the same problem?
Logged
Pages: [1]   Go Up