第 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