Help setting up anti-spam using Dovecot and whatever with 6.3

2018-03-27 Thread Chris Bennett
I'd love some help setting up some spam filtering before I turn on spamd. I've seen lots of guides, but I really don't know what configuration would be best. The guides, of course, don't give enough detail that I can follow. I'm fine using dovecot with postgresql, but I don't know how to setup the

Re: OpenSMTPd PostgreSQL user authentication

2018-03-27 Thread Denis
smtpd auth works from PGSQL since than. Thank you for answers. Right configs are below: $ cat /etc/mail/smptd.conf ... table alias db:/etc/mail/alias table domains posgres:/etc/mail/pgsql.conf table virtuals postgres:/etc/mail/pgsql.conf table pass postgres:/etc/mail/pgsql.conf table userinfo

Re: OpenSMTPd PostgreSQL user authentication

2018-03-27 Thread Reio Remma
On 27.03.18 16:58, Denis wrote: query_alias SELECT CONCAT (alias, ' ', dest) AS alias FROM maildatabase WHERE alias=$1 query_domain SELECT domain FROM maildatabase WHERE domain=$1 query_credentials SELECT user, pass FROM maildatabase WHERE userid=$1 AND active=$1 query_userinfo SELECT CONCAT

Re: OpenSMTPd PostgreSQL user authentication

2018-03-27 Thread Reio Remma
Curious, MySQL and SQLite use ? for parameters, table-postgresql help also says the question mark is used, but the actual example has $1. I've no idea whether both should work, but you might want to have a go with ? instead of $1 in the query strings. Also you might want to run in verbose

OpenSMTPd PostgreSQL user authentication

2018-03-27 Thread Denis
Hello, Having working OpenSMTPd with plain text file user authentication. The auth from table(5) works like a charm currently. But I have a trouble to authenticate users by OpenSMTPd + Dovecot from shared PGSQL database. As for Dovecot, it authenticates users from PGSQL as expected. Dovecot's