I have been using fire secual version 8 for the last 2 years with opensimulator. In the MySQL settings you need to make the default authentication MySQL native password. You also need to turn SSL off. After that you need to make sure that the user that accesses the opensimulator database authenticate with MySQL native password. The previous problems with having to manually change the collate no longer apply.
On Thu, 31 Mar 2022, 13:49 , <[email protected]> wrote: > Send Opensim-dev mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Opensim-dev digest..." > > > Today's Topics: > > 1. MySQL 8.0 Anyone? (Mike Higgins) > 2. Re: MySQL 8.0 Anyone? (Melanie) > 3. Re: MySQL 8.0 Anyone? ([email protected]) > 4. Re: MySQL 8.0 Anyone? (Jeff Kelley) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 30 Mar 2022 13:08:01 -0700 > From: Mike Higgins <[email protected]> > To: [email protected] > Subject: [Opensim-dev] MySQL 8.0 Anyone? > Message-ID: <[email protected]> > Content-Type: text/plain; charset=UTF-8; format=flowed > > I need to update my MySQL to version 8.0 for some new features. My 18.04 > Ubuntu server came with MySQL 5.7. > > Has anyone else run OpenSim on MySQL 8.0 on Linux? Do they play well > together? > > > > > ------------------------------ > > Message: 2 > Date: Wed, 30 Mar 2022 21:41:02 +0100 > From: Melanie <[email protected]> > To: "opensim-dev" <[email protected]> > Subject: Re: [Opensim-dev] MySQL 8.0 Anyone? > Message-ID: > <[email protected]> > Content-Type: text/plain; charset="UTF-8" > > Last time I tried, it wasn't compatible with MySQL 8.0 > > > > - Melanie > > > > ---- On Wed, 30 Mar 2022 21:08:01 +0100 Mike Higgins <[email protected]> > wrote ---- > > > > I need to update my MySQL to version 8.0 for some new features. My 18.04 > Ubuntu server came with MySQL 5.7. > > Has anyone else run OpenSim on MySQL 8.0 on Linux? Do they play well > together? > > > _______________________________________________ > Opensim-dev mailing list > mailto:[email protected] > http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev > > ------------------------------ > > Message: 3 > Date: Wed, 30 Mar 2022 16:43:22 -0400 > From: <[email protected]> > To: <[email protected]> > Subject: Re: [Opensim-dev] MySQL 8.0 Anyone? > Message-ID: <[email protected]> > Content-Type: text/plain; charset="us-ascii" > > I run a development version with 8.0. You need to update mysql drivers and > there are some issues with table default collations that need some > attention. It can be made to work but its not an out of the box easy > upgrade. > > Mike > > -----Original Message----- > From: [email protected] > <[email protected]> On Behalf Of Melanie > Sent: Wednesday, March 30, 2022 4:41 PM > To: opensim-dev <[email protected]> > Subject: Re: [Opensim-dev] MySQL 8.0 Anyone? > > Last time I tried, it wasn't compatible with MySQL 8.0 > > > > - Melanie > > > > ---- On Wed, 30 Mar 2022 21:08:01 +0100 Mike Higgins <[email protected]> > wrote ---- > > > > I need to update my MySQL to version 8.0 for some new features. My 18.04 > Ubuntu server came with MySQL 5.7. > > Has anyone else run OpenSim on MySQL 8.0 on Linux? Do they play well > together? > > > _______________________________________________ > Opensim-dev mailing list > mailto:[email protected] > http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev > _______________________________________________ > Opensim-dev mailing list > [email protected] > http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev > > > > ------------------------------ > > Message: 4 > Date: Wed, 30 Mar 2022 14:12:34 +0100 > From: Jeff Kelley <[email protected]> > To: [email protected] > Subject: Re: [Opensim-dev] MySQL 8.0 Anyone? > Message-ID: <p06240833de6a06211866@[192.168.0.7]> > Content-Type: text/plain; charset="us-ascii" ; format="flowed" > > At 1:08 PM -0700 3/30/22, Mike Higgins wrote: > > >Has anyone else run OpenSim on MySQL 8.0 on Linux? Do they play well > together? > > Make sure that > > default-authentication-plugin = mysql_native_password > > is in the configuration files chain. Chek it with > > mysql> SHOW VARIABLES LIKE '%authentication%'; > +-------------------------------+-----------------------+ > | Variable_name | Value | > +-------------------------------+-----------------------+ > | authentication_policy | *,, | > | default_authentication_plugin | mysql_native_password | > +-------------------------------+-----------------------+ > 2 rows in set (0.01 sec) > > > I had a Debian update that broke the configuration chain ( /etc/mysql > my.cnf aliased to /etc/alternatives/my.cnf, itself pointing back to > mariadb.cnf). > > > -- Jeff > > > ------------------------------ > > _______________________________________________ > Opensim-dev mailing list > [email protected] > http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev > > > End of Opensim-dev Digest, Vol 78, Issue 5 > ****************************************** > _______________________________________________ Opensim-dev mailing list [email protected] http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev
