Pessoal utilizo o DEBIAN SARGE, e estou tentando utilizar COURIE+POSTFIX+MYSQL.
Ja segui todas as receitas de bolo disponíveis sobre o assunto, tanto nacional quanto internacional, fiz algumas alterações, porém nenhuma resolveu os problemas aqui apresentados. Espero que na comunidade o sucesso seja melhor. - Quando dou um start no postifix - Tenho os seguintes resultados no syslog postfix/postfix-script: stopping the Postfix mail system postfix/master[28293]: terminating on signal 15 postfix/postfix-script: starting the Postfix mail system postfix/master[28398]: daemon started -- version 2.1.4 - Ao testar localmente Telnet localhost 25 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. 220 meuhost.meudominio ESMTP meudominio - Com o comando anterior tenho o seguinte resultado no syslog postfix/smtpd[28407]: connect from localhost[127.0.0.1] - Quanto tento continuar o teste, ao digitar a linha abaixo mail from: to user - Obtenho o seguinte resultado no syslog Oct 30 10:32:52 meu_host postfix/trivial-rewrite[28412]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Oct 30 10:32:52 meu_host postfix/trivial-rewrite[28412]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/ru n/mysqld/mysqld.sock' (2) Oct 30 10:32:52 meu_host postfix/trivial-rewrite[28412]: fatal: mysql:/etc/postfix/mysql_virtual_alias_maps.cf(0,100): table lookup problem Oct 30 10:32:53 meu_host postfix/smtpd[28407]: warning: premature end-of-input on private/rewrite socket while reading input attribute name Oct 30 10:32:53 meu_host postfix/smtpd[28407]: warning: problem talking to service rewrite: Success Oct 30 10:32:53 meu_host postfix/master[28398]: warning: process /usr/lib/postfix/trivial-rewrite pid 28412 exit status 1 Oct 30 10:32:54 meu_host postfix/trivial-rewrite[28413]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/ru n/mysqld/mysqld.sock' (2) Oct 30 10:32:54 meu_host postfix/trivial-rewrite[28413]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/ru n/mysqld/mysqld.sock' (2) Oct 30 10:32:54 meu_host postfix/trivial-rewrite[28413]: fatal: mysql:/etc/postfix/mysql_virtual_alias_maps.cf(0,100): table lookup problem Oct 30 10:32:55 meu_host postfix/smtpd[28407]: warning: premature end-of-input on private/rewrite socket while reading input attribute name Oct 30 10:32:55 meu_host postfix/smtpd[28407]: warning: problem talking to service rewrite: Success Oct 30 10:32:55 meu_host postfix/master[28398]: warning: process /usr/lib/postfix/trivial-rewrite pid 28413 exit status 1 Oct 30 10:32:55 meu_host postfix/master[28398]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling Oct 30 10:33:01 meu_host /USR/SBIN/CRON[28415]: (root) CMD (/usr/sbin/tz-brasil) - No passwd encontrase o usuario user user:x:1001:1001:,,,:/home/user:/bin/bash - No arquivos .cf, nos campos user e password, fiz o seguinte teste: Loguei como o user e password definidos nos arquivos.cf, acessei normalmente o mysql, ou seja, realizo todas as operacoes no banco sem problema algum. - Porem os testes, como apresentado, mostram que o postfix nao consegue conversar com o MYSQL, alguem, teria alguma sugestao? - Vejam meus arquivos de configuracao: #============main.cf #======== CONFIGURACOES =============== queue_directory = /var/spool/postfix/ program_directory=/usr/sbin command_directory = /usr/sbin daemon_directory = /usr/lib/postfix mail_owner = postfix default_privs=nobody default_transport=smtp alias_maps=hash:/etc/aliases alias_database=hash:/etc/aliases readme_directory = no sample_directory = /etc/postfix/sample sendmail_path = /usr/sbin/sendmail setgid_group = postdrop manpage_directory = /usr/share/man newaliases_path = /usr/bin/newaliases mailq_path = /usr/bin/mailq smtpd_banner=$myhostname ESMTP $mydomain disable_vrfy_command=yes home_mailbox=Maildir/ # ========== NOME DO DOMINIO =========== myhostname=nome_do_host.meudominio mydomain=meudominio myorigin= $mydomain mydestination= $myhostname, localhost.$mydomain, $mydomain, nome_do_host.$mydomain ###======== MYSQL ============== virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf virtual_mailbox_base = /postfix virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf virtual_gid_maps = static:108 virtual_gid_maps = static:108 transport_maps = mysql:/etc/postfix/mysql_transport_maps.cf #======= Quota ============ virtual_mailbox_limit_inbox = no virtual_mailbox_limit_maps= mysql:/etc/postfix/mysql_virtual_mailbox_limit_maps.cf virtual_mailbox_limit_override = yes virtual_maildir_extended = yes virtual_create_maildirsize = yes virtual_mailbox_limit = 100000000 virtual_maildir_limit_message = Sorry, the user's maildir has overdrawn his diskspace quota, please try again later. virtual_overquota_bounce = yes # =======MAILDROP ========== virtual_transport = maildrop fallback_transport = /usr/bin/maildrop maildrop_destination_recipient_limit = 1 unknown_local_recipient_reject_code = 55555 #====================mysql_transport_maps.cf user=user_do_mysql password=senha hosts=localhost dbname=database_mysql table=domain select_field=transport where_field=domain #==================mysql_virtual_alias_maps.cf user=user_do_mysql passwd=senha dbname=database_mysql table=alias select_field=goto where_field=address host=localhost #==================mysql_virtual_mailbox_maps.cf user=user_do_mysql password=senha dbname=postifx table=mailbox select_field=maildir where_field=username host=localhost #==================mysql_virtual_mailbox_limit_maps.cf user=user_do_mysql password=senha dbname=database_mysql table=mailbox select_field=quota where_field=username hosts=localhost #====================master.cf # # ========================================================================== # service type private unpriv chroot wakeup maxproc command + args # (yes) (yes) (yes) (never) (100) # ========================================================================== smtp inet n - n - - smtpd pickup fifo n - n 60 1 pickup cleanup unix n - - - 0 cleanup qmgr fifo n - - 300 1 qmgr rewrite unix - - - - - trivial-rewrite bounce unix - - - - 0 bounce defer unix - - - - 0 bounce trace unix - - - - 0 bounce verify unix - - - - 1 verify flush unix n - - 1000? 0 flush proxymap unix - - n - - proxymap smtp unix - - - - - smtp relay unix - - - - - smtp showq unix n - - - - showq error unix - - - - - error local unix - n n - - local virtual unix - n n - - virtual lmtp unix - - n - - lmtp anvil unix - - n - 1 anvil # # maildrop unix - n n - - pipe flags=DRhu user=maildrop argv=/usr/bin/maildrop -w 90 -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}