Author: Kellen Fields
Date: November 16, 2023
Environmental details: Self-hosted
When installing Jama Connect, you must create a my.cnf file with the appropriate settings, listed: HERE. This will cause database connection issues if this file is ignored when setting up MySQL.
- Open up my.cnf on database server, located at /etc/mysql/
- Add [mysqld] to the top of the my.cnf file so the server reads it when starting.
- The new file will look like this (all base settings recommended):
# The MySQL database server configuration file.
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
# For explanations see
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
According to MySQL documentation. "You can place InnoDB options in the [mysqld] group of any option file that your server reads when it starts."
Jama's recommended settings do include innodb options.