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
No inbound email - SQLgrey Alert Emails?
- shawniverson
- Posts: 3649
- Joined: 13 Jan 2014 23:30
- Location: Indianapolis, Indiana USA
- Contact:
Re: No inbound email - SQLgrey Alert Emails?
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?
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.
so it seems you are getting too much incoming mail at that particular moment?
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*
}
Re: No inbound email - SQLgrey Alert Emails?
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
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?
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
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?
Same happening to me too!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
Re: No inbound email - SQLgrey Alert Emails?
Same to me.
Re: No inbound email - SQLgrey Alert Emails?
Hi All,
A bit late to the party but has there been a solution to this problem. I recently started receiving the same messages...
A bit late to the party but has there been a solution to this problem. I recently started receiving the same messages...
- shawniverson
- Posts: 3649
- Joined: 13 Jan 2014 23:30
- Location: Indianapolis, Indiana USA
- Contact:
Re: No inbound email - SQLgrey Alert Emails?
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.
- shawniverson
- Posts: 3649
- Joined: 13 Jan 2014 23:30
- Location: Indianapolis, Indiana USA
- Contact: