Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008700opensim[GRID] Inventory Servicepublic2020-05-10 22:432020-07-19 21:38
ReporterWilly 
Assigned To 
PrioritynormalSeverityminorReproducibilityalways
StatusnewResolutionopen 
PlatformPC Intel Core I7 - Ram 16 GoOSWindowsOS Version10
Product Version0.9.1.0 
Target VersionFixed in Version 
Summary0008700: IAR command - Script located in object's inventory
DescriptionWhen we create an iar file by setting the permission --perm = CTM, we get after import the objects and the scripts with all the rights (in this case everything works correctly)

But if a script is in an object, when we open the inventory of this object after the import, we see that the name of the script is followed by the mention (no copy) (no modify)

Also, we cannot view and edit the script.

I tried to see in which database table is this type of script, located in the inventory of an object, but I did not succeed.

For a script placed in the inventory of an avatar, we can easily modify the rights by a simple update.

Currently I want to migrate my database from Mysql to Postgresql, because its size exceeds four gigabytes and Mysql no longer works correctly.
For this migration, I use IAR command, which allows me to filter my data and take only the objects that are useful to me.

But I am blocked by these scripts placed in the objects, which are no longer readable and modifiable after import.
Provisionally, is there a workaround using sql queries ?
Steps To Reproduce1 - Create a simple LSL script in the inventory of an object (a cube)

2 - Launch an IAR command to save this cube located in the avatar's inventory.
    [save iar --perm=CTM bob dino Objects/cube mypassword C:\cube.iar]

3 - Launch an IAR command to load this IAR in another database
    [load iar --merge bob dino Objects mypassword C:\cube.iar]

4 - Rezz the cube, which was imported by IAR command, an try to open the LSL script located in its inventory:
    This script is no readable and no modifiable


Additional InformationThis problem is reproducible on the previous version of OpenSim (0.8.2.1)
TagsNo tags attached.
Git Revision or version number
Run ModeStandalone (1 Region)
Physics EngineBulletSim
Script EngineXEngine
EnvironmentMono / Windows
Mono Version4.0.1
ViewerFirestorm
Attached Files

- Relationships

-  Notes
(0036470)
tampa (reporter)
2020-05-11 03:37

Okay seems to not obey the setting rather than modify it from what I can tell there seems to be no code to look into the object, just the asset, which has no code to handle the flag.

Beside that though, "Currently I want to migrate my database from Mysql to Postgresql, because its size exceeds four gigabytes and Mysql no longer works correctly." What? Sorry but that shouldn't be happening at all, mysql is more than capable of handling very large tables just fine. If you encounter issues you need to tune your configuration.
(0036472)
Willy (reporter)
2020-05-11 04:37
edited on: 2020-05-25 08:25

It seems that the avatar UUID is in the IAR file, which is not normal.
There are therefore three possibilities to solve this problem.

-> delete this UUID in the IAR file.
-> be able to mention the avatar's UUID in the IAR command.
-> choose the UUID of an avatar when creating the database or when creating a new avatar.

Personally, I think this last option would is the most interesting to temporarily work around this problem.
If the user who needs to use the iar has not yet been created, is to choose the avatar uuid, instead of take the uuid offered by opensim.
The CREATE USER command also allows this option, if the database is already created.

[Remarks]
I have not tested every case.
For creating and loading an IAR in the same version 9.1 of opensim, the --perm = CTM option may be fully functional.
But for the creation and loading of an IAR from a version 8.2 of opensim to a version 9.1, the --perm = CTM option is valid under certain conditions.
Rather than modifying the code, you should perhaps comment on this option perm = CTM
What is certain is that choosing the same avatar name with the same uuid solves this problem.
Maybe, another way to solve this problem would be for the user to modify the rights on the scripts, with an update command, in the PRIMITEMS table, before the objects return to the inventory.
If the objects are already in the inventory, it is too late because the scripts in the inventory of the object, are coded in binary in the column DATA of the table ASSETS.
We can also try to manually modify the rights on the scripts, in the object inventory (but it is often burdensome!)

(0036627)
Ferd Frederix (reporter)
2020-07-19 21:38

You can easily run with 100 gigabytes in mysql under opensim If it grows much beyond that, consider enabling fsassets. Its faster, smaller as it de-duplicates assets, and a major advantage is you can span multiple drives with symbolic links.


These may need to be adjusted for your database name. This myisamcheck does not work on region tables as they are not based in ISAM tables.

myisamchk --force --fast --update-state ..\data\mysql\*.MYI
myisamchk --force --fast --update-state ..\data\robust\*.MYI

Check: mysqlcheck.exe -A -u root -p

The last two only if errors show up.

Repair: mysqlcheck.exe -A -u root -r -p
Optimize: mysqlcheck.exe -A -u root -o -p

- Issue History
Date Modified Username Field Change
2020-05-10 22:43 Willy New Issue
2020-05-11 03:37 tampa Note Added: 0036470
2020-05-11 04:37 Willy Note Added: 0036472
2020-05-11 04:55 Willy Note Edited: 0036472 View Revisions
2020-05-11 04:56 Willy Note Edited: 0036472 View Revisions
2020-05-11 05:00 Willy Note Edited: 0036472 View Revisions
2020-05-11 05:01 Willy Note Edited: 0036472 View Revisions
2020-05-11 05:02 Willy Note Edited: 0036472 View Revisions
2020-05-11 05:10 Willy Note Edited: 0036472 View Revisions
2020-05-11 08:08 Willy Note Edited: 0036472 View Revisions
2020-05-11 08:08 Willy Note Edited: 0036472 View Revisions
2020-05-11 08:09 Willy Note Edited: 0036472 View Revisions
2020-05-11 08:42 Willy Note Edited: 0036472 View Revisions
2020-05-11 08:43 Willy Note Edited: 0036472 View Revisions
2020-05-11 12:00 Willy Note Edited: 0036472 View Revisions
2020-05-11 12:09 Willy Note Edited: 0036472 View Revisions
2020-05-15 08:27 Willy Note Edited: 0036472 View Revisions
2020-05-25 08:25 Willy Note Edited: 0036472 View Revisions
2020-07-19 21:38 Ferd Frederix Note Added: 0036627


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker