Re: smtpd_recipient_restrictions in mongodb?

2020-07-14 Thread SysAdmin EM
Exactly. Here a typical row | 1382959 | nelly_cab...@gmail.com | REJECT Recipient address rejected for policy reasons | 2018-11-04 01:49:33 mysql> describe virtual_sender_access ; +---+-+--+-+-+-+ | Field | T

Re: smtpd_recipient_restrictions in mongodb?

2020-07-14 Thread Ralph Seichter
* SysAdmin EM: > query = SELECT access FROM virtual_sender_access WHERE source='%s' You wrote that you only store nonexistent sources. In that case, the value of the "access" column should always be something that indicates "access denied", possibly a constant value across all entries? If so,

Re: smtpd_recipient_restrictions in mongodb?

2020-07-13 Thread SysAdmin EM
The user database is set up because my clients, some bad users, send mass mailings to non-existent accounts, such as hotmail, gmail, which usually measure the number of IP bounces. Also sometimes there are cases where the PC or mobile device is infected with a virus and they use the email account t

Re: smtpd_recipient_restrictions in mongodb?

2020-07-13 Thread Ralph Seichter
* SysAdmin EM: > I use a suppression list where I block domains and email accounts that > don't exist to prevent the reputation of my IP addresses from going > down. [...] The table currently has 4 million rows, so I am looking > for a faster database engine than MySql. Can you clarify for me: Yo