MySQL connection problem

Harry · January 29, 2017, 03:36:39 PM

Hello,

When I try to launch the bot I get an error about the SSL connection without server identity verification. I have attached the log file

Thanks
Harry

Code Select

2017-01-29 14:08:05	START_MANAGER	JTS3ServerMod 6.3.3 Hosting Edition (31.12.2016) Instance Manager started...
2017-01-29 14:08:05	CONFIG	Loading InstanceManager config file from: /root/JTS3ServerMod_HostingEdition/config/JTS3ServerMod_InstanceManager.cfg
2017-01-29 14:08:05	CONFIG	Bot chat command !exec is disabled!
2017-01-29 14:08:05	CONFIG	Multi IP Mode disabled!
2017-01-29 14:08:05	LOGGER_SQL_ERROR	Critical: Cannot connect to MySQL server for logging!
2017-01-29 14:08:05	JTS3ServerMod 6.3.3 Hosting Edition (31.12.2016): EXCEPTION
java.sql.SQLException: Access denied for user 'bot'@'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-29 14:08:05	CONFIG	MySQL mode enabled!
2017-01-29 14:08:05	MYSQL_ERROR	Error while connecting to database: java.sql.SQLException: Access denied for user 'bot'@'localhost' (using password: YES)
2017-01-29 14:08:05	JTS3ServerMod 6.3.3 Hosting Edition (31.12.2016): EXCEPTION
java.sql.SQLException: Access denied for user 'bot'@'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-29 14:08:05	QUIT_MANAGER	Error while loading the JTS3ServerMod InstanceManager config file, read error messages above to know more. Quitting now...

Stefan1200 · January 29, 2017, 05:21:54 PM

Check the user account settings on the MySQL server, this is the error message:
Error while connecting to database: java.sql.SQLException: Access denied for user 'bot'@'localhost' (using password: YES)

For the SSL certificate warning, check this: https://www.stefan1200.de/forum/index.php?topic=416.0

Harry · January 29, 2017, 05:30:23 PM

Quote from: Stefan1200 on January 29, 2017, 05:21:54 PM
Check the user account settings on the MySQL server, this is the error message:
Error while connecting to database: java.sql.SQLException: Access denied for user 'bot'@'localhost' (using password: YES)

For the SSL certificate warning, check this: https://www.stefan1200.de/forum/index.php?topic=416.0

What would be wrong with the user account settings?

Harry · January 29, 2017, 05:49:59 PM

Attached is a picture of all the permissions for the 'bot' account which is being used

Stefan1200 · January 29, 2017, 10:01:16 PM

Als MySQL Server Adresse ist auch localhost in der JTS3ServerMod_InstanceManager.cfg Datei angegeben worden?

Harry · January 29, 2017, 10:07:42 PM

Quote from: Stefan1200 on January 29, 2017, 10:01:16 PM
Als MySQL Server Adresse ist auch localhost in der JTS3ServerMod_InstanceManager.cfg Datei angegeben worden?

I dont speak German but I used Google Translate so here goes, yes I set the address to 127.0.0.1

Thanks
Harry

Stefan1200 · January 29, 2017, 10:13:27 PM

Quote from: Harry on January 29, 2017, 10:07:42 PM
I dont speak German but I used Google Translate so here goes, yes I set the address to 127.0.0.1

Sorry, I'm already tired and sometimes I translate English into German so fast in my brain, that I forgot, that I have to answer in English.

Then I don't know. This is an error message from the MySQL server. The MySQL server rejects the connection attempt from the JTS3ServerMod.

But make sure that you don't have spaces around the MySQL password in the JTS3ServerMod_InstanceManager.cfg file, which are not part of the password.

Harry · January 29, 2017, 11:06:14 PM

Quote from: Stefan1200 on January 29, 2017, 10:13:27 PM
Quote from: Harry on January 29, 2017, 10:07:42 PM
I dont speak German but I used Google Translate so here goes, yes I set the address to 127.0.0.1

Sorry, I'm already tired and sometimes I translate English into German so fast in my brain, that I forgot, that I have to answer in English.

Then I don't know. This is an error message from the MySQL server. The MySQL server rejects the connection attempt from the JTS3ServerMod.

But make sure that you don't have spaces around the MySQL password in the JTS3ServerMod_InstanceManager.cfg file, which are not part of the password.

Wow, it was as simple as removing the space after the password haha. Thank you