Erro no Postfix
Ola Pessoal
Estou tendo um problema com a configuração do PostFix + Mysql + Mailscanner + Courier + PostfixAdmin. Estou usando o Debian 3.1 R1 e apos ter criado os as tabelas no mysql(usei a configuração das tabelas que vem no postfixadmin 2.1.0), foi no Postfix admin e criei o dominio ex.casa.com.br e na hora que vou criar o mailbox deste dominio aparece no log as mensagens abaixo e não cria a pasta para caixa de entrada do usuário que estou criando.
O que estar dando errado?
Segue abaixo os arquivos de configuração e log dos erros.
Desde já agradeço
Ricardo Bittencourt
### /Var/log/mail.log ###
Feb 28 17:03:10 localhost postfix/trivial-rewrite[17435]: warning: connect to mysql server 127.0.0.1: Host 'localhost.localdomain' is not allowed to connect to this MySQL server
Feb 28 17:03:10 localhost postfix/trivial-rewrite[17435]: fatal: mysql:/etc/postfix/mysql_virtual_alias_maps.cf(0,100): table lookup problem
Feb 28 17:03:11 localhost postfix/smtpd[17396]: warning: premature end-of-input on private/rewrite socket while reading input attribute name
Feb 28 17:03:11 localhost postfix/smtpd[17396]: warning: problem talking to service rewrite: Success
Feb 28 17:03:11 localhost postfix/master[17382]: warning: process /usr/lib/postfix/trivial-rewrite pid 17435 exit status 1
Feb 28 17:03:11 localhost postfix/master[17382]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
### /var/log/mail.err
Feb 28 17:03:10 localhost postfix/trivial-rewrite[17435]: fatal: mysql:/etc/postfix/mysql_virtual_alias_maps.cf(0,100): table lookup problem
Feb 28 17:01:13 localhost postfix/trivial-rewrite[17435]: fatal: mysql:/etc/postfix/mysql_virtual_alias_maps.cf(0,100): table lookup problem
### MAIN.CF ###
# See /usr/share/postfix/main.cf.dist for a commented, more complete version
smtpd_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
myhostname = debian.casa.com.br
mydomain = casa.com.br
myorigin = $mydomain
mydestination = $myhostname localhost.$mydomain localhost $mydomain
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
home_mailbox = Maildir/
relayhost =
mynetworks = 127.0.0.0/8, 10.10.2.0/24
mailbox_size_limit = 51200000
recipient_delimiter = +
inet_interfaces = all
# Configuração de Integração com o MYSQL
virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf
virtual_mailbox_base = /var/virtualmail
virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf
virtual_mailbox_limit = 51200000
virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf
virtual_uid_maps = static:103
virtual_gid_maps = static:105
### MASTER.CF ###
# ==========================================================================
# service type private unpriv chroot wakeup maxproc command + args
# (yes) (yes) (yes) (never) (100)
# ==========================================================================
smtp inet n - n - - smtpd
#submission inet n - n - - smtpd
# -o smtpd_etrn_restrictions=reject
#628 inet n - n - - qmqpd
pickup fifo n - n 60 1 pickup
cleanup unix n - n - 0 cleanup
qmgr fifo n - n 300 1 qmgr
#qmgr fifo n - n 300 1 oqmgr
rewrite unix - - n - - trivial-rewrite
bounce unix - - n - 0 bounce
defer unix - - n - 0 bounce
trace unix - - n - 0 bounce
verify unix - - n - 1 verify
flush unix n - n 1000? 0 flush
proxymap unix - - n - - proxymap
smtp unix - - n - - smtp
relay unix - - n - - smtp
# -o smtp_helo_timeout=5 -o smtp_connect_timeout=5
showq unix n - n - - showq
error unix - - n - - error
local unix - n n - - local
virtual unix - n n - - virtual
lmtp unix - - n - - lmtp
anvil unix - - n - 1 anvil
#
# Interfaces to non-Postfix software. Be sure to examine the manual
# pages of the non-Postfix software to find out what options it wants.
#
# maildrop. See the Postfix MAILDROP_README file for details.
#
maildrop unix - n n - - pipe
flags=DRhu user=vmail argv=/usr/local/bin/maildrop -d ${recipient}
uucp unix - n n - - pipe
flags=Fqhu user=uucp argv=uux -r -n -z -a$sender - $nexthop!rmail ($recipient)
ifmail unix - n n - - pipe
flags=F user=ftn argv=/usr/lib/ifmail/ifmail -r $nexthop ($recipient)
bsmtp unix - n n - - pipe
flags=Fq. user=bsmtp argv=/usr/lib/bsmtp/bsmtp -d -t$nexthop -f$sender $recipient
scalemail-backend unix - n n - 2 pipe
flags=R user=scalemail argv=/usr/lib/scalemail/bin/scalemail-store ${nexthop} ${user} ${extension}
# only used by postfix-tls
#tlsmgr fifo - - n 300 1 tlsmgr
#smtps inet n - n - - smtpd -o smtpd_tls_wrappermode=yes -o smtpd_sasl_auth_enable=yes
#587 inet n - n - - smtpd -o smtpd_enforce_tls=yes -o smtpd_sasl_auth_enable=yes
### mysql_virtual_alias_maps.cf ###
user = postfix
password = postfix
hosts = 127.0.0.1
dbname = postfix
table = alias
select_field = goto
where_field = address
### mysql_virtual_domains_maps.cf ###
user = postfix
password = postfix
hosts = 127.0.0.1
dbname = postfix
table = domain
select_field = description
where_field = domain
### mysql_virtual_mailbox_maps.cf ###
user = postfix
password = postfix
hosts = 127.0.0.1
dbname = postfix
table = mailbox
select_field = maildir
where_field = username
Reply to: