<<Previous Section Tutorial Start Next Section>>
In part 4 of this tutorial, we will finally get into some Opensim s**t. After a few edits to some config files you will be ready login to your own sim.
Step 1 - Install (Unzip) Opensim
Installing Opensim is not really like installing a regular application at this point. There is no click though forehead installer. However, installation cannot be easier. Simply upzip/extract the zip file it comes in. For me the zip file I downloaded was opensim-bin-0.5.8. After extracting, I had a directory named opensimbin. Note, this was different from 0.5.5 where there was an opensim/bin directory structure.
Step 2 - Find and Rename the MySQL Connection Initialization file.
The first thing we need to do is tell Opensim where to find the MySQL database and how to connect to it. Find the file mysql_connection.ini.example.
NOTE: You may only see mysql_connection.ini. In reality this file is actually named mysql_connection.ini.example. You may not see the .example unless you have enabled file types. If you have not enabled file types in Vista then do so. To do this select the opensimbin folder and then from the Windows Explorer menu select “Organize” and then “Folder and Search Options” from the drop-down list. Go to the “View” tab and uncheck “Hide Extensions for Known File Types”.
We want to change this from an example to the real thing, so create a copy and rename it to “mysql_connection.ini”. Accept the change when Windows complains about changing the file type.
WARNING: Rename the mysql not mssql file. I’ve gotten the wrong one several times. Not mSsql file, rather mYsql.
Step 3 - Edit the mysql_connection.ini file
Now that you have created the mysql connection file let’s edit it and tell it how to reach our database. Open the mysql_connection.ini file using whatever editing program you like. I’d suggest wordpad as it deals with line wrapping pretty well. There are only a few lines to edit.
- hostname=localhost
- database=<name of your database, mine was opensimdb>
- username=<name of your user, mine was opensimdbuser>
- password=<password you set for this user>
Step 4 - Find and Rename the OpenSim Initialization File
The next part of the configuration is to tell Opensim to use MySQL vs. other databases. We need to copy and rename the example initialization file like we did in step 2. Find the file OpenSim.ini.example. Copy it and rename it to “OpenSim.ini”. Tell Windows to bug off and accept what you are trying to do.
Step 5 - Edit OpenSim.ini
There are several changes we want to make in this file. The main one is to tell Opensim to use MySQL as the datastore for everything. The second one is to enable the more sophisticated physics engine. If you don’t you won’t be able to walk on any prim, instead you will just walk through the prims.
Find and replace the following items:
- Change the storage plugin from Null to MySQL
- Change: storage_plugin = “OpenSim.Data.Null.dll”
- To: storage_plugin=”OpenSim.Data.MySQL.dll”
- Add a semi-colon to the following line (this comments the line out or tells Opensim to ignore it).
- storage_connection_string=”URI=file:OpenSim.db,version=3″
- Remove the semi-colon on the following line and add your database information.
- ;storage_connection_string=”Data Source=localhost;Database=opensim;User ID=opensim;Password=*****;”;
- storage_connection_string=”Data Source=localhost;Database=<your db>;User ID=<your user>;Password=<yourpassword>;”;
- Comment out (add a semi-colon to the front of basic physics and uncomment out OpenDynamicsEngine). IT should look like this when you are done.
- ; Choose one of the physics engines below
- ;physics = basicphysics
- ;physics = POS
- physics = OpenDynamicsEngine
- ;physics = modified_BulletX
- Change the inventory plugin to MySQL and add a inventory_source string for MySQL. It should look like the following:
- ; Inventory database provider
- ; inventory_plugin = “OpenSim.Data.SQLite.dll”
- inventory_plugin = “OpenSim.Data.MySQL.dll” <– Change to MySQL
- ; inventory_plugin = “OpenSim.Data.NHibernate.dll” ; for nhibernate
- ; Inventory Source NHibernate Example (DIALECT;DRIVER;CONNECTSTRING)
- ; inventory_source = “SQLiteDialect;SqliteClientDriver;URI=file:Inventory.db,version=3″ <– Comment out by adding a semi-colon
- inventory_source=”DataSource=localhost;Database=<your db>;User ID=<your user>;Password=<your password>;”; <– Added this line
- Do the same thing for Asset and User sections (change the plugin and add the following lines
That’s it! Next, lets fire up that new server.

13 comments
Comments feed for this article
Trackback link
http://www.virtualwhite.com/wp-trackback.php?p=16
August 9, 2008 at 11:05 am
Pingback from Adam Frisby » Blog Archive » Resources for running your own OpenSim.
July 15, 2008 at 7:03 pm
spitz
so close…and then you left us hanging for the last section! you mean I have to try to fire up this beast by myself???
July 15, 2008 at 8:30 pm
bwhite
Sorry Spitz, got distracted by work and Google’s Lively launch. Part 5 went up last night. Let me know if it works for you.
July 19, 2008 at 4:17 pm
spitz
Miracle never cease…I was actually able to use your information, parse it together with some other stuff from other kind folks on the web…and was able to bring up my OpenSIM on Vista!!!
I was even able to figure out how to connect my 2 XP boxex to the same SIM! There was a bit more port forwarding/router stuff involved than I was used to, but it worked. I now have 3 Ruths standing on top of a mountain staring at each other!
Now the fun part of connecting them to the OS Grid
Thanks for your help!
August 1, 2008 at 2:21 am
Mike McKay
Thanks so much for this. You step by step has been very easy to follow.
I ran into a snag at the end here though but figured it all out and got me a Ruth.
I’m running Windows XP & .NET 3.5. Here’s a few things others can look out for:
1) Biggest one is the quotation marks. When I clicked on OpenSim.exe in the /bin folder after making the proper changes in the two files I came to the database section and got a bunch of red lines in the DOS window and then it crashed ?DataSource…. I noticed the quotation marks were the problem. retyped them and no problem.
2) After the scripts setup the database and initialize, you have to enter a few things, then you can open the SecondLife viewer via the command line instruction in the next section. The server needs to be running before you can log in.
3) When you log in with the Second Life viewer, just type your new login name and password (made in the DOS window when it all compiles) in the normal boxes, not the white boxes in the center of the screen. It worked better for me.
Just a couple points. Feel free to edit my comment bwhite.
Best
Mike
aka Professor Merryman in SL
August 1, 2008 at 2:43 am
Mike McKay
I don’t get the white boxes in the middle of the viewer anymore..hehe
August 1, 2008 at 10:43 am
bwhite
Glad to hear this was helpful Mike, thanks for the comments, looks like this works on XP as well.
August 3, 2008 at 2:54 pm
seo blog
That was a well written article, very interesting,thank you for a good read.
August 6, 2008 at 8:57 pm
California Condor
In the OpenSim.ini, straight double quotes rather than slanted double quotes should be used or else errors will be generated.
August 30, 2008 at 12:27 am
J W B
Thanks for this great tut. I am getting a good grasp of opensim config from you. I believe we are watching the building of something great right before our very eyes. Inter-connected Virtual Worlds have the potential along with a Semantic web to redefine the web. I personally hope 3D Virtual/Augmented Reality plays a role in Web 3.0
This could be some of the most exciting stuff I have seen on the Internet in a long time.
August 10, 2009 at 9:25 pm
Bubbzilla
Im install version 0.6.6 of OpenSim, and I cant find the mysql_connection.ini.example file anywhare. any advice?
October 31, 2009 at 9:10 am
Fred
0.6.8 also has no mysql_connection.ini
Now I’m stymied
November 13, 2009 at 9:26 am
Anonymous
Ditto for me. Apparently this file went away. So…. ???