[Opensim-users] robust/opensim estate tables

[James Hughes]

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
> https://lists.berlios.de/mailman/listinfo/opensim-users