[Opensim-users] Fresh standalone install wants table.GridUser

[Jeff Kelley]

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.