Chapter 7. Database Management

Table of Contents

Recommended database versions
Database Preparation
dbSchemaLoader Utility
Prepare the MySQL Database for the Tigase Server
Prepare the Derby Database for the Tigase Server
Prepare the MS SQL Server Database for the Tigase Server
Prepare the PostgreSQL Database for the Tigase Server
Preparing Tigase for MongoDB
Hashed User Passwords in Database
Shortcut
Full Route
Tigase Server and Multiple Databases
Importing User Data
Importing Existing Data
Connecting the Tigase Server to MySQL Database
Integrating Tigase Server with Drupal
Integrating Tigase Server With LibreSource
MySQL Database Use
PostgreSQL Database Use
Schema Updates
Tigase Server Schema v7.1 Updates
Tigase 5.1 Database Schema Upgrade
Derby Database Schema Upgrade for Tigase 5.1
MySQL Database Schema Upgrade for Tigase 5.1
PostgreSQL Database Schema Upgrade for Tigase 5.1
Tigase Database Minor but Useful Schema Change in Version 5.1.0
Tigase Server Version 4.x
MySQL Database Schema Upgrade for Tigase 4.0

Tigase is coded to perform with multiple database types and numbers. Owing to it’s versatile nature, there are some tools and procedures that may be of use to certain administrators.

Recommended database versions

As of v7.1.0 here are the minimum and recommended versions of databases for use with Tigase:

DatabaseRecommended VersionMinimum VersionAdditional Information

DerbyDB

10.12.1.1

10.12.1.1

Included with Tigase XMPP Server

MySQL

5.6

5.5

 

SQLServer

2012

2008 R2

 

MongoDB

2.6

2.6

Driver not working with mongoDB 3.0 or newer.

Although Tigase may support other versions of databases, these are the ones we are most familiar with in offering support and advice. Use of databases outside these guidelines may result in unforeseen errors.