[7.450][BUG][FIXED] broken Mail Reporting

As already mentioned by another member, dashboard does not count processed mails. On top of that all the reporting for the mails is broken. The graphs are working but no reporting.
If I try to generate a report manually, I get this in the system logs basically indicating that "mailsec_data" has a problem with it...

2009:05:30-13:13:48 gatekeeper postgres[31574]: [13-1] ERROR:  relation "mailsec_data" does not exist
2009:05:30-13:13:48 gatekeeper postgres[31574]: [13-2] STATEMENT:  SELECT (dstuser || '@' || dstdomain) as recipient,transform_common(CAST(sum(mailcount) AS BIGINT)) as
2009:05:30-13:13:48 gatekeeper postgres[31574]: [13-3]  sum_count_str,sum(mailcount) as sum_count_int,transform_SI(CAST(sum(mailsize) AS BIGINT),1) as sum_size_str,sum(mailsize) as
2009:05:30-13:13:48 gatekeeper postgres[31574]: [13-4]  sum_size_int,transform_common(count(DISTINCT (srcuser || '@' || srcdomain))) as cnt_sdr_str,count(DISTINCT (srcuser || '@' ||
2009:05:30-13:13:48 gatekeeper postgres[31574]: [13-5]  srcdomain)) as cnt_sdr_int FROM mailsec_data WHERE dayabs = 733557 AND type = 1 GROUP BY recipient ORDER BY sum_count_int DESC

I guess a little whoopsie in postgresql.

Parents

0 RDL over 16 years ago

Sorry, above message should be under another error report. FYI, I rebooted the box 7.450 and it still isn't showing email stats on the dashboard, but IS processing mail. Weird.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Monarch over 16 years ago in reply to RDL

I assume these problems are all due to the same cause like this firstly reported one: https://community.sophos.com/products/unified-threat-management/astaroorg/f/98/t/67452
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 nitehawk over 16 years ago in reply to Monarch

Monarch, I've had the same in mind. Can either Billybob or RDL confirm this to be related to the thread mentioned by you? If yes, I would like to set this thread to status "DUPE".
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Billybob over 16 years ago in reply to nitehawk

I guess they could be the same. By dashboard, I assumed, it meant the main page that says dashboard. I was referring to the mail security tab, but in any case if the underline culprit is the same "mailsec_data" table then I guess they are related but I am not sure.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Billybob over 16 years ago in reply to nitehawk

I guess they could be the same. By dashboard, I assumed, it meant the main page that says dashboard. I was referring to the mail security tab, but in any case if the underline culprit is the same "mailsec_data" table then I guess they are related but I am not sure.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 nitehawk over 16 years ago in reply to Billybob

I'll file a ticket for this since I'm not pretty sure if this is really the dashboard issue. I can confirm this on my gateway:

calvin:/root # cat /var/log/system.log | grep 'relation "mailsec_'
2009:06:13-22:51:51 (none) postgres[3019]: [34-1] ERROR:  relation "mailsec_archive" does not exist
2009:06:13-22:51:52 (none) postgres[3019]: [51-1] ERROR:  relation "mailsec_archive" does not exist
2009:06:13-22:51:52 (none) postgres[3019]: [55-1] ERROR:  relation "mailsec_archive" does not exist
2009:06:13-22:51:52 (none) postgres[3019]: [56-1] ERROR:  relation "mailsec_data" does not exist
2009:06:13-22:51:52 (none) postgres[3019]: [57-1] ERROR:  relation "mailsec_data" does not exist
2009:06:13-23:04:19 calvin postgres[5810]: [3-1] ERROR:  relation "mailsec_data" does not exist
2009:06:13-23:04:19 calvin postgres[5810]: [4-1] ERROR:  relation "mailsec_data" does not exist

I can't find them in the database, too:

 public | mailanon_addrs                | table    | reporting
 public | mailanon_addrs__rowno_seq     | sequence | reporting
 public | mailanon_domains              | table    | reporting
 public | mailanon_domains__rowno_seq   | sequence | reporting
 public | mailsec                       | table    | reporting
 public | mailsec__rowno_seq            | sequence | reporting

Let's wait for a developer's feedback :-).

Cheers
nitehawk

0 Astaro Beta Bot over 16 years ago in reply to nitehawk

Astaro Beta Report
--------------------------------
Version: 7.450
Type: BUG
State: FIXED
Reporter: Billybob
Contributor: RDL,Monarch
MantisID: 10594
--------------------------------