[Opensim-dev] Using remote user database

[Justin Clark-Casey]

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
> 
> SignpostMarv Martin wrote:
>> I'm looking to experiment with something, and for that I need the user
>> server's database on a remote server (all other tables would be in the
>> local sqlite databases), so performance isn't really an issue.
>>
>> ~ Marv
>>
>>
>>   


-- 
justincc
Justin Clark-Casey