<html><body><div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:12pt"><div style="font-family: 'Courier New', courier, monaco, monospace, sans-serif; font-size: 12pt; ">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.</div><div style="font-family: 'Courier New', courier, monaco, monospace, sans-serif; font-size: 12pt; "><br></div><div style="background-color: transparent; "><span style="font-size: 16px;">Asking more directly: Would removing SQlite->Opensim.db use decrease flexibility or performance of the Opensim instance?</span></div><div style="font-family: 'Courier
New', courier, monaco, monospace, sans-serif; font-size: 12pt; "><br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px;"> <div style="font-family: 'Courier New', courier, monaco, monospace, sans-serif; font-size: 12pt; "> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt; "> <div dir="ltr"> <font size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> James Hughes <jamesh@bluewallgroup.com><br> <b><span style="font-weight: bold;">To:</span></b> Nicky Perian <nickyperian@yahoo.com>; opensim-users@lists.berlios.de <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, October 2, 2012 6:43 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [Opensim-users] robust/opensim estate tables<br> </font> </div> <br>I have it working on a grid with a separate estate database in mysql. To <br>do
that, comment the Include-Storage = <br>"config-include/storage/SQLiteStandalone.ini", then uncomment...<br><br>StorageProvider = "OpenSim.Data.MySQL.dll"<br>ConnectionString = "Data Source=localhost;Database=db_name;User <br>ID=db_user;Password=db_pass;Old Guids=true;"<br>EstateConnectionString = "Data Source=localhost;Database=db_estate;User <br>ID=db_user;Password=db_pass;Old Guids=true;"<br><br>If you select MySQL and leave the EstateConnectionString commented, then <br>your estate data *should* be included in your region data selected with <br>the parameters in "ConnectionString".<br><br>If you see something different then let me know and I'll dig further.<br><br>Thanks,<br>BlueWall<br><br><br>On 10/01/2012 07:26 PM, Nicky Perian wrote:<br>> maybe this is a non-problem but, it has me stumped.<br>> when running a standalone w/mysql the estate tables are populated into<br>> the database.<br>> when running robust/opensim instances the
estate tables appear to to be<br>> placed in an sqlite database<br>> as per the setting in GridCommon.ini of:<br>> [DatabaseService]<br>> ;<br>> ; ### Choose the DB<br>> ;<br>><br>> ; SQLite<br>> Include-Storage = "config-include/storage/SQLiteStandalone.ini";<br>><br>> Attempts to comment this out and use mysql database fail w/ region not<br>> part of estate error.<br>><br>><br>> Is there a way to place the estate tables into the mysql database?<br>><br>> This came up because I wanted to transfer ownership of region by table<br>> entry as I had done before in a standalone configuration.<br>><br>> If this is the way estate data is handled in the robust/opensim<br>> configuration; how are the estate tables edited to transfer region<br>> ownership?<br>><br>> Additionally, the show names data does not persist for run to run which<br>> it does for a standalone.<br>><br>>
Comments please.<br>><br>> Nicky<br>><br>><br>><br>><br>> _______________________________________________<br>> Opensim-users mailing list<br>> <a ymailto="mailto:Opensim-users@lists.berlios.de" href="mailto:Opensim-users@lists.berlios.de">Opensim-users@lists.berlios.de</a><br>> <a href="https://lists.berlios.de/mailman/listinfo/opensim-users" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-users</a><br><br><br><br> </div> </div> </blockquote></div> </div></body></html>