Missing SPAM reports

[vsupport]

Since the upgrade to 7.3.6

root@pmg1:~# pmgreport -debug 1
DBD:g::db do failed: ERROR: cannot cast type timestamp with time zone to integer
LINE 1: ...Count = Count + 1,MTime = EXTRACT(EPOCH FROM now()::INTEGER)...
^ at /usr/share/perl5/PMG/Statistic.pm line 109.

Any thought?

 

[mdo]

Others (me included) reported this issue in a different ticket ("After succesfully upgrade to v8 error on pmg-smtp-filter") related to the PMG 8.0 upgrade but you are right, our logs show that this issue must have started with the 7.3-6 upgrade, not as part of the 8.0 upgrade (which we did 2 days later).

 

[Stoiko Ivanov]

The issue is present both in 8.0 and the latest 7.3 - but a patch has been applied to both versions:
https://lists.proxmox.com/pipermail/pmg-devel/2023-June/002472.html

We'll ship updated packages soon!
Thanks for the report!

 

[Stoiko Ivanov]

pmg-api 8.0.4 (for Debian Bookworm) and pmg-api 7.3-7 (for Debian Bullseye) are available in the pmgtest repository

(see https://pmg.proxmox.com/pmg-docs/pmg-admin-guide.html#pmg_package_repositories)

and contain the fix for this.

 

[sbr]

Spam quarantine page is empty in GUI, while there are some messages in /var/spool/pmg/spam

>ls -al /var/spool/pmg/spam
total 16
drwxr-xr-x 4 root root 4096 Jul 3 15:34 .
drwxr-xr-x 6 root root 4096 Jun 29 22:05 ..
drwxr-xr-x 2 root root 4096 Jul 3 15:34 41
drwxr-xr-x 2 root root 4096 Jul 2 15:13 8E

pmgversion -v
proxmox-mailgateway: 8.0.0 (API: 8.0.4/d649469164b3, running kernel: 6.2.16-3-pve)
pmg-api: 8.0.4
pmg-gui: 4.0.2
pve-kernel-6.2: 8.0.2
pve-kernel-6.2.16-3-pve: 6.2.16-3
clamav-daemon: 1.0.1+dfsg-2
ifupdown2: 3.2.0-1+pmx3
libarchive-perl: 3.6.2
libjs-extjs: 7.0.0-3
libjs-framework7: 4.4.7-2
libproxmox-acme-perl: 1.4.6
libproxmox-acme-plugins: 1.4.6
libpve-apiclient-perl: 3.3.0
libpve-common-perl: 8.0.6
libpve-http-server-perl: 5.0.4
libxdgmime-perl: 1.1.0
lvm2: 2.03.16-2
pmg-docs: 8.0.1
pmg-i18n: 3.0.5
pmg-log-tracker: 2.4.1
proxmox-mini-journalreader: 1.4.0
proxmox-offline-mirror-helper: 0.6.2
proxmox-spamassassin: 4.0.0-4
proxmox-widget-toolkit: 4.0.6
pve-firmware: 3.7-1
pve-xtermjs: 4.16.0-3
zfsutils-linux: 2.1.12-pve1

 

[Stoiko Ivanov]

Spam quarantine page is empty in GUI, while there are some messages in /var/spool/pmg/spam

Yes this is perfectly possible.
a) you just showed the first level of directories in the spamquarantine (the quarantined mails are put in many subdirectories to not have a directory with too many files, which usually slows access to files and metadata quite a lot (most MTA daemons also split their spool directories) - if you want to find out which and how many files are still on disk - try `find /var/spool/pmg/spam`
b) You need to take into account that the spam-quarantine can be empty for one user, while still having messages for another (although nowadays you can select 'all' as mailbox to see the quarantine of all users
c) cleanup of the quarantine happens lazily after the quarantine life-time expires - if you click on deliver/delete the mail is only marked as deleted in the database - the actual removal of the file happens after it is past the lifetime (in the `pmgqm purge` invocation done by the pmgspamreport.timer)

I hope this explains it!

 

[sbr]

Thanks for hint, I indeed had to select mailbox to see list of messages.

 

[mdo]

pmg-api 8.0.4 (for Debian Bookworm) and pmg-api 7.3-7 (for Debian Bullseye) are available in the pmgtest repository

(see https://pmg.proxmox.com/pmg-docs/pmg-admin-guide.html#pmg_package_repositories)

and contain the fix for this.

Thanks for the fix! All working here.