[CentOS] Virtual email with Postfix, MySQL and Dovecot problem

Fri Sep 5 17:22:07 UTC 2008
Lunix1618 <lunix1618 at gmail.com>

Hello all,

Anyone of you success to install virtual email with Postfix, MySQL and 
Dovecot on CentOS 5.2 ? I am running: mysql-server-5.0.45-7.el5, 
postfix-2.3.3-2.el5.centos.mysql_pgsql and dovecot-1.0.7-2.el5 on CentOS 
5.2 box and can not make it work.

All deamons (mysqld, postfix master, dovecot) are running but I can not 
make it deliver email to virtual user via Dovecot.
The log file show that postfix is not deliver email to virtual user but 
it deliver to all virtual aliased address.

The configuration file is working with my test on laptop that running 
Fedora 9 with mysql-server-5.0.51a-1.fc9.i386, postfix-2.5.1-2.fc9.i386 
and dovecot-1.0.15-10.fc9.i386

The version number is not too much different so I think it is not a problem.

Attached are config files that working on fedora 9 and I using it on 
CentOS but not work
This configuration I followed the guide at 
http://workaround.org/articles/ispmail-etch/

I am not native English speaker so my explanation above may not clearly 
enough, pls raise question for me if you need further information

Your advices are highly appreciates!

Thank you and regards,
lunix.

PS: below is mail log for a session that I use telnet to port 25, send 
an email for test, I've deleted some info and replaced with X and Y for 
privacy reason:
------------LOG BEGIN-----------
Sep  5 23:52:16 centos-svr dovecot: Dovecot v1.0.7 starting up
Sep  5 23:52:16 centos-svr dovecot: auth-worker(default): mysql: 
Connected to localhost (mailserver)
Sep  5 23:52:22 centos-svr sendmail[9442]: alias database /etc/aliases 
rebuilt by abc
Sep  5 23:52:22 centos-svr sendmail[9442]: /etc/aliases: 76 aliases, 
longest 10 bytes, 765 bytes total
Sep  5 23:52:22 centos-svr postfix/postfix-script: starting the Postfix 
mail system
Sep  5 23:52:22 centos-svr postfix/master[9488]: daemon started -- 
version 2.3.3, configuration /etc/postfix
Sep  5 23:52:28 centos-svr postfix/smtpd[9493]: connect from 
centos-svr.XXXX.local[127.0.0.1]
Sep  5 23:53:37 centos-svr postfix/smtpd[9493]: 6E4FA5B0091: 
client=centos-svr.XXXX.local[127.0.0.1]
Sep  5 23:53:41 centos-svr postfix/cleanup[9502]: 6E4FA5B0091: 
message-id=<20080905165337.6E4FA5B0091 at mail.XXXX.com>
Sep  5 23:53:41 centos-svr postfix/qmgr[9491]: 6E4FA5B0091: 
from=<XXXXX at XXX.com.YY>, size=363, nrcpt=2 (queue active)
Sep  5 23:53:44 centos-svr postfix/smtpd[9493]: disconnect from 
centos-svr.XXXX.local[127.0.0.1]
Sep  5 23:53:50 centos-svr postfix/smtp[9505]: 6E4FA5B0091: 
to=<XXX at gmail.com>, orig_to=<XXX at XXX.com>, 
relay=gmail-smtp-in.l.google.com[209.85.201.27]:25, delay=22, 
delays=14/0.01/5.8/2.4, dsn=2.0.0, status=sent (250 2.0.0 OK 1220633760 
22si669435wfi.14)
Sep  5 23:53:52 centos-svr postfix/smtp[9506]: 6E4FA5B0091: 
to=<XXX at XXX.com.YY>, orig_to=<XXX at XXXX.com>, 
relay=aspmx.l.google.com[209.85.201.27]:25, delay=24, 
delays=14/0.01/7.5/3.2, dsn=2.0.0, status=sent (250 2.0.0 OK 1220633763 
20si679269wfi.11)
Sep  5 23:53:52 centos-svr postfix/qmgr[9491]: 6E4FA5B0091: removed

------LOG END ---------


-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: dovecot.conf
URL: <http://lists.centos.org/pipermail/centos/attachments/20080906/8b30120e/attachment-0006.conf>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: dovecot-sql.conf
URL: <http://lists.centos.org/pipermail/centos/attachments/20080906/8b30120e/attachment-0007.conf>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: main.cf
URL: <http://lists.centos.org/pipermail/centos/attachments/20080906/8b30120e/attachment-0018.ksh>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: master.cf
URL: <http://lists.centos.org/pipermail/centos/attachments/20080906/8b30120e/attachment-0019.ksh>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: mysql-email2email.cf
URL: <http://lists.centos.org/pipermail/centos/attachments/20080906/8b30120e/attachment-0020.ksh>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: mysql-virtual-alias-maps.cf
URL: <http://lists.centos.org/pipermail/centos/attachments/20080906/8b30120e/attachment-0021.ksh>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: mysql-virtual-mailbox-domains.cf
URL: <http://lists.centos.org/pipermail/centos/attachments/20080906/8b30120e/attachment-0022.ksh>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: mysql-virtual-mailbox-maps.cf
URL: <http://lists.centos.org/pipermail/centos/attachments/20080906/8b30120e/attachment-0023.ksh>