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

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

↑

by NSL †[edit]

Modlos: Moodle 用 OpenSim インターフェイス by NSL
DTL/NSL Money Server by NSL
OAR Converter of Linux for Unity by NSL
OAR Converter of Windows for Unity by NSL

Patch for OpenSim in NAT by NSL
OpenSim Modules by NSL bt NSL
- SFS Wind Module

↑

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

↑

0.9.3 with .NET6 †[edit]

yum install dotnet-*-6.0

git clone git://opensimulator.org/git/opensim 
cd opensim
git checkout dotnet6

./runprebuild.sh
./compile.sh

cd bin
./opensim.sh  or ./OpenSim

↑

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.3)

OpenSim †[edit]

Links †[edit]

Download †[edit]

Git †[edit]

Related Software †[edit]

by NSL †[edit]

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

0.9.3 with .NET6 †[edit]

内部構造 †[edit]

Server †[edit]

Functions †[edit]

Our (NSL's) Works †[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]