Upgrade to MySQL 5.6 or MariaDB 10.0#

Beginning with version 1.7 of i-doit the system requirements for the database back end change. While version 1.6 required at least MySQL 5.5 or MariaDB 5.5, version 1.7 requires MySQL 5.6 or MariaDB 10.0. This may also entail changes to the operating systems which are supported by synetics. This article describes the most important details to ensure that i-doit continues to function completely.

In order to determine which version is in use, the following command can be executed in the command line (this works with both MySQL and MariaDB):

1

mysql --version

For each operating system there may be multiple upgrade paths. We recommend the use of those, which, from our point of view, have the least impact on the system:

Debian GNU/Linux 8#

Version 8 of Debian GNU/Linux contains MySQL 5.5 and MariaDB 10.0 in the standard packages. If MySQL is installed, it is sufficient to install the MariaDB package. In doing so, MySQL is replaced with MariaDB:

1
2

sudo apt-get update
sudo apt-get install mariadb-server php5-mysqlnd

Debian GNU/Linux 7.8#

Version 7.8 of Debian GNU/Linux contains MySQL 5.5 in the standard packages, but not MariaDB. To use MariaDB the official repository for MariaDB can be downloaded and installed. Caution: Third-party repositories may impair the system. MySQL is replaced by MariaDB when installing the latter:

1
2
3
4
5
6

sudo apt-get update
sudo apt-get install python-software-properties
sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
sudo add-apt-repository 'deb [arch=amd64,i386] [http://mirror.23media.de/mariadb/repo/10.0/debian](http://mirror.23media.de/mariadb/repo/10.0/debian) wheezy main'
sudo apt-get update
sudo apt-get install mariadb-server php5-mysqlnd

Ubuntu 14.04 LTS#

Version 14.04 LTS of Ubuntu contains MySQL 5.5, 5.6 and MariaDB 5.5 in the standard packages. Because of this we recommend using MySQL 5.6. Should MySQL 5.5 or MariaDB 5.5 be already installed, then these are replaced by MySQL 5.6:

1
2

sudo apt-get update
sudo apt-get install mysql-server-5.6 php5-mysqlnd mysql-client-core-5.6 mysql-client-5.6

Ubuntu 12.04 LTS#

Version 12.04 LTS of Ubuntu contains MySQL 5.5 in the standard packages but no MariaDB. Since this version of the operating system contains very old packages for MySQL, PHP and Apache Webserver, we do not recommend its usage and instead advise to upgrade to version 14.04 LTS. If this is not feasible, a change to MariaDB 10.0 can be made by downloading and installing the official repository for MariaDB. Caution: Third-party repositories may impair the system. MySQL is replaced with the installation of MariaDB:

1
2
3
4
5
6

sudo apt-get update
sudo apt-get install python-software-properties
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
sudo add-apt-repository 'deb [arch=amd64,i386] [http://mirror.23media.de/mariadb/repo/10.0/ubuntu](http://mirror.23media.de/mariadb/repo/10.0/ubuntu) precise main'
sudo apt-get update
sudo apt-get install mariadb-server php5-mysqlnd

Red Hat Enterprise Linux 7.1#

Version 7.1 of Red Hat Enterprise Linux (RHEL) contains MariaDB 5.5 in the standard packages but no MySQL. To change to MariaDB 10.0, only a few steps are needed according to a blog entry from MariaDB. In this way, MariaDB 5.5 is replaced by 10.0. Caution: Third-party repositories may impair the system.

First of all, the current version is uninstalled:

1

sudo yum remove mariadb-server mariadb-libs

After this, the file /etc/yum.repos.d/MariaDB.repo has to be created and edited:

1
2
3
4
5
6
7

# MariaDB 10.0 RedHat repository list
# [http://mariadb.org/mariadb/repositories/](http://mariadb.org/mariadb/repositories/)
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0/rhel7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Finally, the packages are installed, the MariaDB server is started and the databases are updated:

1
2
3

sudo yum install MariaDB-server MariaDB-client
sudo /etc/init.d/mysql start
sudo mysql_upgrade -uroot -p

When uninstalling the packages as mentioned earlier, the related PHP extension may be uninstalled as well. To install it again we need the following commands:

1
2

sudo yum install php-mysqlnd.x86_64
sudo service httpd restart

Red Hat Enterprise Linux 6.7#

Version 6.7 of Red Hat Enterprise Linux (RHEL) contains MySQL 5.1 in the standard packages but no MariaDB. Since this operating system version contains very old packages for MySQL, PHP and Apache webserver, we generally advise not to use it and instead recommend upgrading to version 7.1. If this is not feasible, a change to MariaDB 10.0 can be made by downloading and installing the official repository for MariaDB wird, as described in a MariaDB blog entry. Caution: Third-party repositories may impair the system.

First of all, the current version is uninstalled:

1

sudo yum remove mysql-server mysql-libs

After this, the file /etc/yum.repos.d/MariaDB.repo has to be created and edited:

1
2
3
4
5
6
7

# MariaDB 10.0 RedHat repository list
# [http://mariadb.org/mariadb/repositories/](http://mariadb.org/mariadb/repositories/)
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0/rhel6-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Finally, the package is installed:

1

sudo yum install MariaDB-server MariaDB-client

SUSE Linux Enterprise Server 12#

Version 12 of SUSE Linux Enterprise Server (SLES) already contains MariaDB 10.0 in the standard packages but not MySQL. Therefore no upgrade is needed.

Windows Server 2008/2012#

XAMPP is recommended if Windows Server 2008/2012 is in usage. The XAMPP distribution made available by Apache Friends includes Apache Webserver, PHP and MariaDB. Care should be taken to always use the latest version.

The following steps are needed if a version of XAMPP without MariaDB 10.0 is applied:

1. Copy the XAMPP folder, in most cases in C:\xampp\
2. Download the latest version of XAMPP from the official website
3. Uninstall the present XAMPP version
4. Delete the XAMPP folder
5. Install the new XAMPP version in the same folder
6. Restore the folders htdocs and mysql\data from the copy of the XAMPP folder, do no overwrite existing files
7. Adjust the configuration files, so that they meet the required system settings
8. Start Apache Webserver and MariaDB5
9. Perform tests

Troubleshooting#

1

mysqli_connect(): Headers and client library minor version mismatch. Headers:50544 Library:100024 (/var/www/html/i-doit/src/classes/components/isys_component_database_mysqli.class.php:16)

1

sudo service apache2 restart