database Configuration File

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.

Copyright © 2020-2024 General Bytes USA LLC