[Opensim-users] Re MySql 8

Wed Apr 27 14:28:09 UTC 2022

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.uk at 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-request at opensimulator.org>
> wrote:
>
> > Send Opensim-users mailing list submissions to
> >         opensim-users at 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-request at opensimulator.org
> >
> > You can reach the person managing the list at
> >         opensim-users-owner at 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 (tringate at gmail.com)
> >    2. Re: opensim can't connect to MySQL (Melanie)
> >
> >
> > ----------------------------------------------------------------------
> >
> > Message: 1
> > Date: Tue, 26 Apr 2022 18:07:36 -0400
> > From: <tringate at gmail.com>
> > To: "OS-Opensim Users" <opensim-users at opensimulator.org>
> > Subject: [Opensim-users] opensim can't connect to MySQL
> > Message-ID: <494B9B6B2DD043F2ADAAD53492AB4738 at 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 <melanie at t-data.com>
> > To: "opensim-users" <opensim-users at opensimulator.org>
> > Subject: Re: [Opensim-users] opensim can't connect to MySQL
> > Message-ID:
> >         <18067f20515.cf29f13e371673.7078368415128617416 at 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  <tringate at 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 at opensimulator.org
> > http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
> >
> > ------------------------------
> >
> > _______________________________________________
> > Opensim-users mailing list
> > Opensim-users at 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 at 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