Using without MySQL
Good article, but it doesn't even speak about one important fact: it's possible to have postfix without mysql.
Mysql is quite heavy for what is required by postfix, and I want to manage users separately in an LDAP database. I'll see if it's possible to do it and perhaps update the wiki.
Postfixadmin Cfg & Dovecot Select Statement
i used this tutorial to install dovecot, postfix and postfixadmin. It worked but the value down here is not working in the whole context of this tutorial.
If -> $CONF['domain_in_mailbox'] = 'YES'; <- is set to YES then we get in the sql table mailbox the value for maildir : -> email@example.com/<-.
But the SQL Query from the Virtual user mail tutorial uses this query: user_query = SELECT '/home/vmail/%d/%n' as home, 'maildir:/home/vmail/%d/%n' as mail, 5000 AS uid, 5000 AS gid, concat('dirsize:storage=', quota) AS quota FROM mailbox WHERE username = '%u' AND active = '1'
'maildir:/home/vmail/%d/%n' - means append the user name without the domain.
this causes that we will have two directories created by postfix - in /home/vmail/domain.org/bob and /firstname.lastname@example.org
I tried some things and changed the SQL String from %d/%n to %d/%u but at the end i decided it's the easiest part not to save the domainname in the mailbox name.
So the solution should be to use $CONF['domain_in_mailbox'] = 'NO';
(hope this is helful)
spamassassin and dovecot
- Do you have more details on what you want explained exactly? Dovecot can call SA in different ways and this wiki covers the most useful ones. My own favorite is via LMTP + sieve as it's the fastest and most scalable. See also https://en.wikipedia.org/wiki/Local_Mail_Transfer_Protocol.
- --Zang (talk) 23:38, 10 June 2016 (UTC)
- i miss some introduction about the concept behind spamassassin. that might be one sentence like "Spamassassin is a rule based mail rating system working as dedicated service.". that would make it easier to know what to expect from that section (whether it solves my problem or not). as it is now, one depends on guessing based on the name only, and it is kind of implicated everyone knows what spamassassin does (and how, conceptually).
- i am not sure, i explained it well… i'll try again if you wish…? Fordprefect (talk) 11:09, 11 June 2016 (UTC)