Database connection

Hi all, a question as I would like to put the services on different db if I do jopensim does not work exactly? to work the services must all be on a single db?

Hi Marcus

I'm not sure if I understand the question completely ...

The database of OpenSimulator and the one from Joomla do not need to reside on the same server.

It makes it a little more tricky of course if they are located on different servers, since most mysql/mariadb configurations and/or firewall settings do not allow access from "outside" ... but as long as these permissions are granted, it should work.

Greetz

Hi Foto50, no my question was another
I was going to divide the OpenSim services on separate db that is not to have a single OpenSim instance, but separate, for example a db for AssetService one for AuthService one for Estate is so on, I was wondering if I divide the db Jopensim does not work as it takes the data from a single db?

Basically, jOpenSim takes "only" data from the robust database for basic functions like creating/editing users.

Additional functions (e.g. like events - parcels, search data, etc.) are coming from/to the modules (in this case from jOpenSimSearch) from each simulator. Otherwise it would simply be impossible to run jOpenSim on a REAL grid.

One thing though: I didnt know yet that AuthService can be seperated from the robust database. The table "auth" should remain in the robust database, so jOpenSim can add the required entry for the encrypted password for a new created user.

Thanks Foto50, so if I understand correctly some services can I direct them on a split db?
but some type AuthenticationService and AuthorizationService must not be on the same db as Robust? one thing can I also move PresenceService and UserAccountService? or should these also remain on Robut's db? it would be useful to know which services can be put on a separate db and which not
Thanks

Hi,

well jOpenSim is looking for following tables in same database: UserAccounts, auth, Friends, regions and Presence.

As far as I remember, "Friends" is only used in the friends module, but that one takes the values from the component.

Greetz

Hi,
ah ok, those all remain in the robust db, they cannot be divided as services