darold / sendmailanalyzer

Sendmail log Analyzer is a tool to monitor sendmail usage and generate HTML and graph reports. It reports all you ever wanted to know about email trafic on your network. You can also use it in ISP environment with per domain and per mailbox report.
http://sendmailanalyzer.darold.net/
GNU General Public License v3.0
76 stars 13 forks source link

Blank Reporting? #81

Closed jeff3d29 closed 2 years ago

jeff3d29 commented 2 years ago

New to sendmail and sendmailreporting.

I have deploy my first Sendmail MTA now, I want to see the reporting so deploy sendmailanalyzer on separate server as didn't felt right having on the same server as the MTA. I believe I configure everything correctly but being receving no report or chart. What did I miss?

image

darold commented 2 years ago

Hi,

I'm surprised by the blank artound the mail0 server name. Can you please post few line of your log or send then to my private email also give me the command line you are using to execute sendmailanalyzer.

Also are you using rsyslog to send your log to the other server or are you copying the log?

jeff3d29 commented 2 years ago

@darold I'm using rsyslog to send the logs from the MTA to sendmailanalyzer. I send a private message, using /usr/local/sendmailanalyzer -f

pmvo51 commented 2 years ago

Friends, I also did my first install of Sendmailanalyzer and the graphs were not generated.

Another error found was when manually executing sa_report.cgi because I had an error "Language file is not readable lang/en_US". I needed to comment out this function to get it to run successfully.

Can you help me?

image

darold commented 2 years ago

you need to copy the lang/ directory from the sources where the sa_report.cgi is installed. You CGI directory where sa_report.cgi is install should looks to the default:

$ tree /usr/local/sendmailanalyzer/www/
/usr/local/sendmailanalyzer/www/
├── flotr2.js
├── lang
│   ├── bg_BG
│   ├── de_DE
│   ├── en_US
│   ├── ERROR_CODE
│   ├── es_ES
│   ├── fr_FR
│   ├── it_IT
│   ├── pt_BR
│   └── ru_RU
├── salogo.png
├── sa_report.cgi
└── sorttable.js

If this is the case, you should verify the permission, files here probably need to be readable by the www-data user or the one your httpd server is running.

darold commented 2 years ago

@jeff3d29 I don't remember if this issue has been solved and can be closed, can you confirm please?

pmvo51 commented 2 years ago

@darold

Thank you! Now I can evolve because I really had to give permission on the "lang" folder.

==> The next step is to have the graphics generation. I'm sending the logs via rsyslog (see tree below).

/var/log/remote/ ├── auth │   └── ServerName │   ├── xxxxx.log │   ├── xxxxx.log │   ├── xxxxx.log │  
└── msg ├── ServerName │   ├── xxxxx.log │   ├── xxxxx.log │   ├── xxxxx.log

image

pmvo51 commented 2 years ago

Hello, anybody help me, please?

image

darold commented 2 years ago

Hi, I can not help much more on this outside saying that it should works. If you can send to my private email < gilles AT darold DOT net > a tarball of your logs I will try to reproduce your issue.

pmvo51 commented 2 years ago

@darold Solved!

My friend, just to register that the graphics were not being generated because I needed to change the selinux context of the directory where the caches are stored (here: /var/lib/sendmailanalyzer/) and I used the context: httpd_sys_content_t. After this change the graphics opened normally.

Thanks!

jeff3d29 commented 2 years ago

All,

Apologies for not getting back sooner on this matter. The matter was fixed by updating policies in the reporting server to allow incoming data via rsyslog. Once that was set, it was a matter of updating apache to be able to read it.