[Opensim-users] OpenSim 0.5.1 Release won't start

Mon Mar 10 06:22:08 UTC 2008

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.

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
   asset_database = "mysql"
   asset_plugin = "OpenSim.Framework.Data.MySQL.dll"

I hope this helps.....Fish

;****BEGIN*****
[Startup]
gridmode = false

;##########
; MESHER
;##########
; Select a mesher here. ZeroMesher is save and fast.
; ZeroMesher also means that the physics engine models the physics of prims
; sticking to the basic shapes the engine does support. Usually this is
only a box.
; Meshmerizer gives a better handling of complex prims by using triangle
meshes.
; Note, that only ODE physics currently deals with meshed prims in a
satisfactoring way
;
;meshing = ZeroMesher
meshing = Meshmerizer

;##########
; PHYSICS
;##########
; Choose one of the physics engines below
;physics = basicphysics
;physics = POS
;physics = modified_BulletX
physics = OpenDynamicsEngine

; 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.
physical_prim = true

;##########
; STORAGE
;##########
; *** Prim Storage - only leave one storage_plugin uncommented ***
; ****************************************************************
; --- The NullStorage stores nothing - effectively disabling persistence:
; storage_plugin = "OpenSim.DataStore.NullStorage.dll"

; --- To use sqlite as region storage:
;storage_plugin = "OpenSim.Framework.Data.SQLite.dll"
;storage_connection_string="URI=file:OpenSim.db,version=3";

; --- To use MySQL storage, supply your own connectionstring (this is
only an example):
;     note that the supplied account needs create privilegies if you
want it to auto-create needed tables.
storage_plugin="OpenSim.Framework.Data.MySQL.dll"
storage_connection_string="Data Source=127.0.0.1;Database=opensim;User
ID=root;Password=yourMySQLPasswordHere;";

startup_console_commands_file = "startup_commands.txt"
shutdown_console_commands_file = "shutdown_commands.txt"
serverside_object_permissions = true

; Select the type of database to use for asset storage
;asset_database = "db4o"
;asset_database = "sqlite"
;asset_database = "grid"
;asset_database = "mssql"
asset_database = "mysql"

verbose = true

;##########
; SCRIPTING
;##########
; ScriptEngine
script_engine = OpenSim.Region.ScriptEngine.DotNetEngine.dll
;Experimental remote ScriptServer plugin:
;script_engine = OpenSim.Region.ScriptEngine.RemoteServer.dll

; To run a script every few minutes, set the script filename here
; timer_Script = "filename"

[StandAlone]
accounts_authenticate = true
welcome_message = "Hello, Avatar!  Welcome to OpenSim!"

;inventory_plugin = "OpenSim.Framework.Data.SQLite.dll"
inventory_plugin = "OpenSim.Framework.Data.MySQL.dll"

;userDatabase_plugin = "OpenSim.Framework.Data.SQLite.dll"
userDatabase_plugin = "OpenSim.Framework.Data.MySQL.dll"

; ***Added this section on 2008-03-02.......Fish
;asset_plugin = "OpenSim.Framework.Data.SQLite.dll"
asset_plugin = "OpenSim.Framework.Data.MySQL.dll"

default_location_x = 1000
default_location_y = 1000
dump_assets_to_file = false

[Network]
http_listener_port = 9000
remoting_listener_port = 8895

; Uncomment below to enable llRemoteData/remote channels
; remoteDataPort = 20800

grid_server_url = "http://127.0.0.1:8001"
grid_send_key = "null"
grid_recv_key = "null"

user_server_url = "http://127.0.0.1:8002"
user_send_key = "null"
user_recv_key = "null"

asset_server_url = "http://127.0.0.1:8003"

inventory_server_url = "http://127.0.0.1:8004"

[Chat]
whisper_distance = 10
say_distance = 30
shout_distance = 100

; Uncomment the following for IRC bridge
; experimental, so if it breaks... keep both parts... yada yada
; also, not good error detection when it fails
;[IRC]
;server  = irc.freenode.net
;nick    = OSbot
;channel = #innovatieproject

; Uncomment the following to control the progression of daytime
; in the Sim.  The defaults are what is shown below
[Sun]
; number of wall clock hours for an opensim day.  24.0 would mean realtime
day_length = 0.5

; send a Sun update ever frame_rate # of frames.  A lower number will
; make for smoother sun transition at the cost of network
;frame_rate = 100

;****END*****

Joe Greene wrote:
>
> 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
>
> Version Info:
> SuSe Enterprise 9.3 ( with updates )
> Mono: Mono JIT compiler version 1.2.6 (Installed via YAST from Mono Site)
> MySQL: 4.1.10a
>
> libode 0.9-25
>
> Console Log:
>
> opensim at opensim1:~/bin> mono OpenSim.exe
> OpenSim 0.5, SVN build
>
> Performing compatibility checks...  Environment is compatible.
>
> Starting...
>
> ERROR: There was an error while scanning assembly:
> /opt/opensim-0.5.1-release/bi
> n/PhysX-wrapper.dll (Could not load file or assembly
> '/opt/opensim-0.5.1-release
> /bin/PhysX-wrapper.dll' or one of its dependencies. An attempt was
> made to load
> a program with an incorrect format.)
> ERROR: There was an error while scanning assembly:
> /opt/opensim-0.5.1-release/bi
> n/ode.dll (Could not load file or assembly
> '/opt/opensim-0.5.1-release/bin/ode.d
> ll' or one of its dependencies. An attempt was made to load a program
> with an in
> correct format.)
> ERROR: There was an error while scanning assembly:
> /opt/opensim-0.5.1-release/bi
> n/openjpeg-libsl.dll (Could not load file or assembly
> '/opt/opensim-0.5.1-releas
> e/bin/openjpeg-libsl.dll' or one of its dependencies. An attempt was
> made to loa
> d a program with an incorrect format.)
> ERROR: There was an error while scanning assembly:
> /opt/opensim-0.5.1-release/bi
> n/sqlite3.dll (Could not load file or assembly
> '/opt/opensim-0.5.1-release/bin/s
> qlite3.dll' or one of its dependencies. An attempt was made to load a
> program wi
> th an incorrect format.)
> 00:14:21 -
> ====================================================================
> 00:14:21 - ========================= STARTING OPENSIM
> =========================
> 00:14:21 -
> ====================================================================
> Creating new local console
> 00:14:21 - [Region]: Started at 3/10/2008 12:14:21 AM
> 00:14:22 - [DATASTORE]: Attempting to load
> OpenSim.Framework.Data.MySQL.dll
> 00:14:22 - [DATASTORE]: MySql - connecting: Data
> Source=localhost;Database=opens
> im;User ID=opensim;Password=******;
> 00:14:23 - [DATASTORE]: Added IRegionDataStore Interface
> 00:14:23 - [ASSET SERVER]: Starting asset storage system
> 00:14:23 - [SQLAssetServer]: AssetStorage: Attempting to load
> OpenSim.Framework.
> Data.SQLite.dll
> [APPLICATION]:
> APPLICATION EXCEPTION DETECTED: System.UnhandledExceptionEventArgs
>
> Exception: System.DllNotFoundException: libsqlite3.so.0
>   at (wrapper managed-to-native)
> Mono.Data.SqliteClient.Sqlite:sqlite3_open16 (s
> tring,intptr&)
>   at Mono.Data.SqliteClient.SqliteConnection.Open () [0x00000]
>   at OpenSim.Framework.Data.SQLite.SQLiteAssetData.Initialise
> (System.String dbf
> ile, System.String dbname) [0x00000]
>   at OpenSim.Framework.Data.SQLite.SQLiteAssetData.Initialise ()
> [0x00000]
>   at OpenSim.Framework.Communications.Cache.SQLAssetServer.AddPlugin
> (System.Str
> ing FileName) [0x00000]
>   at OpenSim.Framework.Communications.Cache.SQLAssetServer..ctor
> (System.String
> pluginName) [0x00000]
>   at OpenSim.OpenSimMain.Initialize () [0x00000]
>   at OpenSim.Region.ClientStack.RegionApplicationBase.StartUp ()
> [0x00000]
>   at OpenSim.OpenSimMain.StartUp () [0x00000]
>   at OpenSim.Application.Main (System.String[] args) [0x00000]
>
> Application is terminating: True
>
>
> -- 
> Joe Greene
> UNIX Systems, Network and IT Specialist
> If you aren't having fun, you're doing the wrong thing!
> All opinions expressed are mine alone. You Can't Have them!
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>   

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20080310/e83e262f/attachment.html>