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