Sara I did that on mysql 8 and got robust working just fine but had nothing but errors when I loaded the first simulator
On Wed, Apr 27, 2022 at 5:13 AM Sara Payne <sarapayne...@gmail.com> wrote: > 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 > -- Kalasiddhi Grid Co-Coordinator HG: kalasiddhigrid.com:8002 Web: http://www.kalasiddhigrid.com Buddhism in Virtual Reality Drang Po _______________________________________________ Opensim-users mailing list Opensim-users@opensimulator.org http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
