[Opensim-dev] Opensim-dev Digest, Mysql 8.x connect issue

[Sara Payne]

You can fix this by doing two things.
1. Add some lines to your mysql.conf.d (on ubuntu, but should be similar on
cent)
ssl=0 skip_ssl default-authentication-plugin=mysql_native_password

2. Create a user for your opensim databases which is authenticated by MySQL
native password
CREATE USER 'OpenSimAdmin'@'localhost'IDENTIFIED WITH mysql_native_password
BY 'password';

On Wed, Mar 17, 2021 at 12:00 PM <opensim-dev-request at opensimulator.org>
wrote:

> Send Opensim-dev mailing list submissions to
>         opensim-dev at opensimulator.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev
> or, via email, send a message with subject or body 'help' to
>         opensim-dev-request at opensimulator.org
>
> You can reach the person managing the list at
>         opensim-dev-owner at opensimulator.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Opensim-dev digest..."
>
>
> Today's Topics:
>
>    1. Centos 8 Stream - Mysql 8.x connect issue Mysql, "You can use
>       sha256 plugin only in SSL connections in this implementation."
>       (Andr? Verwijs)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 16 Mar 2021 22:45:12 +0100
> From: Andr? Verwijs <dutch.glory at yahoo.com>
> To: "opensim-dev opensimulator.org" <opensim-dev at opensimulator.org>
> Subject: [Opensim-dev] Centos 8 Stream - Mysql 8.x connect issue
>         Mysql, "You can use sha256 plugin only in SSL connections in this
>         implementation."
> Message-ID: <ddbb67a7-094b-02eb-d97d-5930710dfe10 at yahoo.com>
> Content-Type: text/plain; charset=utf-8; format=flowed
>
>
> With Centos 8 Stream and Mysql 8.x I have a connect issue with Mysql:
>
> "You can use sha256 plugin only in SSL connections in this implementation."
>
>
> ## log text:
> Failed to load plugin
> OpenSim.Region.Framework.Interfaces.ISimulationDataStore from
> OpenSim.Data.MySQL.dll with args Data Source=localhost; SslMode=0;
> Database=opensim; User ID=OpenSim_Tester; Password=Verwijs at 1969;
>
> System.Reflection.TargetInvocationException: Exception has been thrown
> by the target of an invocation. ---> System.NotImplementedException: You
> can use sha256 plugin only in SSL connections in this implementation.
> --
>
> how do i tun off SSL with CenOS and/or Mysql and how do i check..??
> or do i REALLY need ssl to connect?
>
>
> Thank you
> be nice :) :)
> --
>
>
> ______________________________________________________________________________________
> My Twitter Page:
> twitter.com OpenSimFan <http://twitter.com/OpenSimFan>
>
> My Instagram page:
> instagram.com dutchglory <http://instagram.com/dutchglory>
>
> My Facebook page (be my friend, please)
> facebook.com Andr? Verwijs <http://www.facebook.com/andre.verwijs>
>
> My Google+ page (follow me please )
> Andr? Verwijs - Google+ <https://plus.google.com/111310545842863442992>
>
>
> ------------------------------
>
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at opensimulator.org
> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev
>
>
> End of Opensim-dev Digest, Vol 68, Issue 5
> ******************************************
>