Change font size
It is currently Thu Dec 03, 2020 2:33 am

Forum rules


{L_IMAGE}
. please keep questions related to an OpenSimulator and OSgrid nature.



Post a new topicPost a reply Page 1 of 1   [ 7 posts ]
Author Message
 Post subject: Linux Mint update
PostPosted: Thu Jul 16, 2020 4:47 pm 
OSG Elite
User avatar

Joined: Thu Aug 06, 2009 7:07 am
Posts: 372
Location: B.C. Canada
This morning I updated Linux Mint to Linux Mint 20 Ulyana. Ever since, OpenSim can't open MySQL.
The error I get is
2020-07-16 14:26:31,123 ERROR - OpenSim.Services.Base.ServiceBase [SERVICE BASE]: Failed to load plugin OpenSim.Region.Framework.Interfaces.ISimulationDataStore from OpenSim.Data.MySQL.dll with args Data
Source=localhost;Database=****;User ID=****;Password=****;Old Guids=true;
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Security.Authentication.AuthenticationException: Authentication failed, see inner exception. --->
Mono.Btls.MonoBtlsException: Ssl error:1000042e:SSL routines:OPENSSL_internal:TLSV1_ALERT_PROTOCOL_VERSION
at /build/mono-6.10.0.104/external/boringssl/ssl/tls_record.c:462
at Mono.Btls.MonoBtlsContext.ProcessHandshake () [0x00048] in <4e15bbae9d7043d8afd6cfd50bd9bd5a>:0
at Mono.Net.Security.MobileAuthenticatedStream.ProcessHandshake (Mono.Net.Security.AsyncOperationStatus status, System.Boolean renegotiate) [0x000da] in <4e15bbae9d7043d8afd6cfd50bd9bd5a>:0
at (wrapper remoting-invoke-with-check) Mono.Net.Security.MobileAuthenticatedStream.ProcessHandshake(Mono.Net.Security.AsyncOperationStatus,bool)
at Mono.Net.Security.AsyncHandshakeRequest.Run (Mono.Net.Security.AsyncOperationStatus status) [0x00006] in <4e15bbae9d7043d8afd6cfd50bd9bd5a>:0
at Mono.Net.Security.AsyncProtocolRequest.ProcessOperation (System.Threading.CancellationToken cancellationToken) [0x000fc] in <4e15bbae9d7043d8afd6cfd50bd9bd5a>:0
--- End of inner exception stack trace ---

and on it goes.
What I did notice, is that mysql> \s gives

mysql> \s
--------------
mysql Ver 8.0.20-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))

Connection id: 8
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 8.0.20-0ubuntu0.20.04.1 (Ubuntu)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb4
Conn. characterset: utf8mb4
UNIX socket: /var/run/mysqld/mysqld.sock
Binary data as: Hexadecimal
Uptime: 4 min 5 sec

Threads: 2 Questions: 5 Slow queries: 0 Opens: 115 Flush tables: 3 Open tables: 36 Queries per second avg: 0.020
=====================
My old machine, that I am using now for osgrid, says mysql Ver 14.14 Distrib 5.7.30 for Linux. Server and Db characterset are latin1, Client and Conn characterset are utf8.
No mention of utf8mb4.
I have no idea what it was before the update.


Top
 Profile  
 
 Post subject: Re: Linux Mint update
PostPosted: Thu Jul 16, 2020 5:17 pm 
OSG Elite
User avatar

Joined: Thu Aug 06, 2009 7:07 am
Posts: 372
Location: B.C. Canada
Looks like I found my answer on opensimulator.org
MySQL must be configured to use UTF8 as its default character set.


Top
 Profile  
 
 Post subject: Re: Linux Mint update
PostPosted: Fri Jul 17, 2020 7:11 am 
OSG Elite
User avatar

Joined: Thu Aug 06, 2009 7:07 am
Posts: 372
Location: B.C. Canada
I put
[mysqld]
character-set-server=utf8
[client]
default-character-set=utf8

in my.cnf as suggested on the wiki page, but still won't start.


Top
 Profile  
 
 Post subject: Re: Linux Mint update
PostPosted: Fri Jul 17, 2020 9:16 pm 
OSG Elite
User avatar

Joined: Thu Aug 06, 2009 7:07 am
Posts: 372
Location: B.C. Canada
Got it. I installed MariaDB, created new databases then loaded the sql database dumps I made before the Mint upgrade. So far, so good. I would think mysql would have worked too but for some reason it didn't. I probably missed something and I'm not going through it again to find out.
Maybe when, or if, I upgrade my other linux machine. :P


Top
 Profile  
 
 Post subject: Re: Linux Mint update
PostPosted: Thu Nov 19, 2020 1:05 am 

Joined: Thu Nov 19, 2020 1:01 am
Posts: 2
works for me for opensim 0.910 and 0.911 on ubuntu 20.04 and mysql 8.xx
change mysql settings:
sudo gedit /etc/mysql/my.cnf

add
[mysqld]
ssl=0
default-authentication-plugin=mysql_native_password
save and quit
restart linux
delete user for opensim database
create user for opensim database, authentication-plugin mysql_native_password


Top
 Profile  
 
 Post subject: Re: Linux Mint update
PostPosted: Thu Nov 19, 2020 2:35 am 

Joined: Thu Nov 19, 2020 1:01 am
Posts: 2
.. check mysql settings:

sudo mysql -u root -p
[sudo] password for ******:
Enter password:

mysql> SELECT plugin from mysql.user where User='your opensim user';
+-----------------------+
| plugin |
+-----------------------+
| mysql_native_password |
+-----------------------+
1 row in set (0.00 sec)

mysql> show variables like 'default_authentication_plugin';
+-------------------------------+-----------------------+
| Variable_name | Value |
+-------------------------------+-----------------------+
| default_authentication_plugin | mysql_native_password |
+-------------------------------+-----------------------+
1 row in set (0.05 sec)

mysql> show variables like '%ssl%';
+-------------------------------------+----------+
| Variable_name | Value |
+-------------------------------------+----------+
| admin_ssl_ca | |
| admin_ssl_capath | |
| admin_ssl_cert | |
| admin_ssl_cipher | |
| admin_ssl_crl | |
| admin_ssl_crlpath | |
| admin_ssl_key | |
| have_openssl | DISABLED |
| have_ssl | DISABLED |
| mysqlx_ssl_ca | |
| mysqlx_ssl_capath | |
| mysqlx_ssl_cert | |
| mysqlx_ssl_cipher | |
| mysqlx_ssl_crl | |
| mysqlx_ssl_crlpath | |
| mysqlx_ssl_key | |
| performance_schema_show_processlist | OFF |
| ssl_ca | |
| ssl_capath | |
| ssl_cert | |
| ssl_cipher | |
| ssl_crl | |
| ssl_crlpath | |
| ssl_fips_mode | OFF |
| ssl_key | |
+-------------------------------------+----------+
25 rows in set (0.01 sec)

mysql> quit


Top
 Profile  
 
 Post subject: Re: Linux Mint update
PostPosted: Thu Nov 19, 2020 8:15 am 
OSG Elite
User avatar

Joined: Thu Aug 06, 2009 7:07 am
Posts: 372
Location: B.C. Canada
It's working for me too now. I don't remember what I did, but something is working


Top
 Profile  
 
Display posts from previous:  Sort by  
Post a new topicPost a reply Page 1 of 1   [ 7 posts ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron


Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
610nm Style by Daniel St. Jules of Gamexe.net