Region/Map not working in XoopenSim and OpenSim 0.7.0.2 in ROBUST Mode
- このフォーラムに新しいトピックを立てることはできません
- このフォーラムではゲスト投稿が禁止されています
Manny
投稿数: 2
投稿数: 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
投票数:369
平均点:3.36
iseki
投稿数: 1581
投稿数: 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;
投票数:132
平均点:3.86
iseki
投稿数: 1581
投稿数: 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.
投票数:250
平均点:3.88
Manny
投稿数: 2
投稿数: 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
投票数:235
平均点:4.81
