Hi I want to installing the jts3 Hosting Edition, but I try to start it and it gives me this error:
JTS3ServerMod 6.3.3 Hosting Edition (31.12.2016) Instance Manager started...
Writing InstanceManager log file to: /root/JTS3ServerMod_HostingEdition/JTS3ServerMod_InstanceManager.log
Loading InstanceManager config file from: /root/JTS3ServerMod_HostingEdition/config/JTS3ServerMod_InstanceManager.cfg
Critical: Cannot connect to MySQL server for logging!
MySQL mode enabled!
Error while connecting to database: java.sql.SQLException: Access denied for user 'JTS3'@'localhost' (using password: YES)
Error while loading the JTS3ServerMod InstanceManager config file, read error messages above to know more. Quitting now...
This is the jts3 log:
2017-01-22 09:32:29 START_MANAGER JTS3ServerMod 6.3.3 Hosting Edition (31.12.2016) Instance Manager started...
2017-01-22 09:32:29 CONFIG Loading InstanceManager config file from: /root/JTS3ServerMod_HostingEdition/config/JTS3ServerMod_InstanceManager.cfg
2017-01-22 09:32:29 CONFIG Bot chat command !exec is disabled!
2017-01-22 09:32:29 CONFIG Multi IP Mode disabled!
2017-01-22 09:32:30 LOGGER_SQL_ERROR Critical: Cannot connect to MySQL server for logging!
2017-01-22 09:32:30 JTS3ServerMod 6.3.3 Hosting Edition (31.12.2016): EXCEPTION
java.sql.SQLException: Access denied for user 'JTS3'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
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: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:410)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
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)
2017-01-22 09:32:30 CONFIG MySQL mode enabled!
2017-01-22 09:32:30 MYSQL_ERROR Error while connecting to database: java.sql.SQLException: Access denied for user 'JTS3'@'localhost' (using password: YES)
2017-01-22 09:32:30 JTS3ServerMod 6.3.3 Hosting Edition (31.12.2016): EXCEPTION
java.sql.SQLException: Access denied for user 'JTS3'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
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: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:410)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
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)
2017-01-22 09:32:30 QUIT_MANAGER Error while loading the JTS3ServerMod InstanceManager config file, read error messages above to know more. Quitting now...
This is the error message from the MySQL server:
Access denied for user 'JTS3'@'localhost' (using password: YES)
I know but all information is correct as I can fix?
can you help me with a team wewer session or another?
Quote from: Zephy on January 22, 2017, 03:38:10 PM
I know but all information is correct as I can fix?
Well, if the username and password is correct, it seems that the MySQL user JTS3 is not allowed to connect from locahost. This is not a JTS3ServerMod related error, that is MySQL related.
Moved to the right sub forum.
but it is quite correct because the webinterface you can connect but the bot no and have the same database and same account
Quote from: Zephy on January 22, 2017, 03:41:06 PM
but it is quite correct because the webinterface you can connect but the bot no and have the same database and same account
Maybe you have a space behind the MySQL password in the JTS3ServerMod_InstanceManager.cfg?
It must be attacked at = or detached?
Quote from: Zephy on January 22, 2017, 03:43:19 PM
It must be attacked at = or detached?
As far as I know the space between = and the password will be removed, but if you have a space behind the password, it will be used as password. But just test it and write the password directly behind the = without any spaces.
It should not be the same settings are these:
# Use a MySQL database to save bot instances and configurations. 1 = Enable, 0 = Disable
# There should be a structure sql file in the documents directory.
# Import this into your MySQL database to create the tables (the included web interface do this already for you).
# But you must fill this tables by yourself, the bot just reads the information out there.
mysql_enable = 1
mysql_host = 127.0.0.1
mysql_port = 3306
mysql_user = JTS3
mysql_password =1eZT1crjLCZaxXIV
mysql_database = JTS3
You have a space behind the password, just remove it.
So?
mysql_enable = 1
mysql_host = 127.0.0.1
mysql_port = 3306
mysql_user = JTS3
mysql_password = 1eZT1crjLCZaxXIV
mysql_database = JTS3
You know the word "behind"?
Behind how? You can post the part of the password I'm not understanding.
Then? How should I do?
You still have a space behind the password, just remove it.
There is no space I also tried to remove it and put it back, and the same does not go how can I do?
Both times you posted the password here had a space at the end of the line. You removed it?
I solved thanks stephan