JTS3ServerMod Hosting Edition - Connection Problem

Augusto22xb · July 09, 2016, 08:33:48 PM

I put the bot files within my server.

And I put the "web interface" folder inside my CPANEL server. I did the entire installation along with MYSQL. And set up the file "JTS3ServerMod_InstanceManager.cfg".

In the file I put the MYSQL login options same as that my ISP gave me. And did all the release of my hosting IPs.

Still on my page is still message.

Stefan1200 · July 09, 2016, 09:15:05 PM

Please post the JTS3ServerMod_InstanceManager.log file and the test result of the web interface at the query interface test (Settings / Query Interface).

Augusto22xb · July 11, 2016, 02:29:39 PM

I was doing the test on a windows machine.

I not got success as well. Perfect for me is to make the bot connect to my site.

Quote2016-07-11 09:27:07   START_MANAGER   JTS3ServerMod 6.1.5 Hosting Edition (14.05.2016) Instance Manager started...
2016-07-11 09:27:07   LOCK_FILE
2016-07-11 09:27:07   LOCK_FILE   ************************************************************************************************
2016-07-11 09:27:07   LOCK_FILE   Lock file still exists, it seems this JTS3ServerMod process is running twice! Please check this!
2016-07-11 09:27:07   LOCK_FILE   If you are sure, that the JTS3ServerMod process is not running twice, delete the file:
2016-07-11 09:27:07   LOCK_FILE   C:\Users\augusto\Documents\JTS3ServerMod_HostingEdition_6.1.5\JTS3ServerMod_HostingEdition\config\JTS3ServerMod_InstanceManager.cfg.lock
2016-07-11 09:27:07   LOCK_FILE   ************************************************************************************************
2016-07-11 09:27:07   LOCK_FILE
2016-07-11 09:27:07   CONFIG   Loading InstanceManager config file from: C:\Users\augusto\Documents\JTS3ServerMod_HostingEdition_6.1.5\JTS3ServerMod_HostingEdition\config\JTS3ServerMod_InstanceManager.cfg
2016-07-11 09:27:07   CONFIG   Bot chat command !exec is disabled!
2016-07-11 09:27:07   CONFIG   Multi IP Mode disabled!
2016-07-11 09:27:08   LOGGER_SQL_CONNECT   Successfully connected to MySQL server for logging!
2016-07-11 09:27:08   CONFIG   MySQL mode enabled!
2016-07-11 09:27:09   LICENCE_CHECK   Licence key is valid! Thank you very much for your support, Augusto22xb!
2016-07-11 09:27:09   TELNET_START   Query Interface started on port 5873, bound to network interface 0.0.0.0!
2016-07-11 09:27:09   TELNET_CONNECTION   Rejected telnet connection from 149.56.200.121...
2016-07-11 09:27:10   TELNET_CONNECTION   Rejected telnet connection from 149.56.200.121...
2016-07-11 09:27:10   TELNET_CONNECTION   Rejected telnet connection from 149.56.200.121...
2016-07-11 09:27:10   TELNET_CONNECTION   Rejected telnet connection from 149.56.200.121...
2016-07-11 09:27:11   TELNET_CONNECTION   Rejected telnet connection from 149.56.200.121...
2016-07-11 09:27:11   TELNET_CONNECTION   Rejected telnet connection from 149.56.200.121...

Stefan1200 · July 11, 2016, 04:09:15 PM

Quote from: Augusto22xb on July 11, 2016, 02:29:39 PM
I was doing the test on a windows machine.

I not got success as well. Perfect for me is to make the bot connect to my site.

You have seen this?

Quote from: Augusto22xb on July 11, 2016, 02:29:39 PM
2016-07-11 09:27:09   TELNET_CONNECTION   Rejected telnet connection from 149.56.200.121...
2016-07-11 09:27:10   TELNET_CONNECTION   Rejected telnet connection from 149.56.200.121...
2016-07-11 09:27:10   TELNET_CONNECTION   Rejected telnet connection from 149.56.200.121...
2016-07-11 09:27:10   TELNET_CONNECTION   Rejected telnet connection from 149.56.200.121...
2016-07-11 09:27:11   TELNET_CONNECTION   Rejected telnet connection from 149.56.200.121...
2016-07-11 09:27:11   TELNET_CONNECTION   Rejected telnet connection from 149.56.200.121...

Just fix the telnet_whitelist line on the JTS3ServerMod_InstanceManager.cfg file.

Augusto22xb · July 11, 2016, 04:55:59 PM

But why does this happen?

Quotetelnet_whitelist = 0.0.0.0

All this machine windows is locally

Stefan1200 · July 11, 2016, 05:06:37 PM

Quote from: Augusto22xb on July 11, 2016, 04:55:59 PM
But why does this happen?

149.56.200.121 is not equal to 0.0.0.0, so the connection will be rejected.
Where in the JTS3ServerMod manual did you read, that 0.0.0.0 is equal to "every IP is allowed"?

Augusto22xb · July 11, 2016, 05:35:59 PM

Ok. This here is the log of my Debian machine.

And I'm trying to connect to my site. I created the tables and put the same settings within the space of MYSQL.

No firewall is blocking the communication with the machines.

Quote2016-07-11 12:31:53   START_MANAGER   JTS3ServerMod 6.1.5 Hosting Edition (14.05.2016) Instance Manager started...
2016-07-11 12:31:53   CONFIG   Loading InstanceManager config file from: /root/JTS3ServerMod/config/JTS3ServerMod_InstanceManager.cfg
2016-07-11 12:31:53   CONFIG   Bot chat command !exec is disabled!
2016-07-11 12:31:53   CONFIG   Multi IP Mode disabled!
2016-07-11 12:31:53   LOGGER_SQL_ERROR   Critical: Cannot connect to MySQL server for logging!
2016-07-11 12:31:53   JTS3ServerMod 6.1.5 Hosting Edition (14.05.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:62)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
   at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:981)
   at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:339)
   at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
   at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2286)
   at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2085)
   at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795)
   at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
   at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327)
   at java.sql.DriverManager.getConnection(DriverManager.java:664)
   at java.sql.DriverManager.getConnection(DriverManager.java:247)
   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: Conexão recusada
   at java.net.PlainSocketImpl.socketConnect(Native Method)
   at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
   at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
   at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
   at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
   at java.net.Socket.connect(Socket.java:589)
   at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
   at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:298)
   ... 20 more
2016-07-11 12:31:53   CONFIG   MySQL mode enabled!
2016-07-11 12:31:53   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.
2016-07-11 12:31:53   JTS3ServerMod 6.1.5 Hosting Edition (14.05.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:62)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
   at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:981)
   at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:339)
   at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
   at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2286)
   at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2085)
   at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795)
   at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
   at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327)
   at java.sql.DriverManager.getConnection(DriverManager.java:664)
   at java.sql.DriverManager.getConnection(DriverManager.java:247)
   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: Conexão recusada
   at java.net.PlainSocketImpl.socketConnect(Native Method)
   at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
   at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
   at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
   at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
   at java.net.Socket.connect(Socket.java:589)
   at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
   at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:298)
   ... 19 more
2016-07-11 12:31:53   QUIT_MANAGER   InstanceManager config file at "/root/JTS3ServerMod/config/JTS3ServerMod_InstanceManager.cfg" does not exists, is not valid or an error while connecting to the database occurred, quitting now...

Stefan1200 · July 11, 2016, 05:45:47 PM

Communications link failure: FAQ entry about this error message: https://www.stefan1200.de/forum/index.php?topic=448.0

Edit by Stefan1200: Replaced old information with a link to the updated FAQ entry.

Augusto22xb · July 11, 2016, 05:52:09 PM

I am using this version for MYSQL: MariaDB 10.1

This is my version of Java.

Code Select

java version "1.8.0_91"
Java(TM) SE Runtime Environment (build 1.8.0_91-b14)
Java HotSpot(TM) 64-Bit Server VM (build 25.91-b14, mixed mode)

A problem in the version of any of them?

Stefan1200 · July 11, 2016, 06:00:53 PM

Quote from: Augusto22xb on July 11, 2016, 05:52:09 PM
This is my version of Java.

Code Select Expand
java version "1.8.0_91" Java(TM) SE Runtime Environment (build 1.8.0_91-b14) Java HotSpot(TM) 64-Bit Server VM (build 25.91-b14, mixed mode)

A problem in the version of any of them?

Perfect version.

Augusto22xb · July 12, 2016, 12:20:52 AM

Happens is that I can not move forward it.

telnet_whitelist It is to put the IP of the machine and can put more than one IP?

telnet_bindTo need to setup?

Stefan1200 · July 12, 2016, 08:19:55 AM

Quote from: Augusto22xb on July 12, 2016, 12:20:52 AM
telnet_whitelist It is to put the IP of the machine and can put more than one IP?

telnet_bindTo need to setup?

Do you ever read the comments to each setting in the config file?!? Both questions are answered in the config file and documentation, here the copy of the two settings from the documentation:

Quote# Choose a network interface for the Query Interface. Only set a single ip address of a local network interface here.
# Set nothing here to bound the Query Interface to all network interfaces (default).
# Example: Set to 127.0.0.1 (IPv4) or ::1 (IPv6) to allow connections only from localhost.
telnet_bindTo =

# A comma seperated list (without spaces) of IP addresses, which are allowed to connect to the Query Interface.
# Leave empty, if every IP address is allowed to connect.
telnet_whitelist =

Augusto22xb · July 15, 2016, 10:52:00 PM

Could correct the connection problem of my machine with MYSQL along with the webserver.

Along with Windows had successfully log along with my webserver.

I will now test with Linux.

Augusto22xb · July 20, 2016, 06:17:17 PM

Can you help me ?

That's part of my configuration

Quotetelnet_bindTo = 149.56.200.120
# A comma seperated list (without spaces) of IP addresses, which are allowed to connect to the Query Interface.
# Leave empty, if every IP address is allowed to connect.
telnet_whitelist = 149.56.200.120

The IP: 158.69.163.140 is my web interface.

Quote2016-07-20 13:08:32   START_MANAGER   JTS3ServerMod 6.1.5 Hosting Edition (14.05.2016) Instance Manager started...
2016-07-20 13:08:32   CONFIG   Loading InstanceManager config file from: /root/bot/config/JTS3ServerMod_InstanceManager.cfg
2016-07-20 13:08:32   CONFIG   Bot chat command !exec is disabled!
2016-07-20 13:08:32   CONFIG   Multi IP Mode disabled!
2016-07-20 13:08:32   LOGGER_SQL_CONNECT   Successfully connected to MySQL server for logging!
2016-07-20 13:08:32   CONFIG   MySQL mode enabled!
2016-07-20 13:08:38   LICENCE_CHECK   Licence key is valid! Thank you very much for your support, Augusto22xb!
2016-07-20 13:08:38   TELNET_START   Query Interface started on port 5873, bound to network interface 149.56.200.120!
2016-07-20 13:08:38   TELNET_CONNECTION   Rejected telnet connection from 158.69.163.140...
2016-07-20 13:08:44   TELNET_CONNECTION   Rejected telnet connection from 158.69.163.140...
2016-07-20 13:08:44   TELNET_CONNECTION   Rejected telnet connection from 158.69.163.140...

I need to put in "telnet_whitelist" the IP 158.69.163.140 ?

Thank you.

Stefan1200 · July 20, 2016, 06:55:52 PM

Quote from: Augusto22xb on July 20, 2016, 06:17:17 PM
I need to put in "telnet_whitelist" the IP 158.69.163.140?

Yes