[Opensim-users] Ubuntu 19.10 upgrade broke my mysql access to opensimulator

[Drang Po]

@ Teravus Ovares teravus at gmail.com
" The new versions of mysql use sha2 by default.  Old plugins don't support
it.   That said, you can switch back to the old authentication method
per-user in mysql with a command"

what's the command?  or a webpage that gives it etc... thanks in advance

On Sun, Dec 8, 2019 at 1:14 AM Teravus Ovares <teravus at gmail.com> wrote:

> I have also dealt with this with work phone systems.   The trick is
> changing the authentication method for your users on your mysql server.
>  The new versions of mysql use sha2 by default.  Old plugins don't support
> it.   That said, you can switch back to the old authentication method
> per-user in mysql with a command
>
> On Sat, Dec 7, 2019 at 9:10 PM Dahlia Trimble <dahliatrimble at gmail.com>
> wrote:
>
> > I don't think the mysql connector is compatible with mysql 8. I had the
> > same problem and I had to use 5.7.27
> >
> > On Sat, Dec 7, 2019 at 7:19 PM Clint Ellis <rcellis at protonmail.com>
> wrote:
> >
> > > I am getting an error complaining that
> > > "MySql.Data.MySqlClient.MySqlException: Authentication method
> > > 'caching_sha2_password' not supported by any of the available plugins"
> > > Running MySQL 8.0, and Opensim 0.9.0 as well as OpenSim 0.9.1.  Both
> > throw
> > > the same error.
> > > Any ideas what is going on?
> > >
> > > RC
> > > _______________________________________________
> > > Opensim-users mailing list
> > > 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
> >
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at opensimulator.org
> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
>


-- 
Kalasiddhi Grid Co-Coordinator

HG: kalasiddhigrid.com:8002
Web: http://www.kalasiddhigrid.com
Buddhism in Virtual Reality

Drang Po