Common simple settings wiki should include storage_plugin and storage_connection_string setting in OpenSim.ini
- このフォーラムに新しいトピックを立てることはできません
- このフォーラムではゲスト投稿が禁止されています
Common simple settings wiki should include storage_plugin and storage_connection_string setting in OpenSim.ini
msg# 1
roel
投稿数: 7
The following settings in OpenSim.ini appears not to be recommended in http://www.nsl.tuis.ac.jp/xoops/modules/xpwiki/?OpenSim%2FWEB%20Interface%20%28E%29%2FCommon%20Simple%20Settings. But I found that it is necessary even for Standalone mode.
storage_plugin="OpenSim.Data.MySQL.dll"
storage_connection_string="Data Source=localhost;Database=opensimdb;User ID=opensimdb_user;Password=opensimdb_password;"
The symptom when these settings are missing would be errors in the map, and region lists:
World Map
function loadmap() { mapInstance = new ZoomSize(128); mapInstance = new WORLDMap(document.getElementById('map-container'), {hasZoomControls: false, hasPanningControls: true}); mapInstance.centerAndZoomAtWORLDCoord(new XYPoint(1000, 1000), 1); Database error: Invalid SQL: SELECT PrincipalID,FirstName,LastName FROM UserAccounts,estate_map,estate_settings WHERE RegionID='710a5cc2-4a66-4cee-b38e-fcfe2688c3ee' AND estate_map.EstateID=estate_settings.EstateID AND EstateOwner=PrincipalID
MySQL error: 1146 (Table 'osim.estate_map' doesn't exist)
Session halted.
Region List
Database error: Invalid SQL: SELECT regions.uuid,regionName,locX,locY,serverIP,serverURI,serverHttpPort,owner_uuid,estate_map.EstateID,EstateOwner,firstname,lastname FROM regions LEFT JOIN estate_map ON RegionID=regions.uuid LEFT JOIN estate_settings ON estate_map.EstateID=estate_settings.EstateID LEFT JOIN UserAccounts ON EstateOwner=UserAccounts.PrincipalID LIMIT 0, 25
MySQL error: 1146 (Table 'osim.estate_map' doesn't exist)
Session halted.
storage_plugin="OpenSim.Data.MySQL.dll"
storage_connection_string="Data Source=localhost;Database=opensimdb;User ID=opensimdb_user;Password=opensimdb_password;"
The symptom when these settings are missing would be errors in the map, and region lists:
World Map
function loadmap() { mapInstance = new ZoomSize(128); mapInstance = new WORLDMap(document.getElementById('map-container'), {hasZoomControls: false, hasPanningControls: true}); mapInstance.centerAndZoomAtWORLDCoord(new XYPoint(1000, 1000), 1); Database error: Invalid SQL: SELECT PrincipalID,FirstName,LastName FROM UserAccounts,estate_map,estate_settings WHERE RegionID='710a5cc2-4a66-4cee-b38e-fcfe2688c3ee' AND estate_map.EstateID=estate_settings.EstateID AND EstateOwner=PrincipalID
MySQL error: 1146 (Table 'osim.estate_map' doesn't exist)
Session halted.
Region List
Database error: Invalid SQL: SELECT regions.uuid,regionName,locX,locY,serverIP,serverURI,serverHttpPort,owner_uuid,estate_map.EstateID,EstateOwner,firstname,lastname FROM regions LEFT JOIN estate_map ON RegionID=regions.uuid LEFT JOIN estate_settings ON estate_map.EstateID=estate_settings.EstateID LEFT JOIN UserAccounts ON EstateOwner=UserAccounts.PrincipalID LIMIT 0, 25
MySQL error: 1146 (Table 'osim.estate_map' doesn't exist)
Session halted.
投票数:171
平均点:6.02
Re: Common simple settings wiki should include storage_plugin and storage_connection_string setting in OpenSim.ini
msg# 1.1
iseki
投稿数: 1581
Hi.
Modlos doesn't support SQLite.
You should exec StandAlone mode with MySQL.
> MySQL error: 1146 (Table 'osim.estate_map' doesn't exist)
It seems that your opensim executed with SQLite.
Please check your MySQL DB.
If you lost estae_map or regions table, you rewrite OpenSim.ini and config-include/StandaloneCommon.ini
OpenSim.ini
config-include/StandaloneCommon.ini
Modlos doesn't support SQLite.
You should exec StandAlone mode with MySQL.
> MySQL error: 1146 (Table 'osim.estate_map' doesn't exist)
It seems that your opensim executed with SQLite.
Please check your MySQL DB.
$ mysql -u root -p
Enter password: *******
mysql> use osim;
mysql> show tables;
+----------------------------+
| Tables_in_osim |
+----------------------------+
| Avatars |
| Friends |
| GridUser |
| UserAccounts |
| assets |
| auth |
| estate_groups |
| estate_managers |
| estate_map |
| estate_settings |
| estate_users |
| estateban |
| inventoryfolders |
| inventoryitems |
| land |
| landaccesslist |
| migrations |
| primitems |
| prims |
| primshapes |
| regionban |
| regions |
| regionsettings |
| regionwindlight |
| terrain |
| tokens |
+----------------------------+
If you lost estae_map or regions table, you rewrite OpenSim.ini and config-include/StandaloneCommon.ini
OpenSim.ini
; ##
; ## PRIM STORAGE
; ## ; *** Prim Storage - only leave one storage_plugin uncommented ***
; --- Null stores nothing - effectively disabling persistence:
;storage_plugin = "OpenSim.Data.Null.dll" ; --- To use sqlite as region storage:
;
; PLEASE NOTE: Unfortunately, the current SQLite database plugin (necessary to use SQLite with Mono on Linux) is
; not compatible with the sqlite3 library installed on Mac OSX. If you're using Mono 2.4 you can still use the old sqlite
; library by uncommenting the SQLiteLegacy.dll storage plugin (and commenting out SQLite.dll). Unfortunately, the older library
; will not work with Mono 2.6 on Mac OSX so you will either need to replace the OSX sqlite3 system library or use MySQL instead
;
; You will also need to do the same thing in config-include/StandaloneCommon.ini if you are running in standalone mode
;storage_plugin = "OpenSim.Data.SQLite.dll"
;storage_plugin = "OpenSim.Data.SQLiteLegacy.dll"
;storage_connection_string="URI=file:OpenSim.db,version=3";
; --- To use MySQL storage, supply your own connection string (this is only an example):
; note that the supplied account needs create privilegies if you want it to auto-create needed tables.
;
; -->>> There are multiple connection strings defined in several places. Check it carefully!
;
storage_plugin="OpenSim.Data.MySQL.dll"
storage_connection_string="Data Source=localhost;Database=osim;User ID=your_db_id;Password=your_db_password;"
; If you want to use a different database/server for estate data, then
; uncomment and change this connect string. Defaults to the above if not set
; estate_connection_string="Data Source=localhost;Database=opensim;User ID=opensim;Password=*****;";
config-include/StandaloneCommon.ini
[DatabaseService]
;
; ### Choose the DB
;
; SQLite
;Include-Storage = "config-include/storage/SQLiteStandalone.ini";
; Unfortunately the current SQLite database plugin is not compatible with Mac OSX. You can still use the older
; legacy sqlite library if you are using Mono 2.4. Please see the notes in OpenSim.ini (search for sqlite)
; for more details
;Include-Storage = "config-include/storage/SQLiteLegacyStandalone.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=localhost;Database=osim;User ID=your_db_id;Password=your_db_password;"
..................
..................
[GridService]
;; For in-memory region storage (default)
; StorageProvider = "OpenSim.Data.Null.dll:NullRegionData"
;;--- For MySql region storage (alternative)
StorageProvider = "OpenSim.Data.MySQL.dll:MySqlRegionData"
..................
投票数:192
平均点:5.63
Re: Common simple settings wiki should include storage_plugin and storage_connection_string setting in OpenSim.ini
msg# 1.1.1
roel
投稿数: 7
Yes this is what I have done. My post is not a bug report but mere additional information on the wiki so others who encounter the same problem would know what to do.
Thank you for the reply Iseki.
Thank you for the reply Iseki.
投票数:244
平均点:5.70