Tigase has had a change to the PubSub Schema, to upgrade to PubSub 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.
Note
Current PubSub Schema is v3.3.0, you will need to repeat these instructions for v3.1.0, v3.2.0 and then v3.3.0 before you run Tigase V7.1.0.
The PubSub Schema has been streamlined for better resource use, this change affects all users of Tigase. To prepare your database for the new schema, first be sure to create a backup! Then apply the appropriate PubSub schema to your MySQL and it will add the new storage procedure.
All these files should be in your /database folder within Tigase, however if you are missing the appropriate files, use the links below and place them into that folder.
The MySQL schema can be found Here.
The Derby schema can be found Here.
The PostGRESQL schema can be found Here.
The same files are also included in all distributions of v8.0.0 in [tigaseroot]/database/ . All changes to database schema are meant to be backward compatible.
You can use a utility in Tigase to update the schema using the following command from the Tigase root:
-
Linux
java -cp "jars/*" tigase.db.util.DBSchemaLoader
-
Windows:
java -cp jars/* tigase.db.util.DBSchemaLoader
Note
Some variation may be necessary depending on how your java build uses -cp
option
Use the following options to customize. Options in bold are required.:
-dbType
database_type {derby, mysql, postgresql, sqlserver} (required)-schemaVersion
schema version {4, 5, 5-1}-dbName
database name (required)-dbHostname
database hostname (default is localhost)-dbUser
tigase username-dbPass
tigase user password-rootUser
database root username (required)-rootPass
database root password (required)-file path
to sql schema file (required)-query
sql query to execute-logLevel
java logger Level-adminJID
comma separated list of admin JIDs-adminJIDpass
password (one for all entered JIDs
Note
Arguments take following precedent: query, file, whole schema
As a result your final command should look something like this:
java -cp "jars/*" tigase.db.util.DBSchemaLoader -dbType mysql -dbName tigasedb -dbUser root -dbPass password -file database/mysql-pubsub-schema-3.1.0.sql