Jump to content
  • 0
Sign in to follow this  
madmonkey

server run problems (pi)

Question

I am coding for a some time already and learn most coding by meself and looking on internet about how to do stuff only somehow i now got something and i have no idea how to fix this.
I do this all for learning coding java since i am hope to run a server myself someday. No i dont wanna use ide i wanna learn coding this way so i have to correct it all without help from ide.
yesterday this diddn't happen but now it does.

what i do/did.

- running the server (put it online for meself and my co-owner)
- running my client.jar (or the run.bat) doesn't matter.
- logging on my server.

this whas no problem untill today.
this happends today.

-running server.
- running client (did try .jar en .bat)
- log on.
- holding black screen for about 1min.
-auto log off before i can do something.


and here is what my server run.bat says. thanks already for evryone that did read this and try to help me out :D

[IMG]http://i58.tinypic.com/5dqyw4.png[/IMG]

Share this post


Link to post
Share on other sites

11 answers to this question

Recommended Posts

  • 0
Caused by : Java.net.ConnectException: Connection timed out: connect.
at com.mysql.jdbc.SQLError.createCommunicationsException
<SQLError.java:1074>

do you have your sql setup? cause your server it seems to me it handles its character data within a Sql database.

Share this post


Link to post
Share on other sites
  • 0
Nope i dont have any from this Sql stuff i used a base that already sql had handeld and never got a problem with it since i am using this one (already 4 month)

Share this post


Link to post
Share on other sites
  • 0
copy the error from the .bat file and paste it here with [code] brackets
on the bat file right click and press Select all and press your enter button.
The enter button with copy it.

Cause it seems you are telling the server it has a sql database setup to handle its character files.
and its not getting the connection so when ever you try to login the character files are non exsistant so you're getting nulls.

Share this post


Link to post
Share on other sites
  • 0
[CODE][18-4-15 18:53]: Simplicity is now online.
[18-4-15 18:54]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Commun
ications link failure

The last packet successfully received from the server was 1.429.376.050.122 mill
iseconds ago. The last packet sent successfully to the server was 0 millisecond
s ago.
[18-4-15 18:54]: at sun.reflect.NativeConstructorAccessorImpl.newInstance
0(Native Method)
[18-4-15 18:54]: at sun.reflect.NativeConstructorAccessorImpl.newInstance
(NativeConstructorAccessorImpl.java:62)
[18-4-15 18:54]: at sun.reflect.DelegatingConstructorAccessorImpl.newInst
ance(DelegatingConstructorAccessorImpl.java:45)
[18-4-15 18:54]: at java.lang.reflect.Constructor.newInstance(Constructor
.java:408)
[18-4-15 18:54]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
[18-4-15 18:54]: at com.mysql.jdbc.SQLError.createCommunicationsException
(SQLError.java:1074)
[18-4-15 18:54]: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionI
mpl.java:2214)
[18-4-15 18:54]: at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.j
ava:773)
[18-4-15 18:54]: at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection
.java:46)
[18-4-15 18:54]: at sun.reflect.NativeConstructorAccessorImpl.newInstance
0(Native Method)
[18-4-15 18:54]: at sun.reflect.NativeConstructorAccessorImpl.newInstance
(NativeConstructorAccessorImpl.java:62)
[18-4-15 18:54]: at sun.reflect.DelegatingConstructorAccessorImpl.newInst
ance(DelegatingConstructorAccessorImpl.java:45)
[18-4-15 18:54]: at java.lang.reflect.Constructor.newInstance(Constructor
.java:408)
[18-4-15 18:54]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
[18-4-15 18:54]: at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionI
mpl.java:352)
[18-4-15 18:54]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegist
eringDriver.java:282)
[18-4-15 18:54]: at java.sql.DriverManager.getConnection(DriverManager.ja
va:664)
[18-4-15 18:54]: at java.sql.DriverManager.getConnection(DriverManager.ja
va:247)
[18-4-15 18:54]: at server.util.PlayersOnline.createCon(PlayersOnline.jav
a:17)
[18-4-15 18:54]: at server.model.players.Client.initialize(Client.java:61
9)
[18-4-15 18:54]: at server.model.players.PlayerHandler.process(PlayerHand
ler.java:122)
[18-4-15 18:54]: at server.Server.main(Server.java:193)
[18-4-15 18:54]: Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsExcept
ion: Communications link failure

The last packet successfully received from the server was 1.429.376.050.122 mill
iseconds ago. The last packet sent successfully to the server was 0 millisecond
s ago.
[18-4-15 18:54]: at sun.reflect.NativeConstructorAccessorImpl.newInstance
0(Native Method)
[18-4-15 18:54]: at sun.reflect.NativeConstructorAccessorImpl.newInstance
(NativeConstructorAccessorImpl.java:62)
[18-4-15 18:54]: at sun.reflect.DelegatingConstructorAccessorImpl.newInst
ance(DelegatingConstructorAccessorImpl.java:45)
[18-4-15 18:54]: at java.lang.reflect.Constructor.newInstance(Constructor
.java:408)
[18-4-15 18:54]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
[18-4-15 18:54]: at com.mysql.jdbc.SQLError.createCommunicationsException
(SQLError.java:1074)
[18-4-15 18:54]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
[18-4-15 18:54]: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionI
mpl.java:2137)
[18-4-15 18:54]: ... 15 more
[18-4-15 18:54]: Caused by: java.net.ConnectException: Connection timed out: con
nect
[18-4-15 18:54]: at java.net.DualStackPlainSocketImpl.connect0(Native Met
hod)
[18-4-15 18:54]: at java.net.DualStackPlainSocketImpl.socketConnect(DualS
tackPlainSocketImpl.java:79)
[18-4-15 18:54]: at java.net.AbstractPlainSocketImpl.doConnect(AbstractPl
ainSocketImpl.java:345)
[18-4-15 18:54]: at java.net.AbstractPlainSocketImpl.connectToAddress(Abs
tractPlainSocketImpl.java:206)
[18-4-15 18:54]: at java.net.AbstractPlainSocketImpl.connect(AbstractPlai
nSocketImpl.java:188)
[18-4-15 18:54]: at java.net.PlainSocketImpl.connect(PlainSocketImpl.java
:172)
[18-4-15 18:54]: at java.net.SocksSocketImpl.connect(SocksSocketImpl.java
:392)
[18-4-15 18:54]: at java.net.Socket.connect(Socket.java:589)
[18-4-15 18:54]: at java.net.Socket.connect(Socket.java:538)
[18-4-15 18:54]: at java.net.Socket.<init>(Socket.java:434)
[18-4-15 18:54]: at java.net.Socket.<init>(Socket.java:244)
[18-4-15 18:54]: at com.mysql.jdbc.StandardSocketFactory.connect(Standard
SocketFactory.java:253)
[18-4-15 18:54]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:290)
[18-4-15 18:54]: ... 16 more
[18-4-15 18:54]: MySQL Error:DELETE FROM `online` WHERE id = 1;
[18-4-15 18:54]: java.lang.NullPointerException
[18-4-15 18:54]: at server.util.PlayersOnline.query(PlayersOnline.java:29
)
[18-4-15 18:54]: at server.util.PlayersOnline.offline(PlayersOnline.java:
50)
[18-4-15 18:54]: at server.model.players.Client.initialize(Client.java:62
0)
[18-4-15 18:54]: at server.model.players.PlayerHandler.process(PlayerHand
ler.java:122)
[18-4-15 18:54]: at server.Server.main(Server.java:193)
[18-4-15 18:54]: java.lang.NullPointerException
[18-4-15 18:54]: at server.util.PlayersOnline.destroyCon(PlayersOnline.ja
va:41)
[18-4-15 18:54]: at server.model.players.Client.initialize(Client.java:62
1)
[18-4-15 18:54]: at server.model.players.PlayerHandler.process(PlayerHand
ler.java:122)
[18-4-15 18:54]: at server.Server.main(Server.java:193)
[18-4-15 18:54]: [REGISTERED]: test
[18-4-15 18:54]: [DEREGISTERED]: test[/CODE]

this is the error it give's

Share this post


Link to post
Share on other sites
  • 0
[quote name='madmonkey'][CODE][18-4-15 18:53]: Simplicity is now online.
[18-4-15 18:54]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Commun
ications link failure

The last packet successfully received from the server was 1.429.376.050.122 mill
iseconds ago. The last packet sent successfully to the server was 0 millisecond
s ago.
[18-4-15 18:54]: at sun.reflect.NativeConstructorAccessorImpl.newInstance
0(Native Method)
[18-4-15 18:54]: at sun.reflect.NativeConstructorAccessorImpl.newInstance
(NativeConstructorAccessorImpl.java:62)
[18-4-15 18:54]: at sun.reflect.DelegatingConstructorAccessorImpl.newInst
ance(DelegatingConstructorAccessorImpl.java:45)
[18-4-15 18:54]: at java.lang.reflect.Constructor.newInstance(Constructor
.java:408)
[18-4-15 18:54]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
[18-4-15 18:54]: at com.mysql.jdbc.SQLError.createCommunicationsException
(SQLError.java:1074)
[18-4-15 18:54]: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionI
mpl.java:2214)
[18-4-15 18:54]: at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.j
ava:773)
[18-4-15 18:54]: at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection
.java:46)
[18-4-15 18:54]: at sun.reflect.NativeConstructorAccessorImpl.newInstance
0(Native Method)
[18-4-15 18:54]: at sun.reflect.NativeConstructorAccessorImpl.newInstance
(NativeConstructorAccessorImpl.java:62)
[18-4-15 18:54]: at sun.reflect.DelegatingConstructorAccessorImpl.newInst
ance(DelegatingConstructorAccessorImpl.java:45)
[18-4-15 18:54]: at java.lang.reflect.Constructor.newInstance(Constructor
.java:408)
[18-4-15 18:54]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
[18-4-15 18:54]: at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionI
mpl.java:352)
[18-4-15 18:54]: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegist
eringDriver.java:282)
[18-4-15 18:54]: at java.sql.DriverManager.getConnection(DriverManager.ja
va:664)
[18-4-15 18:54]: at java.sql.DriverManager.getConnection(DriverManager.ja
va:247)
[18-4-15 18:54]: at server.util.PlayersOnline.createCon(PlayersOnline.jav
a:17)
[18-4-15 18:54]: at server.model.players.Client.initialize(Client.java:61
9)
[18-4-15 18:54]: at server.model.players.PlayerHandler.process(PlayerHand
ler.java:122)
[18-4-15 18:54]: at server.Server.main(Server.java:193)
[18-4-15 18:54]: Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsExcept
ion: Communications link failure

The last packet successfully received from the server was 1.429.376.050.122 mill
iseconds ago. The last packet sent successfully to the server was 0 millisecond
s ago.
[18-4-15 18:54]: at sun.reflect.NativeConstructorAccessorImpl.newInstance
0(Native Method)
[18-4-15 18:54]: at sun.reflect.NativeConstructorAccessorImpl.newInstance
(NativeConstructorAccessorImpl.java:62)
[18-4-15 18:54]: at sun.reflect.DelegatingConstructorAccessorImpl.newInst
ance(DelegatingConstructorAccessorImpl.java:45)
[18-4-15 18:54]: at java.lang.reflect.Constructor.newInstance(Constructor
.java:408)
[18-4-15 18:54]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
[18-4-15 18:54]: at com.mysql.jdbc.SQLError.createCommunicationsException
(SQLError.java:1074)
[18-4-15 18:54]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
[18-4-15 18:54]: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionI
mpl.java:2137)
[18-4-15 18:54]: ... 15 more
[18-4-15 18:54]: Caused by: java.net.ConnectException: Connection timed out: con
nect
[18-4-15 18:54]: at java.net.DualStackPlainSocketImpl.connect0(Native Met
hod)
[18-4-15 18:54]: at java.net.DualStackPlainSocketImpl.socketConnect(DualS
tackPlainSocketImpl.java:79)
[18-4-15 18:54]: at java.net.AbstractPlainSocketImpl.doConnect(AbstractPl
ainSocketImpl.java:345)
[18-4-15 18:54]: at java.net.AbstractPlainSocketImpl.connectToAddress(Abs
tractPlainSocketImpl.java:206)
[18-4-15 18:54]: at java.net.AbstractPlainSocketImpl.connect(AbstractPlai
nSocketImpl.java:188)
[18-4-15 18:54]: at java.net.PlainSocketImpl.connect(PlainSocketImpl.java
:172)
[18-4-15 18:54]: at java.net.SocksSocketImpl.connect(SocksSocketImpl.java
:392)
[18-4-15 18:54]: at java.net.Socket.connect(Socket.java:589)
[18-4-15 18:54]: at java.net.Socket.connect(Socket.java:538)
[18-4-15 18:54]: at java.net.Socket.<init>(Socket.java:434)
[18-4-15 18:54]: at java.net.Socket.<init>(Socket.java:244)
[18-4-15 18:54]: at com.mysql.jdbc.StandardSocketFactory.connect(Standard
SocketFactory.java:253)
[18-4-15 18:54]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:290)
[18-4-15 18:54]: ... 16 more
[18-4-15 18:54]: MySQL Error:DELETE FROM `online` WHERE id = 1;
[18-4-15 18:54]: java.lang.NullPointerException
[18-4-15 18:54]: at server.util.PlayersOnline.query(PlayersOnline.java:29
)
[18-4-15 18:54]: at server.util.PlayersOnline.offline(PlayersOnline.java:
50)
[18-4-15 18:54]: at server.model.players.Client.initialize(Client.java:62
0)
[18-4-15 18:54]: at server.model.players.PlayerHandler.process(PlayerHand
ler.java:122)
[18-4-15 18:54]: at server.Server.main(Server.java:193)
[18-4-15 18:54]: java.lang.NullPointerException
[18-4-15 18:54]: at server.util.PlayersOnline.destroyCon(PlayersOnline.ja
va:41)
[18-4-15 18:54]: at server.model.players.Client.initialize(Client.java:62
1)
[18-4-15 18:54]: at server.model.players.PlayerHandler.process(PlayerHand
ler.java:122)
[18-4-15 18:54]: at server.Server.main(Server.java:193)
[18-4-15 18:54]: [REGISTERED]: test
[18-4-15 18:54]: [DEREGISTERED]: test[/CODE]

this is the error it give's[/QUOTE]

[code]
[18-4-15 18:54]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Commun
ications link failure
[18-4-15 18:54]: Caused by: java.net.ConnectException: Connection timed out: con
nect
[18-4-15 18:54]: at com.mysql.jdbc.StandardSocketFactory.connect(Standard
SocketFactory.java:253)
[18-4-15 18:54]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:290)
[18-4-15 18:54]: ... 16 more
[18-4-15 18:54]: MySQL Error:DELETE FROM `online` WHERE id = 1;
[18-4-15 18:54]: java.lang.NullPointerException
[18-4-15 18:54]: at server.util.PlayersOnline.query(PlayersOnline.java:29
)
[/code]

what was the last thing you edited on the server? and have you ever ran the server before?

Im downloading the source to see if the error shows for me as well Edited by omniex

Share this post


Link to post
Share on other sites
  • 0
[quote name='omniex'][code]
[18-4-15 18:54]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Commun
ications link failure
[18-4-15 18:54]: Caused by: java.net.ConnectException: Connection timed out: con
nect
[18-4-15 18:54]: at com.mysql.jdbc.StandardSocketFactory.connect(Standard
SocketFactory.java:253)
[18-4-15 18:54]: at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:290)
[18-4-15 18:54]: ... 16 more
[18-4-15 18:54]: MySQL Error:DELETE FROM `online` WHERE id = 1;
[18-4-15 18:54]: java.lang.NullPointerException
[18-4-15 18:54]: at server.util.PlayersOnline.query(PlayersOnline.java:29
)
[/code]

what was the last thing you edited on the server? and have you ever ran the server before?[/QUOTE]

I did Chance Xp rates from skills that whas last i did.

And yes i could log in untill yesterday for about 4months long i had no problems with logging in or out and since today he won't do it anymore.

Share this post


Link to post
Share on other sites
  • 0
becuse of the help from omniex i know for 90% sure that the problem is within the mysql but i dont know how to fix this for someone who helps me out that my server is working, i thank you alot omniex for your help you already did if u can help me more shall be nice.

Anyone who can help your welcome to help since i am dont know it anymore, i created a mysql database but it doesn't work somehow.

Share this post


Link to post
Share on other sites
  • 0
[quote name='madmonkey']becuse of the help from omniex i know for 90% sure that the problem is within the mysql but i dont know how to fix this for someone who helps me out that my server is working, i thank you alot omniex for your help you already did if u can help me more shall be nice.

Anyone who can help your welcome to help since i am dont know it anymore, i created a mysql database but it doesn't work somehow.[/QUOTE]

Do you have the mysql file anymore?

Share this post


Link to post
Share on other sites
Sign in to follow this  

×