Need help connecting to MySql without SSL

tford

Diving into a project on a new server and hit a speed bump in connecting to MySql.

Our IT group does not yet have SSL installed on this server and I received this message when trying to connect AwareIM to MySql:

Fri Jun 19 17:14:12 EDT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

Server startup error. Access to database is denied.

Can anyone help me know where to place the suggested clause:
useSSL=false

hpl123

tford wrote
Diving into a project on a new server and hit a speed bump in connecting to MySql.

Our IT group does not yet have SSL installed on this server and I received this message when trying to connect AwareIM to MySql:

Fri Jun 19 17:14:12 EDT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

Server startup error. Access to database is denied.

Can anyone help me know where to place the suggested clause:
useSSL=false

The SSL error is the one we get all the time when using MySQL and I don´t think it´s related to the error you are having. The error is you not being able to access the database so check credentials, DB name etc..

PointsWell

tford wrote
Diving into a project on a new server and hit a speed bump in connecting to MySql.

I just had a server rebuild and for a hot minute had the same problem. I "fixed" by using MySQL server 8.0.20, with the J connector (platform independent) v 8.0.20.

There was a lot of fiddling about and restarts.

customaware

I was never able to fix it....
So, coupled with the inabiluty of MySQL to handle Sequences, have migrated all except one of my database to Maria DB. No more issues.

tford

Himanshu rocks! Problem solved with a Zoom call.

lineamovil

Hi, Im having similar problem.

Install works great on MySQL version 5. No problems at all.

Problem comes with MySql version 8. I look in the forum and in the Install guide, but it is not letting connect as I did in previous MySql versions.

I dont think it should be hard to make an install. If you have a solution will appreciate very much!

thank you!

customaware

Maria DB.

ACDC

Himanshu rocks! Problem solved with a Zoom call.

It seems Himanshu has a solution, would you care to share ? 🙂

himanshu

Sorry, I got late...

here is the fix
Screenshot 2020-07-02 at 9.43.38 PM.png

Hope it helps!

hpl123

Thanks for sharing the solution and/but I am confused. What exactly was the problem and what does this fix do? Will this remove all the SSL errors or is this something else entirely?

himanshu

Hi Henrik,

This is regarding MySQL 8.+ installation issue which does not allow you to connect the MySQL instance. In MySQL version 8 default config of authentication is set to encryption only "caching_sha2_password" which create a issue to connect locally.

So you need to change the authentication to native which allow you accept the standard way we follow in older version.

hpl123

Ok, now I see thanks. Has anyone managed to get rid of the SSL error messages?

tford

I got rid of the error messages for good with Mark's help this morning ... switched to MariaDB. I should have listened to him in the first place.

lineamovil

I have been using Mysql because Workbench works pretty good for me. And it seems to be a popular database, (also I got to learn the basics on MySQL)

I hope there will be soon a quick connection with MySQL.

I know it works with MySQL 5.x but maybe for security reason or performance will be better to use MySQL 8.0.

I found this: https://github.com/RennurApps/AwareIM-resources
LOOK for: Database Servers

hpl123

Sucks we have to change DB just to remove these 🙁

PointsWell

hpl123 wrote
Sucks we have to change DB just to remove these 🙁

I do not have this problem with MySQL 8 with a v8 JDBC driver. Passwords not updated to new storage method.

tford

Henrik,

Would you mind sharing where you obtain this and how to install it into an AwareIM configuration?