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-requ...@opensimulator.org> wrote: > Send Opensim-dev mailing list submissions to > opensim-dev@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-requ...@opensimulator.org > > You can reach the person managing the list at > opensim-dev-ow...@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.gl...@yahoo.com> > To: "opensim-dev opensimulator.org" <opensim-dev@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-5930710df...@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@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@opensimulator.org > http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev > > > End of Opensim-dev Digest, Vol 68, Issue 5 > ****************************************** > _______________________________________________ Opensim-dev mailing list Opensim-dev@opensimulator.org http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev
