Page 1 of 1

eFa 4.0.2 - no messages inserted into mailscanner database

Posted: 13 Feb 2020 11:53
by andre
Hi,

I've upgraded eFa 3.0.26 to eFa 4.0.2 and in mailwatch no messages are being recorded into database. So far I've done:

- tested id user and password had privileges on the database (it had)
- put maxmind license
- ssl_error_log (no errors)
- mailwatch upgrade.php gives the following summary ()

Code: Select all

*** ERROR/WARNING SUMMARY ***
conf.php: optional configuration entry "RPC_PORT" is missing, needed if RPC_ONLY mode is enabled
conf.php: optional configuration entry "RPC_SSL" is missing, needed if RPC_ONLY mode is enabled
conf.php: optional configuration entry "RPC_REMOTE_SERVER" is missing, needed to show number of mails in postfix queues on remote server (RPC)
conf.php: optional configuration entry "VIRUS_REGEX" is missing, needed in distributed setup
conf.php: optional configuration entry "LDAP_BIND_PREFIX" is missing, needed when using LDAP authentication
conf.php: optional configuration entry "LDAP_BIND_SUFFIX" is missing, needed when using LDAP authentication
conf.php: optional configuration entry "EXIM_QUEUE_IN" is missing, needed only if using Exim as MTA
conf.php: optional configuration entry "EXIM_QUEUE_OUT" is missing, needed only if using Exim as MTA
conf.php: optional configuration entry "PWD_RESET_FROM_NAME" is missing, needed if Password Reset feature is enabled
conf.php: optional configuration entry "PWD_RESET_FROM_ADDRESS" is missing, needed if Password Reset feature is enabled
conf.php: optional configuration entry "MAILQ" is missing, needed when using Exim or Sendmail to display the inbound/outbound mail queue lengths
conf.php: optional configuration entry "MAIL_SENDER" is missing, needed if you use Exim or Sendmail Queue
conf.php: optional configuration entry "SESSION_NAME" is missing, needed if experiencing session conflicts
conf.php: optional configuration entry "SENDMAIL_QUEUE_IN" is missing, needed only if using Sendmail as MTA
conf.php: optional configuration entry "SENDMAIL_QUEUE_OUT" is missing, needed only if using Sendmail as MTA
conf.php: optional configuration entry "MAILWATCH_SMTP_HOSTNAME" is missing, needed only if you use a remote SMTP server to send MailWatch emails
conf.php: optional configuration entry "ALLOW_NO_USER_DOMAIN" is missing, allow usernames not in mail format for domain admins and regular users
conf.php: optional configuration entry "ENABLE_SUPER_DOMAIN_ADMINS" is missing, allows domain admins to change domain admins from the same domain
- MailScanner --lint (no errors)


Any ideas what could be happening ?

thanks in advance

Re: eFa 4.0.2 - no messages inserted into mailscanner database

Posted: 13 Feb 2020 12:04
by henk
You did reboot and checked the upgradelog?
The missing optional entries are in

Code: Select all

/var/www/html/mailscanner/conf.php
Likely there is a rpmnew file with the missing enries mentioned.

Code: Select all

# ls -l /var/www/html/mailscanner/c*
On the Gui you can do checks in the tools section.

Just to check if all services are running.

Code: Select all

systemctl status postfix postfix_relay msmilter milter_relay sqlgrey mailscanner mariadb httpd clamav-unofficial-sigs.timer |less

Re: eFa 4.0.2 - no messages inserted into mailscanner database

Posted: 13 Feb 2020 12:13
by andre
Hi

I solved the problem. There was a warning in postfix

Code: Select all

postfix/smtpd[7522]: warning: connect to Milter service inet:localhost:8893: Connection refused
in /etc/opendkim.conf socket was listening in 8891

Code: Select all

##  Create a socket through which your MTA can communicate.
Socket  inet:8891@localhost
also in main.cf in postfix had the following lines:

Code: Select all

smtpd_milters = inet:localhost:8891, inet:localhost:8893, inet:127.0.0.1:33333
non_smtpd_milters = inet:localhost:8891, inet:localhost:8893
Changed to:

Code: Select all

smtpd_milters = inet:localhost:8891, inet:127.0.0.1:33333
non_smtpd_milters = inet:localhost:8891
and restarted postfix. Now mailwatch is updating the messages

Re: eFa 4.0.2 - no messages inserted into mailscanner database

Posted: 13 Feb 2020 13:42
by henk
Why is the Connection refused?
Can you check:

Code: Select all

systemctl status opendmarc opendkim
And see what is running (or not) on 8891 and 8893? (opendmarc)

Code: Select all

netstat -tapn

Re: eFa 4.0.2 - no messages inserted into mailscanner database

Posted: 13 Feb 2020 14:01
by andre
You are right henk, opendmarc wasn't running. So contrary to what I wrote in the previous post, it is not necessary to change main.cf I just needed to start opendmarc

Thanks :dance: