This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

SMTP Reports are empty

When I click on Email Protection the report on the right is empty saying no data available. However, at least 200 emails have moved through the proxy. The executive reports for smtp are empty also.

UTM v9

Where might I look to troubleshoot this?


This thread was automatically locked due to age.
Parents
  • I logged in via ssh as loginuser, then used sudo -i to get root.
    First command ran with no issues.
    Second command complained about only superuser can vacuum. Last I checked, root was superuser. I'll try this with sudo as loginuser.

    From the results of the second command:
    sopho:/root # psql -Ureporting -c"vacuum;" reporting
    WARNING: skipping "pg_database" --- only superuser can vacuum it
    WARNING: skipping "pg_authid" --- only superuser can vacuum it
    WARNING: skipping "pg_tablespace" --- only superuser can vacuum it
    WARNING: skipping "pg_pltemplate" --- only superuser can vacuum it
    WARNING: skipping "pg_shdepend" --- only superuser can vacuum it
    WARNING: skipping "pg_shdescription" --- only superuser can vacuum it
    WARNING: skipping "pg_auth_members" --- only superuser can vacuum it
    VACUUM
    sopho:/root #
Reply
  • I logged in via ssh as loginuser, then used sudo -i to get root.
    First command ran with no issues.
    Second command complained about only superuser can vacuum. Last I checked, root was superuser. I'll try this with sudo as loginuser.

    From the results of the second command:
    sopho:/root # psql -Ureporting -c"vacuum;" reporting
    WARNING: skipping "pg_database" --- only superuser can vacuum it
    WARNING: skipping "pg_authid" --- only superuser can vacuum it
    WARNING: skipping "pg_tablespace" --- only superuser can vacuum it
    WARNING: skipping "pg_pltemplate" --- only superuser can vacuum it
    WARNING: skipping "pg_shdepend" --- only superuser can vacuum it
    WARNING: skipping "pg_shdescription" --- only superuser can vacuum it
    WARNING: skipping "pg_auth_members" --- only superuser can vacuum it
    VACUUM
    sopho:/root #
Children
No Data