[Opensim-dev] Using remote user database

[SignpostMarv Martin]

No joy. User tables not created in remote database.

Justin Clark-Casey wrote:
> Actually, now the rest of my brain has had time to catch up with the 
> 'reply to e-mail' portion, I think in this particular case it may well 
> be possible.  Assuming you're operating standalone (which I guess you 
> are as you're talking about local sqlite databases), then you *could* 
> change mysql_connection.ini to point at your remote connection.
>
> Then once you change OpenSim.ini/userDatabase_plugin to point to mysql 
> rather than sqlite, the user db plugin should use the connection 
> details in mysql_connection.ini, leaving all the sqlite still using 
> local connections.
>
> I've never tried this myself, but it would be interesting to know why 
> it doesn't work, if, in fact, it doesn't.
>
> Justin Clark-Casey wrote:
>> Unfortunately it's not possible to have different connection settings 
>> for different tables at the moment (at least within OpenSim).  In the 
>> MySQL case, bin/mysql_connection.ini is used for all tables 
>> (mssql_connection.ini in the MSSQL case).
>>
>> -- 
>> justincc