V18.0.5 mr-5 reporting is broken.

Hello rfcat_vk,

Thank you for reaching out!

BST is British Standard Time. 

Can you confirm by running the frequency the email is being sent out

# grep Executive smtpd_main.log

# less applog.log | grep "Executive"

# less ntpclient.log

# less iview.log (Does this one shows any error?)

# psql -U nobody -d corporate -c "select * from tblmailschedule;" -x

I am waiting for my report, I checked the one from yesterday but it was ok, this was the Executive Report, is this incorrect zone time showing for all of your reports?

Also double-check the time didn't change in the Firewall (System >> Administration >> Time) I don't think so. or just run 

# date

Regards,

Hi emmosophos,

The first command file smtpd_mail.log does not exist.

Current time is 1021.

Ian

Hello rfcat_vk,

I added some more logs to my initial answer.

the log is smtpd_mail.log 

Regards,

Hi emmosophos,

typing mistake on answer smtpd_mail.log does not exist.

I assume I need to change to the log directory because none of the other files are found?

Ian

Hello rfcat_vk,

Oh sorry, yes you need to change to /log/ directory.

and yes I keep writing incorrectly the correct log is smtpd_main.log

Regards

Interestingly, I have not received any reports for over an hour basically since I started trying to run your requests for answers.

Ian

The reports started being delivered every 30 minutes again this morning.

The logviewer shows the mail being sent and delivered.

Ian

The reports started being delivered every 30 minutes again this morning.

The logviewer shows the mail being sent and delivered.

Ian

I restarted the XG to see if that wold fix the issue. The reports generated immediately after the restart still show BST, why?

Ian

I tried running those commands you provided after the restart and still files not found.

current date and time

Fri Apr  9 08:44:31 AEST 2021  
Ian

Hello rfcat_vk,

Thank you for the follow-up.

That’s strange, can you please open a ticket with Support and reference this Case ID, include the Email report, and the output of the commands I share with you.

Regards,

Hi emmosophos,

I am  hom eiser, so the support is not available to me. Probably the best I can do open the access to the XG or re-install if I can find an ISO.

Ian

Hello rfcat_vk,

If you’re ok, you can send me via PM the Access ID to your device and I can investigate.

Regard

Hi EmmoSophos,

done, thank you.

Ian

Today's report's (10th April) show the reporting date for the 8th of April. I was trying to locate guest user traffic which of course was on the 9th  of April.