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 » 29 Jul 2015 21:58

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: 2769
Joined: 13 Jan 2014 23:30
Location: Rushville, Indiana, USA
Contact:

Re: No inbound email - SQLgrey Alert Emails?

Post by shawniverson » 07 Aug 2015 07:09

You may want to run MySQL recovery using EFA-Configure, in case the database is in need of repair.
Version eFa 4.0.0 RC3 now available in testing repo. Come join us in advancing eFa!

User avatar
pdwalker
Posts: 1137
Joined: 18 Mar 2015 09:16

Re: No inbound email - SQLgrey Alert Emails?

Post by pdwalker » 25 Aug 2015 08:13

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 » 12 Dec 2016 15:03

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 » 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

rooter_c
Posts: 10
Joined: 05 Mar 2013 04:52

Re: No inbound email - SQLgrey Alert Emails?

Post by rooter_c » 19 Feb 2019 05:14

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 » 28 Mar 2019 18:47

Same to me.

Post Reply