1. Database Installation
If you already have a MySQL or PostgreSQL database installed that you will be using with CleanSpeak, you can skip this section completely.
To use CleanSpeak, you need to install a database. The database requirements are listed above. You can use CleanSpeak with either MySQL or PostgreSQL. Follow the instructions below to install a supported database.
You only need to install either MySQL or PostgreSQL to use CleanSpeak.
1.1. Install MySQL
If you want to use MySQL for your database, you will need to install version 8 or later. Depending on your operating system, you can download and install MySQL or use the operating systems package management tools. Use the instructions below to install MySQL based on your operating system.
To install MySQL on a Linux system, you can use the
yum tools depending on whether or not your Linux distribution is based on Red Hat or Debian. The package name may vary depending on your platform, for example:
<version> is the version you wish to install. Here’s the commands for each:
$ yum install mysql-server
$ sudo apt-get install mysql-server
1.1.2. Windows or macOS
If you are installing MySQL on a platform that does not support RPM or DEB packages, you will need to download it manually from the MySQL website here: https://dev.mysql.com/downloads/mysql/
1.1.3. MySQL and Unicode
To properly store 4 byte unicode, the character set must be set to
By default this configuration is enforced during startup. If CleanSpeak fails to startup due to this validation the log will contain detailed messages about the MySQL configuration.
It is recommended to ensure you have properly configured MySQL to use
If you need to modify your configuration, restart MySQL for the changes to take effect.
[client] default-character-set = utf8mb4 [mysql] default-character-set = utf8mb4 [mysqld] character-set-client-handshake = FALSE character-set-server = utf8mb4 collation-server = utf8mb4_bin
This is a system-wide configuration option, so be certain that this change won’t impact other databases and applications on the same MySQL server. Not all of these configuration options may be available, depending on your database configuration. Once you have configured the available options, you may disable this feature if the startup still fails due to this validation. See
database.mysql.enforce-utf8mb4 in the Configuration reference.
1.2. Installing PostgreSQL
To install PostgreSQL on a Linux system, you can use the
yum tools depending on whether or not your Linux distribution is based on Red Hat or Debian. The package name may vary depending on your platform.
$ sudo yum install postgresql-server postgresql $ sudo yum install postgresql9-contrib.x86_64
$ sudo apt-get install postgresql-server $ sudo apt-get install postgresql-contrib
1.2.2. Windows or macOS
If you are installing PostgreSQL on a platform that does not support RPM or DEB packages, you will need to manually download it from the PostgreSQL website here: https://www.postgresql.org/