[Opensim-dev] New SQLiteNG database module for using SQLite with mono 2.6 and above

[Justin Clark-Casey]

Hi folks,

Today I put code into master that should allow OpenSim to be used with SQLite again if you're running mono 2.6 or later.

Unfortunately, due to compatibility issues between mono 2.4 and 2.6 I had to create an entirely new module, called OpenSim.Data.SQLiteNG.dll.

I would be very grateful if people running >mono 2.6 and the very latest OpenSim master could try it out.  To use it, you'll need to change your database settings in two places.  In OpenSim.ini you'll need to change

storage_plugin = "OpenSim.Data.SQLite.dll" to storage_plugin = "OpenSim.Data.SQLiteNG.dll"

and in config-include/storage you'll need to change

Include-Storage = "config-include/storage/SQLiteStandalone.ini" to  Include-Storage = "config-include/storage/SQLiteNGStandalone.ini"

This information is also in OpenSim.ini.example and StandaloneCommon.ini.example.

As ever, I recommend backing up all your *.db database files first if there's any valuable information in them.

Unfortunately, I've heard a report from Diva that this module doesn't work on the Mac because the version of sqlite3.so in Mac OS X doesn't export the sqlite3_column_origin_name symbol.  This is probably the issue shown at https://bugzilla.novell.com/show_bug.cgi?id=380252#c3.  Linux and Mac don't actually appear to use the .so library that comes with OpenSim which does export that symbol.

However, I'd still be interested to know if this works on other Linux distributions - I've only tested with my own Ubuntu.  SQLiteNG.dll also appears to work fine on Windows.

-- 
Justin Clark-Casey (justincc)
http://justincc.org
http://twitter.com/justincc