No inbound email - SQLgrey Alert Emails?

General eFa discussion
Post Reply
EFAUser1
Posts: 17
Joined: 22 Dec 2014 18:56

No inbound email - SQLgrey Alert Emails?

Post 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
User avatar
shawniverson
Posts: 3644
Joined: 13 Jan 2014 23:30
Location: Indianapolis, Indiana USA
Contact:

Re: No inbound email - SQLgrey Alert Emails?

Post by shawniverson »

You may want to run MySQL recovery using EFA-Configure, in case the database is in need of repair.
User avatar
pdwalker
Posts: 1553
Joined: 18 Mar 2015 09:16

Re: No inbound email - SQLgrey Alert Emails?

Post 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?
zyxel79
Posts: 2
Joined: 12 Dec 2016 14:22

Re: No inbound email - SQLgrey Alert Emails?

Post 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
Liam
Posts: 1
Joined: 10 Nov 2017 11:47

Re: No inbound email - SQLgrey Alert Emails?

Post 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
rooter_c
Posts: 13
Joined: 05 Mar 2013 04:52

Re: No inbound email - SQLgrey Alert Emails?

Post 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!
ulus
Posts: 3
Joined: 22 Mar 2013 17:07

Re: No inbound email - SQLgrey Alert Emails?

Post by ulus »

Same to me.
Thazwick
Posts: 3
Joined: 23 Mar 2018 14:58

Re: No inbound email - SQLgrey Alert Emails?

Post 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...
User avatar
shawniverson
Posts: 3644
Joined: 13 Jan 2014 23:30
Location: Indianapolis, Indiana USA
Contact:

Re: No inbound email - SQLgrey Alert Emails?

Post 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.
Post Reply