V2 Groups

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
(added comparison between Flotsam and jOpenSim tables)
(→‎Services)
 
(38 intermediate revisions by 8 users not shown)
Line 1: Line 1:
−
As of OpenSimulator 0.7.6 Diva implemented the V2 Groups, which are now part of OpenSimulator core. Using the new groups do not need to use any third Party modules any more.
+
{{Quicklinks}}
  
−
The below script helps, converting exsisting Flotsam Groups or jOpenSim Groups (which uses Flotsam anyway) to the new Groups. This ensures, that you dont loose any Group Information, when you want to Switch over.
+
=Introduction=
 +
As of OpenSimulator 0.7.6, OpenSimulator has shipped with a core groups service. This can be used instead of the XmlRpcGroups/Flotsam third party service, though this will remain supported.
  
−
Differences between jOpenSim and Flotsam (the table names):
+
Please be aware that this facility is new.  It may contain bugs or have as yet unknown issues with scaling to large grids.  This facility is currently not enabled by default.
  
−
jos_opensim_groupactive = osagent
+
=Configuration=
−
jos_opensim_group = osgroup
+
−
jos_opensim_groupinvite =osgroupinvite
+
−
jos_opensim_groupmembership = osgroupmembership
+
−
jos_opensim_groupnotice = osgroupnotice
+
−
jos_opensim_grouprolemembership = osgrouprolemembership
+
−
jos_opensim_grouprole = osrole
+
  
−
The Script (Replace ROBUSTDB with your ROBUST database and FLOTSAMDB with your database, containing your jOpenSim or your Flotsam tables!):
+
==Standalone==
  
−
<pre>
+
In OpenSim.ini, the following settings are required in Hypergrid and non-Hypergrid modes. This also generates the groups table in the database used for your Standalone installation.
 +
 
 +
<source lang="ini">
 +
[Groups]
 +
  Enabled = true
 +
  Module = "Groups Module V2"
 +
  MessagingModule = "Groups Messaging Module V2"
 +
</source>
 +
 
 +
For a non-Hypergrid installation, you will also want to specify the services connector as
 +
 
 +
<source lang="ini">
 +
[Groups]
 +
  ServicesConnectorModule = "Groups Local Service Connector"
 +
</source>
 +
 
 +
On a Hypergrid installation, you will want to instead specify it as
 +
 
 +
<source lang="ini">
 +
[Groups]
 +
  ServicesConnectorModule = "Groups HG Service Connector"
 +
</source>
 +
 
 +
On a Hypergrid installation, you will need to make the following additional settings.
 +
 
 +
<source lang="ini">
 +
[Groups]
 +
  LocalService = local
 +
  ;HomeURI = http://example.com:8002
 +
  ; or
 +
  HomeURI = "${Const|BaseURL}:${Const|PublicPort}"
 +
</source>
 +
 
 +
==Grid==
 +
 
 +
To enable core groups for a grid, one needs to configure each simulators OpenSim.ini and enable the ROBUST services.
 +
 
 +
===Simulator===
 +
 
 +
In OpenSim.ini, the following settings are required in Hypergrid and non-Hypergrid modes. This also generates the groups table in your ROBUST database.
 +
 
 +
<source lang="ini">
 +
[Groups]
 +
  Enabled = true
 +
  Module = "Groups Module V2"
 +
  ;GroupsServerURI = http://example.com:8003
 +
  ; or
 +
  GroupsServerURI = ${Const|BaseURL}:${Const|PrivatePort}
 +
  MessagingModule = "Groups Messaging Module V2"
 +
</source>
 +
 
 +
For a non-Hypergrid installation, you will also want to specify the services connector as
 +
 
 +
<source lang="ini">
 +
[Groups]
 +
  ServicesConnectorModule = "Groups Remote Service Connector"
 +
</source>
 +
 
 +
On a Hypergrid installation, you will want to instead specify it as
 +
 
 +
<source lang="ini">
 +
[Groups]
 +
  ServicesConnectorModule = "Groups HG Service Connector"
 +
</source>
 +
 
 +
On a Hypergrid installation, you will need to make the following additional settings.
 +
 
 +
<source lang="ini">
 +
[Groups]
 +
  LocalService = remote
 +
  ;HomeURI = http://example.com:8002
 +
  ; or
 +
  HomeURI = "${Const|BaseURL}:${Const|PublicPort}"
 +
</source>
 +
 
 +
===Services===
 +
In Robust.ini, you need to enable the core groups service.
 +
 
 +
<source lang="ini">
 +
[ServiceList]
 +
  ;GroupsServiceConnector = "8003/OpenSim.Addons.Groups.dll:GroupsServiceRobustConnector"
 +
  ; or
 +
  GroupsServiceConnector = "${Const|PrivatePort}/OpenSim.Addons.Groups.dll:GroupsServiceRobustConnector"
 +
</source>
 +
 
 +
=Migration=
 +
 
 +
The script below aims to help convert existing Flotsam Groups or jOpenSim Groups (which uses Flotsam anyway) database tables to the new core group tables.
 +
 
 +
== Differences between tables names ==
 +
{|class="wikitable"
 +
! jOpenSim
 +
! Flotsam
 +
! V2
 +
|-
 +
|jos_opensim_groupactive
 +
|osagent
 +
* AgentID
 +
* ActiveGroupID
 +
|os_groups_principals
 +
* PrincipalID
 +
* ActiveGroupID
 +
|-
 +
|jos_opensim_group
 +
|osgroup
 +
* GroupID
 +
* Name
 +
* Charter
 +
* InsigniaID
 +
* FounderID
 +
* MemberShipFee
 +
* OpenEnrollment
 +
* ShowInList
 +
* AllowPublish
 +
* MaturePublish
 +
* OwnerRoleID
 +
|os_groups_groups
 +
* GroupID
 +
* Name
 +
* Charter
 +
* InsigniaID
 +
* FounderID
 +
* MembershipFee
 +
* OpenEnrollment
 +
* ShowInList
 +
* AllowPublish
 +
* MaturePublish
 +
* OwnerRoleID
 +
|-
 +
|jos_opensim_groupinvite
 +
|osgroupinvite
 +
* InviteID
 +
* GroupID
 +
* RoleID
 +
* AgentID
 +
* TMStamp
 +
|os_groups_invites
 +
* InviteID
 +
* GroupID
 +
* RoleID
 +
* PrincipalID
 +
* TMStamp
 +
|-
 +
|jos_opensim_groupmembership
 +
|osgroupmembership
 +
* GroupID
 +
* AgentID
 +
* SelectedRoleID
 +
* Contribution
 +
* ListInProfile
 +
* AcceptNotices
 +
|os_groups_membership
 +
* GroupID
 +
* PrincipalID
 +
* SelectedRoleID
 +
* Contribution
 +
* ListInProfile
 +
* AcceptNotices
 +
|-
 +
|jos_opensim_groupnotice
 +
|osgroupnotice
 +
* GroupID
 +
* NoticeID
 +
* Timestamp
 +
* FromName
 +
* Subject
 +
* Message
 +
|os_groups_notices
 +
* GroupID
 +
* NoticeID
 +
* TMStamp
 +
* FromName
 +
* Subject
 +
* Message
 +
|-
 +
|jos_opensim_grouprolemembership
 +
|osgrouprolemembership
 +
* GroupID
 +
* RoleID
 +
* AgentID
 +
|os_groups_rolemembership
 +
* GroupID
 +
* RoleID
 +
* PrincipalID
 +
|-
 +
|jos_opensim_grouprole
 +
|osrole
 +
* GroupID
 +
* RoleID
 +
* Name
 +
* Description
 +
* Title
 +
* Powers
 +
|os_groups_roles
 +
* GroupID
 +
* RoleID
 +
* Name
 +
* Description
 +
* Title
 +
* Powers
 +
|}
 +
 
 +
== Notes ==
 +
 
 +
You do not need to consider the field '''BinaryBucket''' in the flotsam table '''osgroupnotice''' as long as you did not apply the patch attached to [http://opensimulator.org/mantis/view.php?id=6699 Mantis #6699]. If you have applied it, then maybe the following information will help, if you do not want to miss the content in the new tables:
 +
 
 +
Byte offset and description of bucket data:
 +
 
 +
* 0:  1 byte indicating if attachment is present
 +
* 1:  1 byte indicating the type of attachment
 +
* 2:  16 bytes - Group UUID
 +
* 18: 16 bytes - UUID of the attachment owner
 +
* 34: 16 bytes - UUID of the attachment
 +
* 50: variable - Name of the attachment
 +
* ??: NUL byte to terminate the attachment name
 +
 
 +
This information is copied from the original patch and describes the content format of field BinaryBucket.
 +
 
 +
== Flotsam ==
 +
Use this script if your are using the Flotsam groups.
 +
 
 +
The Script (Replace ROBUSTDB with your ROBUST database and FLOTSAMDB with your database, containing your Flotsam tables!):
 +
<source lang=sql>
 +
INSERT INTO `ROBUSTDB`.`os_groups_groups`
 +
(GroupID, Name, Charter, InsigniaID, FounderID, MembershipFee, OpenEnrollment, ShowInList,
 +
AllowPublish, MaturePublish, OwnerRoleID)
 +
SELECT GroupID, Name, Charter, InsigniaID, FounderID, MemberShipFee, OpenEnrollment, ShowInList, AllowPublish,
 +
MaturePublish, OwnerRoleID
 +
FROM `FLOTSAMDB`.osgroup;
 +
 +
/*fill os_groups_invites in ROBUST database with values from osgroupinvite
 +
or FlotSam osgroupinvite*/
 +
INSERT INTO `ROBUSTDB`.`os_groups_invites`
 +
(InviteID, GroupID, RoleID, PrincipalID, TMStamp)
 +
SELECT InviteID, GroupID, RoleID, AgentID, TMStamp
 +
FROM `FLOTSAMDB`.osgroupinvite;
 +
 +
/*fill os_groups_membership in ROBUST database with values from osgroupmembership
 +
or FlotSam osgroupmembership*/
 +
INSERT INTO `ROBUSTDB`.`os_groups_membership`
 +
(GroupID, PrincipalID, SelectedRoleID, Contribution, ListInProfile, AcceptNotices)
 +
SELECT GroupID, AgentID, SelectedRoleID, Contribution, ListInProfile, AcceptNotices
 +
FROM `FLOTSAMDB`.osgroupmembership;
 +
 +
/*fill os_groups_notices in ROBUST database with values from osgroupnotice
 +
or FlotSam osgroupnotice*/
 +
INSERT INTO `ROBUSTDB`.`os_groups_notices`
 +
(GroupID, NoticeID, TMStamp, FromName, Subject, Message)
 +
SELECT GroupID, NoticeID, Timestamp, FromName, Subject, Message
 +
FROM `FLOTSAMDB`.osgroupnotice;
 +
 +
/*fill os_groups_principals in ROBUST database with values from osagent
 +
or FlotSam osagent*/
 +
INSERT INTO `ROBUSTDB`.`os_groups_principals`
 +
(PrincipalID, ActiveGroupID)
 +
SELECT AgentID, ActiveGroupID
 +
FROM `FLOTSAMDB`.osagent;
 +
 +
/*fill os_groups_rolemembership in ROBUST database with values from osrolemembership
 +
or FlotSam osgrouprolemembership*/
 +
INSERT INTO `ROBUSTDB`.os_groups_rolemembership
 +
(GroupID, RoleID, PrincipalID)
 +
SELECT GroupID, RoleID, AgentID
 +
FROM `FLOTSAMDB`.osgrouprolemembership;
 +
 +
/*fill os_groups_roles in ROBUST database with values from osroles
 +
or FlotSam osrole*/
 +
INSERT INTO `ROBUSTDB`.os_groups_roles
 +
(GroupID, RoleID, Name, Description, Title, Powers)
 +
SELECT GroupID, RoleID, Name, Description, Title, Powers
 +
FROM `FLOTSAMDB`.osrole;
 +
 
 +
</source>
 +
 
 +
== jOpenSim ==
 +
Use this script if you are using the jOpenSim groups.
 +
 
 +
The Script (Replace ROBUSTDB with your ROBUST database and FLOTSAMDB with your database, containing your jOpenSim tables!):
 +
 
 +
<source lang=sql>
  
 
/* SQL script to convert group tables from Flotsam Groups (Group database) or jOpenSim (tables in Joomla Database)
 
/* SQL script to convert group tables from Flotsam Groups (Group database) or jOpenSim (tables in Joomla Database)
Line 65: Line 339:
 
/*fill os_groups_rolemembership in ROBUST database with values from jos_opensim_grouprolemembership
 
/*fill os_groups_rolemembership in ROBUST database with values from jos_opensim_grouprolemembership
 
or FlotSam osgrouprolemembership*/
 
or FlotSam osgrouprolemembership*/
−
INSERT INTO opensim_robust_test.os_groups_rolemembership
+
INSERT INTO `ROBUSTDB`.os_groups_rolemembership
 
(GroupID, RoleID, PrincipalID)
 
(GroupID, RoleID, PrincipalID)
 
SELECT GroupID, RoleID, AgentID
 
SELECT GroupID, RoleID, AgentID
Line 72: Line 346:
 
/*fill os_groups_roles in ROBUST database with values from jos_opensim_grouproles
 
/*fill os_groups_roles in ROBUST database with values from jos_opensim_grouproles
 
or FlotSam osrole*/
 
or FlotSam osrole*/
−
INSERT INTO opensim_robust_test.os_groups_roles
+
INSERT INTO `ROBUSTDB`.os_groups_roles
 
(GroupID, RoleID, Name, Description, Title, Powers)
 
(GroupID, RoleID, Name, Description, Title, Powers)
 
SELECT GroupID, RoleID, Name, Description, Title, Powers
 
SELECT GroupID, RoleID, Name, Description, Title, Powers
Line 79: Line 353:
 
/*fill os_groups_roles in ROBUST database with values from jos_opensim_offlinemessages
 
/*fill os_groups_roles in ROBUST database with values from jos_opensim_offlinemessages
 
--> no corresponding table in FlotSam  --  only applies to jOpenSim*/
 
--> no corresponding table in FlotSam  --  only applies to jOpenSim*/
−
INSERT INTO opensim_robust_test.im_offline
+
INSERT INTO `ROBUSTDB`.im_offline
 
(PrincipalID, Message, TMStamp)
 
(PrincipalID, Message, TMStamp)
 
SELECT fromAgentID, Message, sent
 
SELECT fromAgentID, Message, sent
 
FROM `FLOTSAMDB`.jos_opensim_offlinemessages;
 
FROM `FLOTSAMDB`.jos_opensim_offlinemessages;
−
</pre>
+
</source>
 +
 
 +
More informations on [http://wiki.jopensim.com/index.php/migration_from_groups_v2 jOpenSim migration from Groups V2]

Latest revision as of 04:30, 11 March 2021

Languages Languages: 

En.png English   De.png Deutsch   Fr.png Français

Contents

[edit] Introduction

As of OpenSimulator 0.7.6, OpenSimulator has shipped with a core groups service. This can be used instead of the XmlRpcGroups/Flotsam third party service, though this will remain supported.

Please be aware that this facility is new. It may contain bugs or have as yet unknown issues with scaling to large grids. This facility is currently not enabled by default.

[edit] Configuration

[edit] Standalone

In OpenSim.ini, the following settings are required in Hypergrid and non-Hypergrid modes. This also generates the groups table in the database used for your Standalone installation. 

[Groups]
  Enabled = true
  Module = "Groups Module V2"
  MessagingModule = "Groups Messaging Module V2"

For a non-Hypergrid installation, you will also want to specify the services connector as 

[Groups]
  ServicesConnectorModule = "Groups Local Service Connector"

On a Hypergrid installation, you will want to instead specify it as 

[Groups]
  ServicesConnectorModule = "Groups HG Service Connector"

On a Hypergrid installation, you will need to make the following additional settings. 

[Groups]
  LocalService = local
  ;HomeURI = http://example.com:8002
  ; or
  HomeURI = "${Const|BaseURL}:${Const|PublicPort}"

[edit] Grid

To enable core groups for a grid, one needs to configure each simulators OpenSim.ini and enable the ROBUST services.

[edit] Simulator

In OpenSim.ini, the following settings are required in Hypergrid and non-Hypergrid modes. This also generates the groups table in your ROBUST database. 

[Groups]
  Enabled = true
  Module = "Groups Module V2"
  ;GroupsServerURI = http://example.com:8003
  ; or
  GroupsServerURI = ${Const|BaseURL}:${Const|PrivatePort}
  MessagingModule = "Groups Messaging Module V2"

For a non-Hypergrid installation, you will also want to specify the services connector as 

[Groups]
  ServicesConnectorModule = "Groups Remote Service Connector"

On a Hypergrid installation, you will want to instead specify it as 

[Groups]
  ServicesConnectorModule = "Groups HG Service Connector"

On a Hypergrid installation, you will need to make the following additional settings. 

[Groups]
  LocalService = remote
  ;HomeURI = http://example.com:8002
  ; or
  HomeURI = "${Const|BaseURL}:${Const|PublicPort}"

[edit] Services

In Robust.ini, you need to enable the core groups service. 

[ServiceList]
  ;GroupsServiceConnector = "8003/OpenSim.Addons.Groups.dll:GroupsServiceRobustConnector"
  ; or
  GroupsServiceConnector = "${Const|PrivatePort}/OpenSim.Addons.Groups.dll:GroupsServiceRobustConnector"

[edit] Migration

The script below aims to help convert existing Flotsam Groups or jOpenSim Groups (which uses Flotsam anyway) database tables to the new core group tables.

[edit] Differences between tables names

jOpenSim Flotsam V2
jos_opensim_groupactive osagent 
* AgentID
* ActiveGroupID
os_groups_principals 
* PrincipalID
* ActiveGroupID
jos_opensim_group osgroup 
* GroupID
* Name
* Charter
* InsigniaID
* FounderID
* MemberShipFee
* OpenEnrollment
* ShowInList
* AllowPublish
* MaturePublish
* OwnerRoleID
os_groups_groups 
* GroupID
* Name
* Charter
* InsigniaID
* FounderID
* MembershipFee
* OpenEnrollment
* ShowInList
* AllowPublish
* MaturePublish
* OwnerRoleID
jos_opensim_groupinvite osgroupinvite 
* InviteID
* GroupID
* RoleID
* AgentID
* TMStamp
os_groups_invites 
* InviteID
* GroupID
* RoleID
* PrincipalID
* TMStamp
jos_opensim_groupmembership osgroupmembership 
* GroupID
* AgentID
* SelectedRoleID
* Contribution
* ListInProfile
* AcceptNotices
os_groups_membership 
* GroupID
* PrincipalID
* SelectedRoleID
* Contribution
* ListInProfile
* AcceptNotices
jos_opensim_groupnotice osgroupnotice 
* GroupID
* NoticeID
* Timestamp
* FromName
* Subject
* Message
os_groups_notices 
* GroupID
* NoticeID
* TMStamp
* FromName
* Subject
* Message
jos_opensim_grouprolemembership osgrouprolemembership 
* GroupID
* RoleID
* AgentID
os_groups_rolemembership 
* GroupID
* RoleID
* PrincipalID
jos_opensim_grouprole osrole 
* GroupID
* RoleID
* Name
* Description
* Title
* Powers
os_groups_roles 
* GroupID
* RoleID
* Name
* Description
* Title
* Powers

[edit] Notes

You do not need to consider the field BinaryBucket in the flotsam table osgroupnotice as long as you did not apply the patch attached to Mantis #6699. If you have applied it, then maybe the following information will help, if you do not want to miss the content in the new tables:

Byte offset and description of bucket data:

  • 0: 1 byte indicating if attachment is present
  • 1: 1 byte indicating the type of attachment
  • 2: 16 bytes - Group UUID
  • 18: 16 bytes - UUID of the attachment owner
  • 34: 16 bytes - UUID of the attachment
  • 50: variable - Name of the attachment
  •  ??: NUL byte to terminate the attachment name

This information is copied from the original patch and describes the content format of field BinaryBucket.

[edit] Flotsam

Use this script if your are using the Flotsam groups.

The Script (Replace ROBUSTDB with your ROBUST database and FLOTSAMDB with your database, containing your Flotsam tables!): 

INSERT INTO `ROBUSTDB`.`os_groups_groups`
(GroupID, Name, Charter, InsigniaID, FounderID, MembershipFee, OpenEnrollment, ShowInList,
AllowPublish, MaturePublish, OwnerRoleID)
SELECT GroupID, Name, Charter, InsigniaID, FounderID, MemberShipFee, OpenEnrollment, ShowInList, AllowPublish,
MaturePublish, OwnerRoleID
FROM `FLOTSAMDB`.osgroup;
 
/*fill os_groups_invites in ROBUST database with values from osgroupinvite
or FlotSam osgroupinvite*/
INSERT INTO `ROBUSTDB`.`os_groups_invites`
(InviteID, GroupID, RoleID, PrincipalID, TMStamp)
SELECT InviteID, GroupID, RoleID, AgentID, TMStamp
FROM `FLOTSAMDB`.osgroupinvite;
 
/*fill os_groups_membership in ROBUST database with values from osgroupmembership
or FlotSam osgroupmembership*/
INSERT INTO `ROBUSTDB`.`os_groups_membership`
(GroupID, PrincipalID, SelectedRoleID, Contribution, ListInProfile, AcceptNotices)
SELECT GroupID, AgentID, SelectedRoleID, Contribution, ListInProfile, AcceptNotices
FROM `FLOTSAMDB`.osgroupmembership;
 
/*fill os_groups_notices in ROBUST database with values from osgroupnotice
or FlotSam osgroupnotice*/
INSERT INTO `ROBUSTDB`.`os_groups_notices`
(GroupID, NoticeID, TMStamp, FromName, Subject, Message)
SELECT GroupID, NoticeID, Timestamp, FromName, Subject, Message
FROM `FLOTSAMDB`.osgroupnotice;
 
/*fill os_groups_principals in ROBUST database with values from osagent
or FlotSam osagent*/
INSERT INTO `ROBUSTDB`.`os_groups_principals`
(PrincipalID, ActiveGroupID)
SELECT AgentID, ActiveGroupID
FROM `FLOTSAMDB`.osagent;
 
/*fill os_groups_rolemembership in ROBUST database with values from osrolemembership
or FlotSam osgrouprolemembership*/
INSERT INTO `ROBUSTDB`.os_groups_rolemembership
(GroupID, RoleID, PrincipalID)
SELECT GroupID, RoleID, AgentID
FROM `FLOTSAMDB`.osgrouprolemembership;
 
/*fill os_groups_roles in ROBUST database with values from osroles
or FlotSam osrole*/
INSERT INTO `ROBUSTDB`.os_groups_roles
(GroupID, RoleID, Name, Description, Title, Powers)
SELECT GroupID, RoleID, Name, Description, Title, Powers
FROM `FLOTSAMDB`.osrole;

[edit] jOpenSim

Use this script if you are using the jOpenSim groups.

The Script (Replace ROBUSTDB with your ROBUST database and FLOTSAMDB with your database, containing your jOpenSim tables!): 

/* SQL script to convert group tables from Flotsam Groups (Group database) or jOpenSim (tables in Joomla Database)
to new V2 groups, which are part of OpenSimulator core up from 0.7.6 branch*/
 
/* FlotSam Tables latest version from
https://github.com/mcortez/flotsam/tree/master/flotsam/Servers/XmlRpcGroupsServer/
Commit-No.: 18275462c9*/
 
/* jOpenSim Version: 0.2.6.4*/
 
/*fill os_groups_groups in ROBUST database with values from jos_opensim_groups
or FlotSam osgroup*/
INSERT INTO `ROBUSTDB`.`os_groups_groups`
(GroupID, Name, Charter, InsigniaID, FounderID, MembershipFee, OpenEnrollment, ShowInList,
AllowPublish, MaturePublish, OwnerRoleID)
SELECT GroupID, Name, Charter, InsigniaID, FounderID, MemberShipFee, OpenEnrollment, ShowInList, AllowPublish,
MaturePublish, OwnerRoleID
FROM `FLOTSAMDB`.jos_opensim_group;
 
/*fill os_groups_invites in ROBUST database with values from jos_opensim_groupinvite
or FlotSam osgroupinvite*/
INSERT INTO `ROBUSTDB`.`os_groups_invites`
(InviteID, GroupID, RoleID, PrincipalID, TMStamp)
SELECT InviteID, GroupID, RoleID, AgentID, TMStamp
FROM `FLOTSAMDB`.jos_opensim_groupinvite;
 
/*fill os_groups_membership in ROBUST database with values from jos_opensim_groupmembership
or FlotSam osgroupmembership*/
INSERT INTO `ROBUSTDB`.`os_groups_membership`
(GroupID, PrincipalID, SelectedRoleID, Contribution, ListInProfile, AcceptNotices)
SELECT GroupID, AgentID, SelectedRoleID, Contribution, ListInProfile, AcceptNotices
FROM `FLOTSAMDB`.jos_opensim_groupmembership;
 
/*fill os_groups_notices in ROBUST database with values from jos_opensim_groupnotice
or FlotSam osgroupnotice*/
INSERT INTO `ROBUSTDB`.`os_groups_notices`
(GroupID, NoticeID, TMStamp, FromName, Subject, Message)
SELECT GroupID, NoticeID, Timestamp, FromName, Subject, Message
FROM `FLOTSAMDB`.jos_opensim_groupnotice;
 
/*fill os_groups_principals in ROBUST database with values from jos_opensim_groupactive
or FlotSam osagent*/
INSERT INTO `ROBUSTDB`.`os_groups_principals`
(PrincipalID, ActiveGroupID)
SELECT AgentID, ActiveGroupID
FROM `FLOTSAMDB`.jos_opensim_groupactive;
 
/*fill os_groups_rolemembership in ROBUST database with values from jos_opensim_grouprolemembership
or FlotSam osgrouprolemembership*/
INSERT INTO `ROBUSTDB`.os_groups_rolemembership
(GroupID, RoleID, PrincipalID)
SELECT GroupID, RoleID, AgentID
FROM `FLOTSAMDB`.jos_opensim_grouprolemembership;
 
/*fill os_groups_roles in ROBUST database with values from jos_opensim_grouproles
or FlotSam osrole*/
INSERT INTO `ROBUSTDB`.os_groups_roles
(GroupID, RoleID, Name, Description, Title, Powers)
SELECT GroupID, RoleID, Name, Description, Title, Powers
FROM `FLOTSAMDB`.jos_opensim_grouprole;
 
/*fill os_groups_roles in ROBUST database with values from jos_opensim_offlinemessages
--> no corresponding table in FlotSam  --  only applies to jOpenSim*/
INSERT INTO `ROBUSTDB`.im_offline
(PrincipalID, Message, TMStamp)
SELECT fromAgentID, Message, sent
FROM `FLOTSAMDB`.jos_opensim_offlinemessages;

More informations on jOpenSim migration from Groups V2

Retrieved from "http://opensimulator.org/index.php?title=V2_Groups&oldid=50607"
Personal tools
General
About This Wiki