Need help connecting to MySql without SSL

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Need help connecting to MySql without SSL

Post by 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
Tom - V8.8 build 3137 - MySql / PostGres
hpl123
Posts: 2579
Joined: Fri Feb 01, 2013 1:13 pm
Location: Scandinavia

Re: Need help connecting to MySql without SSL

Post by 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..
Henrik (V8 Developer Ed. - Windows)
PointsWell
Posts: 1457
Joined: Tue Jan 24, 2017 5:51 am
Location: 'Stralya

Re: Need help connecting to MySql without SSL

Post by 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
Posts: 2392
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Need help connecting to MySql without SSL

Post by 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.
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: Need help connecting to MySql without SSL

Post by tford »

Himanshu rocks! Problem solved with a Zoom call.
Tom - V8.8 build 3137 - MySql / PostGres
lineamovil
Posts: 201
Joined: Tue Jul 27, 2010 2:17 am
Location: Mexico

Re: Need help connecting to MySql without SSL

Post by 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!
LineaMovil // Carlos Castillo
AwareIM Version 8.6
Windows Server 2021
MySQL Database 8.4
MEXICO
customaware
Posts: 2392
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Need help connecting to MySql without SSL

Post by customaware »

Maria DB.
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
ACDC
Posts: 1138
Joined: Sat Jun 30, 2007 5:03 pm
Location: California, USA

Re: Need help connecting to MySql without SSL

Post by ACDC »

Himanshu rocks! Problem solved with a Zoom call.
It seems Himanshu has a solution, would you care to share ? :)
himanshu
Posts: 722
Joined: Thu Jun 19, 2008 6:24 am
Location: India
Contact:

Re: Need help connecting to MySql without SSL

Post by himanshu »

Sorry, I got late...

here is the fix
workbench screenshot
workbench screenshot
Screenshot 2020-07-02 at 9.43.38 PM.png (93.82 KiB) Viewed 15216 times
Hope it helps!
From,
Himanshu Jain


AwareIM Consultant (since version 4.0)
OS: Windows 10.0, Mac
DB: MYSQL, MSSQL
hpl123
Posts: 2579
Joined: Fri Feb 01, 2013 1:13 pm
Location: Scandinavia

Re: Need help connecting to MySql without SSL

Post by 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?
Henrik (V8 Developer Ed. - Windows)
himanshu
Posts: 722
Joined: Thu Jun 19, 2008 6:24 am
Location: India
Contact:

Re: Need help connecting to MySql without SSL

Post by 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.
From,
Himanshu Jain


AwareIM Consultant (since version 4.0)
OS: Windows 10.0, Mac
DB: MYSQL, MSSQL
hpl123
Posts: 2579
Joined: Fri Feb 01, 2013 1:13 pm
Location: Scandinavia

Re: Need help connecting to MySql without SSL

Post by hpl123 »

Ok, now I see thanks. Has anyone managed to get rid of the SSL error messages?
Henrik (V8 Developer Ed. - Windows)
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: Need help connecting to MySql without SSL

Post by 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.
Tom - V8.8 build 3137 - MySql / PostGres
lineamovil
Posts: 201
Joined: Tue Jul 27, 2010 2:17 am
Location: Mexico

Re: Need help connecting to MySql without SSL

Post by 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*
LineaMovil // Carlos Castillo
AwareIM Version 8.6
Windows Server 2021
MySQL Database 8.4
MEXICO
hpl123
Posts: 2579
Joined: Fri Feb 01, 2013 1:13 pm
Location: Scandinavia

Re: Need help connecting to MySql without SSL

Post by hpl123 »

Sucks we have to change DB just to remove these :(
Henrik (V8 Developer Ed. - Windows)
Post Reply