OpenSim のバックアップ(No.17)

OpenSim †[edit]

OpenSim は Second Life サーバと互換のオープンソース
~~OpenSL は Second Life ビューアと互換のオープンソース~~ -> Hippo Viewer

↑

Links †[edit]

OpenSim サイト: http://opensimulator.org/
ダウンロード： http://opensimulator.org/dist/

opensim-libs: git://opensimulator.org/git/opensim-libs

http://www.isus.jp/article/game-special/opensimulator_1/

git git://opensimulator.org/git/opensim

↑

Download †[edit]

↑

Git †[edit]

git clone git://opensimulator.org/git/opensim

↑

Related Software †[edit]

OpenMetaverse http://openmv.org/
opensim-libs: http://opensimulator.org/git/opensim-libs
OpenLife http://openlifegrid.com/

Freeの Assetと Inventoryのデータ OpenLibrary r0.20　 (要OpenLifeのアカウント)
OpenSim Web Interface OpenSimWI-Redux
OpenSim - Grid Control Panel
realXtend

↑

Source Code Memo †[edit]

estate item の作り方

insert into estate_settings (EstateID, EstateName,AllowVoice,UseGlobalTime,PricePerMeter,AllowDirectTeleport,ParentEstateID,PublicAccess) Values ('106', 'Sirius01', '1', '1', '1','1','1','1');

insert into estate_settings (EstateID, EstateName,AllowVoice,UseGlobalTime,PricePerMeter,AllowDirectTeleport,ParentEstateID,PublicAccess) Values ('111', 'Ayahime', '1', '1', '1','1','1','1');

estate と Region の対応付け

update estate_map set EstateID='111' where RegionID='30e40c7e-1c29-40c8-b57d-3d7091c1601d';

↑

Trouble Shooting †[edit]

↑

DB の prims テーブルの Textカラムに UTF-8 が格納できない問題 †[edit]

↑

MySQL †[edit]

↑

MySQL error in ExecuteReader: MySql.Data.MySqlClient.MySqlException: Table XXXXXX is marked as crashed and should be repaired †[edit]

MySQL にログインし，repair table XXXXXX； で修復．

↑

Authentication with old password no longer supported, use 4.1 style passwords. †[edit]

接続用モジュールが変わってパスワードの文字が41文字必要だそうだ.

+-----------+-------------+-------------------------------------------+
| Host      | User        | Password                                  |
+-----------+-------------+-------------------------------------------+
| localhost | root        | a446bd48313ea0e1                          |
| rigel-c   | OpensimUser | *DE2467C2A5C64DDF491A284A62A51A867F44FF9B |
| %         | OpensimUser | fc842bd464941c95                          |
+-----------+-------------+-------------------------------------------+
3 rows in set (0.00 sec)

mysql> set session old_passwords = 0; 
Query OK, 0 rows affected (0.00 sec)

mysql> set password for 'OpensimUser'@'%' = password('XXXXXXXXXX');
Query OK, 0 rows affected (0.00 sec)

mysql> select Host,User,Password from user;
+-----------+-------------+-------------------------------------------+
| Host      | User        | Password                                  |
+-----------+-------------+-------------------------------------------+
| localhost | root        | a446bd48313ea0e1                          |
| rigel-c   | OpensimUser | *DE2467C2A5C64DDF491A284A62A51A867F44FF9B |
| %         | OpensimUser | *DE2467C2A5C64DDF491A284A62A51A867F44FF9B |
+-----------+-------------+-------------------------------------------+
3 rows in set (0.00 sec)

↑

UTF-8 エラー †[edit]

2023-08-11 10:44:28,907 ERROR [REGION DB]: MySQL error in ExecuteNonQuery: Incorrect string value: '\xE3\x82\xBF\xE3\x83\x83...' for column `jogrid_db`.`prims`.`Text` at row 1
2023-08-11 10:44:28,909 ERROR [SCENE]: Storing of Group Inviter, 61815b84-8af0-47d6-9ae6-d77c211b4f24 in Dejima failed with exception Incorrect string value: '\xE3\x82\xBF\xE3\x83\x83...' for column `jogrid_db`.`prims`.`Text` at row 1  at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00096] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
 at MySql.Data.MySqlClient.NativeDriver.GetResult (System.Int32& affectedRow, System.Int64& insertedId) [0x00026] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
 at MySql.Data.MySqlClient.Driver.GetResult (System.Int32 statementId, System.Int32& affectedRows, System.Int64& insertedId) [0x00000] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
 at MySql.Data.MySqlClient.Driver.NextResult (System.Int32 statementId, System.Boolean force) [0x00023] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
 at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00205] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
 at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00315] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
 at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader () [0x00000] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
 at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery () [0x00033] in <27e5c3ed78eb46aa9cd5940a180a729f>:0
 at OpenSim.Data.MySQL.MySQLSimulationData.ExecuteNonQuery (MySql.Data.MySqlClient.MySqlCommand c) [0x00024] in <49ad00f865c2440e88417bcc6435df21>:0
 at OpenSim.Data.MySQL.MySQLSimulationData.StoreObject (OpenSim.Region.Framework.Scenes.SceneObjectGroup obj, OpenMetaverse.UUID regionUUID) [0x00078] in <49ad00f865c2440e88417bcc6435df21>:0
 at OpenSim.Services.SimulationService.SimulationDataService.StoreObject (OpenSim.Region.Framework.Scenes.SceneObjectGroup obj, OpenMetaverse.UUID regionUUID) [0x00000] in <dd79fb8f3b534c28a6b384b0b1301459>:0
 at OpenSim.Region.Framework.Scenes.SceneObjectGroup.ProcessBackup (OpenSim.Region.Framework.Interfaces.ISimulationDataService datastore, System.Boolean forcedBackup) [0x00341] in <6c444f9c865f452696c6e04195af8c86>:0

↑

OpenSim のバックアップ(No.17)

OpenSim †[edit]

Links †[edit]

Download †[edit]

Git †[edit]

Related Software †[edit]

by NSL (Our works) †[edit]

コンパイル，設定，実行 †[edit]

内部構造 †[edit]

Server †[edit]

Functions †[edit]

Modules †[edit]

Memo †[edit]

Bugs †[edit]

DeBug †[edit]

Geo System †[edit]

Source Code Memo †[edit]

Trouble Shooting †[edit]

DB の prims テーブルの Textカラムに UTF-8 が格納できない問題 †[edit]

MySQL †[edit]

MySQL error in ExecuteReader: MySql.Data.MySqlClient.MySqlException: Table XXXXXX is marked as crashed and should be repaired †[edit]

Authentication with old password no longer supported, use 4.1 style passwords. †[edit]

UTF-8 エラー †[edit]

Index †[edit]