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

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...

Important Information

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