Re: Fresh standalone install wants table.GridUser (Fred Beckhusen)

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Re: Fresh standalone install wants table.GridUser (Fred Beckhusen)

Fred Beckhusen

For mysql, this works to set UTF-8 so no changes are needed to the
create database commands.  Perhaps it is relevant to Mariadb?

in My.ini:

[mysqld]
character-set-server=utf8

regards:

Fred Beckhusen
[hidden email]


On 2019-01

> Today's Topics:
>
>     1. Re: General voice issue (Jeff Kelley)
>     2. Re: Fresh standalone install wants table.GridUser (Peter Petroff)
>     3. Re: Fresh standalone install wants table.GridUser (Jeff Kelley)
>
>
> ----------------------------------------------------------------------
>
>
> Message: 3
> Date: Thu, 24 Jan 2019 09:31:19 +0100
> From: Jeff Kelley<[hidden email]>
> To:[hidden email]
> Subject: Re: [Opensim-users] Fresh standalone install wants
> table.GridUser
> Message-ID:<p06240818d86f2762d0f0@[192.168.0.7]>
> Content-Type: text/plain; charset="us-ascii" ; format="flowed"
>
> 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
> [hidden email]
> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
>
>
> End of Opensim-users Digest, Vol 56, Issue 22
> *********************************************
_______________________________________________
Opensim-users mailing list
[hidden email]
http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users