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

smtpd_recipient_restrictions in mongodb?

2020-07-13 Thread SysAdmin EM
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.

Re: Postfix MySql result in bolean

2020-07-13 Thread Benny Pedersen
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)

Re: Postfix MySql result in bolean

2020-07-13 Thread Wietse Venema
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

Postfix MySql result in bolean

2020-07-13 Thread 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 possible to use boolean data? like t