[Opensim-users] Re MySql 8

Wed Apr 27 12:12:58 UTC 2022

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
> ********************************************
>