The section describes installation and configuration of the MySQL database to work with Tigase server.
Download the binary package from MySQL download area at mysql.com. Make sure you select executable proper for your operating system.
Run the installation program and follow default installation steps. When the installation is complete find the MySQL elements in the Windows Start menu and run the MySQL Configuration Wizard. Follow the wizard and make sure to check settings against the screenshots in the guide below.
In Welcome window just press 'Next'.(pic.1)
In the next window select option: 'Detailed Configuration' and press 'Next' (pic. 2)
On the next screen select option: 'Server Machine' and press 'Next' (pic. 3)
On the forth windows leave the default" 'Multi-functional Database' and press 'Next' (pic. 4)
On the step number five just press 'Next' using defaults. (pic. 5)
Again, on window 6 select the default - 'Decision Support (DSS)/OLAP' and press 'Next' (pic.6)
Make sure you switch OFF the 'Strict mode' and and press 'Next' (pic. 7)
On the character encoding page select: 'Manual Selected Default Character set/ Collation' and 'utf8', press 'Next' (pic.8)
On next window select 'Include Bin Directory in Windows PATH' and press 'Next' (pic.9)
On this window just enter the database super user password and make sure you remember it. When ready press 'Next' (pic. 10)
This is the last screen. Press 'Execute' to save the configuration parameters. (pic. 11)
When the configuration is saved you can repeat all the steps and change settings at any time by running: START ⇒ Programs ⇒ MYSQL⇒ MYSQL serwer machine⇒ MySQL Server Instance Config Wizard
Now we have to setup Tigase database. From the Start menu run the MySQL console and enter all commands below finishing them with <ENTER>:
-
Create the database:
mysql>create database tigasedb;
-
Add database user:
mysql> GRANT ALL ON tigasedb.* TO tigase_user@'%' IDENTIFIED BY 'tigase_passwd'; mysql> GRANT ALL ON tigasedb.* TO tigase_user@'localhost' IDENTIFIED BY 'tigase_passwd'; mysql> GRANT ALL ON tigasedb.* TO tigase_user IDENTIFIED BY 'tigase_passwd'; mysql> FLUSH PRIVILEGES;
-
Load Tigase database schema:
mysql> use tigasedb; mysql> source c:/Program Files/Tigase/database/mysql-schema.sql;
When the system is up and running you can connect with any XMPP client (Psi for example) to your server to see if it is working.