<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Below is my OpenSim.ini file for using MySQL running in standalone mode
for 0.5.0, with MySQL on the same box as opensim. You will need to put
your password for MySQL root user, or whatever user you're using. I
had to create the empty database, "opensim" before everything would
work. Then, remember to GRANT ALL privileges to your userName for the
opensim database, and then FLUSH PRIVILEGES.<br>
<br>
I had to add these lines to the example file that came with the
installer to make it work. This tripped me up, and caused the SQLite
activity in the log at startup. They are included in my OpenSim.ini
below<br>
asset_database = "mysql"<br>
asset_plugin = "OpenSim.Framework.Data.MySQL.dll"<br>
<br>
I hope this helps.....Fish<br>
<br>
<br>
<br>
;****BEGIN*****<br>
[Startup]<br>
gridmode = false<br>
<br>
;##########<br>
; MESHER<br>
;##########<br>
; Select a mesher here. ZeroMesher is save and fast.<br>
; ZeroMesher also means that the physics engine models the physics of
prims<br>
; sticking to the basic shapes the engine does support. Usually this is
only a box.<br>
; Meshmerizer gives a better handling of complex prims by using
triangle meshes.<br>
; Note, that only ODE physics currently deals with meshed prims in a
satisfactoring way<br>
; <br>
;meshing = ZeroMesher<br>
meshing = Meshmerizer<br>
<br>
<br>
;##########<br>
; PHYSICS<br>
;##########<br>
; Choose one of the physics engines below<br>
;physics = basicphysics<br>
;physics = POS<br>
;physics = modified_BulletX<br>
physics = OpenDynamicsEngine<br>
<br>
; if you would like to allow prim to be physical and move by physics
with the physical checkbox in the client set this to true.<br>
physical_prim = true<br>
<br>
<br>
;##########<br>
; STORAGE<br>
;##########<br>
; *** Prim Storage - only leave one storage_plugin uncommented ***<br>
; ****************************************************************<br>
; --- The NullStorage stores nothing - effectively disabling
persistence:<br>
; storage_plugin = "OpenSim.DataStore.NullStorage.dll"<br>
<br>
; --- To use sqlite as region storage:<br>
;storage_plugin = "OpenSim.Framework.Data.SQLite.dll"<br>
;storage_connection_string="URI=<a class="moz-txt-link-freetext" href="file:OpenSim.db,version=3">file:OpenSim.db,version=3</a>";<br>
<br>
; --- To use MySQL storage, supply your own connectionstring (this is
only an example):<br>
; note that the supplied account needs create privilegies if you
want it to auto-create needed tables.<br>
storage_plugin="OpenSim.Framework.Data.MySQL.dll"<br>
storage_connection_string="Data Source=127.0.0.1;Database=opensim;User
ID=root;Password=yourMySQLPasswordHere;";<br>
<br>
startup_console_commands_file = "startup_commands.txt"<br>
shutdown_console_commands_file = "shutdown_commands.txt"<br>
serverside_object_permissions = true<br>
<br>
; Select the type of database to use for asset storage<br>
;asset_database = "db4o"<br>
;asset_database = "sqlite"<br>
;asset_database = "grid"<br>
;asset_database = "mssql"<br>
asset_database = "mysql"<br>
<br>
verbose = true<br>
<br>
<br>
;##########<br>
; SCRIPTING<br>
;##########<br>
; ScriptEngine<br>
script_engine = OpenSim.Region.ScriptEngine.DotNetEngine.dll<br>
;Experimental remote ScriptServer plugin:<br>
;script_engine = OpenSim.Region.ScriptEngine.RemoteServer.dll<br>
<br>
; To run a script every few minutes, set the script filename here<br>
; timer_Script = "filename"<br>
<br>
[StandAlone]<br>
accounts_authenticate = true<br>
welcome_message = "Hello, Avatar! Welcome to OpenSim!"<br>
<br>
;inventory_plugin = "OpenSim.Framework.Data.SQLite.dll"<br>
inventory_plugin = "OpenSim.Framework.Data.MySQL.dll"<br>
<br>
;userDatabase_plugin = "OpenSim.Framework.Data.SQLite.dll"<br>
userDatabase_plugin = "OpenSim.Framework.Data.MySQL.dll"<br>
<br>
; ***Added this section on 2008-03-02.......Fish<br>
;asset_plugin = "OpenSim.Framework.Data.SQLite.dll"<br>
asset_plugin = "OpenSim.Framework.Data.MySQL.dll"
<br>
<br>
default_location_x = 1000<br>
default_location_y = 1000<br>
dump_assets_to_file = false<br>
<br>
<br>
[Network]<br>
http_listener_port = 9000<br>
remoting_listener_port = 8895<br>
<br>
; Uncomment below to enable llRemoteData/remote channels<br>
; remoteDataPort = 20800<br>
<br>
grid_server_url = <a class="moz-txt-link-rfc2396E" href="http://127.0.0.1:8001">"http://127.0.0.1:8001"</a><br>
grid_send_key = "null"<br>
grid_recv_key = "null"<br>
<br>
user_server_url = <a class="moz-txt-link-rfc2396E" href="http://127.0.0.1:8002">"http://127.0.0.1:8002"</a><br>
user_send_key = "null"<br>
user_recv_key = "null"<br>
<br>
asset_server_url = <a class="moz-txt-link-rfc2396E" href="http://127.0.0.1:8003">"http://127.0.0.1:8003"</a><br>
<br>
inventory_server_url = <a class="moz-txt-link-rfc2396E" href="http://127.0.0.1:8004">"http://127.0.0.1:8004"</a> <br>
<br>
[Chat]<br>
whisper_distance = 10<br>
say_distance = 30<br>
shout_distance = 100<br>
<br>
; Uncomment the following for IRC bridge<br>
; experimental, so if it breaks... keep both parts... yada yada<br>
; also, not good error detection when it fails<br>
;[IRC]<br>
;server = irc.freenode.net<br>
;nick = OSbot<br>
;channel = #innovatieproject <br>
<br>
; Uncomment the following to control the progression of daytime<br>
; in the Sim. The defaults are what is shown below<br>
[Sun]<br>
; number of wall clock hours for an opensim day. 24.0 would mean
realtime<br>
day_length = 0.5 <br>
<br>
; send a Sun update ever frame_rate # of frames. A lower number will<br>
; make for smoother sun transition at the cost of network<br>
;frame_rate = 100<br>
<br>
;****END*****<br>
<br>
<br>
Joe Greene wrote:
<blockquote
cite="mid:20080310002028.giuztv6fqc08ko08@www.greenemyst.com"
type="cite">
<p>Problem Desc: Opensim [ASSET SERVER] appear to be attempting to
open and
SQLitew database althoguh no such reference appears (even in comments)
in my
OpenSim.ini file. As I'm using MySQL (both the OpenSim.ini and the
mysql_connection.ini) I have no SQLite installed. Any suggestions on
what I'm
doing wrong, or shall I submit my OpenSim.ini</p>
<p>Version Info:<br>
SuSe Enterprise 9.3 ( with updates )<br>
Mono: Mono JIT compiler version
1.2.6 (Installed via YAST from Mono Site)<br>
MySQL: 4.1.10a</p>
<p>libode
0.9-25</p>
<p>Console Log:</p>
<p>opensim@opensim1:~/bin> mono OpenSim.exe<br>
OpenSim 0.5, SVN build <br>
<br>
Performing compatibility checks...
Environment is compatible.<br>
<br>
Starting...<br>
<br>
ERROR: There was
an error while scanning assembly: /opt/opensim-0.5.1-release/bi<br>
n/PhysX-wrapper.dll (Could not load file or assembly
'/opt/opensim-0.5.1-release<br>
/bin/PhysX-wrapper.dll' or one of its
dependencies. An attempt was made to load <br>
a program with an incorrect
format.)<br>
ERROR: There was an error while scanning assembly:
/opt/opensim-0.5.1-release/bi<br>
n/ode.dll (Could not load file or assembly
'/opt/opensim-0.5.1-release/bin/ode.d<br>
ll' or one of its dependencies. An
attempt was made to load a program with an in<br>
correct format.)<br>
ERROR:
There was an error while scanning assembly:
/opt/opensim-0.5.1-release/bi<br>
n/openjpeg-libsl.dll (Could not load file or assembly
'/opt/opensim-0.5.1-releas<br>
e/bin/openjpeg-libsl.dll' or one of its
dependencies. An attempt was made to loa<br>
d a program with an incorrect
format.)<br>
ERROR: There was an error while scanning assembly:
/opt/opensim-0.5.1-release/bi<br>
n/sqlite3.dll (Could not load file or
assembly '/opt/opensim-0.5.1-release/bin/s<br>
qlite3.dll' or one of its
dependencies. An attempt was made to load a program wi<br>
th an incorrect
format.)<br>
00:14:21 -
====================================================================<br>
00:14:21 - ========================= STARTING OPENSIM
=========================<br>
00:14:21 -
====================================================================<br>
Creating new local console<br>
00:14:21 - [Region]: Started at 3/10/2008
12:14:21 AM<br>
00:14:22 - [DATASTORE]: Attempting to load
OpenSim.Framework.Data.MySQL.dll<br>
00:14:22 - [DATASTORE]: MySql -
connecting: Data Source=localhost;Database=opens<br>
im;User
ID=opensim;Password=******;<br>
00:14:23 - [DATASTORE]: Added IRegionDataStore
Interface<br>
00:14:23 - [ASSET SERVER]: Starting asset storage system<br>
00:14:23 - [SQLAssetServer]: AssetStorage: Attempting to load
OpenSim.Framework.<br>
Data.SQLite.dll<br>
[APPLICATION]: <br>
APPLICATION
EXCEPTION DETECTED: System.UnhandledExceptionEventArgs<br>
<br>
Exception:
System.DllNotFoundException: libsqlite3.so.0<br>
at (wrapper
managed-to-native) Mono.Data.SqliteClient.Sqlite:sqlite3_open16 (s<br>
tring,intptr&)<br>
at Mono.Data.SqliteClient.SqliteConnection.Open ()
[0x00000] <br>
at OpenSim.Framework.Data.SQLite.SQLiteAssetData.Initialise
(System.String dbf<br>
ile, System.String dbname) [0x00000] <br>
at
OpenSim.Framework.Data.SQLite.SQLiteAssetData.Initialise () [0x00000] <br>
at OpenSim.Framework.Communications.Cache.SQLAssetServer.AddPlugin
(System.Str<br>
ing FileName) [0x00000] <br>
at
OpenSim.Framework.Communications.Cache.SQLAssetServer..ctor
(System.String <br>
pluginName) [0x00000] <br>
at OpenSim.OpenSimMain.Initialize () [0x00000]
<br>
at OpenSim.Region.ClientStack.RegionApplicationBase.StartUp ()
[0x00000] <br>
at OpenSim.OpenSimMain.StartUp () [0x00000] <br>
at
OpenSim.Application.Main (System.String[] args) [0x00000] <br>
<br>
Application is terminating: True<br>
</p>
<p><br>
-- <br>
Joe Greene<br>
UNIX Systems, Network and IT Specialist<br>
If you aren't having fun, you're doing the wrong thing!<br>
All opinions expressed are mine alone. You Can't Have them!<br>
<br>
<br>
</p>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
Opensim-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Opensim-users@lists.berlios.de">Opensim-users@lists.berlios.de</a>
<a class="moz-txt-link-freetext" href="https://lists.berlios.de/mailman/listinfo/opensim-users">https://lists.berlios.de/mailman/listinfo/opensim-users</a>
</pre>
</blockquote>
<br>
</body>
</html>