Page 1 of 1
No inbound email - SQLgrey Alert Emails?
Posted: 29 Jul 2015 21:58
by EFAUser1
Started receiving a bunch of alerts overnight mentioning: "SQLgrey established connection to: DBI:mysql:database=sqlgrey;host=localhost (max warn message rate hit, throttling)"
Also seeing this one from EFA a few hours before the above message: "SQLgrey encountered an SQL error and triggered a reconnection to: DBI:mysql:database=sqlgrey;host=localhost"
EFA now appears to have stopped receiving most inbound emails. Outside senders receive a reject notice:
Action: failed
Status: 4.3.5
Remote-MTA: dns; mail.(domain).com
Diagnostic-Code: smtp; 451 4.3.5 Server configuration problem
Re: No inbound email - SQLgrey Alert Emails?
Posted: 07 Aug 2015 07:09
by shawniverson
You may want to run MySQL recovery using EFA-Configure, in case the database is in need of repair.
Re: No inbound email - SQLgrey Alert Emails?
Posted: 25 Aug 2015 08:13
by pdwalker
Did you ever resolve this problem?
According to the SQLGrey source code (
https://github.com/mmatuska/sqlgrey/blob/master/sqlgrey ) the error message appears at line 166 at the time of this reply.
Code: Select all
# is there room for a mail ?
if ($self->{sqlgrey}{mail_bucket} >= 1) {
if ($self->{sqlgrey}{mail_bucket} < 2) {
$content .= ' (max warn message rate hit, throttling)';
}
# actual mail sending
*snip*
}
so it seems you are getting too much incoming mail at that particular moment?
Re: No inbound email - SQLgrey Alert Emails?
Posted: 12 Dec 2016 15:03
by zyxel79
Hi,
we ran often into the same Problem- we get sometime much incomming e-mails and greylist stop working with error
"SQLgrey established connection to: DBI:mysql:database=sqlgrey;host=localhost (max warn message rate hit, throttling)"
Is there a way to limit the incomming E-Mail to avoid this issue?
thanks
franz
Re: No inbound email - SQLgrey Alert Emails?
Posted: 14 Dec 2018 10:58
by Liam
Hi,
I found out that just before the SQLgrey error, most of the time I received a mail with a non-ascii character.
Just Like this one: From: "Corinne" <Nathan?
Smithvposo@hkeyapi.com> (this is from a spam mail btw)
So, if there is a solution to accept those non-ascii characters in the database, or just discard them, the problem is also solved.
Thanks,
Liam
Re: No inbound email - SQLgrey Alert Emails?
Posted: 19 Feb 2019 05:14
by rooter_c
Liam wrote: ↑14 Dec 2018 10:58
Hi,
I found out that just before the SQLgrey error, most of the time I received a mail with a non-ascii character.
Just Like this one: From: "Corinne" <Nathan?
Smithvposo@hkeyapi.com> (this is from a spam mail btw)
So, if there is a solution to accept those non-ascii characters in the database, or just discard them, the problem is also solved.
Thanks,
Liam
Same happening to me too!
Re: No inbound email - SQLgrey Alert Emails?
Posted: 28 Mar 2019 18:47
by ulus
Same to me.
Re: No inbound email - SQLgrey Alert Emails?
Posted: 21 Dec 2020 07:46
by Thazwick
Hi All,
A bit late to the party but has there been a solution to this problem. I recently started receiving the same messages...
Re: No inbound email - SQLgrey Alert Emails?
Posted: 22 Dec 2020 22:18
by shawniverson
I'm researching this. I believe there is a solution in the forums and involves upgrading the tables to utf8mb4 for SQLgrey. I will research and apply a fix.
Re: No inbound email - SQLgrey Alert Emails?
Posted: 22 Dec 2020 22:20
by shawniverson