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
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 pos
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 (use
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 mod
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
LMT