MantisBT - opensim
View Issue Details
0008298opensim[GRID] User Servicepublic2018-02-23 13:122019-02-05 12:27
TyphaineArtez 
TyphaineArtez 
highblockalways
closedno change required 
0.9.0 
 
Standalone (1 Region)
BulletSim
Mono / Linux64
Other
Not applicable
0008298: Some tables are not created in MySQL storage configuration
I am on Linux, with MariaDB (10.1.31)
I create a brand new opensim 0.9 instance, configure as StandaloneHypergrid.

First launch, tables creation and migration going on for most tables, but refuses to create GridUser (see log fragment: https://pastebin.com/ePTBeX8T [^]).

I could get the sql to inject to create it, but then I also have the same issue with group related tables.

unzip opensim 0.9
configure it to use MySQL (with valid database and user)
Joined file is a snapshot of phpmyadmin, showing the number of tables created after OpenSim being up and running
No tags attached.
png imgur-2018_02_23-22:09:55.png (7,881) 2018-02-23 13:12
http://opensimulator.org/mantis/file_download.php?file_id=4718&type=bug
png
Issue History
2018-02-23 13:12TyphaineArtezNew Issue
2018-02-23 13:12TyphaineArtezFile Added: imgur-2018_02_23-22:09:55.png
2018-02-23 14:52UbitUmarovNote Added: 0032559
2018-02-23 15:02TyphaineArtezNote Added: 0032560
2018-02-23 15:04TyphaineArtezResolutionopen => no change required
2019-01-22 00:19TyphaineArtezNote Added: 0033902
2019-01-22 00:19TyphaineArtezStatusnew => resolved
2019-01-22 00:19TyphaineArtezAssigned To => TyphaineArtez
2019-02-05 12:27BillBlightNote Added: 0034310
2019-02-05 12:27BillBlightStatusresolved => closed

Notes
(0032559)
UbitUmarov   
2018-02-23 14:52   
try set mariadb default character to utf8 or utf8mb3 and not uft8mb4
(0032560)
TyphaineArtez   
2018-02-23 15:02   
database charset changed to utf8_general_ci, the table could be created.

Fixed, thank you
(0033902)
TyphaineArtez   
2019-01-22 00:19   
Set mariadb default character set to utf8 or utf8mb3 and not uft8mb4
(0034310)
BillBlight   
2019-02-05 12:27   
Old Issues, closed, can be reopened if they still exist