Configuration files: Database

Database configuration file

Location: `/batm/config/database`

Mandatory entries with default values

db_name=batm
db_username=batm
db_password=batm
db_host=127.0.0.1
db_port=3306

Optional DB query entries with default values

Available from 20210808 release.

Note: the two entries below are different for Master and Admin (CAS GUI)

db_connection_params_master=useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8&autoReconnect=true&useSSL=false
db_connection_params_admin=useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8&autoReconnect=true&serverTimezone=UTC&useCursorFetch=true&enabledTLSProtocols=TLSv1,TLSv1.1,TLSv1.2,TLSv1.3

You can specify these entries when you need to provide different or additional query (connection URL) parameters (e.g. SSL settings).

Don’t change the value in standalone.xml’s <connection-url> tag, use this config file instead.

MySQL Command Line Options

When in a need to customize mysql command line options (e.g. in batm-manage backup/restore command) please refer to https://dev.mysql.com/doc/refman/5.7/en/option-files.html to use Global options to define your custom parameters.

Available options: https://dev.mysql.com/doc/refman/5.7/en/connection-options.html

Root passwords

The MySQL root password is required for database restores. Ubuntu (by default) doesn’t set a password for the MySQL “root” user during installation. The schema used by MySQL is not as insecure as you might think, but it could still be hardened nonetheless. A missing root password may cause issues during restores, depending upon the version you use.

The MySQL “root” user and your Ubuntu “root” user passwords are not the same thing.

Creating a root password is recommended for improved security.

If you currently don’t have a root password:

mysql -u root -e "ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'rootpass'; FLUSH PRIVILEGES;"

replace rootpass with any memorable root password.

If you have a root password and wish to change it:

replace rootpass with any memorable root password, then
enter the old password when requested.

If you’ve lost or forgotten your old root password, please refer to this excellent article from Digital Ocean:

https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password-on-ubuntu-20-04

remember, you are using MySQL (not MariaDB). Follow the correct instructions.

How to examine your password configuration:

To test if you have a MySQL password set, use:

This is an example of an unset (or improperly set) password:

the insecure authorization plugin is using “auth_socket” (which is native to newer Ubuntu versions and the default on DO droplets).

This is what should happen:

Enter the (now required) password, and then type (at the mysql prompt):

Perfect.