Chapter 10. Managing databases with the command-line assistant daemon

Procedure

1. Install the database of your choice:

   • To install MySQL, enter:

     # dnf install python3-PyMySQL

   • To install PostgreSQL, enter:

     # dnf install python3-psycopg2

2. Access your database configuration file at /etc/xdg/command-line-assistant/config.toml.

3. Locate and comment out the default configuration. For example:

    [database]
       # type = "sqlite"
       # connection_string = "/var/lib/command-line-assistant/history.db"

4. Configure the database of your choice. The following information is also available in /etc/xdg/command-line-assistant/config.toml.

   1. Set the database type, where <db_type> can be mysql or postgresql.

   2. Set the database details.

       type = <db_type>
       host = "<hostname_or_ip_address>"
       port = "5432"
       username = "<database_user_name>"
       password = "<password>"
       database = "<database_name>"

5. After changing the database type, restart the clad daemon to apply the changes:

   $ sudo systemctl restart clad

Procedure

1. Access your database configuration file at /etc/xdg/command-line-assistant/config.toml.

2. Remove the username and password parameters from the [database] section, for example:

   [database]
   type = "postgresql"
   host = "localhost"
   port = "5432"
   database = "history"

   Note

   If you leave the username and password in the configuration file, these credentials take precedence over the systemd-creds tool.

3. Generate encrypted credentials for your username or password. The following example uses systemd-ask-password commands. The name must follow the schema of database-username and database-password, otherwise, clad does not load the credentials properly.

   1. To generate an encrypted username, run the following command:

      $ systemd-ask-password -n | ( echo "[Service]" && systemd-creds encrypt --name=<database_username> -p - - ) >/etc/systemd/system/clad.service.d/<username>.conf

   2. To generate an encrypted password, run the following command:

      $ systemd-ask-password -n | ( echo "[Service]" && systemd-creds encrypt --name=<database_password> -p - - ) >/etc/systemd/system/clad.service.d/<password>.conf

4. After updating the database credentials, reload systemd and restart the clad daemon to apply the changes:

   $ sudo systemctl daemon-reload
   $ sudo systemctl restart clad