Skip to main content

Bulk Update Recipient Report Settings

On a SSH/Command prompt enter the following command:

mysql -u root -p

At the Enter password prompt enter the MySQL root password you set during initial setup.

On the MariaDB [(none)]> prompt enter the following:

use hermes;

You will get the following output:

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

On the MariaDB [hermes]> prompt enter the following:

Enable Report Only if Quarantined Messages Exist

update user_settings set report_enabled = 'YES';

Enable Report Regardless if Quarantined Messages Exist

update user_settings set report_enabled = 'ALL';

Disable Quarantine Reports

update user_settings set report_enabled = 'NO';

At the MariaDB [hermes]> prompt enter the following:

exit