16.11.2021, 17:57
Probleme bei der Erstellung von Gruppen können bei fehlenden Tabellen innerhalb der Datenbank auftreten.
Fehlende Datenbanktabellen für OpenSim (Gruppenfunktion) manuell nachinstallieren.
Folgende Tabellen manuell hinzufügen:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 25
Server version: 8.0.27-0ubuntu0.20.04.1 (Ubuntu)
Copyright © 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema
| mysql
| onmaus1 - Datenbank
| mausi2
| erna3
| performance_schema
| sys
+--------------------+
7 rows in set (0.01 sec)
mysql> use onmaus1;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> SHOW TABLES;
+-------------------+
| Tables_in_onmaus1 |
+-------------------+
| Avatars
| Friends
| GridUser
| Presence
| UserAccounts
| assets
| auth
| bakedterrain
| classifieds
| estate_groups
| estate_managers
| estate_map
| estate_settings
| estate_users
| estateban
| hg_traveling_data
| im_offline
| inventoryfolders
| inventoryitems
| land
| landaccesslist
| migrations <-------------------------SELECT * FROM
| primitems
| prims
| primshapes
| regionban
| regionenvironment
| regionextra
| regions
| regionsettings
| regionwindlight
| spawn_points
| terrain
| tokens
| userdata
| usernotes
| userpicks
| userprofile
| usersettings
+-------------------+
39 rows in set (0.00 sec)
mysql> select * from migrations;
+-----------------+---------+
| name | version |
+-----------------+---------+
| migrations 1
| RegionStore 58
| EstateStore 35
| IM_Store 5
| UserAccount 6
| GridStore 10
| AssetStore 10
| AuthStore 4
| GridUserStore 2
| InventoryStore 7
| Avatar 3
| Presence 4
| os_groups_Store 3
| UserProfiles 5
| HGTravelStore 2
| FriendsStore 4
+-----------------+---------+
16 rows in set (0.00 sec)
Tabellen anlegen:
mysql> CREATE TABLE `os_groups_groups` (
-> `GroupID` char(36) NOT NULL default '',
-> `Location` varchar(255) NOT NULL default '',
-> `Name` varchar(255) CHARACTER SET utf8 NOT NULL default '',
-> `Charter` text CHARACTER SET utf8 NOT NULL,
-> `InsigniaID` char(36) NOT NULL default '',
-> `FounderID` char(36) NOT NULL default '',
-> `MembershipFee` int(11) NOT NULL default '0',
-> `OpenEnrollment` varchar(255) NOT NULL default '',
-> `ShowInList` int(4) NOT NULL default '0',
-> `AllowPublish` int(4) NOT NULL default '0',
-> `MaturePublish` int(4) NOT NULL default '0',
-> `OwnerRoleID` char(36) NOT NULL default '',
-> PRIMARY KEY (`GroupID`),
-> UNIQUE KEY `Name` (`Name`),
-> FULLTEXT KEY `Name_2` (`Name`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected, 6 warnings (4.52 sec)
mysql> CREATE TABLE `os_groups_membership` (
-> `GroupID`char(36) NOT NULL default '',
-> `PrincipalID` VARCHAR(255) NOT NULL default '',
-> `SelectedRoleID` char(36) NOT NULL default '',
-> `Contribution` int(11) NOT NULL default '0',
-> `ListInProfile` int(4) NOT NULL default '1',
-> `AcceptNotices` int(4) NOT NULL default '1',
-> `AccessToken` char(36) NOT NULL default '',
-> PRIMARY KEY (`GroupID`,`PrincipalID`),
-> KEY `PrincipalID` (`PrincipalID`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected, 3 warnings (1.21 sec)
mysql> CREATE TABLE `os_groups_roles` (
-> `GroupID` char(36) NOT NULL default '',
-> `RoleID` char(36) NOT NULL default '',
-> `Name` varchar(255) CHARACTER SET utf8 NOT NULL default '',
-> `Description` varchar(255) CHARACTER SET utf8 NOT NULL default '',
-> `Title` varchar(255) CHARACTER SET utf8 NOT NULL default '',
-> `Powers` bigint(20) unsigned NOT NULL default '0',
-> PRIMARY KEY (`GroupID`,`RoleID`),
-> KEY `GroupID` (`GroupID`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected, 4 warnings (1.19 sec)
mysql> CREATE TABLE `os_groups_rolemembership` (
-> `GroupID` char(36) NOT NULL default '',
-> `RoleID` char(36) NOT NULL default '',
-> `PrincipalID` VARCHAR(255) NOT NULL default '',
-> PRIMARY KEY (`GroupID`,`RoleID`,`PrincipalID`),
-> KEY `PrincipalID` (`PrincipalID`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (1.17 sec)
mysql> CREATE TABLE `os_groups_invites` (
-> `InviteID` char(36) NOT NULL default '',
-> `GroupID` char(36) NOT NULL default '',
-> `RoleID` char(36) NOT NULL default '',
-> `PrincipalID` VARCHAR(255) NOT NULL default '',
-> `TMStamp` timestamp NOT NULL,
-> PRIMARY KEY (`InviteID`),
-> UNIQUE KEY `PrincipalGroup` (`GroupID`,`PrincipalID`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (1.11 sec)
mysql> CREATE TABLE `os_groups_notices` (
-> `GroupID` char(36) NOT NULL default '',
-> `NoticeID` char(36) NOT NULL default '',
-> `TMStamp` int(10) unsigned NOT NULL default '0',
-> `FromName` varchar(255) NOT NULL default '',
-> `Subject` varchar(255) CHARACTER SET utf8 NOT NULL default '',
-> `Message` text CHARACTER SET utf8 NOT NULL,
-> `HasAttachment` int(4) NOT NULL default '0',
-> `AttachmentType` int(4) NOT NULL default '0',
-> `AttachmentName` varchar(128) NOT NULL default '',
-> `AttachmentItemID` char(36) NOT NULL default '',
-> `AttachmentOwnerID` varchar(255) NOT NULL default '',
-> PRIMARY KEY (`NoticeID`),
-> KEY `GroupID` (`GroupID`),
-> KEY `TMStamp` (`TMStamp`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected, 5 warnings (0.98 sec)
mysql> CREATE TABLE `os_groups_principals` (
-> `PrincipalID` VARCHAR(255) NOT NULL default '',
-> `ActiveGroupID` char(36) NOT NULL default '',
-> PRIMARY KEY (`PrincipalID`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (1.03 sec)
mysql> ALTER TABLE `os_groups_invites`
->
-> MODIFY `TMStamp` timestamp NOT NULL default CURRENT_TIMESTAMP;
Query OK, 0 rows affected (0.14 sec)
Records: 0 Duplicates: 0 Warnings: 0
Kontrolle:
mysql> show tables;
+--------------------------+
| Tables_in_onmaus1 |
+--------------------------+
| Avatars |
| Friends |
| GridUser |
| Presence |
| UserAccounts |
| assets |
| auth |
| bakedterrain |
| classifieds |
| estate_groups |
| estate_managers |
| estate_map |
| estate_settings |
| estate_users |
| estateban |
| hg_traveling_data |
| im_offline |
| inventoryfolders |
| inventoryitems |
| land |
| landaccesslist |
| migrations |
| os_groups_groups |
| os_groups_invites |
| os_groups_membership |
| os_groups_notices |
| os_groups_principals |
| os_groups_rolemembership |
| os_groups_roles |
| primitems |
| prims |
| primshapes |
| regionban |
| regionenvironment |
| regionextra |
| regions |
| regionsettings |
| regionwindlight |
| spawn_points |
| terrain |
| tokens |
| userdata |
| usernotes |
| userpicks |
| userprofile |
| usersettings |
+--------------------------+
46 rows in set (0.01 sec)
mysql> exit
Bye
Fehlende Datenbanktabellen für OpenSim (Gruppenfunktion) manuell nachinstallieren.
Folgende Tabellen manuell hinzufügen:
- CREATE TABLE os_groups_groups
- CREATE TABLE os_groups_membership
- CREATE TABLE os_groups_roles
- CREATE TABLE os_groups_rolemembership
- CREATE TABLE os_groups_invites
- CREATE TABLE os_groups_notices
- CREATE TABLE os_groups_principals
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 25
Server version: 8.0.27-0ubuntu0.20.04.1 (Ubuntu)
Copyright © 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema
| mysql
| onmaus1 - Datenbank
| mausi2
| erna3
| performance_schema
| sys
+--------------------+
7 rows in set (0.01 sec)
mysql> use onmaus1;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> SHOW TABLES;
+-------------------+
| Tables_in_onmaus1 |
+-------------------+
| Avatars
| Friends
| GridUser
| Presence
| UserAccounts
| assets
| auth
| bakedterrain
| classifieds
| estate_groups
| estate_managers
| estate_map
| estate_settings
| estate_users
| estateban
| hg_traveling_data
| im_offline
| inventoryfolders
| inventoryitems
| land
| landaccesslist
| migrations <-------------------------SELECT * FROM
| primitems
| prims
| primshapes
| regionban
| regionenvironment
| regionextra
| regions
| regionsettings
| regionwindlight
| spawn_points
| terrain
| tokens
| userdata
| usernotes
| userpicks
| userprofile
| usersettings
+-------------------+
39 rows in set (0.00 sec)
mysql> select * from migrations;
+-----------------+---------+
| name | version |
+-----------------+---------+
| migrations 1
| RegionStore 58
| EstateStore 35
| IM_Store 5
| UserAccount 6
| GridStore 10
| AssetStore 10
| AuthStore 4
| GridUserStore 2
| InventoryStore 7
| Avatar 3
| Presence 4
| os_groups_Store 3
| UserProfiles 5
| HGTravelStore 2
| FriendsStore 4
+-----------------+---------+
16 rows in set (0.00 sec)
Tabellen anlegen:
mysql> CREATE TABLE `os_groups_groups` (
-> `GroupID` char(36) NOT NULL default '',
-> `Location` varchar(255) NOT NULL default '',
-> `Name` varchar(255) CHARACTER SET utf8 NOT NULL default '',
-> `Charter` text CHARACTER SET utf8 NOT NULL,
-> `InsigniaID` char(36) NOT NULL default '',
-> `FounderID` char(36) NOT NULL default '',
-> `MembershipFee` int(11) NOT NULL default '0',
-> `OpenEnrollment` varchar(255) NOT NULL default '',
-> `ShowInList` int(4) NOT NULL default '0',
-> `AllowPublish` int(4) NOT NULL default '0',
-> `MaturePublish` int(4) NOT NULL default '0',
-> `OwnerRoleID` char(36) NOT NULL default '',
-> PRIMARY KEY (`GroupID`),
-> UNIQUE KEY `Name` (`Name`),
-> FULLTEXT KEY `Name_2` (`Name`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected, 6 warnings (4.52 sec)
mysql> CREATE TABLE `os_groups_membership` (
-> `GroupID`char(36) NOT NULL default '',
-> `PrincipalID` VARCHAR(255) NOT NULL default '',
-> `SelectedRoleID` char(36) NOT NULL default '',
-> `Contribution` int(11) NOT NULL default '0',
-> `ListInProfile` int(4) NOT NULL default '1',
-> `AcceptNotices` int(4) NOT NULL default '1',
-> `AccessToken` char(36) NOT NULL default '',
-> PRIMARY KEY (`GroupID`,`PrincipalID`),
-> KEY `PrincipalID` (`PrincipalID`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected, 3 warnings (1.21 sec)
mysql> CREATE TABLE `os_groups_roles` (
-> `GroupID` char(36) NOT NULL default '',
-> `RoleID` char(36) NOT NULL default '',
-> `Name` varchar(255) CHARACTER SET utf8 NOT NULL default '',
-> `Description` varchar(255) CHARACTER SET utf8 NOT NULL default '',
-> `Title` varchar(255) CHARACTER SET utf8 NOT NULL default '',
-> `Powers` bigint(20) unsigned NOT NULL default '0',
-> PRIMARY KEY (`GroupID`,`RoleID`),
-> KEY `GroupID` (`GroupID`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected, 4 warnings (1.19 sec)
mysql> CREATE TABLE `os_groups_rolemembership` (
-> `GroupID` char(36) NOT NULL default '',
-> `RoleID` char(36) NOT NULL default '',
-> `PrincipalID` VARCHAR(255) NOT NULL default '',
-> PRIMARY KEY (`GroupID`,`RoleID`,`PrincipalID`),
-> KEY `PrincipalID` (`PrincipalID`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (1.17 sec)
mysql> CREATE TABLE `os_groups_invites` (
-> `InviteID` char(36) NOT NULL default '',
-> `GroupID` char(36) NOT NULL default '',
-> `RoleID` char(36) NOT NULL default '',
-> `PrincipalID` VARCHAR(255) NOT NULL default '',
-> `TMStamp` timestamp NOT NULL,
-> PRIMARY KEY (`InviteID`),
-> UNIQUE KEY `PrincipalGroup` (`GroupID`,`PrincipalID`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (1.11 sec)
mysql> CREATE TABLE `os_groups_notices` (
-> `GroupID` char(36) NOT NULL default '',
-> `NoticeID` char(36) NOT NULL default '',
-> `TMStamp` int(10) unsigned NOT NULL default '0',
-> `FromName` varchar(255) NOT NULL default '',
-> `Subject` varchar(255) CHARACTER SET utf8 NOT NULL default '',
-> `Message` text CHARACTER SET utf8 NOT NULL,
-> `HasAttachment` int(4) NOT NULL default '0',
-> `AttachmentType` int(4) NOT NULL default '0',
-> `AttachmentName` varchar(128) NOT NULL default '',
-> `AttachmentItemID` char(36) NOT NULL default '',
-> `AttachmentOwnerID` varchar(255) NOT NULL default '',
-> PRIMARY KEY (`NoticeID`),
-> KEY `GroupID` (`GroupID`),
-> KEY `TMStamp` (`TMStamp`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected, 5 warnings (0.98 sec)
mysql> CREATE TABLE `os_groups_principals` (
-> `PrincipalID` VARCHAR(255) NOT NULL default '',
-> `ActiveGroupID` char(36) NOT NULL default '',
-> PRIMARY KEY (`PrincipalID`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (1.03 sec)
mysql> ALTER TABLE `os_groups_invites`
->
-> MODIFY `TMStamp` timestamp NOT NULL default CURRENT_TIMESTAMP;
Query OK, 0 rows affected (0.14 sec)
Records: 0 Duplicates: 0 Warnings: 0
Kontrolle:
mysql> show tables;
+--------------------------+
| Tables_in_onmaus1 |
+--------------------------+
| Avatars |
| Friends |
| GridUser |
| Presence |
| UserAccounts |
| assets |
| auth |
| bakedterrain |
| classifieds |
| estate_groups |
| estate_managers |
| estate_map |
| estate_settings |
| estate_users |
| estateban |
| hg_traveling_data |
| im_offline |
| inventoryfolders |
| inventoryitems |
| land |
| landaccesslist |
| migrations |
| os_groups_groups |
| os_groups_invites |
| os_groups_membership |
| os_groups_notices |
| os_groups_principals |
| os_groups_rolemembership |
| os_groups_roles |
| primitems |
| prims |
| primshapes |
| regionban |
| regionenvironment |
| regionextra |
| regions |
| regionsettings |
| regionwindlight |
| spawn_points |
| terrain |
| tokens |
| userdata |
| usernotes |
| userpicks |
| userprofile |
| usersettings |
+--------------------------+
46 rows in set (0.01 sec)
mysql> exit
Bye