Contrary to what Melanie said you can use MySql8 with opensim but its not an out of the box solution.
You need to set the default authentication plugin to mysql native password. In addition you need to make sure the mysql user authenticates using mysql native password. After that it should work fine if you also turn of ssl in the way mentioned already. I use MySql 8 with opensim under Linux and Windows. With windows you can set the default authentication when you install MySql server. I assume you can also change it using the config ini files but have not tried under Windows. On Wed, 27 Apr 2022, 13:00 , <opensim-users-requ...@opensimulator.org> wrote: > Send Opensim-users mailing list submissions to > opensim-users@opensimulator.org > > To subscribe or unsubscribe via the World Wide Web, visit > http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users > or, via email, send a message with subject or body 'help' to > opensim-users-requ...@opensimulator.org > > You can reach the person managing the list at > opensim-users-ow...@opensimulator.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Opensim-users digest..." > > > Today's Topics: > > 1. opensim can't connect to MySQL (tring...@gmail.com) > 2. Re: opensim can't connect to MySQL (Melanie) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Tue, 26 Apr 2022 18:07:36 -0400 > From: <tring...@gmail.com> > To: "OS-Opensim Users" <opensim-users@opensimulator.org> > Subject: [Opensim-users] opensim can't connect to MySQL > Message-ID: <494B9B6B2DD043F2ADAAD53492AB4738@TomsDesktop> > Content-Type: text/plain; charset="iso-8859-1" > > Need help again. This time it's with MySQL on windows 10. > > I have a fair amount of experience with MySQL on Linux and a little with > it on windows. I have real problems understanding windows and the > workbench program for MySQL. > Phpmyadmin is so much simpler to use for me. > > My problem is I have V 8.0.13.0 (2018) of MySQL running on my desktop > computer and it is working just fine. > I a new region running just fine on OSgrid using the built in MySQLlite > that comes with opensim but want to use a more robust database than that. > The version I installed of MySQL on this system is V 8.0.29.0 (2022). > > I can't see any difference in my setup between the two systems, but > opensim fails with the following error when it tries to access the database. > 2022-04-26 16:24:00,252 ERROR [SERVICE BASE]: Failed to load plugin > OpenSim.Region.Framework.Interfaces.ISimulationDataStore from > OpenSim.Data.MySQL.dll with args Data > Source=localhost;Database=osg-romantica;User ID=*****;Password=******;Old > Guids=true;SslMode=None; > System.Reflection.TargetInvocationException: Exception has been thrown by > the target of an invocation. ---> MySql.Data.MySqlClient.MySqlException: > Authentication method 'caching_sha2_password' not supported by any of the > available plugins. > > The configuration line for MySQL in both systems is identical with the > exception of the database name. > > ConnectionString = "Data Source=localhost;Database=osg-romantica;User > ID=*****;Password=*****;Old Guids=true;SslMode=None;" > > I have tried using both the above line with and without the SslMode=None; > parameter and it makes no difference. > > Before I see if installing the older version fixes it I wanted to ask if > I'm missing something new in the workbench program that I need to do to > define the server and it's parameters. > > Slow Putzo > > ------------------------------ > > Message: 2 > Date: Tue, 26 Apr 2022 23:15:55 +0100 > From: Melanie <mela...@t-data.com> > To: "opensim-users" <opensim-users@opensimulator.org> > Subject: Re: [Opensim-users] opensim can't connect to MySQL > Message-ID: > <18067f20515.cf29f13e371673.7078368415128617...@t-data.com> > Content-Type: text/plain; charset="UTF-8" > > Opensim doesn't support MySQL 8 and also doesn't support MariaDB.? You > need to install the latest supported MySQL 5.7. > > > > - Melanie > > > > > > > > ---- On Tue, 26 Apr 2022 23:07:36 +0100 <tring...@gmail.com> wrote ---- > > > > Need help again. This time it's with MySQL on windows 10. > > I have a fair amount of experience with MySQL on Linux and a little with > it on windows. I have real problems understanding windows and the > workbench program for MySQL. > Phpmyadmin is so much simpler to use for me. > > My problem is I have V 8.0.13.0 (2018) of MySQL running on my desktop > computer and it is working just fine. > I a new region running just fine on OSgrid using the built in MySQLlite > that comes with opensim but want to use a more robust database than that. > The version I installed of MySQL on this system is V 8.0.29.0 (2022). > > I can't see any difference in my setup between the two systems, but > opensim fails with the following error when it tries to access the > database. > 2022-04-26 16:24:00,252 ERROR [SERVICE BASE]: Failed to load plugin > OpenSim.Region.Framework.Interfaces.ISimulationDataStore from > OpenSim.Data.MySQL.dll with args Data > Source=localhost;Database=osg-romantica;User ID=*****;Password=******;Old > Guids=true;SslMode=None; > System.Reflection.TargetInvocationException: Exception has been thrown by > the target of an invocation. ---> MySql.Data.MySqlClient.MySqlException: > Authentication method 'caching_sha2_password' not supported by any of the > available plugins. > > The configuration line for MySQL in both systems is identical with the > exception of the database name. > > ConnectionString = "Data Source=localhost;Database=osg-romantica;User > ID=*****;Password=*****;Old Guids=true;SslMode=None;" > > I have tried using both the above line with and without the SslMode=None; > parameter and it makes no difference. > > Before I see if installing the older version fixes it I wanted to ask if > I'm missing something new in the workbench program that I need to do to > define the server and it's parameters. > > Slow Putzo > _______________________________________________ > Opensim-users mailing list > mailto:Opensim-users@opensimulator.org > http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users > > ------------------------------ > > _______________________________________________ > Opensim-users mailing list > Opensim-users@opensimulator.org > http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users > > > End of Opensim-users Digest, Vol 94, Issue 5 > ******************************************** > _______________________________________________ Opensim-users mailing list Opensim-users@opensimulator.org http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
