flagflag  If you want to see English page, please click "English" Button at Left.

Common simple settings wiki should include storage_plugin and storage_connection_string setting in OpenSim.ini

  • このフォーラムに新しいトピックを立てることはできません
  • このフォーラムではゲスト投稿が禁止されています
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 | 投稿日時 2011-1-28 18:09
roel  Just popping in   投稿数: 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.
投票数:164 平均点:5.85
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 | 投稿日時 2011-1-31 18:12
iseki  Home away from home   投稿数: 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.
$ 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"
..................
投票数:186 平均点:5.70
前の投稿 - 次の投稿 | 親投稿 - 子投稿なし | 投稿日時 2011-2-2 17:27
roel  Just popping in   投稿数: 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.
投票数:240 平均点:5.71

  条件検索へ


サイト内 検索

ログイン

ユーザー名:

パスワード:


パスワード紛失
新規登録

サブ メニュー

ミニカレンダー

前月2024年 4月翌月
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30
<今日>

オンライン状況

67 人のユーザが現在オンラインです。 (2 人のユーザが Forum を参照しています。)

登録ユーザ: 0
ゲスト: 67

もっと...

アクセスカウンタ

今日 : 1187118711871187
昨日 : 1169911699116991169911699
総計 : 2328852223288522232885222328852223288522232885222328852223288522
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com