Region/Map not working in XoopenSim and OpenSim 0.7.0.2 in ROBUST Mode
- You cannot open a new topic into this forum
- Guests cannot post into this forum
Manny
Posts: 2

Hello,
I've a Problem with the xoopensim installation on a Grid. In the Admin Section, i point to the Database, ROBUST is using. I now, can create and see all Avatars but I can not see Regions and get no MAP. There come's up an SQL error, which says, that estate.... is not known (of course, because this is content of the OpenSim.exe, which point to another database.
Do I have to apply a patch or a hack to the file, where the SQL Statements are defined or have i something missed during installation?
It would be nice, if someone helps me. domain is: http://www.secondlearning.de
Regards
Manny
By the way - in Everything is ok, if the Sim runs in standalone mode!
SQL Error for MAP creation:
function loadmap() { mapInstance = new ZoomSize(128); mapInstance = new WORLDMap(document.getElementById('map-container'), {hasZoomControls: false, hasPanningControls: true}); mapInstance.centerAndZoomAtWORLDCoord(new XYPoint(5000, 5000), 1); Database error: Invalid SQL: SELECT PrincipalID,FirstName,LastName FROM UserAccounts,estate_map,estate_settings WHERE RegionID='232aef07-06f6-4a52-957e-adf9d4a84c77' AND estate_map.EstateID=estate_settings.EstateID AND EstateOwner=PrincipalID
MySQL error: 1146 (Table 'sl_grid.estate_map' doesn't exist)
Session halted.
System:
Ubuntu 10.04 with PHP 5.2.4, MySql 5.1, Apache 2.2, mono 2.4.2
OpenSim 0.7.0.2
XoopsCube 2.1.8
I've a Problem with the xoopensim installation on a Grid. In the Admin Section, i point to the Database, ROBUST is using. I now, can create and see all Avatars but I can not see Regions and get no MAP. There come's up an SQL error, which says, that estate.... is not known (of course, because this is content of the OpenSim.exe, which point to another database.
Do I have to apply a patch or a hack to the file, where the SQL Statements are defined or have i something missed during installation?
It would be nice, if someone helps me. domain is: http://www.secondlearning.de
Regards
Manny
By the way - in Everything is ok, if the Sim runs in standalone mode!
SQL Error for MAP creation:
function loadmap() { mapInstance = new ZoomSize(128); mapInstance = new WORLDMap(document.getElementById('map-container'), {hasZoomControls: false, hasPanningControls: true}); mapInstance.centerAndZoomAtWORLDCoord(new XYPoint(5000, 5000), 1); Database error: Invalid SQL: SELECT PrincipalID,FirstName,LastName FROM UserAccounts,estate_map,estate_settings WHERE RegionID='232aef07-06f6-4a52-957e-adf9d4a84c77' AND estate_map.EstateID=estate_settings.EstateID AND EstateOwner=PrincipalID
MySQL error: 1146 (Table 'sl_grid.estate_map' doesn't exist)
Session halted.
System:
Ubuntu 10.04 with PHP 5.2.4, MySql 5.1, Apache 2.2, mono 2.4.2
OpenSim 0.7.0.2
XoopsCube 2.1.8
Votes:369
Average:3.36
iseki
Posts: 1581

Hi,
Your OpenSim DB has not estate_map table.
You can check your OpenSim DB below command.
Your OpenSim DB has not estate_map table.
You can check your OpenSim DB below command.
% mysql -u root -p
Enter password: #####
mysql> show databases;
.........
mysql> use Your_OpenSim_DB_Name;
mysql> show tables;
Votes:132
Average:3.86
iseki
Posts: 1581

Hi,
I am looking your Web page of XoopenSim, now.
There is no Region at your OpenSim. Please make some Region.
Thanks.
I am looking your Web page of XoopenSim, now.
There is no Region at your OpenSim. Please make some Region.
Thanks.
Votes:251
Average:3.86
Previous post
-
Next post
|
Parent
-
No child
|
Posted on 2011/1/20 7:24
Manny
Posts: 2

Hi,
I had to compile some new things. Now there is a region. And you are true - as i have connected XoopenSim to the DB where Robust stores the user information, there is only a table, where the connected regions are stored - and no estate table and no land table (these are content in the secon db, where the opensim.exe process stores it's data.
So, if you are running standalone, you have all the tables in 1 db. But if you uses robust and connected regions, you hav 1 db for robust and 1 for each region server (opensim)
Regards
Manny
I had to compile some new things. Now there is a region. And you are true - as i have connected XoopenSim to the DB where Robust stores the user information, there is only a table, where the connected regions are stored - and no estate table and no land table (these are content in the secon db, where the opensim.exe process stores it's data.
So, if you are running standalone, you have all the tables in 1 db. But if you uses robust and connected regions, you hav 1 db for robust and 1 for each region server (opensim)
Regards
Manny
Votes:235
Average:4.81