Main Menu
Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - Ace United

#1
JTS3ServerMod MySQL & WebInterface / Error MySQL
January 21, 2017, 10:24:58 PM
Hello,
I have an error:
2017-01-21 21:53:24 START_MANAGER JTS3ServerMod 6.3.3 Hosting Edition (31.12.2016) Instance Manager started...
2017-01-21 21:53:24 CONFIG Loading InstanceManager config file from: /var/www/JTS3ServerMod_HostingEdition/config/JTS3ServerMod_InstanceManager.cfg
2017-01-21 21:53:24 CONFIG Bot chat command !exec is disabled!
2017-01-21 21:53:24 CONFIG Multi IP Mode disabled!
2017-01-21 21:53:25 LOGGER_SQL_ERROR Critical: Cannot connect to MySQL server for logging!
2017-01-21 21:53:25 JTS3ServerMod 6.3.3 Hosting Edition (31.12.2016): EXCEPTION
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:989)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2251)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at de.stefan1200.util.MySQLConnect.connect(Unknown Source)
at de.stefan1200.jts3servermod.u.a(Unknown Source)
at de.stefan1200.jts3servermod.u.<init>(Unknown Source)
at de.stefan1200.jts3servermod.f.c(Unknown Source)
at de.stefan1200.jts3servermod.f.<init>(Unknown Source)
at de.stefan1200.jts3servermod.JTS3ServerMod.main(Unknown Source)
Caused by: java.net.ConnectException: Connexion refusée (Connection refused)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
... 20 more
2017-01-21 21:53:25 CONFIG MySQL mode enabled!
2017-01-21 21:53:25 MYSQL_ERROR Error while connecting to database: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
2017-01-21 21:53:25 JTS3ServerMod 6.3.3 Hosting Edition (31.12.2016): EXCEPTION
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:989)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2251)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at de.stefan1200.util.MySQLConnect.connect(Unknown Source)
at de.stefan1200.jts3servermod.f.e(Unknown Source)
at de.stefan1200.jts3servermod.f.c(Unknown Source)
at de.stefan1200.jts3servermod.f.<init>(Unknown Source)
at de.stefan1200.jts3servermod.JTS3ServerMod.main(Unknown Source)
Caused by: java.net.ConnectException: Connexion refusée (Connection refused)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
... 19 more
2017-01-21 21:53:25 QUIT_MANAGER Error while loading the JTS3ServerMod InstanceManager config file, read error messages above to know more. Quitting now...
#2
Quote from: DivisionOfGaming on September 19, 2016, 02:07:20 PM
Bbut the channel group is not easy for all and is limit to 1 channel group and server group have no limit to add
#3
Some say that the channel servers allows it but the channel group is not easy for all and is limit to 1 channel group and server group have no limit to add
#4
Example:
You have server groups for all kinds of games in your clan.
Diablo III, League of Legends, CS:Source etc etc...

When you make a channel you can only set joinpower to join the channel.
I can put joinpower for the Diablo III server group on 60, League of Legends on 61 and CS:Source on 62.
And the channels: Diablo III, needed power of 60. League of Legends needed power of 61 and CS:Source 62.
So a Diablo III member cannot join the League of Legends channel or the CS:Source channel.

But a member with the CS:Source servergroup can join ALL Channels.
I think teamspeak will be much better with my idea:

To have in the: EDIT CHANNEL option an extra tab with: Allow or something like that.

Example: the Diablo III channel.
Only allow: Diablo III Server Group. all other server groups are not allowed to join this channel now. no joinpower needed. just allowed server groups.
Example:
#5
JTS3ServerMod MySQL & WebInterface / Re: Bot unknown!
August 25, 2016, 05:53:44 PM
Anthony
#6
JTS3ServerMod MySQL & WebInterface / Re: Bot unknown!
August 25, 2016, 11:22:23 AM
Sure, your are not present today?
#7
JTS3ServerMod MySQL & WebInterface / Re: Bot unknown!
August 24, 2016, 10:20:59 PM
Quote from: Stefan1200 on August 24, 2016, 09:39:15 PM
Quote from: DivisionOfGaming on August 24, 2016, 09:23:18 PM]
How to know if it is the same database

Well, if you used the same MySQL Server IP and database name at the web interface and in the JTS3ServerMod_InstanceManager.cfg file, than you should be fine.
It's same but I have the same problem, I have clean database in reinstall and have the same problem
#8
JTS3ServerMod MySQL & WebInterface / Re: Bot unknown!
August 24, 2016, 09:23:18 PM
Quote from: Stefan1200 on August 24, 2016, 09:09:59 PM
What happens, if you restart the JTS3ServerMod?

Do the web interface and JTS3ServerMod really use the same database?

How to know if it is the same database
#9
JTS3ServerMod MySQL & WebInterface / Re: Bot unknown!
August 24, 2016, 09:07:46 PM
Quote from: Stefan1200 on August 24, 2016, 08:43:27 PM
Quote from: DivisionOfGaming on August 24, 2016, 07:30:35 PMI have reload no work, delete and create bot no work, I have: Bot unknown!

What will be displayed on the Query Interface settings?

Everything works great!

< JTS3ServerMod
> login ********
< STATUS OK
> instancerunningcount
< 0
< STATUS OK
> qui
#10
JTS3ServerMod MySQL & WebInterface / Re: Bot unknown!
August 24, 2016, 07:30:35 PM
Quote from: Stefan1200 on August 24, 2016, 06:59:21 PM
You created the bot before you made the query interface working. But that is easy to fix.

Go to the bot list page and click on manual instance list reload. Wait 15 seconds and the status should change.

I have reload no work, delete and create bot no work, I have: Bot unknown!
#12
JTS3ServerMod MySQL & WebInterface / Bot unknown!
August 24, 2016, 06:50:40 PM
Hello,
I solved many problems during installation but I have this error on the web interface:
Bot Status: Bot unknown!
Log:
2016-08-24 18:43:15 START_MANAGER JTS3ServerMod 6.1.5 Hosting Edition (14.05.2016) Instance Manager started...
2016-08-24 18:43:15 CONFIG Loading InstanceManager config file from: /var/www/JTS3ServerMod_HostingEdition/config/JTS3ServerMod_InstanceManager.cfg
2016-08-24 18:43:15 CONFIG Bot chat command !exec is disabled!
2016-08-24 18:43:15 CONFIG Multi IP Mode disabled!
2016-08-24 18:43:15 CONFIG MySQL mode disabled!
2016-08-24 18:43:17 LICENCE_CHECK Licence key is valid! Thank you very much for your support, DivisionOfGaming!
2016-08-24 18:43:17 TELNET_START Query Interface started on port 5873!
2016-08-24 18:43:25 TELNET_CONNECTION Accepted telnet connection from 151.80.138.167...
2016-08-24 18:43:26 TELNET_CONNECTION Closed telnet connection to 151.80.138.167...

Thanks for help.