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
_______________________________________________
Opensim-dev mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-dev

Reply via email to