Statistics for Last 24 hrs are missing

[magicspam]

Hello Knarf,

Thank you for your post.

Could you please let us know if the stats are still missing?

If they are, one of the possible causes for this issue could be corrupt log files.

To correct such issues related to file corruptions, please follow the instructions below:

1. Stop MagicSpam by clicking the "Disable Protection" button found under the "Settings" tab in the "System" section.

2. Issue these two commands to clear out the old log and counter data:

rm /var/log/magicspam/.counter*

rm /var/log/magicspam/mslog*

3. Start MagicSpam again by clicking the "Enable Protection" button found under the "Settings" tab in the "System" section.

Please let us know if the above steps resolve the issue, or if you have any further questions.

[Knarf]

Hi, I already tried that without results:

In settings, I disbled protection, deleted the log files in /var/log/magicspam/ amd enabled protection again.
Also I completely removed the extension from Plesk and reinstalled it again.
However, the problem persists.

[magicspam]

Hello Knarf,

Than you for letting us know.

To continue troubleshooting, could you please let us know if there was any changes in your system at or around September 25th?

Could you please send us the listing of:

ls -laR /var/log/magicspam

In addition, could you please let us know the following information about your system:

- MagicSpam Version
- Operating System and Version
- Operating System Architecture (32 bit or 64 bit)
- Plesk Version
- MTA (Qmail, Postfix, Exim)

Thank you Knarf.

[Knarf]

I had reinstalled the complete server at September 17th, after which MagicSpam has worked for a couple of days.
The only changes that I can think of that could have affected the working of MagicSpam, is installing more extensions and changing system time zone (to Europe/Amsterdam) and rebooting the server.
At September 25th I deleted the log files in /var/log/magicspam/ as described in an effort to eliminate the problem as described above, without results.

Answers to your questions:

# ls -laR /var/log/magicspam
/var/log/magicspam:
total 696
drwxr-xr-x 2 magicspam psaadm 4096 Sep 27 00:01 .
drwxr-xr-x 24 root root 4096 Sep 27 03:54 ..
-rw-r----- 1 magicspam psaadm 997 Sep 27 23:07 .counterv2.dat.09
-rw-r----- 1 magicspam psaadm 773 Sep 27 23:07 .counterv2.dat.hourly
-rw-r----- 1 magicspam psaadm 266480 Sep 27 23:07 mslog
-rw-r----- 1 magicspam psaadm 250777 Sep 26 23:55 mslog.1
-rw-r----- 1 magicspam psaadm 158602 Sep 25 23:59 mslog.2

- MagicSpam Version: 2.0.18-1
- Operating System and Version: CentOS Linux 7.5.1804 (Core)‬
- Operating System Architecture (32 bit or 64 bit): 64 bit
- Plesk Version: Plesk Onyx Version 17.8.11 Update #22
- MTA (Qmail, Postfix, Exim): Postfix

Thank you for your time to investigate this problem.

[magicspam]

Hello Knarf,

Thank you for your post.

Based on the provided information, we believe that the issue is related to incorrect time zone in the php.ini file; could you please check the following file:

/opt/psa/admin/conf/php.ini

and make sure that the correct timezone is configured to Europe/Amsterdam as well?

If you change the value of the timezone in the php.ini file, please remember to reload the php.ini.

Please let us know if this resolves the issue or if you need any further assistance.

[Knarf]

Thank you for your information. I tried what you suggested but I couldn't find the provided path to php.ini, but I found a path to php.ini in /etc/php.ini
There I made the following changes:

Code: Select all

[Date]
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
date.timezone = "Europe/Amsterdam"

; http://php.net/date.default-latitude
date.default_latitude = 52.371807

; http://php.net/date.default-longitude
date.default_longitude = 4.896029

In Plesk > Tools & Settings > Services Management, I restarted Apache, Nginx, PHP-FPM services, and also I restarted MagicSpam through the UI (MagicSpam Protection > Settings > Disable Protection and then Enable Protection), but the statistics for the last 24h are still missing. The time of the incoming mail in the recent log entries is correctly displayed. Do you have other suggestions?

Knipsel4.jpg (107.47 KiB) Viewed 76381 times

[magicspam]

Hello Knarf,

Thank you for your post.

From your post we understand that you were unable to find the provided path and editing /etc/php.ini did not resolve the issue.

To continue troubleshooting this issue, could you please confirm that the /opt/psa/admin/conf/ directory exists?
If the php.ini file does not exist in the /opt/psa/admin/conf/ folder, please create it and add the correct timezone to the file:

e.g: date.timezone = "Europe/Amsterdam"

Lastly, please restart the plesk sw services by running:

service sw-engine restart && service sw-cp-server restart

Please let us know if this resolves the issue.

[Knarf]

Dear MagicSpam Support,
I want to let you know that thanks to your information the problem has been solved now!

Further information:
The /opt/psa/admin/conf/ directory doesn't exist on my system.
However, after another search, I found /usr/local/psa/admin/conf/php.ini
I added the line date.timezone = "Europe/Amsterdam" at the end of this file and I restarted Plesk sw services.
Immediately after that, MagicSpam was showing the statistics for last 24 hrs again and is working as expected now.
Thanks again for your oustanding support!

Knipsel5.jpg (108.22 KiB) Viewed 70118 times

Knipsel6.JPG (79.51 KiB) Viewed 70118 times

[magicspam]

Hello Knarf,

Thank you for the update.

We are happy to hear that the issue has now been resolved.

Thank you for choosing MagicSpam!