Tagged: MySQL 8.X
This topic has 18 replies, 3 voices, and was last updated 1 year, 6 months ago by Thomas.
-
AuthorPosts
-
June 11, 2019 at 3:57 pm #9542
Thomas
MemberI am unable to add MySQL 8.x to my services. I have upgraded to Version 2 of mspControl.
Database (2088, 6/7/2019 9:27 AM, Status: Ok)
Enterprise Server (2.0.0.1023)
Portal (2.0.0.1023)
SRV-XXXX (2.0.0.1023)The process I am doing is add the service to the server:
Then click on the “Add Service” button and then the error is displayed on the screen:
MySQL 8 is installed on this server. I also have the current MySQL ODBC and .NET Connector installed as well.
I am able to go back to the MySQL 5.7 and add the service from there, however I am sure this can’t be possibly correct as version 8.x has some major changes oh how authentication works.
After you click the Add Service button it processes and then goes to the configure service page. Any idea why the version 8.x service doesn’t appear to be working ?
Like0Be the first one to like this.Please wait...Attachments:
You must be logged in to access attached files.
June 12, 2019 at 10:00 am #9549MSPControl
KeymasterSent to Developer to check into it.
Like11 person likes this.Please wait...June 24, 2019 at 6:13 pm #9563Thomas
MemberWanted to follow up on this. I upgraded to the latest version today and am still unable to add MySQL 8 Servers to my configuration. I get the following error when I try to add the server / service.
The expected version of the software is not found on your server.
As of this post the site reports Last version: 2.0.0.1068 (6/24/2019 2:09 PM)
My installed version is:
Database (2097, 6/24/2019 5:02 PM, Status: Ok)
Enterprise Server (2.0.0.1068)
Portal (2.0.0.1068)
SRV-XXXX (2.0.0.1068)Like0Be the first one to like this.Please wait...June 25, 2019 at 11:42 am #9569Thomas
MemberIn troubleshooting another issue I have been upgrading my software. I am still getting the same error as before.
Current version is now:
Database (2097, 6/24/2019 5:02 PM, Status: Error)
Enterprise Server (2.0.0.1075)
Portal (2.0.0.1075)
SRV-XXXX (2.0.0.1075)Like0Be the first one to like this.Please wait...June 26, 2019 at 3:27 pm #9574Thomas
MemberI have upgraded to the current version 2.0.0.1088 to correct another issue. I am still unable to add the MySQL Server service to my server. The error I get is:
- The expected version of the software is not found on your server.
Current version:
Database (2100, 6/26/2019 2:12 PM, Status: Ok)
Enterprise Server (2.0.0.1088)
Portal (2.0.0.1088)
SRV-XXXX (2.0.0.1088)Like0Be the first one to like this.Please wait...July 3, 2019 at 10:08 am #9581Thomas
MemberI have upgraded to the current version 2.0.0.1106. I am still unable to add the MySQL Server service to my server. The error I get is:
The expected version of the software is not found on your server.
Current version:
Database (2104, 7/3/2019 9:04 AM, Status: Ok)
Enterprise Server (2.0.0.1106)
Portal (2.0.0.1106)
SRV-XXXX (2.0.0.1106)Like0Be the first one to like this.Please wait...July 4, 2019 at 10:24 pm #9589MSPControl
KeymasterYes we are still working on it. Should be soon sorry about the trouble.
Like0Be the first one to like this.Please wait...July 5, 2019 at 9:36 am #9591MSPControl
KeymasterThomas – a fix has been applied let us know if it works for you. It’s applied in 2.0.0.1117+
Like11 person likes this.Please wait...July 5, 2019 at 10:33 am #9592Thomas
MemberI am able to add the service to the server, however now I am getting the following error when I try to configure the service.
Service installation results:
Could not connect to the specified MySQL Server: Authentication method ‘caching_sha2_password’ not supported by any of the available plugins.I have installed the latest version of MySQL
MySQL Server 8.0.16
Connector/ODBC 8.0.16
Connector/NET 8.0.16Current Version:
Database (2105, 7/5/2019 9:05 AM, Status: Ok)
Enterprise Server (2.0.0.1117)
Portal (2.0.0.1117)
SRV-XXXX (2.0.0.1117)Like0Be the first one to like this.Please wait...July 6, 2019 at 12:34 pm #9598Rich Bailo
MemberThomas,
Thanks for your patients, and Thank you for bringing all of this to our attention. when MySQL was added as a provider it was a slight oversight to all the new features MySQL 8.X has to offer. We are working on bringing all these features current. I am hoping that the provider will be operational Monday, and all new features added within the next week.
We will keep you updated on our progress.
Like11 person likes this.Please wait...1 user thanked author for this post.
July 9, 2019 at 2:17 pm #9601Thomas
MemberI went ahead and downloaded the current version 1126 for testing. Still unable to connect. Just so that others are aware this is only related to the portal. Local connections from customers and their sites (for example WordPress) work just fine. Thankfully I just have to maintain the current MySQL connections to existing databases.
Error:
Service installation results:
Could not connect to the specified MySQL Server: Authentication method ‘caching_sha2_password’ not supported by any of the available plugins.Database (2106, 7/9/2019 12:57 PM, Status: Ok)
Enterprise Server (2.0.0.1126)
Portal (2.0.0.1126)
SRV-XXXX (2.0.0.1126)Like0Be the first one to like this.Please wait...July 12, 2019 at 10:05 am #9602Thomas
MemberI have updated to the current version. Currently still unable to connect with the same error message.
Service installation results:
Could not connect to the specified MySQL Server: Authentication method ‘caching_sha2_password’ not supported by any of the available plugins.Current Version:
Database (2110, 7/10/2019 9:40 PM, Status: Ok)
Enterprise Server (2.0.0.1137)
Portal (2.0.0.1137)
SRV-XXXX (2.0.0.1137)Like0Be the first one to like this.Please wait...July 15, 2019 at 11:15 am #9603Thomas
MemberStatus Update:
Unfortunately I am still getting the same error as last week.Service installation results:
Could not connect to the specified MySQL Server: Authentication method ‘caching_sha2_password’ not supported by any of the available plugins.Last version: 2.0.0.1145 (7/15/2019 7:21 AM)
Database (2110, 7/10/2019 9:40 PM, Status: Ok)
Enterprise Server (2.0.0.1145)
Portal (2.0.0.1145)
SRV-XXXX (2.0.0.1145)Like0Be the first one to like this.Please wait...July 16, 2019 at 6:08 pm #9605MSPControl
KeymasterThomas, it’s probably a week out from here. Seems the problems with the new provider were larger then we first thought. Rich who is working on it works on the control panel as a hobby – so it’s going at his pace and I wont pressure him because I am grateful for his help. As soon as we got something to show I will post to the forum to let you know.
Like0Be the first one to like this.Please wait...July 18, 2019 at 11:37 pm #9608Rich Bailo
MemberThomas,
I am almost finished with the changes to MySQL 8 Provider. I do have a few questions for you.
- Is this a fresh install of MySQL 8.0 or an Upgrade?
- If a fresh install what authentication did you choose, Default or Legacy?
- Are there any other versions of MySQL installed on the server?
I should be checking and testing my changes tonight and tomorrow and will keep you updated.
Like0Be the first one to like this.Please wait...1 user thanked author for this post.
July 19, 2019 at 9:11 am #9610Thomas
MemberGood morning Rich,
Thank you for your hard work on this. Please let me know if there is anything you would like for me to try.
Is this a fresh install of MySQL 8.0 or an Upgrade?
- This server was running 5.7. I did a MySQL dump of each database and then completely uninstalled 5.7, deleted the remaining files and folders off the server. Then I did a complete fresh install of MySQL 8.0.16 and restored the MySQL dumps.
If a fresh install what authentication did you choose, Default or Legacy?
- I selected the new default secure method for passwords
Are there any other versions of MySQL installed on the server?
- No this is the only MySQL instance on this server
Like0Be the first one to like this.Please wait...July 20, 2019 at 8:18 am #9611MSPControl
KeymasterTry latest and see how far you get. Let us know.
Like0Be the first one to like this.Please wait...July 20, 2019 at 12:40 pm #9612Rich Bailo
MemberThomas,
You might run into an issue with users, See here: https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html .
If you look at your users you need to determine what authentication they are using Since they came from a 5.7 setup but you setup MySQL 8 with default caching_sha2_password, you might have an issue. Maybe using the old password button might work. Also If MySQL 8 is not installed on the same server as the application like ‘localhost’ You will need MySQL setup with SSL or an unencrypted connection that supports password exchange using an RSA key pair. If you need help I’ll be here later tonight.
Like0Be the first one to like this.Please wait...July 20, 2019 at 1:35 pm #9613Thomas
MemberGood morning everyone,
I am happy to report that this connection issue has been resolved as of the current release of mspControl 2.0.0.1165. Thank you for all your work in getting this resolved. The only remaining issue that I have is the license issue where everything is disabled. But I believe I have another thread about that.
@Rich Bailo, I have verified that my clients are not having any issues. I forgot to mention that I created new users and tables then restored the data. This should have prevented the issue you are talking about.
You might run into an issue with users, See here: https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html .
Thank you for the heads up though, so far I haven’t had any reported connection issues from clients. This issue only affected mspControl Portal.
Current Version:
Database (2114, 7/19/2019 8:59 AM, Status: Ok)
Enterprise Server (2.0.0.1165)
Portal (2.0.0.1165)
SRV-XXXX (2.0.0.1165)Like0Be the first one to like this.Please wait... -
AuthorPosts
You must be logged in to reply to this topic.