If you are installing a new version of v7.1.0 on a new database, the schema should automatically be installed.
First, shut down any running instances of Tigase to prevent conflicts with database editing.
and run the upgrade procedure to upgrade the cluster’s authorization data.
By default, the procedure will upgrade the authorization data of the shards as well.
DBSchema Loader -db Hostname $ -db Type $ -root User $ -db Pass $ -db Name $ -schema Version $ -root Pass $ -db User $ -admin JID "$" -admin JIDpass $ -log Level ALL -file database/$-schema-upgrade-to-7-1.sqljava -cp jars/* A finalized command will look something like this:java -cp "jars/*"
DBSchema Loader -db Hostname $ -db Type $ -root User $ -db Pass $ -db Name $ -schema Version $ -root Pass $ -db User $ -admin JID "$" -admin JIDpass $ -log Level ALL -file database/$-schema-upgrade-to-7-1Please note that the SQL file for the update will have an associated database with the filename. DBSchema Loader -db Hostname localhost -db Type mysql -root User root -root Pass root -db User admin -db Pass admin -schema Version 7.1 -db Name Tigasedb -admin JID "[email protected]" -admin JIDPass adminpass -log Level ALL -file database/mysql-schema-upgrade-to-7.1Tigase has had a change to the Pub Sub Schema, to upgrade to Pub Sub Schema v7.1 without having to reform your databases, use this guide to update your databases to be compatible with the new version of Tigase.
The AWS Schema Conversion Tool (AWS SCT) is a standalone application that provides a project-based user interface.
AWS SCT is available for Fedora Linux, mac OS, Microsoft Windows, and Ubuntu Linux version 15.04.
The command is as follows: In a linux environmentjava -cp "jars/*" For more information, see Storing Driver Paths in the Global Settings.You can download the database drivers from the following locations.Current Pub Sub Schema is v3.2.0, you will need to repeat these instructions for v3.1.0 and then v3.2.0 before you run Tigase V7.1.0.The Pub Sub Schema has been streamlined for better resource use, this change affects all users of Tigase. The same files are also included in all distributions of v7.1.0 in [tigaseroot]/database/ .
After a schema update has been carried out, services that require the previous version of the schema may cease to operate.