FAQ
From OpenSimulator
(→MySQL) |
(Add jsonsimstats stats too) |
||
(144 intermediate revisions by 47 users not shown) | |||
Line 1: | Line 1: | ||
− | + | {{Quicklinks}} | |
− | + | <br /> | |
− | = What is | + | == About OpenSimulator == |
− | + | === What is OpenSimulator? === | |
− | + | OpenSimulator is a platform for operating a virtual world, and supports multiple independent regions connecting to a single centralized grid. This is somewhat similar to the web, where anyone can run their own web server, tied together through the internet. It can also be used to create a private grid, analogous to a private intranet. | |
=== What is a region? === | === What is a region? === | ||
− | + | A region is what you see when you log into OpenSimulator. It is the physical place (well, virtual physical space) where avatars move and interact. It is a square patch of land which may contain an island, mountains, a plain, buildings, etc., or just an ocean. | |
− | A region is what you see when you log into | + | |
=== What is the grid? === | === What is the grid? === | ||
− | + | The grid is the level that organizes the regions and their positions in the world, and handles things that need to exist across regions, such as a user's inventory. You can think of it as similar to the world map. | |
− | The grid is the level that organizes the regions and their positions in the world, and handles things that need to exist across regions, such as a user's inventory. | + | |
=== What does ... mean? === | === What does ... mean? === | ||
+ | See the [[Definitions|Technical Reference Glossary]] for definitions of terms commonly used in OpenSimulator. | ||
− | + | == Configuring OpenSimulator == | |
− | + | First, read [[OpenSim Configuration]]. | |
− | = | + | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | First, read [[OpenSim | + | |
− | + | ||
=== Where can I get a new UUID for my sim config? === | === Where can I get a new UUID for my sim config? === | ||
− | + | * See [[OpenSim Configuration]] | |
− | + | ||
=== Can I run multiple regions with OpenSim? === | === Can I run multiple regions with OpenSim? === | ||
− | + | * See [[OpenSim Configuration]] | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | * See [[OpenSim | + | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
=== What databases can be used with OpenSim? === | === What databases can be used with OpenSim? === | ||
− | + | * See [[OpenSim Configuration]] | |
− | + | === What about PostgreSQL or NHibernate? === | |
+ | * NHibernate support, which enabled OpenSimulator to access PostgreSQL database, was removed on October 2009 ([http://opensimulator.org/viewgit/?a=commitdiff&p=opensim&h=fdce1be3db287bed901332b90ba57165e201d3fc r/11252]) due to lack of users and mainteners ([http://lists.berlios.de/pipermail/opensim-dev/2010-April/008537.html Opensim-dev: NHibernate status]). | ||
− | == | + | == Running OpenSimulator == |
− | + | === An error is thrown while trying to start up OpenSimulator === | |
− | + | ||
− | + | See [[Troubleshooting]]. | |
− | + | ||
− | + | == Connecting to OpenSimulator == | |
+ | === I've set up my OpenSimulator server and it looks like the login works but the client hangs on 'connecting to region' === | ||
− | + | There are 2 steps to login. | |
− | + | 1) When you start up the client and enter your name/password, it sends those details to the OpenSimulator login service. If your password is correct, it tells the region simulator that you're coming. It then sends back to you (the client) the ip address and port to use to enter that region (as gleaned from your Regions.ini file). | |
− | + | 2) Your client then connects to the region using those details. | |
− | + | If the client hangs on 'connecting to region' then the details being sent to it in step 2) are not allowing it to connect. Check your Regions.ini carefully and try to telnet to the ip & port that should be available. | |
− | + | If you're seeing this problem after you've made your sim available to the outside world (where people outside your network can connect to it but you cannot) then you probably don't have a router that supports NAT loopback. This allows you to connect to a local machine through your router via an external address. See [[NAT Loopback Routers]] for a list of routers that support this feature. | |
− | === I | + | == OpenSimulator in the Wild == |
+ | === Are there test servers running OpenSimulator I can connect to? === | ||
− | + | Yes. Check out our [[Grid List]]! There are often many private servers up for testing. Hang out on the [[IRC]] channel, and troll for URI's. | |
− | + | ||
− | + | There are also several private organizations offering directories and search engines. They include: | |
− | * | + | * [http://www.hyperica.com Hyperica] -- a categorized directory of hypergrid-enabled OpenSimulator destinations, currently over 250 locations<br /> |
+ | * [http://www.metaverseink.com MetaverseInk] -- ha key-word-based search engine for OpenSimulator grids, mostly those running the Diva Distro | ||
+ | :'''''Note:''' Diva seems to continue to maintain the search engine, but for many years it stopped working as it should, and automatic (voluntary) updates fail with an error, so this search engine will be hopelessly outdated — [[User:Gwyneth Llewelyn|Gwyneth Llewelyn]] ([[User talk:Gwyneth Llewelyn|talk]]) 12:16, 23 May 2020 (PDT)'' | ||
+ | * [http://www.gridhop.net GridHop] -- a list covering the major OpenSimulator grids, currently over 150 destinations accessible over hypergrid teleport | ||
+ | '''Note: This link seems to be dead. [[User:Acryline|Acryline]] :12:00, 22 Sept 2021 | ||
+ | * [http://www.hgurl.com HGURL] -- a key-word-search database for all grid, all accessible via hypergrid (in progress API for acces to search engine and info in world). | ||
+ | * [http://www.thehypergates.com/ The HyperGates] -- The first dynamic, auto-updating HyperGrid directory for both HyperGrid 1.5 ( OpenSimulator 0.7.x ) and HyperGrid 1.0 ( OpenSimulator 0.6.x ) standalones & grids. Download the HyperGate from the site now and Join the HyperGate Network. The most reliable HyperGrid directory. | ||
+ | :'''''Note:''' Seems to be dead; site has been 'taken over' by a Japanese company — [[User:Gwyneth Llewelyn|Gwyneth Llewelyn]] ([[User talk:Gwyneth Llewelyn|talk]]) 12:16, 23 May 2020 (PDT)'' | ||
+ | * [http://www.opensimworld.com/ OpenSimWorld.com] -- A HyperGrid directory that monitors the number of visitors per region. Their teleporter allows you to access destinations from in-world. | ||
− | === | + | === Are there any companies that will host my grid for me? === |
− | + | Yes there are dozens of independent OpenSimulator hosting providers. The following are not affiliated with OpenSimulator.org. | |
− | * | + | * [https://zetamex.com/ Zetamex Network] |
− | + | * [https://reactiongrid.com ReactionGrid] | |
− | + | * [https://tomahost.com/ TomaHost] | |
− | + | * [http://www.dreamlandmetaverse.com DreamLand Metaverse] | |
− | + | * [http://www.yoursimspot.com YourSimSpot] | |
− | + | * [http://edocio.com Edocio (Educational Sims Only.] | |
− | + | More vendors listed here: [https://www.hypergridbusiness.com/category/vendors/ Hypergrid Business Vendors Directory] -- a categorized directory of OpenSimulator vendors, currently listing about four dozen providers.<br /> | |
− | * | + | |
− | + | ||
− | + | ||
− | * | + | |
− | + | ||
− | * | + | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
=== Can I teleport from the Linden Lab Second Life grid to my Sim? === | === Can I teleport from the Linden Lab Second Life grid to my Sim? === | ||
+ | No. In 2008 and 2009, there had been the connection to vaak grid, [http://blog.secondlife.com/2008/07/31/open-grid-public-beta-begins-today/ which enabled us to teleport from Second Life over to an OpenSimulator grid] before LindenLab closing it. As of 2010, "The vaak grid is currently unavailable as we transition from OGP based services to VWRAP based services."([http://wiki.secondlife.com/wiki/Open_Grid_Public_Beta "Open Grid Public Beta" in Second Life Wiki]) | ||
− | + | == Troubleshooting == | |
− | + | Please see the [[Troubleshooting]] page. | |
− | = | + | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | === | + | == MySQL == |
+ | === How do I isolate and delete a user's Trash items in a MySQL grid database? === | ||
+ | <font color="red">NOTE:</font> BACK UP YOUR DATABASE! | ||
− | * | + | CAUTION: The Linux default directory for the MySQL database is /var/lib/mysql Many backup tools (e.g. backupPC) do NOT back up /var/*! Make certain that the database and not just the MySQL code (/usr/bin/mysql) is included in your nightly backups! The actual paths will be different for different operating systems and databases, but the problem is the same. |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | |||
− | |||
'''1.''' Locate the avatars UUID you wish to find the trash items of, in the '''users''' table<br /> | '''1.''' Locate the avatars UUID you wish to find the trash items of, in the '''users''' table<br /> | ||
<font size="0.9em">This query will locate a specified users UUID: (replace User/Test with username/lastname)</font> | <font size="0.9em">This query will locate a specified users UUID: (replace User/Test with username/lastname)</font> | ||
Line 217: | Line 95: | ||
'''2.''' Use the avatars UUID to search the field_name '''AgentID''' in the '''inventoryFolders''' table, using '''Trash''' as the '''folderName''' to isolate the users Trash '''folderID'''<br /> | '''2.''' Use the avatars UUID to search the field_name '''AgentID''' in the '''inventoryFolders''' table, using '''Trash''' as the '''folderName''' to isolate the users Trash '''folderID'''<br /> | ||
<font size="0.9em">This query will locate the users Trash folder entry: (replace 00000000-0000-0000-0000-000000000000 with UUID of user)</font> | <font size="0.9em">This query will locate the users Trash folder entry: (replace 00000000-0000-0000-0000-000000000000 with UUID of user)</font> | ||
− | <nowiki>SELECT `folderID` FROM `inventoryfolders` WHERE `agentID` LIKE '00000000-0000-0000-0000-000000000000' AND `folderName` LIKE 'Trash' | + | <nowiki>SELECT `folderID` FROM `inventoryfolders` WHERE `agentID` LIKE '00000000-0000-0000-0000-000000000000' AND `folderName` LIKE 'Trash' LIMIT 0 , 30;</nowiki> |
− | LIMIT 0 , 30;</nowiki> | + | |
<br /> | <br /> | ||
'''3.''' Use the '''folderID''' UUID obtained in the last query to find all of the trash items in the '''inventoryitems''' table, you can then delete them once you have isolated them.<br /> | '''3.''' Use the '''folderID''' UUID obtained in the last query to find all of the trash items in the '''inventoryitems''' table, you can then delete them once you have isolated them.<br /> | ||
Line 226: | Line 103: | ||
'''<font color="red">NOTE:</font>''' These steps will not remove the associated assets from the assets table, just the items in the inventory '''inventoryitems''' table. | '''<font color="red">NOTE:</font>''' These steps will not remove the associated assets from the assets table, just the items in the inventory '''inventoryitems''' table. | ||
− | == How do I isolate and resolve duplicate inventory folder entries in a MySQL grid database? == | + | === How do I isolate and resolve duplicate inventory folder entries in a MySQL grid database? === |
+ | <font color="red">NOTE:</font> BACK UP YOUR DATABASE!<br /> | ||
− | + | '''1.''' It's first a good idea to search for the affected avatars UUID in the '''inventoryFolders''' table to see the duplicate entries. When you see this, you'll see the problem of duplicate entries. The key here will be to find out which is being used.<br /> | |
+ | |||
+ | '''2.''' Upload a file inworld and name it something unique. This will isolate the UUID of your root folder that is being used (even though there are dups only one is being used)<br /> | ||
− | = | + | '''3.''' Search the '''inventoryitems''' table for your uniquely named item and locate it's '''parentFolderID''' <br /><br /> |
+ | <font size="0.9em">This query will isolate the '''parentFolderID''' based on your search for the unique item (replace '''unique_name''' with your unique item name)</font> | ||
+ | <nowiki>SELECT `parentFolderID` FROM `inventoryitems` WHERE `inventoryName` LIKE 'unique_name' LIMIT 0 , 30;</nowiki> | ||
− | + | '''4.''' Check the '''inventoryfolders''' table against the '''parentFolderID''' UUID obtained in the last search. That is your root folder that is being used.. you can delete all duplicate entries that do not match that parentFolderID. In the end, you should only have one of each type (Trash, etc)<br /><br /> | |
+ | <font size="0.9em">This query will return all values that are NOT the parentID obtained in the last search. (replace 00000000-0000-0000-0000-000000000000 with the parentID located in step 3)</font> | ||
+ | <nowiki>SELECT * FROM `inventoryfolders` WHERE `folderID` NOT LIKE '00000000-0000-0000-0000-000000000000' LIMIT 0 , 30;</nowiki> | ||
− | === | + | == In World Questions == |
− | + | === Does in world scripting work yet? === | |
− | + | Not fully implemented, but most of it works, and there is a lot of work going on here. Please see [[ScriptEngines]], [[LSL Status]] and [[OSSL Status]] for the latest info. | |
=== Can I customize my avatar? === | === Can I customize my avatar? === | ||
− | + | Yes. In order to do this: | |
− | Yes. | + | |
* Click the Inventory Button | * Click the Inventory Button | ||
* Create -> New Clothes -> Shirt, Pants, etc | * Create -> New Clothes -> Shirt, Pants, etc | ||
Line 247: | Line 130: | ||
* Wear them | * Wear them | ||
− | Your avatar doesn't always face a nice direction for doing this, so you'll need to use the camera operations to see your face for some of the modifications. | + | Your avatar doesn't always face a nice direction for doing this, so you'll need to use the camera operations to see your face for some of the modifications. This is a known issue, will be fixed in the future. Also, you'll need to rewear you parts once you first join the environment. Right now default appearance is always "Ruth". |
− | + | === Why do I look like I gas cloud right after I did the the previous steps? === | |
+ | Second Life eliminated Ruth from their client. The Ruth we see in OpenSimulator is our own attempt of a yoga teacher and not truly Second Life's Ruth. When you create a shirt, pants, skin and shape and wear them without changing any parameters, the Second Life Viewer understands you are not Ruth. Since Ruth is no more, you become a cloud of gas. To fix it, either change a parameter of one of them before wearing all 4, or, if you already are a gas cloud, right click one of these items in your inventory and click edit. That should bring up the edit appearance menus. Just move any sliders and voilá. | ||
− | = | + | === Why doesn't my world map update when I edit the terrain? === |
− | + | There are three approaches depending on just how adventurous you want to be. From the least to the most adventurous: | |
+ | * From the simulator console run generate map or simply restart your simulator | ||
+ | * Edit MaptileRefresh parameter in [Map] section of OpenSimDefaults.ini | ||
+ | * Not for the faint of heart! Edit the "WorldMapModule.cs" file and change the "LazySaveGeneratedMaptile" method to change the "RefreshSeconds" value to something less than two days. Be sure to read the comments and understand why things are the way they are. | ||
− | + | Once your terrain stabilizes, this won't be much of a problem, but it is nice to see the updates while you're furiously developing something. | |
− | + | === How do I give a user God Mode privileges? === | |
+ | Open the Opensim database, select table useraccounts and set the UserLevel to 200 for the account that should have God Mode privileges. | ||
− | + | Then, in the Advanced menu of the Firestorm viewer, the user must select "Display the Developer menu". In the Developer menu select "Request Admin Status". | |
− | === | + | == Scripting == |
+ | === System.Reflection.TargetParameterCountException: parameters do not match signature === | ||
+ | The parameters for the states doesn't match with required. For example, this script should show the error above. | ||
+ | <source lang="lsl"> | ||
+ | default | ||
+ | { | ||
+ | touch_start() // SHOULD have a parameter there | ||
+ | { | ||
+ | llApplyImpulse( <0., 0., 10000.>, FALSE ); | ||
+ | } | ||
+ | } | ||
+ | </source> | ||
− | + | === Bool eval === | |
+ | Always test your integer(bool) and any variable against an actual test, never just do if(variable) | ||
+ | <source lang="lsl"> | ||
+ | integer hello = 1; | ||
+ | default | ||
+ | { | ||
+ | state_entry() | ||
+ | { | ||
+ | if (hello == TRUE) | ||
+ | { | ||
+ | llSay(0, "Hello, World!"); | ||
+ | } | ||
+ | } | ||
+ | } | ||
+ | </source> | ||
− | + | == Region Statistics on a Web Page == | |
+ | === Information about your regions. === | ||
+ | Region statistics such as region name, avatar name, avatar position<x,y,z>, number of prims, and a lot of other information can be obtained on a web page by: | ||
+ | * Adding the following to the bottom of the OpenSim.ini file | ||
+ | [WebStats] | ||
+ | enabled=true | ||
+ | * Using a web browser and typing in "Region Server Hostname:http_listener_port" + "/SStats/" | ||
− | + | For example | |
+ | <nowiki>http://127.0.0.1:9000/SStats/</nowiki> | ||
− | + | The resulting web page is continually updated using AJAX, so there is no need to refresh the page to obtain current information. One possible use for this web page information would be to see who is logged on to the region in real time - without actually logging in.<br /> | |
+ | This web page provides region information similar to the kind generated by using various server console commands to obtain region statistics. See [[Server Commands]] | ||
− | + | Another option for more basic stats is jsonsimstats, which can be queried via curl: | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | <nowiki>curl -s -m 10 -X POST "http://localhost:$httpport$/jsonSimStats"</nowiki> | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | Replace $httpport$ with the simulator port. | |
− | + | [[Category:Users]] | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | [[Category: | + |
Latest revision as of 17:42, 24 February 2022
Contents |
[edit] About OpenSimulator
[edit] What is OpenSimulator?
OpenSimulator is a platform for operating a virtual world, and supports multiple independent regions connecting to a single centralized grid. This is somewhat similar to the web, where anyone can run their own web server, tied together through the internet. It can also be used to create a private grid, analogous to a private intranet.
[edit] What is a region?
A region is what you see when you log into OpenSimulator. It is the physical place (well, virtual physical space) where avatars move and interact. It is a square patch of land which may contain an island, mountains, a plain, buildings, etc., or just an ocean.
[edit] What is the grid?
The grid is the level that organizes the regions and their positions in the world, and handles things that need to exist across regions, such as a user's inventory. You can think of it as similar to the world map.
[edit] What does ... mean?
See the Technical Reference Glossary for definitions of terms commonly used in OpenSimulator.
[edit] Configuring OpenSimulator
First, read OpenSim Configuration.
[edit] Where can I get a new UUID for my sim config?
[edit] Can I run multiple regions with OpenSim?
[edit] What databases can be used with OpenSim?
[edit] What about PostgreSQL or NHibernate?
- NHibernate support, which enabled OpenSimulator to access PostgreSQL database, was removed on October 2009 (r/11252) due to lack of users and mainteners (Opensim-dev: NHibernate status).
[edit] Running OpenSimulator
[edit] An error is thrown while trying to start up OpenSimulator
See Troubleshooting.
[edit] Connecting to OpenSimulator
[edit] I've set up my OpenSimulator server and it looks like the login works but the client hangs on 'connecting to region'
There are 2 steps to login.
1) When you start up the client and enter your name/password, it sends those details to the OpenSimulator login service. If your password is correct, it tells the region simulator that you're coming. It then sends back to you (the client) the ip address and port to use to enter that region (as gleaned from your Regions.ini file).
2) Your client then connects to the region using those details.
If the client hangs on 'connecting to region' then the details being sent to it in step 2) are not allowing it to connect. Check your Regions.ini carefully and try to telnet to the ip & port that should be available.
If you're seeing this problem after you've made your sim available to the outside world (where people outside your network can connect to it but you cannot) then you probably don't have a router that supports NAT loopback. This allows you to connect to a local machine through your router via an external address. See NAT Loopback Routers for a list of routers that support this feature.
[edit] OpenSimulator in the Wild
[edit] Are there test servers running OpenSimulator I can connect to?
Yes. Check out our Grid List! There are often many private servers up for testing. Hang out on the IRC channel, and troll for URI's.
There are also several private organizations offering directories and search engines. They include:
- Hyperica -- a categorized directory of hypergrid-enabled OpenSimulator destinations, currently over 250 locations
- MetaverseInk -- ha key-word-based search engine for OpenSimulator grids, mostly those running the Diva Distro
- Note: Diva seems to continue to maintain the search engine, but for many years it stopped working as it should, and automatic (voluntary) updates fail with an error, so this search engine will be hopelessly outdated — Gwyneth Llewelyn (talk) 12:16, 23 May 2020 (PDT)
- GridHop -- a list covering the major OpenSimulator grids, currently over 150 destinations accessible over hypergrid teleport
Note: This link seems to be dead. Acryline :12:00, 22 Sept 2021
- HGURL -- a key-word-search database for all grid, all accessible via hypergrid (in progress API for acces to search engine and info in world).
- The HyperGates -- The first dynamic, auto-updating HyperGrid directory for both HyperGrid 1.5 ( OpenSimulator 0.7.x ) and HyperGrid 1.0 ( OpenSimulator 0.6.x ) standalones & grids. Download the HyperGate from the site now and Join the HyperGate Network. The most reliable HyperGrid directory.
- Note: Seems to be dead; site has been 'taken over' by a Japanese company — Gwyneth Llewelyn (talk) 12:16, 23 May 2020 (PDT)
- OpenSimWorld.com -- A HyperGrid directory that monitors the number of visitors per region. Their teleporter allows you to access destinations from in-world.
[edit] Are there any companies that will host my grid for me?
Yes there are dozens of independent OpenSimulator hosting providers. The following are not affiliated with OpenSimulator.org.
- Zetamex Network
- ReactionGrid
- TomaHost
- DreamLand Metaverse
- YourSimSpot
- Edocio (Educational Sims Only.
More vendors listed here: Hypergrid Business Vendors Directory -- a categorized directory of OpenSimulator vendors, currently listing about four dozen providers.
[edit] Can I teleport from the Linden Lab Second Life grid to my Sim?
No. In 2008 and 2009, there had been the connection to vaak grid, which enabled us to teleport from Second Life over to an OpenSimulator grid before LindenLab closing it. As of 2010, "The vaak grid is currently unavailable as we transition from OGP based services to VWRAP based services."("Open Grid Public Beta" in Second Life Wiki)
[edit] Troubleshooting
Please see the Troubleshooting page.
[edit] MySQL
[edit] How do I isolate and delete a user's Trash items in a MySQL grid database?
NOTE: BACK UP YOUR DATABASE!
CAUTION: The Linux default directory for the MySQL database is /var/lib/mysql Many backup tools (e.g. backupPC) do NOT back up /var/*! Make certain that the database and not just the MySQL code (/usr/bin/mysql) is included in your nightly backups! The actual paths will be different for different operating systems and databases, but the problem is the same.
1. Locate the avatars UUID you wish to find the trash items of, in the users table
This query will locate a specified users UUID: (replace User/Test with username/lastname)
SELECT `UUID` FROM `users` WHERE `username` LIKE 'User' AND `lastname` LIKE 'Test' LIMIT 0 , 30;
2. Use the avatars UUID to search the field_name AgentID in the inventoryFolders table, using Trash as the folderName to isolate the users Trash folderID
This query will locate the users Trash folder entry: (replace 00000000-0000-0000-0000-000000000000 with UUID of user)
SELECT `folderID` FROM `inventoryfolders` WHERE `agentID` LIKE '00000000-0000-0000-0000-000000000000' AND `folderName` LIKE 'Trash' LIMIT 0 , 30;
3. Use the folderID UUID obtained in the last query to find all of the trash items in the inventoryitems table, you can then delete them once you have isolated them.
This query will locate the trash items of the avatar in question: (replace 00000000-0000-0000-0000-000000000000 with Trash folder UUID obtained in the last query)
SELECT * FROM `inventoryitems` WHERE `parentFolderID` LIKE '00000000-0000-0000-0000-000000000000' LIMIT 0 , 9999;
NOTE: These steps will not remove the associated assets from the assets table, just the items in the inventory inventoryitems table.
[edit] How do I isolate and resolve duplicate inventory folder entries in a MySQL grid database?
NOTE: BACK UP YOUR DATABASE!
1. It's first a good idea to search for the affected avatars UUID in the inventoryFolders table to see the duplicate entries. When you see this, you'll see the problem of duplicate entries. The key here will be to find out which is being used.
2. Upload a file inworld and name it something unique. This will isolate the UUID of your root folder that is being used (even though there are dups only one is being used)
3. Search the inventoryitems table for your uniquely named item and locate it's parentFolderID
This query will isolate the parentFolderID based on your search for the unique item (replace unique_name with your unique item name)
SELECT `parentFolderID` FROM `inventoryitems` WHERE `inventoryName` LIKE 'unique_name' LIMIT 0 , 30;
4. Check the inventoryfolders table against the parentFolderID UUID obtained in the last search. That is your root folder that is being used.. you can delete all duplicate entries that do not match that parentFolderID. In the end, you should only have one of each type (Trash, etc)
This query will return all values that are NOT the parentID obtained in the last search. (replace 00000000-0000-0000-0000-000000000000 with the parentID located in step 3)
SELECT * FROM `inventoryfolders` WHERE `folderID` NOT LIKE '00000000-0000-0000-0000-000000000000' LIMIT 0 , 30;
[edit] In World Questions
[edit] Does in world scripting work yet?
Not fully implemented, but most of it works, and there is a lot of work going on here. Please see ScriptEngines, LSL Status and OSSL Status for the latest info.
[edit] Can I customize my avatar?
Yes. In order to do this:
- Click the Inventory Button
- Create -> New Clothes -> Shirt, Pants, etc
- Create -> New Body Parts -> Hair, Shape, etc
- Edit those from your inventory
- Wear them
Your avatar doesn't always face a nice direction for doing this, so you'll need to use the camera operations to see your face for some of the modifications. This is a known issue, will be fixed in the future. Also, you'll need to rewear you parts once you first join the environment. Right now default appearance is always "Ruth".
[edit] Why do I look like I gas cloud right after I did the the previous steps?
Second Life eliminated Ruth from their client. The Ruth we see in OpenSimulator is our own attempt of a yoga teacher and not truly Second Life's Ruth. When you create a shirt, pants, skin and shape and wear them without changing any parameters, the Second Life Viewer understands you are not Ruth. Since Ruth is no more, you become a cloud of gas. To fix it, either change a parameter of one of them before wearing all 4, or, if you already are a gas cloud, right click one of these items in your inventory and click edit. That should bring up the edit appearance menus. Just move any sliders and voilá.
[edit] Why doesn't my world map update when I edit the terrain?
There are three approaches depending on just how adventurous you want to be. From the least to the most adventurous:
- From the simulator console run generate map or simply restart your simulator
- Edit MaptileRefresh parameter in [Map] section of OpenSimDefaults.ini
- Not for the faint of heart! Edit the "WorldMapModule.cs" file and change the "LazySaveGeneratedMaptile" method to change the "RefreshSeconds" value to something less than two days. Be sure to read the comments and understand why things are the way they are.
Once your terrain stabilizes, this won't be much of a problem, but it is nice to see the updates while you're furiously developing something.
[edit] How do I give a user God Mode privileges?
Open the Opensim database, select table useraccounts and set the UserLevel to 200 for the account that should have God Mode privileges.
Then, in the Advanced menu of the Firestorm viewer, the user must select "Display the Developer menu". In the Developer menu select "Request Admin Status".
[edit] Scripting
[edit] System.Reflection.TargetParameterCountException: parameters do not match signature
The parameters for the states doesn't match with required. For example, this script should show the error above.
default { touch_start() // SHOULD have a parameter there { llApplyImpulse( <0., 0., 10000.>, FALSE ); } }
[edit] Bool eval
Always test your integer(bool) and any variable against an actual test, never just do if(variable)
integer hello = 1; default { state_entry() { if (hello == TRUE) { llSay(0, "Hello, World!"); } } }
[edit] Region Statistics on a Web Page
[edit] Information about your regions.
Region statistics such as region name, avatar name, avatar position<x,y,z>, number of prims, and a lot of other information can be obtained on a web page by:
- Adding the following to the bottom of the OpenSim.ini file
[WebStats] enabled=true
- Using a web browser and typing in "Region Server Hostname:http_listener_port" + "/SStats/"
For example
http://127.0.0.1:9000/SStats/
The resulting web page is continually updated using AJAX, so there is no need to refresh the page to obtain current information. One possible use for this web page information would be to see who is logged on to the region in real time - without actually logging in.
This web page provides region information similar to the kind generated by using various server console commands to obtain region statistics. See Server Commands
Another option for more basic stats is jsonsimstats, which can be queried via curl:
curl -s -m 10 -X POST "http://localhost:$httpport$/jsonSimStats"
Replace $httpport$ with the simulator port.