Ban system = bugged!

[Steel Man]

Dear people,

Sometimes my server lose connection to mysql and no one can login anymore. At login, it says: "invalid account name"
after rebooting the server everything works again. But ofcourse, having this mysql problem is very annoying.

Error:

[8:51:16.226] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: Lost connection to MySQL server during query (2013)

Anyone could help me?
thanks!

 

[Summ]

Your mysql server being unstable?
Maybe DDOS attacks?

 

[swordman]

Hello summ,

thanks for ur answer, but there arent any ddos attacks and mysql server is stable I think..
Ban's are somehow bugged..

Your mysql server being unstable?
Maybe DDOS attacks?

 

[swordman]

Damn, another mysql connection lost.
Anyone has a solution?

 

[Ninja]

Don't use bans to avoid it? xd

 

[Loney]

Try deleting your bans table, and then add it again:

CREATE TABLE IF NOT EXISTS `bans` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` tinyint(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
`value` int(10) unsigned NOT NULL COMMENT 'ip address (integer), player guid or account number',
`param` int(10) unsigned NOT NULL DEFAULT '4294967295' COMMENT 'used only for ip banishment mask (integer)',
`active` tinyint(1) NOT NULL DEFAULT '1',
`expires` int(11) NOT NULL,
`added` int(10) unsigned NOT NULL,
`admin_id` int(10) unsigned NOT NULL DEFAULT '0',
`comment` text NOT NULL,
`reason` int(10) unsigned NOT NULL DEFAULT '0',
`action` int(10) unsigned NOT NULL DEFAULT '0',
`statement` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `type` (`type`,`value`),
KEY `active` (`active`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

 

[Ninja]

It has nothing to do with the bans table afaik. Something with IP banishments is triggering that mysql error.

 

[swordman]

something with ioban.cpp?

 

[Steel Man]

Loney: I have already done this 2 days ago but it happend ago.

Ninja: I don't have any ip-banishments nor any bans.
But it's still happening

 

[Cronox]

doubt you open your ot and have error?

 

[Steel Man]

It various when it happends. Sometimes after 3 days, sometimes after 5 days.
U cant know when it happends, it just happends.
Dou got got a fix?

doubt you open your ot and have error?

 

[Loney]

Check this, maybe here you can found the solution.
http://otland.net/f16/mysql-error-randomly-165943/