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