Re: Re: Landtool.php

I always forget one - here's OpenSim.ini:

[DatabaseService]
;
; ### Choose the DB
;

; SQLite
; Include-Storage = "config-include/storage/SQLiteStandalone.ini";

; MySql
; Uncomment these lines if you want to use mysql storage
; Change the connection string to your db details
StorageProvider = "OpenSim.Data.MySQL.dll"
ConnectionString = "Data Source=192.168.0.164;Database=opensim;User ID=opensim;Password=***;Old Guids=true;"
; Uncomment this line if you are using MySQL and want to use a different database for estates
; The usual application for this is to allow estates to be spread out across multiple simulators by share the same database.
; Most people won't need to do this so only uncomment if you know what you're doing.
;EstateConnectionString = "Data Source=localhost;Database=opensim;User ID=opensim;Password=***;Old Guids=true;"

Note that the MySQL server is on 192.168.0.164 - and they're all using the same opensim account with the same password.

e.g.

root@grid1:~/opensim-0.8.0.3/bin# mysql -uopensim --p*** -h192.168.0.164 opensim
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 53
Server version: 5.5.40-0+wheezy1 (Debian)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show tables;

[shows about 40 tables]

+--------------------------+
| Tables_in_opensim |
+--------------------------+
| Avatars |
| Friends |
| GridUser |
| Presence |
| UserAccounts |
| assets |
| auth |
| balances |
| estate_groups |
| estate_managers |
| estate_map |
| estate_settings |
| estate_users |
| estateban |
| inventoryfolders |
| inventoryitems |
| land |
| landaccesslist |
| migrations |
| os_groups_groups |
| os_groups_invites |
| os_groups_membership |
| os_groups_notices |
| os_groups_principals |
| os_groups_rolemembership |
| os_groups_roles |
| primitems |
| prims |
| primshapes |
| regionban |
| regionenvironment |
| regionextra |
| regions |
| regionsettings |
| regionwindlight |
| spawn_points |
| terrain |
| tokens |
| transactions |
| userinfo |
+--------------------------+
40 rows in set (0.00 sec)

See that all the estate tables, grid tables and money tables (e.g. transactions) are all in the one database.

DSL