Instalacion posfixadmin

Tutorial Instalación Postfixadmin. En debian Lenny

Paquetes a instalar

apt-get install mysql-server postfix postfix-mysql postfix postfix-mysql php5 libapache2-mod-php5 php5-mysql php5-suhosin php5-apc php-pear php5 libapache2-mod-php5 php5-mysql php5-suhosin php-pear courier-authdaemon courier-imap courier-imap-ssl courier-pop courier-pop-ssl courier-authlib-postgresqlcourier-authlib-mysql amavis spamassassin clamav saslfinger sasl saslauth libsasl2 sasl2-bin libsasl2-modules libsasl2-2 sasl2-bin libsasl2-modules clamav-daemon clamav-new maildrop mysql-postfix postfix-mysql libpam-mysq libsasl2-modules-sql

o bien mas actualizado

apt-get install postfix-mysql postfix-mysql php5 libapache2-mod-php5 php5-mysql php5-suhosin php-pear php5 libapache2-m
od-php5 php5-mysqlphp5-suhosin php-pear courier-authdaemon courier-imap courier-imap-ssl courier-pop courier-pop-ssl courier-
authlib-postgresql courier-authlib-mysql amavis spamassassin clamav libsasl2-2 sasl2-bin libsasl2-modules libsasl2-2 sasl2-bin
libsasl2-modules clamav-daemon maildrop postfix-mysql libsasl2-modules-sql

Luego bajar Postfixadmin e instalarlo.

De aquí

A continuación crear la base de datosMysql con las tablas necesarias.

mysql -u root -p < DATABASE_MYSQL.TXT (ver apéndice 2)

Ahora tendremos que configurar todo el sistema para que postfix y courier consulte con mysql cada vez que tenga que manejar los correos salientes y entrantes.
Para eso se deberán colocar los siguientes archivos en el directorio /etc/postfix

Archivo: mysql_virtual_alias_maps.cf

user = root
password= xxxxx
hosts = localhost
dbname = postfix
query = SELECT goto FROM alias WHERE address='%s' AND active = 1

Archivo: mysql_virtual_domains_maps.cf

user = root
password = xxxx
hosts = localhost
dbname = postfix
query = SELECT domain FROM domain WHERE domain='%s'
#optional query to use when relaying for backup MX
#query = SELECT domain FROM domain WHERE domain='%s'
# and backupmx ='0' and active = '1'

Archivo: mysql_virtual_mailbox_maps.cf

user = root
password = xxxxx
hosts = localhost
dbname = postfix
query = SELECT maildir FROM mailbox WHERE username='%s' AND active = 1

Archivo: mysql_virtual_transport_maps.cf

user = root
password = xxxxx
hosts = localhost
dbname = postfix
query = SELECT transport FROM domain WHERE domain='%s'

Luego configuramos elPostfix para que realice las consultas mysql anteriormentes citadas.
Nuestro archivo main.cf quedará como sigue

/etc/postfix/main.cf

# See /usr/share/postfix/main.cf.dist for a commented, more complete version

# Debian specific: Specifying a file name will cause the first
# line of that file to be used as the name. The Debian default
# is /etc/mailname.
#myorigin = /etc/mailnamesmtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
biff = no

# appending .domain is the MUA's job.
append_dot_mydomain = no

# Uncomment the next line to generate "delayed mail" warnings
#delay_warning_time = 4h

readme_directory = no

# TLS parameters
#smtpd_tls_cert_file=/etc/ssl/certs/ssl-cert-snakeoil.pem
#smtpd_tls_key_file=/etc/ssl/private/ssl-cert-snakeoil.key#smtpd_use_tls=yes
#smtpd_tls_session_cache_database = btree:${data_directory}/smtpd_scache
#smtp_tls_session_cache_database = btree:${data_directory}/smtp_scache

# See /usr/share/doc/postfix/TLS_README.gz in the postfix-doc package for
# information on enabling SSL in the smtp client.

myhostname = lossurgentes.mine.nu
mydomain = lossurgentes.mine.nu
alias_maps = hash:/etc/aliasesalias_database = hash:/etc/aliases
#myorigin = /etc/mailname
myorigin = $mydomain
#mydestination = coopsur.com.ar, lossurgentes.coopsur.com.ar, localhost.coopsur.com.ar, localhost
########################## LINEAS PARA SQL CON POSTFIXADMIN ###########
transport_maps = proxy:mysql:/etc/postfix/mysql_virtual_transport_maps.cf
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql_virtual_alias_maps.cf...