OpenSimulator - User contributions [en]

Testing

2011-09-09T16:19:15Z

KatherineDaniels:

{{Quicklinks}}
{{content}}

= Automated Testing =
For information on the current continuous integration system for OpenSim go to [[Automated Testing]].

For information about debugging the test cases go to [[Debugging Unit Tests]].

= Current functionality =

* [[Features Currently Supported]] 
* [[Priorities and Test Plans]] 
 
Check [[LSL Status|LSL Status]] Page for currently implemented scripting features. 
Note: not all scripting features are supported yet. 
 
* Standalone region tested with svn version 9379
* Grid region tested with svn version 9379

== Account ==
{| border="1" cellpadding="5" cellspacing="0"
! width="200" |  
! width="200" | Standalone
! width="200" | Grid
|-
| login
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| logout
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| relog
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| Home - Login Start Location
| bgcolor="lime" | OK
| bgcolor="lime" | OK - Configurable by Region
|-
| Alt Home - if Home unavailable
| bgcolor="yellow" | unknown
| bgcolor="lime" | Alternate Region hardset by GRID
|}

== World ==
{| border="1" cellpadding="5" cellspacing="0"
! width="200" |  
! width="200" | Standalone
! width="200" | Grid
|-
| day / night cycle
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| windlight
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| clouds
| bgcolor="lime" | Working
| bgcolor="lime" | Working
|-
| wind
| bgcolor="lime" | Working
| bgcolor="lime" | Working
|-
| water and water texture
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| terrain and terrain textures
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|}
== Accounts and permissions ==
{| border="1" cellpadding="5" cellspacing="0"
! width="200" |  
! width="200" | Standalone
! width="200" | Grid
|-
| multiple account creation
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| permissions per account
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| account has inventory
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| sim supports multiple logins
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|}
== Avatar ==
{| border="1" cellpadding="5" cellspacing="0"
! width="200" |  
! width="200" | Standalone
! width="200" | Grid
|-
| teleport within region
| bgcolor="yellow" | partially working (always facing north after teleport)
| bgcolor="yellow" | partially working (go inside ground when teleport from low to high position,always facing north after teleport)
|-
| teleport between regions
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| built-in animations (walking, flying, sitting)
| bgcolor="yellow" | partially working
| bgcolor="yellow" | partially working
|-
| uploaded animations / gestures
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| uploaded sounds
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| can wear clothes
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| can attach items
| bgcolor="lime" | OK
| bgcolor="yellow" | OK
|-
| profile
| bgcolor="lime" | pics & text
| bgcolor="lime" | pics & text
|-
| DRAG / CTRL DRAG objects
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|}
== Building ==
{| border="1" cellpadding="5" cellspacing="0"
! width="200" |  
! width="200" | Standalone
! width="200" | Grid
|-
| create prim
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| change prim type
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| change prim transparency
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| change prim colour
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| change prim texture (including uploaded textures)
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| change prim size, cut, hollow, etc
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| prim light, fullbright and flexi
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| link prims
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| unlink prims
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| permissions
| bgcolor="lime" | Working
| bgcolor="lime" | Working
|-
| objects persist in world across login / logoff and server restart
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| parcel support
| bgcolor="lime" | OK See Parcels Below
| bgcolor="lime" | OK See Parcels Below
|}
== Terraforming ==
{| border="1" cellpadding="5" cellspacing="0"
! width="200" |  
! width="200" | Standalone
! width="200" | Grid
|-
| select land
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| raise land
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| lower land
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| flatten land
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| roughen land
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| smooth land
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|}
== Land and parcels ==
{| border="1" cellpadding="5" cellspacing="0"
! width="200" |  
! width="200" | Standalone
! width="200" | Grid
|-
| subdivide
| bgcolor="lime" | Working
| bgcolor="lime" | Working
|-
| join
| bgcolor="lime" | Working
| bgcolor="lime" | Working
|-
| buy and sell
| bgcolor="orange" | Partial, sell and buy, but no money recieved. (Set helper uri to IP ADDRESS AND PORT:9000
| bgcolor="lime" | Working (when using a 3rd party module)
|-
| Set Land To Group
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| Allow Deed To Group
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| Owner Makes Contribution With Deed
| bgcolor="red" | not working
| bgcolor="lime" | Working (when using a 3rd party module)
|-
| Buy Pass - (Temporary Paid Access)
| bgcolor="red" | not working
| bgcolor="red" | Not Yet Implemented
|-
| Buy For Group
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
!scope="row" colspan="3"| '''Covenants'''
|-
| Buy For Group
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| Estate Owner
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
!scope="row" colspan="3"| '''Land Objects'''
|-
| Sim Usage
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| Prims on Parcel
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| Return Parcel Primitives
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| AutoReturn of Prims
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| Show Owners (Land Menu)
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
!scope="row" colspan="3"| '''Land Options'''|
|-
| Show Owners (Land Menu)
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
!scope="row" colspan="3"| '''Land Media'''
|-
| Replace Texture With Media
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| Music Stream URL
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| Restrict Spatialized Sounds to Parcel
| bgcolor="red" | Not Yet Implemented
| bgcolor="red" | Not Yet Implemented
|-
!scope="row" colspan="3"| '''Land Access'''
|-
| Show Owners (Land Menu)
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
!scope="row" colspan="3"| '''Land Bans'''
|-
| Limit Access to Group
| bgcolor="lime" | Yes
| bgcolor="lime" | Yes
|-
| Limit Access by Avatar
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| Individual Avatar Ban
| bgcolor="lime" | Working
| bgcolor="lime" | Working - Grid can disable feature gridwide
|}
== UI ==
{| border="1" cellpadding="5" cellspacing="0"
! width="200" |   [http://www.mycaal.com/ loan modification]

! width="200" | Standalone
! width="200" | Grid
|-
| friends list
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| uploads
| bgcolor="lime" | OK
| bgcolor="lime" | OK, jpg, bmp,tga (alpha)
|-
| edit profile
| bgcolor="lime" | OK, but not complete
| bgcolor="lime" | OK, but not complete
|-
| search
| bgcolor="yellow" | partially working(User, Groups, Parcel, Region)
| bgcolor="yellow" | Working(User, Groups, Land Sales, Events, Classifieds)
|-
| large map
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| minimap
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| money
| bgcolor="lime" | Works if using IP ADDRESS AND PORT:9000
| bgcolor="lime" | Works if using IP ADDRESS AND PORT:9000
|-
| HUD attachments
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|}
== Friends ==
{| border="1" cellpadding="5" cellspacing="0"
! width="200" |  
! width="200" | Standalone
! width="200" | Grid
|-
| add
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| remove
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| permissions
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| mapping
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| online visibility
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| can edit my objects
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| send teleport
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|}
== Groups ==
Groups are implemented, but must be enabled in opensim.ini
{| border="1" cellpadding="5" cellspacing="0"
! width="200" |  
! width="200" | Standalone
! width="200" | Grid
|-
| create
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| join
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| description
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| graphic
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| notices
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| vote
| bgcolor="red" | Not Yet Implemented
| bgcolor="red" | Not Yet Implemented
|-
| invite
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| remove
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| members
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| group list
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| publish
| bgcolor="grey" | unknown
| bgcolor="red" | Not Yet Implemented
|-
| set title
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| change active title
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| enrollment fee
| bgcolor="grey" | unknown
| bgcolor="red" | Not Yet Implemented
|-
| open enrollment
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| set mature flag
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| group land
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|}
=== Group Roles ===
{| border="1" cellpadding="5" cellspacing="0"
! width="200" |  
! width="200" | Standalone
! width="200" | Grid
|-
| create
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| edit
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| remove
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| add person
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| remove person
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| abilities
| bgcolor="yellow" | Partially Implemented
| bgcolor="yellow" | Partially Implemented
|}
== Chat, IM, Voice ==
{| border="1" cellpadding="5" cellspacing="0"
! width="200" |  
! width="200" | Standalone
! width="200" | Grid
|-
| local chat
| bgcolor="lime" | OK
| bgcolor="lime" | OK - Plus Configurable Distance (server)
|-
| Shout
| bgcolor="lime" | OK
| bgcolor="lime" | OK - Plus Configurable Distance (server)
|-
| send / receive IM
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| offline IM
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| group IM
| bgcolor="lime" | OK, but groups must be enabled
| bgcolor="lime" | OK, but groups must be enabled
|-
| multiple friend IM
| bgcolor="red" | unknown
| bgcolor="red" | Not Yet Implemented
|-
| participant list
| bgcolor="red" | unknown
| bgcolor="red" | Not Yet Implemented
|-
| voice
| bgcolor="lime" | Must enable and use freeswitch voice
| bgcolor="lime" | Must enable and use freeswitch voice
|-
| IRC bridge
| bgcolor="lime" | OK
| bgcolor="lime" | OK (Configurable on Server)
|}
== Physics / Collision ==
{| border="1" cellpadding="5" cellspacing="0"
! width="150" |  
! width="150" | basicphysics
! width="150" | POS
! width="150" | OpenDynamicsEngine
! width="150" | modified_BulletX
! width="150" | RealPhysX
! width="150" | BulletDotNET
|-
| walk on ground
| bgcolor="lime" | OK
| bgcolor="lime" | OK
| bgcolor="lime" | OK
| bgcolor="yellow" | partially working (ground is very slippery)
| bgcolor="grey" | unknown
| bgcolor="lime" | OK
|-
| fly
| bgcolor="lime" | OK
| bgcolor="lime" | OK
| bgcolor="lime" | OK
| bgcolor="lime" | OK
| bgcolor="grey" | unknown
| bgcolor="lime" | OK
|-
| sit on ground
| bgcolor="lime" | OK
| bgcolor="lime" | OK
| bgcolor="lime" | OK
| bgcolor="red" | not working
| bgcolor="red" | not working
| bgcolor="lime" | OK
|-
| sit on object
| bgcolor="lime" | OK
| bgcolor="red" | not working
| bgcolor="yellow" | partially working (autopilot has trouble getting to the right spot 'try phantom prim')
| bgcolor="grey" | unknown
| bgcolor="grey" | unknown
| bgcolor="lime" | OK
|-
| walk on object
| bgcolor="red" | not working
| bgcolor="lime" | OK
| bgcolor="lime" | OK
| bgcolor="grey" | unknown
| bgcolor="grey" | unknown
| bgcolor="lime" | OK
|-
| bump into object
| bgcolor="red" | not working
| bgcolor="lime" | OK
| bgcolor="lime" | OK
| bgcolor="grey" | unknown
| bgcolor="grey" | unknown
| bgcolor="lime" | OK
|-
| Collidable Linksets
| bgcolor="red" | not working
| bgcolor="lime" | OK
| bgcolor="lime" | OK
| bgcolor="grey" | unknown
| bgcolor="grey" | unknown
| bgcolor="lime" | OK
|-
| Avatar Land on Prim
| bgcolor="red" | not working
| bgcolor="lime" | OK
| bgcolor="lime" | OK
| bgcolor="grey" | unknown
| bgcolor="grey" | unknown
| bgcolor="lime" | OK
|-
| prim physics
| bgcolor="red" | not working
| bgcolor="red" | not working
| bgcolor="lime" | OK
| bgcolor="grey" | unknown
| bgcolor="grey" | unknown
| bgcolor="lime" | OK
|-
| Physical (active) Linksets
| bgcolor="red" | not working
| bgcolor="red" | not working
| bgcolor="lime" | OK
| bgcolor="red" | not working
| bgcolor="red" | not working
| bgcolor="lime" | OK
|-
| cut/hollow/dimpled prim (non)collisions
| bgcolor="grey" | unknown
| bgcolor="grey" | unknown
| bgcolor="lime" | OK with Meshmerizer
| bgcolor="grey" | unknown
| bgcolor="grey" | unknown
| bgcolor="lime" | OK
|-
| physical vehicles
| bgcolor="red" | not working
| bgcolor="red" | not working
| bgcolor="lime" | OK, but friction is much too high.
| bgcolor="red" | not working
| bgcolor="red" | not working
| bgcolor="red" | not working
|}
== Scripting ==
{| border="1" cellpadding="5" cellspacing="0"
! width="200" |  
! width="200" | Standalone
! width="200" | Grid
|-
| create LSL script
| bgcolor="lime" | OK, see supported commands
| bgcolor="lime" | OK, see supported commands
|-
| add script to object
| bgcolor="lime" | OK
| bgcolor="lime" | Drag from inventory into prim
|-
| execute script in object
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|}
Note: not all scripting features are supported yet.
Check [[LSL Status]] for currently implemented features.
== Inventory ==
{| border="1" cellpadding="5" cellspacing="0"
! width="200" |  
! width="200" | Standalone
! width="200" | Grid
|-
| create new items (folder, notes, body, clothes, prims, scripts)
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| delete prims -> trash
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| delete items -> trash
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| trash folder functions (restore, purge)
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| search inventory
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| "recent items" list
| bgcolor="red" | not working
| bgcolor="yellow" | half, only new uploaded and self created stuff, but acctepted inventory offers not listed (8814)
|-
| inventory persists across logout / login
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| drag items to / from world
| bgcolor="lime" | OK
| bgcolor="lime" | OK
|-
| give inventory items to other avatars
| bgcolor="lime" | OK
| bgcolor="lime" | OK
Inventory should not yet be treated as permanent, whilst development is still occurring.
|}
== Permissions ==
{| border="1" cellpadding="5" cellspacing="0"
! width="200" |  
! width="200" | Standalone - Allowed User
! width="200" | Standalone - Denied User
! width="200" | Grid - Allowed User
! width="200" | Grid - Denied User
|-
| Run Script - Estate Disabled
| bgcolor="grey" | unknown
| bgcolor="grey" | unknown
| bgcolor="lime" | no
| bgcolor="lime" | no
|-
| Run Script - Parcel Disabled
| bgcolor="grey" | unknown
| bgcolor="grey" | unknown
| bgcolor="lime" | yes
| bgcolor="lime" | no
|-
| Rez Object - Estate Disabled
| bgcolor="grey" | unknown
| bgcolor="grey" | unknown
| bgcolor="grey" | N/A
| bgcolor="grey" | N/A
|-
| Rez Object - Parcel Disabled
| bgcolor="grey" | unknown
| bgcolor="grey" | unknown
| bgcolor="lime" | yes
| bgcolor="red" | yes
|-
| Edit Estate Settings
| bgcolor="grey" | unknown
| bgcolor="grey" | unknown
| bgcolor="lime" | yes
| bgcolor="lime" | no
|-
| Edit Terrain
| bgcolor="grey" | unknown
| bgcolor="grey" | unknown
| bgcolor="lime" | yes
| bgcolor="red" | yes
|-
| Duplicate (Drag-Duplicate AND Ctrl-D) Object
| bgcolor="grey" | unknown
| bgcolor="grey" | unknown
| bgcolor="lime" | yes
| bgcolor="red" | yes
|-
| Take Object
| bgcolor="grey" | unknown
| bgcolor="grey" | unknown
| bgcolor="lime" | yes
| bgcolor="red" | yes
|-
| Move Object
| bgcolor="grey" | unknown
| bgcolor="grey" | unknown
| bgcolor="lime" | yes
| bgcolor="red" | yes
|-
| Copy Object
| bgcolor="grey" | unknown
| bgcolor="grey" | unknown
| bgcolor="lime" | yes
| bgcolor="red" | yes
|-
| Edit Object
| bgcolor="grey" | unknown
| bgcolor="grey" | unknown
| bgcolor="lime" | yes
| bgcolor="red" | yes
|-
| Delete Object
| bgcolor="grey" | unknown
| bgcolor="grey" | unknown
| bgcolor="lime" | yes
| bgcolor="red" | yes
|-
| Add/Remove to Object's Inventory
| bgcolor="grey" | unknown
| bgcolor="grey" | unknown
| bgcolor="lime" | yes
| bgcolor="red" | yes
|}

-- note --
new objects had to be rezzed for each change in permissions for a test - new permissions settings did not apply to existing objects
[[Category:Development]]

Connecting

2011-09-09T16:17:26Z

KatherineDaniels:

__NOTOC__
{{Quicklinks}}
 

==Obtaining OpenSim Available Viewers==
'''OpenSimulator doesn't have the client program in its distribution.''' You'll need to download an OpenSim compatible client before connecting to OpenSim grids.
{{:Compatible Viewers}}

Some other viewers that can connect to Second Life can also connect to OpenSim. You can find them in [http://wiki.secondlife.com/wiki/Downloads Downloads#Second Life Wiki].

==Connecting to the Grid with Grid Selector (Recommended) ==

If you can find the grid you want to connect in the grid selector (The dropdown menu at the bottom of the screen to the right of the login button. If you can't find it, try Ctrl-Shift-G), then simply choose it and enter username/password provided by the grid administrators when you created your account on the grid.

'''Basically, you can't login to OpenSim grids with other grid's accounts, including Second Life. You need to create separate accounts for each grids you want to login.''' When you choose the grid, some viewers shows the link to signup page, so create your account as per its instructions.

If you can't, then lookout for the Grid Manager interface. If there is, you can find it near the grid selector or in preference window. Usually, the only fields you have to fill in are:

* '''Grid Name''' (or alike) - The name you can easily identify. OpenSim grids doesn't use this information, so you can name it freely.
* '''Login URI''' - The most important information.<nowiki> It should be like "http://someserver:9000" or "http://someserver:8002". For instance, for osgrid, this is "http://login.osgrid.org/".</nowiki>

You will find the button "Get Grid Info" or alike. If you click it, it might fill other blank fields with some URIs, or show error dialog, or freeze. If you have problem with this button, don't click it and leave other fields empty. This problem is not so much an issue. It works anyway without them.

If it succeed, you will find the new entry in the grid selector.

For detailed instructions, see the documentation for each viewer.

==Connecting to the Grid with Viewer Parameter==

If you can't find grid selector, or you can find it but can't find the grid you want to login in the list and can't find grid manager, there are some other methods.

In any case, all you have to do is to pass this '''loginuri''' command line parameters to the viewer and launch with it. If you are using Second Life Viewer or Snowglobe-based viewers, see [http://wiki.secondlife.com/wiki/Viewer_parameters#Using_Viewer_parameters this wiki page (Viewer parameters#Using Viewer Parameters)] how to do that. The Linden viewer has a number of other options. Some are useful, some are not. See [http://wiki.secondlife.com/wiki/Viewer_parameters#Parameter_reference Parameter Reference from Second Life Wiki] for detail.

For example, Second Life Viewer on Windows, and want to connect to OSGrid, quick-and-easy way would be like that:
<pre>
SecondLife.exe -loginuri <nowiki>http://login.osgrid.org/ -loginpage http://www.osgrid.org/splash/</nowiki>
</pre>

On OSX, you can even use ActionScript, which enables you to select multiple grid to connect to. [[OSX_Grid_Selector_Script]]

==Connecting to your locally hosted server from behind a DSL router using NAT==

Loopback 
Most DSL routers/modems prevent loopback connections as a security feature. This means that a NATed IP address ( such as 192.168.2.40 ) can not connect to your forward facing IP address ( such as 199.149.252.44 ) from behind your DSL router/modem. In a case like this, external IP addresses may connect to your server/region but you can not ( this applies to both standalone and grid modes ).

List of routers featuring NAT Loopback : [[NAT_Loopback_Routers]]

Router solution 
If you are using a ZyXEL DSL router/modem from Embarq, please read [[Network Settings#Local connections with ZyXEL DSL modem/router and NAT/Port Forwarding|this guide]]. This will show you how to reconfigure your DSL router/modem to fix this problem. Similar solutions may exist for other DSL router/modems. A google search for the make and model of your DSL router/modem may provide you with a [http://www.mycaal.com/ loan modification] manual to assist you in this.

A word of caution : be VERY careful what you change and take good notes along the way so you can undo any changes you make in error.

DNS solution(Linux) 
It's possible to host your own DNS-server, so you can prevent some of the dns-naming problems mentioned before. If <nowiki>http://example.org</nowiki> resolves to the external ip, and that loopback connection is prevented by your router, you could point your resolv.conf to a local nameserver like:
nameserver 192.168.2.2
Now you need bind/named installed in order to handle the dns-requests. You can find a bind example configfile here.

== Alternative Connection Approaches ==

=== Via a Web Browser ===

You can also set up a [[Browser Protocol Handler]] which will make opensim:// links in your browser do the expected thing, and launch the right OpenSim viewer.

Database Settings

2011-09-09T16:15:00Z

KatherineDaniels:

{{Quicklinks}}
__NOTOC__

If you want to quick know the walkthrough for database setup, see [[#Quick Setup]].

= Structure =

On OpenSim 0.7.1 or later, you need to set '''StorageProvider''' and '''ConnectionString''' for each data services (e.g. region database, asset service, inventory service) in the config files in config-include/. Usually you'll need to edit '''StandaloneCommon.ini''' for standalone or '''GridCommon.ini''' for grid mode.

In those files, you'll find [DatabaseService] section, which parameters control the parameters of data services in general. Only you have to care about are these two lines below:

<pre>
StorageProvider = "OpenSim.Data.MySQL.dll"
ConnectionString = "Data Source=localhost;Database=opensim;User ID=opensim;Password=***;Old Guids=true;"
</pre>

In this case, it will connect to the database which can access by the connection string "Data Source=localhost;Database=opensim;User ID=opensim;Password=***;Old Guids=true;" using the provider module named "OpenSim.Data.MySQL.dll".

Or, you can include another ini files. You'll find a line like that:
<pre>
Include-Storage = "config-include/storage/SQLiteStandalone.ini";
</pre>
It means it will go on to read config-include/storage/SQLiteStandalone.ini after reading this ini file. If you open SQLiteStandalone.ini file, you'll find StrageProvider and [http://www.mycaal.com/ loan modification] ConnectionString lines in each sections.

'''NOTE: There had been another way to connect to MSSQL database, which was using "mssql_connection.ini" in bin/ directory. On OpenSim 0.7.1 or later, it will NOT be read even if you set it properly. Use ConnectionString in *Common.ini instead. For more specific details, see the section [[#MSSQL]].'''

== Database Parameters ==

{|border="1" cellspacing="0"
|- style="background-color:#DDDDFF;"
| Parameter
| Possible Values
| Description

|-
| StorageProvider
| "OpenSim.Data.SQLite.dll" (SQLite) "OpenSim.Data.MySQL.dll" (MySQL) "OpenSim.Data.MSSQL.dll" (Microsoft SQL Server) "OpenSim.Data.Null.dll" (disable persistence)
| The name of the storage provider modules, which can be found in bin/ folder. The three above are which OpenSim officialy (partially) supports but if you have another providers, you can freely put its name in it. If you choose "OpenSim.Data.Null.dll", OpenSimulator will keep all data in its memory instead of using DBMS.

|-
| ConnectionString
| See [[#ConnectionString Syntax]]
| A string that OpenSim specifies information about a data source. Usually it may include the hostname or ip addresses of database server, database service names, username, schema name and [http://www.proposable.com proposal software] password. The syntax varies between databases.

|-
| EstateConnectionString
| See [[#ConnectionString Syntax]]
| The same as ConnectionString, but it will be used only for Estate Service. (optional)
|}

== ConnectionString Syntax ==

=== MySQL ===

''Data Source=[1];Database=[2];User ID=[3];Password=[4];Old Guids=true;''

*[1] The hostname or ip address of database server
*[2] Database name
*[3] Username for the database above
*[4] Password for the user above

Example: If you have created the database "opensim" in localhost, and then created
the user "opensimuser" and its password is "opensimpassword", it will be:
<pre>
ConnectionString = "Data Source=localhost;Database=opensim;User ID=opensimuser;Password=opensimpassword;Old Guids=true;"
</pre>

=== SQLite ===

''URI=file:[1],version=3,UseUTF16Encoding=True;''

*[1] The path to the database file (relative to the bin/ directory - If there is no file on this path, it will be created automatically)

Example: If you want to create the database for Inventory Service in the directory "bin/db", it will be:
<pre>
ConnectionString = "URI=file:db/inventory.db,version=3,UseUTF16Encoding=True"
</pre>

=== MSSQL ===

''Server=[1];Database=[2];User Id=[3]; password=[4];''

*[1] "servername\instance name" - You can see this string in SQL Server Managerment Studio login dialog(Server:).
*[2] Database name
*[3] Username for the database above
*[4] Password for the user above

Example: If you have installed Microsoft SQL Server Express Edition with default settings on your local machine
, created the database "opensim" in localhost, and [http://www.bestpills4weightloss.com/ weight loss pills for women] then created the user "opensimuser" and its password is "opensimpassword", it will be:
<pre>
ConnectionString = "Server=localhost\SQLEXPRESS;Database=opensim;User Id=opensimuser; password=opensimpassword;"
</pre>

== Using Multiple Storages ==

Currently there are several services in OpenSim.
*[InventoryService]
*[AssetService]
*[AvatarService]
*[AuthenticationService]
*[UserAccountService]
*[GridUserService]
*[FriendsService]
*[EstateDataStore]
*[SimulationDataStore]
*[PresenceService]
*[AuthorizationService]
*[GridService]

You can use different storage for some service by overriding the same propaties in the section for those service. For example, if you are using OpenSim standalone and want to use MySQL 'opensim' in general but MySQL 'opensim2' for Inventory Service and MSSQL for Authentication Service, you'll need to write in StandaloneCommon.ini like that:

<pre>
[DatabaseService]
StorageProvider = "OpenSim.Data.MySQL.dll"
ConnectionString = "Data Source=localhost;Database=opensim;User ID=opensim;Password=***;Old Guids=true;"
...
[InventoryService]
ConnectionString = "Data Source=localhost;Database=opensim2;User ID=opensim;Password=***;Old Guids=true;"
...
[AuthenticationService]
...(another parameters for authentication service)...
StorageProvider = "OpenSim.Data.MSSQL.dll"
ConnectionString = "Data Source=(local);Database=opensim;User=opensim;password=********;"
</pre>

If OpenSim can't find StorageProvider or ConnectionString in each service's section, it will use those in [DatabaseService] section. If OpenSim find each or them, it will use the parameter in each service's section. Thus, then the settings in these sections override those in [DatabaseService] section.

In this case, Inventory Service will:
*read [DatabaseService]StorageProvider
*read [DatabaseService]ConnectionString -> read [InventoryService]ConnectionString and override

Ahthentication Service will:
*read [DatabaseService]StorageProvider -> read [AuthenticationService]StorageProvider and override
*raad [DatabaseService]ConnectionString -> read [AuthenticationService]ConnectionString and override

Note: SQLite and MSSQL providers don't support some services.

Note: For Estate Service, there is another parameter EstateConnectionString in [DatabaseService]. It is the middle priority between [DatabaseService] and [EstateDataStore] ConnectionStrings. OpenSim reads ConnectionString in [DatabaseService] section first, next EstateConnectionString, finally ConnectionString in [EstateDataService] section and overrides.

= Quick Setup =

== SQLite Walkthrough ==

By default, OpenSim will automatically create its SQLite database files(*.db) in bin/ directory. You don't need to do anything generally.
If you want to create the database files in another directory, you can change by editing ConnectionString in bin/config-include/storage/SQLiteStandalone.ini included by config-include/*Commons.ini. See [[#SQLite]] section for the detailed syntax.

== MySQL Walkthrough ==

=== Download ===
Download and install "MySQL Community Server" from [http://dev.mysql.com/downloads/mysql/ MySQL Downloads Page]. On Linux, you can even fetch "mysql-server" or "mysql-community-server" with your native package manager.

=== Installing MySQL Server ===
On Windows:
Download MSI and run it. Select "Typical". After installation, it will launch "MySQL Server Instance Configuration Wizard". Select "Standard Configuration". In the next screen, you might be happy later if you check "Include Bin Directory in Windows PATH". In the next screen, provide mysql root password. It will complete settings for mysql and startup its service automatically. See [http://dev.mysql.com/doc/refman/5.5/en/windows-installation.html MySQL Documentation] for more details.

On Mac OS X:
Download DMG package and install it normally. After install the server package, you can even install MySQL Startup Item if you want MySQL to start automatically during system startup. After that, startup your MySQL by following commands. See [http://dev.mysql.com/doc/refman/5.5/en/macosx-installation.html MySQL Documentation] for more details.
<pre>
$ cd /usr/local/mysql
$ sudo ./bin/mysqld_safe
(enter your password, if necessary)
(press ctrl-Z)
$ bg
(press ctrl-D or enter "exit" to exit the shell)
</pre>

On Linux:
RPM install the downloaded package or install "mysql-server" or "mysql-community-server" with your package manager. For more instructions for installation, see [http://dev.mysql.com/doc/refman/5.5/en/linux-installation.html MySQL Documentation]. After that, startup your MySQL with following command.
<pre>
$ /etc/init.d/mysqld start
</pre>

If you want to startup MySQL server automatically, see [http://dev.mysql.com/doc/refman/5.5/en/automatic-start.html 2.10.1.2. Starting and Stopping MySQL Automatically in MySQL 5.5 Reference Manual].

=== Creating MySQL Database ===
Now you can configure your MySQL with the command line tools.
<pre>
$ mysql -u root --password
(enter your password, or if you haven't set password for MySQL server, type "mysql -u root" instead)
</pre>
You can even use MySQL Command Line Client on Start menu on Windows. After login, create user and database for OpenSim.
<pre>
mysql> create database opensim;
mysql> use opensim;
mysql> create user 'opensimuser'@'localhost' identified by 'opensimpassword';
mysql> grant all on opensim.* to 'opensimuser'@'localhost';
mysql> quit
</pre>

=== Configuring OpenSim ===
Open StandaloneCommon.ini or GridCommon.ini with your editor. First, comment-out the line for SQLite.
<pre>
; SQLite
;Include-Storage = "config-include/storage/SQLiteStandalone.ini";
</pre>
After that, uncomment StorageProvider and ConnectionString property lines in [DatabaseService] section and change the line like that:
<pre>
; MySql
StorageProvider = "OpenSim.Data.MySQL.dll"
ConnectionString = "Data Source=localhost;Database=opensim;User ID=opensimuser;Password=opensimpassword;Old Guids=true;"
</pre>

Save and start OpenSimulator. It will access to your new MySQL database instead of the default SQLite databases.

== MSSQL Walkthrough ==

=== Download ===
To download Microsoft SQL Server 2008 Express edition: [http://www.microsoft.com/Sqlserver/2008/en/us/express.aspx]
Make sure you download Microsoft SQL Server 2008 Express with Tools ([http://www.microsoft.com/downloads/details.aspx?FamilyId=7522A683-4CB2-454E-B908-E805E9BD4E28]) since you will likely want a nice tool to work with your database. If you already downloaded Microsoft SQL Server before, skip to "Checking Instance Configurations" step.

=== Installing Microsoft SQL Server ===
Double-click the downloaded executable and select click Installation and "New SQL Server stand-alone installation or add features to an existing installation". It will start installation process, you only need to click "OK", "Next" or "Install" until you come across the "Feature Selection". In this screen, you need to check "Database Engine Service" and "Management Tools - Basic", then click "Next". In next screen "Instance Configuration", check what is filled in "Named instance:" property - you will later use this later. For example, for default Express Edition, you'll see "SQLEXPRESS". Click "Next". Then go on default until you reach "Server Configuration". In this screen, fill in Account Name and Password field with you windows login name and password. In next "Database Engine Configuration" screen, you will need to enable '''Mixed Mode'''. After that provide password, click "Add Current User", and then continue clicking "Next" or "OK" until it completes the installation process. After that, you'll find the entry "SQL Server Managerment Studio" in "Microsoft SQL Server 2008" on the Windows Start menu. Open it and click "connect" to connect to your instance.

=== Checking Instance Configurations ===
Right-click on your database server in Management Studio and select Properties, then go to the Security tab and select '''SQL Server and Windows Authentication mode''', click OK. If you have already installed SQL Server before and you find "Windows Authentication mode" enabled instead, change it.

=== Creating User for Database ===
Expand the Security node, then right-click the Logins node. Select "New Login..." to open "Login - New" dialog. In this screen, fill "Login name" with the string whatever you like, select "SQL Server authentication", give it a strong password, uncheck "User must change password at next login", and click "OK". In this tutorial, we'll assume you have typed "opensimuser" for Login name, and "opensimpassword" for password.

=== Creating Database ===
Right-click on the Databases node and and select "New Database..." to open "New Database" dialog. In "Database name" field, you provide any names for the new database, which we'll assume is "opensim". In "Owner" field, provide the name of newly created database user("opensimuser" in this tutorial). Accept all defaults and click "OK".

=== Configuring OpenSim ===
Open StandaloneCommon.ini or GridCommon.ini with your editor. First, comment-out the line for SQLite.
<pre>
; SQLite
;Include-Storage = "config-include/storage/SQLiteStandalone.ini";
</pre>
After that, add these line in [DatabaseService] section. As of OpenSim 0.7.1, there is no sample configurations for MSSQL(Microsoft SQL Server), so you need to add them by yourself.
<pre>
; MSSQL
StorageProvider = "OpenSim.Data.MSSQL.dll"
ConnectionString = "Server=localhost\SQLEXPRESS;Database=opensim;User Id=opensimuser; password=opensimpassword;"
</pre>

Save and start OpenSimulator. It will access to your new SQL Server database instead of the default SQLite databases.

[[Category:Database]]