Ancore
New Member
- Joined
- Jul 6, 2012
- Messages
- 216
- Reaction score
- 1
Well, as the title says I am having ´problems with my sql because of someone is attacking me with ddos:
First a character can't get save because of the pings that collapse the vps and imposible to connect to the database to save the character, after that NO one can enter in the server... it says invalid account name and password... And the webpage says : Can't conect to mysql database.
Please really need help with this!
ALWAYS BEFORE SQL LOST THIS ERROR HAPPENS:
[4/8/2012 15:39:23] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1344108813, `lastip` = 145167550, `level` = 37, `group_id` = 1, `health` = 195, `healthmax` = 330, `experience` = 731618, `lookbody` = 10, `lookfeet` = 81, `lookhead` = 0, `looklegs` = 78, `looktype` = 128, `lookaddons` = 0, `maglevel` = 16, `mana` = 740, `manamax` = 905, `manaspent` = 4875, `soul` = 7, `town_id` = 1, `posx` = 929, `posy` = 1079, `posz` = 6, `cap` = 670, `sex` = 1, `balance` = 0, `stamina` = 150995000, `skull` = 0, `skulltime` = 0, `promotion` = 1, `loss_experience` = 100, `loss_mana` = 100, `loss_skills` = 100, `loss_containers` = 100, `loss_items` = 100, `lastlogout` = 1344106560, `blessings` = 0, `pvp_blessing` = 0, `marriage` = 0, `guildnick` = '', `rank_id` = 0, `vocation` = 2 WHERE `id` = 4520 LIMIT 1; - MYSQL ERROR: Lost connection to MySQL server during query (2013)
[4/8/2012 15:39:23] > WARNING: MYSQL Lost connection, attempting to reconnect...
[4/8/2012 15:39:24] Failed connecting to database - MYSQL ERROR: Too many connections (1040)
[4/8/2012 15:39:24] > WARNING: MYSQL Lost connection, attempting to reconnect...
[4/8/2012 15:39:25] Failed connecting to database - MYSQL ERROR: Too many connections (1040)
[4/8/2012 15:39:25] > WARNING: MYSQL Lost connection, attempting to reconnect...
[4/8/2012 15:39:25] Failed connecting to database - MYSQL ERROR: Too many connections (1040)
[4/8/2012 15:39:25] > WARNING: MYSQL Lost connection, attempting to reconnect...
[4/8/2012 15:39:25] Failed connection to database - maximum reconnect attempts passed.
First a character can't get save because of the pings that collapse the vps and imposible to connect to the database to save the character, after that NO one can enter in the server... it says invalid account name and password... And the webpage says : Can't conect to mysql database.
Please really need help with this!
ALWAYS BEFORE SQL LOST THIS ERROR HAPPENS:
[4/8/2012 15:39:23] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1344108813, `lastip` = 145167550, `level` = 37, `group_id` = 1, `health` = 195, `healthmax` = 330, `experience` = 731618, `lookbody` = 10, `lookfeet` = 81, `lookhead` = 0, `looklegs` = 78, `looktype` = 128, `lookaddons` = 0, `maglevel` = 16, `mana` = 740, `manamax` = 905, `manaspent` = 4875, `soul` = 7, `town_id` = 1, `posx` = 929, `posy` = 1079, `posz` = 6, `cap` = 670, `sex` = 1, `balance` = 0, `stamina` = 150995000, `skull` = 0, `skulltime` = 0, `promotion` = 1, `loss_experience` = 100, `loss_mana` = 100, `loss_skills` = 100, `loss_containers` = 100, `loss_items` = 100, `lastlogout` = 1344106560, `blessings` = 0, `pvp_blessing` = 0, `marriage` = 0, `guildnick` = '', `rank_id` = 0, `vocation` = 2 WHERE `id` = 4520 LIMIT 1; - MYSQL ERROR: Lost connection to MySQL server during query (2013)
[4/8/2012 15:39:23] > WARNING: MYSQL Lost connection, attempting to reconnect...
[4/8/2012 15:39:24] Failed connecting to database - MYSQL ERROR: Too many connections (1040)
[4/8/2012 15:39:24] > WARNING: MYSQL Lost connection, attempting to reconnect...
[4/8/2012 15:39:25] Failed connecting to database - MYSQL ERROR: Too many connections (1040)
[4/8/2012 15:39:25] > WARNING: MYSQL Lost connection, attempting to reconnect...
[4/8/2012 15:39:25] Failed connecting to database - MYSQL ERROR: Too many connections (1040)
[4/8/2012 15:39:25] > WARNING: MYSQL Lost connection, attempting to reconnect...
[4/8/2012 15:39:25] Failed connection to database - maximum reconnect attempts passed.
Last edited: