efa-project.org

just fyi:

Upgrading : eFa-1:4.0.4-43.eFa.el8.noarch 35/84
Running scriptlet: eFa-1:4.0.4-43.eFa.el8.noarch 35/84

Preparing to update eFa...
ERROR 1067 (42000) at line 46: Invalid default value for 'lastsent'
Update completed successfully!

Great, thanks for the info!

Okay so here is my "solution":

first I cleared the mtalog_ids table without using a join:
DELETE FROM mtalog_ids WHERE smtp_id not in (SELECT msg_id FROM mtalog) LIMIT 100000;
(I ran this multiple times with a bash script and pause in between until there where no rows affected anymore).

then I ...

Hi,
out of the blue I'm also having this issue... every day my eFa install stops processing mails and if I check the mysql process list I see this "DELETE i.*, m.* FROM mtalog..." query with a very high runtime and it seems it blocks eFa from processing mails.

this issue appeared seemingly out of ...

Hi,
i just tried to update to 4.0.4-42 and got this info/error from yum:

should I be worried about:
ERROR 1067 (42000) at line 46: Invalid default value for 'lastsent'
Job for mariadb.service canceled.

MailWatch for MailScanner Database Upgrade to 1.2.23

Testing connectivity to the database ...

Hi there,

in order to get DSNs working, I read that you need to set MSMail Delivery Method = SMTP
are there any downsides / repercussions to changing it to SMTP instead of QMQP?

cheers,
Tobias

The only thing I found was this line in "ssl_request_log":
84.112.4.48 TLSv1.3 TLS_AES_128_GCM_SHA256 "GET /mailscanner/login.php?error=baduser HTTP/1.1"

this is not really something I could track with fail2ban because if someone just posts the login form but does not follow the redirect this is ...

thanks for your reply. the reason why I ask is that this setting has more implication than I first thought. I was in the process of setting up a "destination_rate_delay" and wondering why it was not working, but having an destination_recipient_limit of 1 means some settings are per recipient and not ...

I also like to use "reject_unknown_reverse_client_hostname" for "smtpd_client_restrictions". Argument being that everybody that is a responsible mailadmin should know about setting a ptr record for their IP.

Hi,

I saw that efa setup sets .
what is the reasoning behind this?

cheers,
Tobias

Hi,
I'm using EFA also as an outbound mail relay - so it delivers the mail from different sources in the internal network to the outside. is it possible to deactivate opendkim / spf checks for mails that originate in defined internal networks (like the ones defined unter Mail Settings->Outbound mail ...

Hi,

does someone know if MailWatch writes failed login attempts to a log file?

cheers,
Tobias

Hi,
some days ago I installed EFA4 with the one step installer (I guess 4.0.3) on a fresh CentOS 8 (CentOS-8.2.2004-x86_64-minimal.iso) but I noticed that there is nothing in e.g. maillog and I had to use "journalctl -u postfix -f" (but this also means that fail2ban would not detect anything)

I ...