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
Need help connecting to MySql without SSL
Need help connecting to MySql without SSL
Tom - V8.8 build 3137 - MySql / PostGres
Re: Need help connecting to MySql without SSL
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..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
Henrik (V8 Developer Ed. - Windows)
-
- Posts: 1462
- Joined: Tue Jan 24, 2017 5:51 am
- Location: 'Stralya
Re: Need help connecting to MySql without SSL
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.tford wrote:Diving into a project on a new server and hit a speed bump in connecting to MySql.
There was a lot of fiddling about and restarts.
-
- Posts: 2413
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: Need help connecting to MySql without SSL
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.
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....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Re: Need help connecting to MySql without SSL
Himanshu rocks! Problem solved with a Zoom call.
Tom - V8.8 build 3137 - MySql / PostGres
-
- Posts: 201
- Joined: Tue Jul 27, 2010 2:17 am
- Location: Mexico
Re: Need help connecting to MySql without SSL
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!
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
AwareIM Version 8.6
Windows Server 2021
MySQL Database 8.4
MEXICO
-
- Posts: 2413
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: Need help connecting to MySql without SSL
Maria DB.
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Re: Need help connecting to MySql without SSL
It seems Himanshu has a solution, would you care to share ?Himanshu rocks! Problem solved with a Zoom call.
Re: Need help connecting to MySql without SSL
Sorry, I got late...
here is the fix Hope it helps!
here is the fix Hope it helps!
From,
Himanshu Jain
AwareIM Consultant (since version 4.0)
OS: Windows 10.0, Mac
DB: MYSQL, MSSQL
Himanshu Jain
AwareIM Consultant (since version 4.0)
OS: Windows 10.0, Mac
DB: MYSQL, MSSQL
Re: Need help connecting to MySql without SSL
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)
Re: Need help connecting to MySql without SSL
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.
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
Himanshu Jain
AwareIM Consultant (since version 4.0)
OS: Windows 10.0, Mac
DB: MYSQL, MSSQL
Re: Need help connecting to MySql without SSL
Ok, now I see thanks. Has anyone managed to get rid of the SSL error messages?
Henrik (V8 Developer Ed. - Windows)
Re: Need help connecting to MySql without SSL
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
-
- Posts: 201
- Joined: Tue Jul 27, 2010 2:17 am
- Location: Mexico
Re: Need help connecting to MySql without SSL
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*
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
AwareIM Version 8.6
Windows Server 2021
MySQL Database 8.4
MEXICO
Re: Need help connecting to MySql without SSL
Sucks we have to change DB just to remove these
Henrik (V8 Developer Ed. - Windows)