Jump to content
  • 0
Elsa

Can anyone help me out on this?

Question

[SQL]: DB error - Can't connect to MySQL server on '127.0.0.1' (111)[Debug]: at ipban_sql.c:218 - SELECT count(*) FROM `ipbanlist` WHERE `rtime` > NOW() AND (`list` = '125.*.*.*' OR `list` = '125.212.*.*' OR `list` = '125.212.121.*' OR `list` = '125.212.121.17')[Status]: Connection refused: IP isn't authorized (deny/allow, ip: 125.212.121.17).[SQL]: DB error - Can't connect to MySQL server on '127.0.0.1' (111)[Debug]: at loginlog_sql.c:90 - INSERT INTO `loginlog`(`time`,`ip`,`user`,`rcode`,`log`) VALUES (NOW(), '125.212.121.17', 'unknown', '-3', 'ip banned')[Info]: Closed connection from '125.212.121.17'.[SQL]: DB error - Can't connect to MySQL server on '127.0.0.1' (111)[Debug]: at ipban_sql.c:218 - SELECT count(*) FROM `ipbanlist` WHERE `rtime` > NOW() AND (`list` = '219.*.*.*' OR `list` = '219.92.*.*' OR `list` = '219.92.128.*' OR `list` = '219.92.128.169')[Status]: Connection refused: IP isn't authorized (deny/allow, ip: 219.92.128.169).[SQL]: DB error - Can't connect to MySQL server on '127.0.0.1' (111)[Debug]: at loginlog_sql.c:90 - INSERT INTO `loginlog`(`time`,`ip`,`user`,`rcode`,`log`) VALUES (NOW(), '219.92.128.169', 'unknown', '-3', 'ip banned')[Info]: Closed connection from '219.92.128.169'.[SQL]: DB error - Can't connect to MySQL server on '127.0.0.1' (111)[Debug]: at ipban_sql.c:218 - SELECT count(*) FROM `ipbanlist` WHERE `rtime` > NOW() AND (`list` = '61.*.*.*' OR `list` = '61.94.*.*' OR `list` = '61.94.173.*' OR `list` = '61.94.173.52')[Status]: Connection refused: IP isn't authorized (deny/allow, ip: 61.94.173.52).[SQL]: DB error - Can't connect to MySQL server on '127.0.0.1' (111)[Debug]: at loginlog_sql.c:90 - INSERT INTO `loginlog`(`time`,`ip`,`user`,`rcode`,`log`) VALUES (NOW(), '61.94.173.52', 'unknown', '-3', 'ip banned')

 

its make my map-server crash. :(

 

 

 

Edited by Elsa

Share this post


Link to post
Share on other sites

6 answers to this question

Recommended Posts

  • 0

import your logs.sql in your mysql

Edited by Naori

Share this post


Link to post
Share on other sites
  • 0

Thanks for th reply guys.  Really appreciate.

 

import your logs.sql in your mysql

@Naori 

 

logs.sql is already imported.

 

Is your mysql running ??

 

 Dastgir : i guess they are running because this problem accur when server running at least 4 5 hrs.

Edited by Elsa

Share this post


Link to post
Share on other sites
  • 0

Thanks for th reply guys.  Really appreciate.

 

import your logs.sql in your mysql

@Naori 

 

logs.sql is already imported.

 

Is your mysql running ??

 

 Dastgir : i guess they are running because this problem accur when server running at least 4 5 hrs.

Better check up?! Maybe mysql crashes??

Share this post


Link to post
Share on other sites
  • 0

 

Thanks for th reply guys.  Really appreciate.

 

 

import your logs.sql in your mysql

@Naori 

 

logs.sql is already imported.

 

 

Is your mysql running ??

 

 Dastgir : i guess they are running because this problem accur when server running at least 4 5 hrs.

Better check up?! Maybe mysql crashes??

 

Im replacing src/login/ipban and re-import logs sql. 

Im tracing them now, my server just got up 15 minutes ago. I will come back later if i got somthing.

 

;)

Share this post


Link to post
Share on other sites
  • 0

 

Thanks for th reply guys.  Really appreciate.

 

 

import your logs.sql in your mysql

@Naori 

 

logs.sql is already imported.

 

 

Is your mysql running ??

 

 Dastgir : i guess they are running because this problem accur when server running at least 4 5 hrs.

Better check up?! Maybe mysql crashes??

 

 

its happen again, but it crasheh the sql table 'char' and it need to be repair...

 

Datsgir, how to fix about the crash? to prevent it to happen again.

 

p/s : i already fix the crash 'char' table.

Edited by Elsa

Share this post


Link to post
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.