At 1:10 PM +1000 1/24/19, Peter Petroff wrote:
I'm afraid it doesn't seem to help; that seems to be about a plugin
failing to load and its failure crashing other things.
https://forum.metrogrid.de/discussion/4848/mysql-issue-when-running-simulator-on-debian
Quote.
One issue I'm aware of with Diva and MariaDB (default mysql on Debian
9) is a missing GridUser table.
The problem is, that MariaDB uses the utf8mb4 character set per
default when you create the table, but the table has been designed
for the utf8 character set which uses less bytes. while utf8 needs
one to three bytes per character, utf8mb4 needs 4 bytes per character.
Given the defined length of 255 characters for the UserID, which is
the primary key, this results in more than the maximum length of 767
bytes for the primary key when used with the utf8mb4 character set.
The solution is simple: create the database with utf8 as the default
character set.
MariaDB [(none)]> create database opensim character set = 'utf8'
collate = 'utf8_general_ci';
End quote.
_______________________________________________
Opensim-users mailing list
[email protected]
http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
