Q-Sims - Upgrading: Difference between revisions
Jump to navigation
Jump to search
m (1 revision imported) |
No edit summary |
||
| Line 1: | Line 1: | ||
__NOTOC__ | __NOTOC__ ''by AdNovea - June 2009''<br/>'''[[Q-Sims_-_The_OpenSim_metavers_for_QNAP|Q-Sims Homepage]]'''<br/> | ||
''by AdNovea - June 2009''<br> | |||
'''[[Q- | |||
= Backup / Restore = | = Backup / Restore = | ||
<blockquote> | <blockquote> | ||
{| width="100%" | {| width="100%" | ||
|- style="background-color: #F4F4FF; font: normal 8pt Arial;" valign="middle" | |- style="background-color: #F4F4FF; font: normal 8pt Arial;" valign="middle" | ||
!width="50"|[[ | ! width="50" | [[File:Information.png|RTENOTITLE]] | ||
|<span style="color:blue"> | | <span style="color:blue">'''IMPORTANT''': Frequently backup your databases.</span><br/> | ||
|} | |} | ||
When Q-Sims is enabled, there is a daily backup of the database performed and the latest 15 (''by default, can be changed into qsims.sh'') backup files are kept.<br> | |||
Database backups are performed every day and can also be run from a console (''no backup performed if the daily archive already exists''): | When Q-Sims is enabled, there is a daily backup of the database performed and the latest 15 (''by default, can be changed into qsims.sh'') backup files are kept.<br/>Database backups are performed every day and can also be run from a console (''no backup performed if the daily archive already exists''): | ||
<blockquote><pre> | <blockquote><pre># cd /share/xxx_DATA/.qpkg/QSims | ||
# cd /share/xxx_DATA/.qpkg/QSims | |||
# ./qsims backup | # ./qsims backup | ||
</pre></blockquote> | </pre> | ||
</blockquote> | |||
{| width="100%" | {| width="100%" | ||
|- style="background-color: #FFF4F4; font: normal 8pt Arial;" valign="middle" | |- style="background-color: #FFF4F4; font: normal 8pt Arial;" valign="middle" | ||
!width="50"|[[ | ! width="50" | [[File:Critical.png|RTENOTITLE]] | ||
|<span style="color:red"> | | <span style="color:red">'''WARNING''': because the database structure may change between OpenSim simulator updates, your database archives may become unusable! In such a situation, you may have to consider a database migration if this is managed by the upgrade.</span> | ||
|} | |} | ||
== SQLite database == | == SQLite database == | ||
<blockquote> | <blockquote>Each day (''assuming Q-Sims is Enabled''), a backup of the SQLite database files located into the '''QSims/bin/*db''' is done. Archive files are located under the '''QSims/backup/sqlite''' folder and rename under '''20xx-mm-dd_dbname.db''':<blockquote> | ||
Each day (''assuming Q-Sims is Enabled''), a backup of the SQLite database files located into the '''QSims/bin/*db''' is done. Archive files are located under the '''QSims/backup/sqlite''' folder and rename under '''20xx-mm-dd_dbname.db''': | *Asset.db (''in Private grid mode only'') | ||
<blockquote> | *inventoryStore.db (''in Private grid mode only'') | ||
* Asset.db (''in Private grid mode only'') | *LocalUserStatistics.db | ||
* inventoryStore.db (''in Private grid mode only'') | *OpenSim.db | ||
* LocalUserStatistics.db | *userprofiles.db (''in Private grid mode only'') | ||
* OpenSim.db | |||
* userprofiles.db (''in Private grid mode only'') | |||
</blockquote> | </blockquote> | ||
=== Restore an archive file === | === Restore an archive file === | ||
To restore, overwrite previous database files with the archived ones. | |||
To restore, overwrite previous database files with the archived ones. | |||
</blockquote> | </blockquote> | ||
== MySQL database == | == MySQL database == | ||
<blockquote> | <blockquote>The data are stored into a MySQL database. | ||
The data are stored into a MySQL database. | *Each day (''assuming Q-Sims is Enabled''), a backup of the MySQL database is performed. The archive file named as '''20yy-mm-dd_QSims.sql.tgz''' is saved under the '''QSims/backup/mysql''' folder. | ||
* Each day (''assuming Q-Sims is Enabled''), a backup of the MySQL database is performed. The archive file named as '''20yy-mm-dd_QSims.sql.tgz''' is saved under the '''QSims/backup/mysql''' folder. | *Your database can be manually backuped using phpMyAdmin. | ||
* Your database can be manually backuped using phpMyAdmin. | <br/> | ||
<br> | === Restore an archive file === | ||
=== Restore an archive file=== | |||
To restore an automatically archived database file, open a SSH console, change directory to the QSims root directory and restore the selected archive as shown in the example below: | To restore an automatically archived database file, open a SSH console, change directory to the QSims root directory and restore the selected archive as shown in the example below: | ||
<pre> | <pre># cd /share/xxx_DATA/.qpkg/QSims | ||
# cd /share/xxx_DATA/.qpkg/QSims | |||
# ./qsims.sh restore ../backup/20yy-mm-dd_QSims.sql.tgz | # ./qsims.sh restore ../backup/20yy-mm-dd_QSims.sql.tgz | ||
</pre> | </pre> | ||
* Enter '''yes''' to start restoration<br><span style="color: darkred"> | |||
*Enter '''yes''' to start restoration<br/><span style="color: darkred">'''ALL DATABASE INFORMATION WILL BE OVERWRITTEN'''</span> | |||
</blockquote> | </blockquote> | ||
== Backup / Restore from the OpenSim console == | == Backup / Restore from the OpenSim console == | ||
<blockquote> | <blockquote>To save and load data for each region in the '''OAR format''' (''OpenSim Archive''). This is very helpful to save/restore changes of a specific regions during building.<br/>''See also [[Q-Sims_-_OpenSim_Console|OpenSim console]]''. | ||
To save and load data for each region in the '''OAR format''' (''OpenSim Archive''). This is very helpful to save/restore changes of a specific regions during building.<br>''See also [[Q-Sims_-_OpenSim_Console|OpenSim console]]''. | *Open a SSH console | ||
* Open a SSH console | *List all the running process (''screen -list'') | ||
* List all the running process (''screen -list'') | *Open the screen console of the '''xxx.OpenSim''' process (''screen -r xxx.OpenSim'') | ||
* Open the screen console of the '''xxx.OpenSim''' process (''screen -r xxx.OpenSim'') | |||
<blockquote> | <blockquote> | ||
=== Save region into OAR file === | === Save region into OAR file === | ||
We assume your region to be OpenTest and the file to be saved into the /backup folder. | We assume your region to be OpenTest and the file to be saved into the /backup folder. | ||
<pre> | <pre>Region (<region_name>)# change region OpenTest | ||
Region (<region_name>)# change region OpenTest | |||
Region (OpenTest)# save oar ../backup/20yy-mm-dd_OpenTest.oar | Region (OpenTest)# save oar ../backup/20yy-mm-dd_OpenTest.oar | ||
</pre> | </pre> | ||
=== Restore region from an OAR file === | |||
<pre> | === Restore region from an OAR file === | ||
Region (<region_name>)# change region OpenTest | <pre>Region (<region_name>)# change region OpenTest | ||
Region (OpenTest)# load oar ../backup/20yy-mm-dd_OpenTest.oar | Region (OpenTest)# load oar ../backup/20yy-mm-dd_OpenTest.oar | ||
</pre> | </pre> | ||
{| width="100%" | {| width="100%" | ||
|- style="background-color: #FFF4F4; font: normal 8pt Arial;" valign="middle" | |- style="background-color: #FFF4F4; font: normal 8pt Arial;" valign="middle" | ||
!width="50"|[[ | ! width="50" | [[File:Critical.png|RTENOTITLE]] | ||
|<span style="color:red"> | | <span style="color:red">'''NOTE''': Because we had some troubles to restore OAR files between different OpenSim versions, we do recommend to also save each of your regions into XML2 format files using:</span><br/> | ||
'''change region OpenTest'''<br> | <span style="color:red">'''change region OpenTest'''<br/>'''save xml2 ../backup/20yy-mm-dd_OpenTest.xml2'''<br/><br/>The terrains are not saved into the XML format files therefore you must save each of your terrains. There are many options (extensions) for terrain formats (R32, RAW, JPG, BMP, PNG, TIF, TER, etc...). To save the terrain of the selected region use:<br/>'''change region OpenTest'''<br/>'''terrain save ../backup/20yy-mm-dd_OpenTest.r32'''</span> | ||
'''save xml2 ../backup/20yy-mm-dd_OpenTest.xml2'''<br> | |||
<br> | |||
The terrains are not saved into the XML format files therefore you must save each of your terrains. There are many options (extensions) for terrain formats (R32, RAW, JPG, BMP, PNG, TIF, TER, etc...). To save the terrain of the selected region use:<br> | |||
'''change region OpenTest'''<br> | |||
'''terrain save ../backup/20yy-mm-dd_OpenTest.r32'''</span> | |||
|} | |} | ||
</blockquote> | |||
<br/>You must also save your inventory which is located on the Inventory server (''OSGrid server is your are running your grid on OSGrid''). | |||
=== Save Inventory into IAR file === | |||
<pre>Region (<region_name>)# change region OpenTest | |||
=== Save Inventory into IAR file === | |||
<pre> | |||
Region (<region_name>)# change region OpenTest | |||
Region (OpenTest)# save iar <user name> <path> <password> ../backup/20yy-mm-dd_Inventory.iar | Region (OpenTest)# save iar <user name> <path> <password> ../backup/20yy-mm-dd_Inventory.iar | ||
</pre> | </pre> | ||
NOTE: To save the whole inventory set the path value to /*</blockquote> | NOTE: To save the whole inventory set the path value to /*</blockquote> | ||
<br> | <br/>''OAR and IAR files are archive files that can be open using the WinRAR tool for example.''<br/> | ||
''OAR and IAR files are archive files that can be open using the WinRAR tool for example.'' | |||
<br> | |||
== QS-Manager backup == | == QS-Manager backup == | ||
<blockquote>QS-Manager automatically saved the configuration files generated by the QSA (''Quick Start Assistant''). We urge you to run the QSA whenever you want to reconfigure Q-Sims.<br/>The following files are saved under the '''/backup''' directory:<br/><blockquote> | |||
*'''OpenSim & UGAIM servers configuration files''' (''to be restored into QSims/bin''): | |||
<blockquote> | <blockquote> | ||
*/bin/'''OpenSim.ini''' | |||
*/bin/'''estate_settings.xml''' | |||
*/bin/'''AssetServer_Config.xml''' | |||
*/bin/'''GridServer_Config.xml''' | |||
*/bin/'''InventoryServer_Config.xml''' | |||
* /bin/'''OpenSim.ini''' | */bin/'''MessagingServer_Config.xml''' | ||
* /bin/'''estate_settings.xml''' | */bin/'''UserServer_Config.xml''' | ||
* /bin/'''AssetServer_Config.xml''' | |||
* /bin/'''GridServer_Config.xml''' | |||
* /bin/'''InventoryServer_Config.xml''' | |||
* /bin/'''MessagingServer_Config.xml''' | |||
* /bin/'''UserServer_Config.xml''' | |||
</blockquote> | </blockquote> | ||
* '''Regions configuration files''' (''to be restored into QSims/bin/Regions''): | |||
*'''Regions configuration files''' (''to be restored into QSims/bin/Regions''): | |||
<blockquote> | <blockquote> | ||
* /regions/'''Regions.ini''' | */regions/'''Regions.ini''' | ||
* /regions/'''default.xml''' (''old OpenSim version'') | */regions/'''default.xml''' (''old OpenSim version'') | ||
* /regions/'''yyyyyy.xml''' - ''any XML region files'' (''old OpenSim version'') | */regions/'''yyyyyy.xml''' - ''any XML region files'' (''old OpenSim version'') | ||
</blockquote> | </blockquote> | ||
* '''QS-Manager configuration file''' (''to be restored into QSims/web/qsmanager/settings'') | |||
*'''QS-Manager configuration file''' (''to be restored into QSims/web/qsmanager/settings'') | |||
('''xxxx=qsmanager for Q-Sims FULL Edition and xxxx=qsm_lite for Q-Sims LITE Edition''): | ('''xxxx=qsmanager for Q-Sims FULL Edition and xxxx=qsm_lite for Q-Sims LITE Edition''): | ||
<blockquote> | <blockquote> | ||
* /settings/'''config.php''' | */settings/'''config.php''' | ||
</blockquote> | </blockquote> | ||
* '''FreeSwitch configuration file for Voice Chat [1]''' (''to be restored into freeswitch/conf/autoload_configs''): | |||
*'''FreeSwitch configuration file for Voice Chat [1]''' (''to be restored into freeswitch/conf/autoload_configs''): | |||
<blockquote> | <blockquote> | ||
* /settings/'''xml_curl.conf.xml''' | */settings/'''xml_curl.conf.xml''' | ||
<small>[1] Only if FreeSwitch is available</small> | <small>[1] Only if FreeSwitch is available</small></blockquote></blockquote> | ||
</blockquote> | |||
</blockquote> | |||
</blockquote></blockquote> | |||
= Upgrades = | = Upgrades = | ||
<blockquote>Because OpenSim is in constant evolution, they are continuous new versions released.<br/>OpenSim is under SVN management for people who are willing to recompile the code themselves.<br/>Q-Sims deals only with the '''compiled code version of OpenSim''' (''because SVN links may be subject to change, please have a look at the OpenSim forum'')<br/><br/><span style="color:red">'''WARNING''': We are <u>NOT committed</u> to provide compiled version of the OpenSim releases nor responsible for release incompatibilities or bugs. Please check the OpenSim website for binary files and post on the appropriate forums.</span><br/><br/> | |||
== OpenSim manual upgrade == | |||
<blockquote> | <blockquote> | ||
*'''Download''' the new binary archive (''the same version works for both Windows and Linux. Mono is doing the work under Linux'') | |||
*'''Save''' the '''configuration''', '''regions''' and '''database''' files mentioned above<br/>''with Q-Sims FULL Edition, during the installation, QS-Manager has already saved a copy of the configuration files under /backup folders, but don't rely too much on it'' | |||
*'''Extract''' the '''/bin''' folder from the OpenSim archive and Overwrite the '''/share/xxx_DATA/.qpkg/QSims/bin''' folder with it. | |||
*'''Restore''' your previously saved files | |||
*Open a SSH console and start OpenSim into it | |||
<blockquote><pre># cd /share/xxx_DATA/.qpkg/QSims | |||
* '''Download''' the new binary archive (''the same version works for both Windows and Linux. Mono is doing the work under Linux'') | |||
* '''Save''' the '''configuration''', '''regions''' and '''database''' files mentioned above<br>''with Q-Sims FULL Edition, during the installation, QS-Manager has already saved a copy of the configuration files under /backup folders, but don't rely too much on it'' | |||
* '''Extract''' the '''/bin''' folder from the OpenSim archive and Overwrite the '''/share/xxx_DATA/.qpkg/QSims/bin''' folder with it. | |||
* '''Restore''' your previously saved files | |||
* Open a SSH console and start OpenSim into it | |||
<blockquote> | |||
<pre> | |||
# cd /share/xxx_DATA/.qpkg/QSims | |||
# chmod -R 777 bin | # chmod -R 777 bin | ||
# cd bin | # cd bin | ||
# mono OpenSim.exe | # mono OpenSim.exe | ||
</pre> | </pre> | ||
<small>In Grid mode (''Private Grid''), you shall start first the UGAIM servers if any.</small> | <small>In Grid mode (''Private Grid''), you shall start first the UGAIM servers if any.</small> | ||
</blockquote> | </blockquote> | ||
* '''Check''' the correct pace of the operations | *'''Check''' the correct pace of the operations | ||
* '''WAIT, WAIT, WAIT, WAIT...''' until all scripts are loaded, storing performed and eventually database migration completed.<br>Lauching a viewer before the end of the process may end with a crash due to incomplete setup (''see in the [[Q-Sims_-_Troubleshooting|Troubleshooting]] section the queuing constraints''). | *'''WAIT, WAIT, WAIT, WAIT...''' until all scripts are loaded, storing performed and eventually database migration completed.<br/>Lauching a viewer before the end of the process may end with a crash due to incomplete setup (''see in the [[Q-Sims_-_Troubleshooting|Troubleshooting]] section the queuing constraints''). | ||
</blockquote> | </blockquote> | ||
== QS-Manager manual upgrade == | |||
== QS-Manager manual upgrade== | |||
<blockquote> | <blockquote> | ||
* '''Download''' the new archive | *'''Download''' the new archive | ||
* '''Save''' your '''QSims/web/xxxx/settings/conf.php''' file ('''xxxx=qsmanager for Q-Sims FULL Edition and xxxx=qsm_lite for Q-Sims LITE Edition'') | *'''Save''' your '''QSims/web/xxxx/settings/conf.php''' file ('''xxxx=qsmanager for Q-Sims FULL Edition and xxxx=qsm_lite for Q-Sims LITE Edition'') | ||
* '''Overwrite''' the ''qsmanager'' folder with the archive files | *'''Overwrite''' the ''qsmanager'' folder with the archive files | ||
* '''Restore''' your previously saved file (''config.php has also been saved in backup/settings during the installation and shall be restored into the /web/qsmanager/settings folder''). | *'''Restore''' your previously saved file (''config.php has also been saved in backup/settings during the installation and shall be restored into the /web/qsmanager/settings folder''). | ||
</blockquote> | </blockquote></blockquote> | ||
</blockquote> | <br/> | ||
<br | [[Category:Communications]] [[Category:QPKG]] [[Category:Q-Sims]] | ||
[[Category:Communications]] [[Category:QPKG | |||
Revision as of 18:08, 5 August 2015
by AdNovea - June 2009
Q-Sims Homepage
Backup / Restore
IMPORTANT: Frequently backup your databases.
When Q-Sims is enabled, there is a daily backup of the database performed and the latest 15 (by default, can be changed into qsims.sh) backup files are kept.
Database backups are performed every day and can also be run from a console (no backup performed if the daily archive already exists):# cd /share/xxx_DATA/.qpkg/QSims # ./qsims backup
WARNING: because the database structure may change between OpenSim simulator updates, your database archives may become unusable! In such a situation, you may have to consider a database migration if this is managed by the upgrade.
SQLite database
Each day (assuming Q-Sims is Enabled), a backup of the SQLite database files located into the QSims/bin/*db is done. Archive files are located under the QSims/backup/sqlite folder and rename under 20xx-mm-dd_dbname.db:
- Asset.db (in Private grid mode only)
- inventoryStore.db (in Private grid mode only)
- LocalUserStatistics.db
- OpenSim.db
- userprofiles.db (in Private grid mode only)
Restore an archive file
To restore, overwrite previous database files with the archived ones.
MySQL database
The data are stored into a MySQL database.
- Each day (assuming Q-Sims is Enabled), a backup of the MySQL database is performed. The archive file named as 20yy-mm-dd_QSims.sql.tgz is saved under the QSims/backup/mysql folder.
- Your database can be manually backuped using phpMyAdmin.
Restore an archive file
To restore an automatically archived database file, open a SSH console, change directory to the QSims root directory and restore the selected archive as shown in the example below:
# cd /share/xxx_DATA/.qpkg/QSims # ./qsims.sh restore ../backup/20yy-mm-dd_QSims.sql.tgz
- Enter yes to start restoration
ALL DATABASE INFORMATION WILL BE OVERWRITTEN
Backup / Restore from the OpenSim console
To save and load data for each region in the OAR format (OpenSim Archive). This is very helpful to save/restore changes of a specific regions during building.
See also OpenSim console.
- Open a SSH console
- List all the running process (screen -list)
- Open the screen console of the xxx.OpenSim process (screen -r xxx.OpenSim)
Save region into OAR file
We assume your region to be OpenTest and the file to be saved into the /backup folder.
Region (<region_name>)# change region OpenTest Region (OpenTest)# save oar ../backup/20yy-mm-dd_OpenTest.oarRestore region from an OAR file
Region (<region_name>)# change region OpenTest Region (OpenTest)# load oar ../backup/20yy-mm-dd_OpenTest.oar
NOTE: Because we had some troubles to restore OAR files between different OpenSim versions, we do recommend to also save each of your regions into XML2 format files using:
change region OpenTest
save xml2 ../backup/20yy-mm-dd_OpenTest.xml2
The terrains are not saved into the XML format files therefore you must save each of your terrains. There are many options (extensions) for terrain formats (R32, RAW, JPG, BMP, PNG, TIF, TER, etc...). To save the terrain of the selected region use:
change region OpenTest
terrain save ../backup/20yy-mm-dd_OpenTest.r32
You must also save your inventory which is located on the Inventory server (OSGrid server is your are running your grid on OSGrid).Save Inventory into IAR file
Region (<region_name>)# change region OpenTest Region (OpenTest)# save iar <user name> <path> <password> ../backup/20yy-mm-dd_Inventory.iarNOTE: To save the whole inventory set the path value to /*
OAR and IAR files are archive files that can be open using the WinRAR tool for example.
QS-Manager backup
QS-Manager automatically saved the configuration files generated by the QSA (Quick Start Assistant). We urge you to run the QSA whenever you want to reconfigure Q-Sims.
The following files are saved under the /backup directory:
- OpenSim & UGAIM servers configuration files (to be restored into QSims/bin):
- /bin/OpenSim.ini
- /bin/estate_settings.xml
- /bin/AssetServer_Config.xml
- /bin/GridServer_Config.xml
- /bin/InventoryServer_Config.xml
- /bin/MessagingServer_Config.xml
- /bin/UserServer_Config.xml
- Regions configuration files (to be restored into QSims/bin/Regions):
- /regions/Regions.ini
- /regions/default.xml (old OpenSim version)
- /regions/yyyyyy.xml - any XML region files (old OpenSim version)
- QS-Manager configuration file (to be restored into QSims/web/qsmanager/settings)
('xxxx=qsmanager for Q-Sims FULL Edition and xxxx=qsm_lite for Q-Sims LITE Edition):
- /settings/config.php
- FreeSwitch configuration file for Voice Chat [1] (to be restored into freeswitch/conf/autoload_configs):
- /settings/xml_curl.conf.xml
[1] Only if FreeSwitch is available
Upgrades
Because OpenSim is in constant evolution, they are continuous new versions released.
OpenSim is under SVN management for people who are willing to recompile the code themselves.
Q-Sims deals only with the compiled code version of OpenSim (because SVN links may be subject to change, please have a look at the OpenSim forum)
WARNING: We are NOT committed to provide compiled version of the OpenSim releases nor responsible for release incompatibilities or bugs. Please check the OpenSim website for binary files and post on the appropriate forums.
OpenSim manual upgrade
- Download the new binary archive (the same version works for both Windows and Linux. Mono is doing the work under Linux)
- Save the configuration, regions and database files mentioned above
with Q-Sims FULL Edition, during the installation, QS-Manager has already saved a copy of the configuration files under /backup folders, but don't rely too much on it- Extract the /bin folder from the OpenSim archive and Overwrite the /share/xxx_DATA/.qpkg/QSims/bin folder with it.
- Restore your previously saved files
- Open a SSH console and start OpenSim into it
# cd /share/xxx_DATA/.qpkg/QSims # chmod -R 777 bin # cd bin # mono OpenSim.exeIn Grid mode (Private Grid), you shall start first the UGAIM servers if any.
- Check the correct pace of the operations
- WAIT, WAIT, WAIT, WAIT... until all scripts are loaded, storing performed and eventually database migration completed.
Lauching a viewer before the end of the process may end with a crash due to incomplete setup (see in the Troubleshooting section the queuing constraints).
QS-Manager manual upgrade
- Download the new archive
- Save your QSims/web/xxxx/settings/conf.php file ('xxxx=qsmanager for Q-Sims FULL Edition and xxxx=qsm_lite for Q-Sims LITE Edition)
- Overwrite the qsmanager folder with the archive files
- Restore your previously saved file (config.php has also been saved in backup/settings during the installation and shall be restored into the /web/qsmanager/settings folder).