Server rentals :: NFOservers.com

Forums

All times are UTC - 8 hours



Author Message
PostPosted: Sat Apr 28, 2012 6:27 pm 
Offline
A regular
A regular

Joined: Sat Apr 28, 2012 6:24 pm
Posts: 49
Errors on a minecraft server:


Code:
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
[INFO] [iConomy] Database Error: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure


How to fix this?

Thank you!


Top
 Profile  
 
PostPosted: Sat Apr 28, 2012 6:53 pm 
Offline
Staff
Staff
User avatar

Joined: Fri Sep 17, 2010 9:06 am
Posts: 2025
Location: California
It sounds like the plugin cannot make a successful connection to the database.

Are you using the correct information with the plugin so it can connect?

_________________
<@TimeX-NFo> Hey, we used to have to carry our packets to the servers.
<@TimeX-NFo> And it was upstream, both ways.

<@TimeX-NFo|away> You're asking the old dude for help?????
<@Kraze^NFo> Yes


Top
 Profile  
 
PostPosted: Sat Apr 28, 2012 7:02 pm 
Offline
A regular
A regular

Joined: Sat Apr 28, 2012 6:24 pm
Posts: 49
Yes, I am using correct details. It happens because it tries to open a new connection, while previous connection is still opened, but I can't find more information about how to fix this.

kraze wrote:
It sounds like the plugin cannot make a successful connection to the database.

Are you using the correct information with the plugin so it can connect?


Top
 Profile  
 
PostPosted: Sat Apr 28, 2012 10:44 pm 
Offline
A regular
A regular

Joined: Sat Apr 28, 2012 6:24 pm
Posts: 49
Any help is a help, man, so, does anyone have any ideas, how to resolve this issue?

It happens not all the time, but, sometimes, when I restarting my server.


Top
 Profile  
 
PostPosted: Sat Apr 28, 2012 10:46 pm 
Offline
Founder
Founder
User avatar

Joined: Thu Apr 18, 2002 11:04 pm
Posts: 9239
Location: Seattle
Are you running both your game server and MySQL server locally? Do you have a connection limit set in MySQL that is being reached?


Top
 Profile  
 
PostPosted: Sat Apr 28, 2012 10:52 pm 
Offline
A regular
A regular

Joined: Sat Apr 28, 2012 6:24 pm
Posts: 49
Edge100x wrote:
Are you running both your game server and MySQL server locally? Do you have a connection limit set in MySQL that is being reached?


Yes, both are running locally. About second question - I am not sure. Can you help me to find out about, how to check it?


Top
 Profile  
 
PostPosted: Sat Apr 28, 2012 10:53 pm 
Offline
Founder
Founder
User avatar

Joined: Thu Apr 18, 2002 11:04 pm
Posts: 9239
Location: Seattle
It should be set in my.cfg, on Linux. Is this a Windows or Linux installation?


Top
 Profile  
 
PostPosted: Sat Apr 28, 2012 11:30 pm 
Offline
A regular
A regular

Joined: Sat Apr 28, 2012 6:24 pm
Posts: 49
Edge100x wrote:
It should be set in my.cfg, on Linux. Is this a Windows or Linux installation?

It's a linux, /etc/my.cnf

Are these parameters fine?
Code:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
wait_timeout = 80
interactive_timeout = 80
# 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
wait_timeout = 80
interactive_timeout = 80


Top
 Profile  
 
PostPosted: Sun Apr 29, 2012 8:30 am 
Offline
Founder
Founder
User avatar

Joined: Thu Apr 18, 2002 11:04 pm
Posts: 9239
Location: Seattle
Try adding a line like this in the first section:

max_connections = 50000

Those are also very low timeouts and I would recommend removing them.


Top
 Profile  
 
PostPosted: Sun Apr 29, 2012 1:13 pm 
Offline
A regular
A regular

Joined: Sat Apr 28, 2012 6:24 pm
Posts: 49
what amount for timeouts would you suggest?


Top
 Profile  
 
PostPosted: Mon Apr 30, 2012 8:41 am 
Offline
Founder
Founder
User avatar

Joined: Thu Apr 18, 2002 11:04 pm
Posts: 9239
Location: Seattle
I would recommend removing those lines entirely and just using the defaults.


Top
 Profile  
 
PostPosted: Sat May 05, 2012 10:27 pm 
Offline
A regular
A regular

Joined: Sat Apr 28, 2012 6:24 pm
Posts: 49
I removed it but error still remains. It spams the server all the time.

How to resolve this?


Top
 Profile  
 
PostPosted: Sat May 05, 2012 10:37 pm 
Offline
Founder
Founder
User avatar

Joined: Thu Apr 18, 2002 11:04 pm
Posts: 9239
Location: Seattle
It's difficult for me to think of what to try further. You may need to contact the plugin author on this one.


Top
 Profile  
 
PostPosted: Sat May 05, 2012 10:52 pm 
Offline
A regular
A regular

Joined: Sat Apr 28, 2012 6:24 pm
Posts: 49
This error has started to appear right after I've switched to your hosting, which means, that plugins have some problems with default mysql settings on linux, because I never touched mysql settings after you've installed a new operating system, or kernel, or how it's called nowdays.
There should be a way to crank some screws. Any idea would do.
Anything?


Top
 Profile  
 
PostPosted: Sat May 05, 2012 11:43 pm 
Offline
Founder
Founder
User avatar

Joined: Thu Apr 18, 2002 11:04 pm
Posts: 9239
Location: Seattle
Mostly what we need here (from your plugin) is a better error message, because the one it is giving is not telling us useful information.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 22 posts ]  Go to page 1, 2  Next

All times are UTC - 8 hours


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
It is currently Fri May 24, 2013 1:10 pm
Powered by phpBB® Forum Software © phpBB Group