Tigase package includes additional tools to make it easier to manage and control you installation. One is used to change configuration settings - config.sh and another is used to manipulate user data in repository - repo.sh.
Depending on whether you use Tigase version built from sources or binary version these scripts might be available in either scripts/ or bin/ subdirectory. To make things simpler let’s assume they are stored in scripts/ directory.
Assuming you have old Tigase server installation with number of users in MySQL database and you want to migrate all of them to LibreSource there are 2 steps involved:
First we need to migrate user data used for authentication. That data will be used by both services: LibreSource and Tigase and they normally stored in LibreSource database. Therefore we have to use LibreSource database connector to handle the data (write or read). Tigase server will be using LibreSource database for reading only but during migration time we need to write user accounts to LS database. Sample command to migrate user accounts looks like this:
./scripts/repo.sh -sc tigase.db.jdbc.JDBCRepository \ -su "jdbc:mysql://localhost/tigase?user=dbuser&password=dbpass" \ -dc tigase.db.jdbc.LibreSourceAuth \ -du "jdbc:postgresql://localhost/libresource?user=demo" \ -cp
Above command will copy all user accounts from MySQL tigase database to libresource database. Please refer to repository management tool documentation for information how to migrate single or selected user accounts.
If you want to also keep all Tigase server data in the same database you have to copy also all other user data like rosters, vCards and so on.
First thing to do we have to load database schema for Tigase data. You don’t have to worry. Tigase tables have distinct names from LibreSource so there is no danger for any conflict. As in example above let’s assume LibreSource data are stored in libresource database and database user name is demo:
psql -q -U demo -d libresource -f database/postgresql-schema.sql
Now we can load transfer all user data from our MySQL database to LibreSource:
./scripts/repo.sh -sc tigase.db.jdbc.JDBCRepository \ -su "jdbc:mysql://localhost/tigase?user=dbuser&password=dbpass" \ -dc tigase.db.jdbc.JDBCRepository \ -du "jdbc:postgresql://localhost/libresource?user=demo" \ -cp
This command looks almost the same as a previous one. Just Java class used for handling destination database is different.