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 - Benjamin

Pages1
#1
JTS3ServerMod MySQL & WebInterface / Re: Bot will sich einfach nicht mehr mit dem mySQL Server verbinden
May 04, 2017, 06:18:22 PM

  • Die IP Adresse oder der Hostname vom MySQL server sind in der JTS3ServerMod_InstanceManager.cfg falsch.
Daten wurden überprüft und stimmen überein.


  • Der Port vom MySQL Server ist in der JTS3ServerMod_InstanceManager.cfg falsch gesetzt.
Port ist richtigt gesetzt.


  • Überprüfe das bind-address Attribut vom MySQL Server. Stelle sicher, dass das bind-address Attribut in den MySQL Server Einstellungen (my.cnf / my.ini) zu einem gültigen Netzwerk Interface oder "0.0.0.0" gebunden ist.
bind-address in den Configs richtig eingestellt.


  • Datenbank Server ist offline.
Server online und erreichbar


  • Datenbank Server erlaubt keine TCP/IP Verbindungen.
Datenbank erlaubt diese.


  • Datenbank Server hat das Verbindungslimit überschritten.
Limit wird nicht überschritten.


  • Irgendwas zwischen Java und der Datenbank blockiert die Verbindung, z.B. eine Firewall oder Proxy.
läuft alles auf dem gleichen Server. Firewall und Proxy greifen nicht ein.
#2
JTS3ServerMod MySQL & WebInterface / Bot will sich einfach nicht mehr mit dem mySQL Server verbinden
May 04, 2017, 01:06:40 PM
Seit geraumer Zeit möchte der Bot sich nicht mehr mit meinem mySQL Server verbinden.
Hier ein mal meine log.
das Webinterface ist angebunden mit dem mySQL Socket

Quote2017-05-04 13:01:20   START_MANAGER   JTS3ServerMod 6.4.0 Hosting Edition (24.03.2017) Instance Manager started...
2017-05-04 13:01:20   LOCK_FILE   
2017-05-04 13:01:20   LOCK_FILE   ************************************************************************************************
2017-05-04 13:01:20   LOCK_FILE   Lock file still exists, it seems this JTS3ServerMod process is running twice! Please check this!
2017-05-04 13:01:20   LOCK_FILE   If you are sure, that the JTS3ServerMod process is not running twice, delete the file:
2017-05-04 13:01:20   LOCK_FILE   /home/teamspeak/bot/config/JTS3ServerMod_InstanceManager.cfg.lock
2017-05-04 13:01:20   LOCK_FILE   ************************************************************************************************
2017-05-04 13:01:20   LOCK_FILE   
2017-05-04 13:01:20   CONFIG   Loading InstanceManager config file from: /home/teamspeak/bot/config/JTS3ServerMod_InstanceManager.cfg
2017-05-04 13:01:20   CONFIG   Bot chat command !exec is disabled!
2017-05-04 13:01:20   CONFIG   Multi IP Mode disabled!
2017-05-04 13:01:20   LOGGER_SQL_ERROR   Critical: Cannot connect to MySQL server for logging!
2017-05-04 13:01:20   JTS3ServerMod 6.4.0 Hosting Edition (24.03.2017): 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: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:2203)
   at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2236)
   at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2035)
   at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:790)
   at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
   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:425)
   at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
   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: Verbindungsaufbau abgelehnt (Connection refused)
   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:300)
   ... 20 more
2017-05-04 13:01:20   CONFIG   MySQL mode enabled!
2017-05-04 13:01:20   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-05-04 13:01:20   JTS3ServerMod 6.4.0 Hosting Edition (24.03.2017): 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: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:2203)
   at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2236)
   at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2035)
   at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:790)
   at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
   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:425)
   at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
   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: Verbindungsaufbau abgelehnt (Connection refused)
   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:300)
   ... 19 more
2017-05-04 13:01:20   QUIT_MANAGER   Error while loading the JTS3ServerMod InstanceManager config file, read error messages above to know more. Quitting now...

Danke schon mal für die Hilfe
Pages1