Hello,
I am using a suppression list in MySql with Postfix.
smtpd_recipient_restrictions = check_recipient_access mysql:/etc/postfix/
mysql-virtual-recipient-access.cf
query = SELECT access FROM virtual_sender_access WHERE source='%s'
the question is, is it possible to use boolean data?
like t
SysAdmin EM:
> Hello,
>
> I am using a suppression list in MySql with Postfix.
>
> smtpd_recipient_restrictions = check_recipient_access mysql:/etc/postfix/
> mysql-virtual-recipient-access.cf
>
> query = SELECT access FROM virtual_sender_access WHERE source='%s'
>
> the question is, is it poss
SysAdmin EM skrev den 2020-07-13 20:43:
SELECT COUNT(1) FROM virtual_sender_access WHERE source =
'u...@gmail.com'?
valid sql query, its just not meaningfull to postfix, and you did not
provide how postfix should use (1)
Hello,
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.
smtpd_recipient_restrictions = check_recipient_access mysql:/etc/postfix/
mysql-virtual-recipient-access.cf
# connection to mysql
hosts = 172.x.
* 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
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
