[Opensim-users] robust/opensim estate tables

[Justin Clark-Casey]

Since estate data is stored region-side and is never seen by ROBUST, there should be no issue here.

On 03/10/12 03:10, Nicky Perian wrote:
> Thanks for the reply. I have an operational performance question. If I changed over to estate on mysql, would that rule
> out transfer of that region to a grid? If not, would transfer of that region to an off site server degrade performance?
> I assume that a remote instance of opensim would have the SULite Opensim.db on a remote server with ROBUST on different
> hardware.
>
> Asking more directly: Would removing SQlite->Opensim.db use decrease flexibility or performance of the Opensim instance?
>
>     ------------------------------------------------------------------------------------------------------------------------
>     *From:* James Hughes <jamesh at bluewallgroup.com>
>     *To:* Nicky Perian <nickyperian at yahoo.com>; opensim-users at lists.berlios.de
>     *Sent:* Tuesday, October 2, 2012 6:43 PM
>     *Subject:* Re: [Opensim-users] robust/opensim estate tables
>
>     I have it working on a grid with a separate estate database in mysql. To
>     do that, comment the Include-Storage =
>     "config-include/storage/SQLiteStandalone.ini", then uncomment...
>
>     StorageProvider = "OpenSim.Data.MySQL.dll"
>     ConnectionString = "Data Source=localhost;Database=db_name;User
>     ID=db_user;Password=db_pass;Old Guids=true;"
>     EstateConnectionString = "Data Source=localhost;Database=db_estate;User
>     ID=db_user;Password=db_pass;Old Guids=true;"
>
>     If you select MySQL and leave the EstateConnectionString commented, then
>     your estate data *should* be included in your region data selected with
>     the parameters in "ConnectionString".
>
>     If you see something different then let me know and I'll dig further.
>
>     Thanks,
>     BlueWall
>
>
>     On 10/01/2012 07:26 PM, Nicky Perian wrote:
>      > maybe this is a non-problem but, it has me stumped.
>      > when running a standalone w/mysql the estate tables are populated into
>      > the database.
>      > when running robust/opensim instances the estate tables appear to to be
>      > placed in an sqlite database
>      > as per the setting in GridCommon.ini of:
>      > [DatabaseService]
>      > ;
>      > ; ### Choose the DB
>      > ;
>      >
>      > ; SQLite
>      > Include-Storage = "config-include/storage/SQLiteStandalone.ini";
>      >
>      > Attempts to comment this out and use mysql database fail w/ region not
>      > part of estate error.
>      >
>      >
>      > Is there a way to place the estate tables into the mysql database?
>      >
>      > This came up because I wanted to transfer ownership of region by table
>      > entry as I had done before in a standalone configuration.
>      >
>      > If this is the way estate data is handled in the robust/opensim
>      > configuration; how are the estate tables edited to transfer region
>      > ownership?
>      >
>      > Additionally, the show names data does not persist for run to run which
>      > it does for a standalone.
>      >
>      > Comments please.
>      >
>      > Nicky
>      >
>      >
>      >
>      >
>      > _______________________________________________
>      > Opensim-users mailing list
>      > Opensim-users at lists.berlios.de <mailto:Opensim-users at lists.berlios.de>
>      > https://lists.berlios.de/mailman/listinfo/opensim-users
>
>
>
>
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>


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