Gestione domini virtual con postfixadmin
| Attenzione questo articolo è ancora incompleto. Sentiti libero di contribuire cliccando sul tasto edit. |
Da repository RVM
sudo aptitude install postfixadmin
sudoedit config
$CONF['admin_email'] = 'gabriele.vivinetto@rvmgroup.it';
$CONF['postfix_admin_url'] = 'http://firemar.marzotto.priv/postfixadmin';
$CONF['database_type'] = 'mysqli'; $CONF['database_host'] = 'localhost'; $CONF['database_user'] = 'postfixadmin'; $CONF['database_password'] = 'postfixpass'; $CONF['database_name'] = 'postfixadmin'; $CONF['database_prefix'] = ;
$CONF['encrypt'] = 'cleartext';
$CONF['default_aliases'] = array (
'abuse' => 'abuse@marzottospa.com', 'hostmaster' => 'hostmaster@marzottospa.com', 'postmaster' => 'postmaster@marzottospa.com', 'webmaster' => 'webmaster@marzottospa.com'
);
$CONF['domain_path'] = 'YES'; $CONF['domain_in_mailbox'] = 'YES';
$CONF['aliases'] = '0'; $CONF['mailboxes'] = '0'; $CONF['maxquota'] = '0';
http://firemar/postfixadmin/setup.php
$CONF['setup_password'] = 'f74986889643960430367b466d2575e6:537950f5dcb72607483e
login con email specificata e pass crea testuser
Configurazione postfix
grep postfix /etc/passwd grep postfix /etc/group
cat | suto t.. /etc/postfix/main.cf
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf
virtual_gid_maps = static:101
virtual_mailbox_base = /home/vmail
virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
virtual_minimum_uid = 101
virtual_transport = virtual
virtual_uid_maps = static:101
EOFile
cat | sudo tee /etc/postfix/mysql_virtual_alias_maps.cf <<EOFile user = postfixadmin password = postfixpass hosts = 127.0.0.1 dbname = postfixadmin table = alias select_field = goto where_field = address EOFile
cat | sudo tee /etc/postfix/mysql_virtual_domains_maps.cf<<EOFile user = postfixadmin password = postfixpass hosts = 127.0.0.1 dbname = postfixadmin table = domain select_field = domain where_field = domain additional_conditions = and backupmx = '0' and active = '1' EOFile
cat | sudo tee /etc/postfix/mysql_virtual_mailbox_maps.cf <<EOFile user = postfixadmin password = postfixpass hosts = 127.0.0.1 table = mailbox dbname = postfixadmin select_field = maildir where_field = username EOFile
sudo aptitude install libsasl2-modules-sql libsasl2-modules
sudoedit /etc/postfix/sasl/smtpd.conf
pwcheck_method: auxprop mech_list: PLAIN LOGIN auxprop_plugin: sql sql_verbose: yes sql_engine: mysql sql_hostnames: 127.0.0.1 sql_user: postfixadmin sql_passwd: postfixpass sql_database: postfixadmin sql_select: select password from mailbox where username ='%u@%r'
sudo invoke-rc.d saslauthd restart
sudo mkdir -p /home/vmail/marzottospa.com
sudo chmod -R 770 /home/vmail
sudo chown -R postfix:postfix /home/vmail/
- Check config
sudo postconf
sudoedit /etc/dovecot/dovecot-sql.conf
connect = dbname=postfixadmin user=postfixadmin host=127.0.0.1 password=postfixpass
default_pass_scheme = PLAIN
password_query = \
SELECT \
password \
FROM \
mailbox
WHERE \
username = '%u'
user_query = \
SELECT \
CONCAT('/home/vmail/',maildir) AS home, \
concat('maildir:/home/vmail/', maildir) as mail, \
101 AS uid, \
101 AS gid \
FROM \
mailbox \
WHERE \
username = '%u'
sudoedit /etc/dovecot/dovecot.conf
protocols = imap imaps pop3 pop3s disable_plaintext_auth = no log_timestamp = "%Y-%m-%d %H:%M:%S " mail_location = maildir:/home/vmail/%d/%n mail_access_groups = mail first_valid_uid = 101 first_valid_gid = 101 protocol imap { }
protocol pop3 { pop3_uidl_format = %08Xu%08Xv }
auth default { mechanisms = digest-md5 plain passdb sql { args = /etc/dovecot/dovecot-sql.conf } userdb sql { args = /etc/dovecot/dovecot-sql.conf } user = root }
sudo invoke-rc.d dovecot restart
Riferimenti
- Jitamitra: Configure Postfix, Postfixadmin, Dovecot On Debian & Ubuntu
- v2p1 Mail server Debian Lenny Postfix Virtual PostfixAdmin MySQL Dovecot Amavisd-new SquirrelMail MailZu
- Postfixadmin – setup/install guide for virtual mail users on Postfix | David Goodwin
- SourceForge.net: Postfixadmin-CLI - postfixadmin
- HowTo/DovecotLDAPostfixAdminMySQL - Dovecot Wiki