Jump to content
  • 0

[SQL]: DB error - MySQL server has gone away


amauni

Question


  • Group:  Members
  • Topic Count:  15
  • Topics Per Day:  0.00
  • Content Count:  59
  • Reputation:   0
  • Joined:  02/25/13
  • Last Seen:  

Hi all...my server keep disconnected and in putty console it showed this error...can anyone help me please? :(

 

Quote

[Info]: Closed connection from '128.199.189.108'.
[Info]: Attempt to connect to login-server...
[Status]: Connecting to 128.199.189.108:6900

: DB error - MySQL server has gone away
[Debug]: at ipban_sql.c:217 - SELECT count(*) FROM `ipbanlist` WHERE `rtime` > NOW() AND (`list` = '128.*.*.*' OR `list` = '128.199.*.*' OR `list` = '128.199.189.*' OR `list` = '128.199.189.108')
[Status]: Connection refused: IP isn't authorised (deny/allow, ip: 128.199.189.108).                                                            [SQL]: DB error - MySQL server has gone away
[Debug]: at loginlog_sql.c:76 - INSERT INTO `loginlog`(`time`,`ip`,`user`,`rcode`,`log`) VALUES (NOW(), '128.199.189.108', 'unknown', '-3', 'ip banned')
[Error]: Unknown packet 0x006a received from login-server, disconnecting.
[Warning]: Connection to Login Server lost.

cd
[Info]: Attempt to connect to login-server...
[Status]: Connecting to 128.199.189.108:6900
[Info]: Closed connection from '128.199.189.108'.
[SQL]: DB error - MySQL server has gone away
[Debug]: at ipban_sql.c:217 - SELECT count(*) FROM `ipbanlist` WHERE `rtime` > NOW() AND (`list` = '128.*.*.*' OR `list` = '128.199.*.*' OR `list` = '128.199.189.*' OR `list` = '128.199.189.108')
[Status]: Connection refused: IP isn't authorised (deny/allow, ip: 128.199.189.108).
/athena-start restart
[SQL]: DB error - MySQL server has gone away
[Debug]: at loginlog_sql.c:76 - INSERT INTO `loginlog`(`time`,`ip`,`user`,`rcode`,`log`) VALUES (NOW(), '128.199.189.108', 'unknown', '-3', 'ip banned')
art[SQL]: DB error - MySQL server has gone away
[Debug]: at ipban_sql.c:259 - DELETE FROM `ipbanlist` WHERE `rtime` <= NOW()
[Error]: Unknown packet 0x006a received from login-server, disconnecting.
[Info]: Closed connection from '128.199.189.108'.
[Warning]: Connection to Login Server lost.

[SQL]: DB error - MySQL server has gone away
[Debug]: at ipban_sql.c:217 - SELECT count(*) FROM `ipbanlist` WHERE `rtime` > NOW() AND (`list` = '60.*.*.*' OR `list` = '60.54.*.*' OR `list` = '60.54.121.*' OR `list` = '60.54.121.97')
[Status]: Connection refused: IP isn't authorised (deny/allow, ip: 60.54.121.97).

 

 

Untitled.jpg

Link to comment
Share on other sites

7 answers to this question

Recommended Posts

  • 0

  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  149
  • Reputation:   24
  • Joined:  02/11/16
  • Last Seen:  

Try using 127.0.0.1 instead of your VPS' IP in inter_athena.conf

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  3
  • Reputation:   1
  • Joined:  10/20/16
  • Last Seen:  

Actually from re-reading I caught something....it kind of looks like your MySQL is actually refusing the connection almost....I'll do some digging and see what the true error means

 

After a bit of searching I found this:

 

"Server dropped an incorrect or too large packet. If mysqld gets a packet that is too large or incorrect, it assumes that something has gone wrong with the client and closes the connection. To fix, you can increase the maximal packet size limit “max_allowed_packet” in my.cnf file, eg. set max_allowed_packet = 128M, then sudo /etc/init.d/mysql restart."

 

This may or may not be the issue but worth a try

Edited by Machiezmo
  • Upvote 1
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  15
  • Topics Per Day:  0.00
  • Content Count:  59
  • Reputation:   0
  • Joined:  02/25/13
  • Last Seen:  

On 11/26/2016 at 2:31 PM, Machiezmo said:

Actually from re-reading I caught something....it kind of looks like your MySQL is actually refusing the connection almost....I'll do some digging and see what the true error means

 

After a bit of searching I found this:

 

"Server dropped an incorrect or too large packet. If mysqld gets a packet that is too large or incorrect, it assumes that something has gone wrong with the client and closes the connection. To fix, you can increase the maximal packet size limit “max_allowed_packet” in my.cnf file, eg. set max_allowed_packet = 128M, then sudo /etc/init.d/mysql restart."

 

This may or may not be the issue but worth a try

Thank you for answering. I will try it and get back to you later after getting the result. THANKS!! :lol:

 

Here is all the code in my.cnf and im using webuzo as the mysql app...i don't see the words with max_allowed_packet... how do i add the words into the file? Thanks in advance, sir..

 

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

 

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  149
  • Reputation:   24
  • Joined:  02/11/16
  • Last Seen:  

Your rA and MySQL are in the same VPS?

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  15
  • Topics Per Day:  0.00
  • Content Count:  59
  • Reputation:   0
  • Joined:  02/25/13
  • Last Seen:  

6 hours ago, Neffletics said:

Your rA and MySQL are in the same VPS?

yes it is sir...

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  15
  • Topics Per Day:  0.00
  • Content Count:  59
  • Reputation:   0
  • Joined:  02/25/13
  • Last Seen:  

On 28/11/2016 at 3:21 PM, Neffletics said:

Try using 127.0.0.1 instead of your VPS' IP in inter_athena.conf

im using linux sir...it can apply ?

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  149
  • Reputation:   24
  • Joined:  02/11/16
  • Last Seen:  

16 hours ago, amauni said:

im using linux sir...it can apply ?

Yes, it does. Have you tried it? Does it work?

Link to comment
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.   Paste as plain text instead

  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.

×
×
  • Create New...