Follow steps below to prepare the MySQL database:
Create the database space for the Tigase server:
mysqladmin -p create tigasedb
Add the tigase_user
user and grant access to the tigasedb database. Depending on how you plan to connect to the database (locally or over the
network) use one of following commands or all if you are not sure:
echo "GRANT ALL ON tigasedb.* TO tigase_user@'%' \ IDENTIFIED BY 'tigase_passwd'; \ FLUSH PRIVILEGES;" | mysql -u root -pdbpass mysql
echo "GRANT ALL ON tigasedb.* TO tigase_user@'localhost' \ IDENTIFIED BY 'tigase_passwd'; \ FLUSH PRIVILEGES;" | mysql -u root -pdbpass mysql
Load the proper mysql schemas into the database.
mysql -u dbuser -p tigasedb < mysql-common-0.0.1.sql mysql -u dbuser -p tigasedb < mysql-common-0.0.2.sql etc..
You will need to repeat this process for the following files:
mysql-common-0.0.1.sql mysql-common-0.0.2.sql mysql-server-7.0.0.sql mysql-server-7.1.0.sql mysql-server-8.0.0.sql mysql-muc-3.0.0.sql mysql-pubsub-3.1.0.sql mysql-pubsub-3.2.0.sql mysql-pubsub-4.0.0.sql mysql-http-api-2.0.0.sql
Other components may require installation such as:
mysql-socks5-2.0.0.sql mysql-push-1.0.0.sql mysql-message-archiving-2.0.0.sql mysql-unified-archive-2.0.0.sql