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

[Teravus Ovares]

Nice!   and Congrats!  :)

Regards

Teravus

On Fri, Apr 23, 2010 at 6:03 PM, Justin Clark-Casey
<jjustincc at googlemail.com> wrote:
> 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
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev
>