[Opensim-dev] Opensim-dev Digest, Vol 78, Issue 5

Thu Mar 31 12:52:32 UTC 2022

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 , <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. MySQL 8.0 Anyone? (Mike Higgins)
>    2. Re: MySQL 8.0 Anyone? (Melanie)
>    3. Re: MySQL 8.0 Anyone? (mike.dickson at utopiaskye.com)
>    4. Re: MySQL 8.0 Anyone? (Jeff Kelley)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 30 Mar 2022 13:08:01 -0700
> From: Mike Higgins <Mike at Kayaker.net>
> To: opensim-dev at opensimulator.org
> Subject: [Opensim-dev] MySQL 8.0 Anyone?
> Message-ID: <33963a58-26ce-935d-c34c-ad399143e8d7 at Kayaker.net>
> 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 <melanie at t-data.com>
> To: "opensim-dev" <opensim-dev at opensimulator.org>
> Subject: Re: [Opensim-dev] MySQL 8.0 Anyone?
> Message-ID:
>         <17fdc8f70f1.d654c2e21047227.7053327809596581436 at t-data.com>
> 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 <Mike at Kayaker.net>
> 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:Opensim-dev at opensimulator.org
> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev
>
> ------------------------------
>
> Message: 3
> Date: Wed, 30 Mar 2022 16:43:22 -0400
> From: <mike.dickson at utopiaskye.com>
> To: <opensim-dev at opensimulator.org>
> Subject: Re: [Opensim-dev] MySQL 8.0 Anyone?
> Message-ID: <077e01d84476$cbf5e870$63e1b950$@utopiaskye.com>
> 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: opensim-dev-bounces at opensimulator.org
> <opensim-dev-bounces at opensimulator.org> On Behalf Of Melanie
> Sent: Wednesday, March 30, 2022 4:41 PM
> To: opensim-dev <opensim-dev at opensimulator.org>
> 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 <Mike at Kayaker.net>
> 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:Opensim-dev at opensimulator.org
> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at opensimulator.org
> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev
>
>
>
> ------------------------------
>
> Message: 4
> Date: Wed, 30 Mar 2022 14:12:34 +0100
> From: Jeff Kelley <opensim at pescadoo.net>
> To: opensim-dev at opensimulator.org
> 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
> Opensim-dev at opensimulator.org
> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev
>
>
> End of Opensim-dev Digest, Vol 78, Issue 5
> ******************************************
>