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 <[email protected]>
*To:* Nicky Perian <[email protected]>; [email protected]
*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
> [email protected] <mailto:[email protected]>
> https://lists.berlios.de/mailman/listinfo/opensim-users
_______________________________________________
Opensim-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-users
--
Justin Clark-Casey (justincc)
OSVW Consulting
http://justincc.org
http://twitter.com/justincc
_______________________________________________
Opensim-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-users
