Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 8.04)

[canardwc]

Hi all,

I've followed this HOWTO, on a fresh install.
When I send an email to a user (created in mysql), the directory /home/vmail/domain/user is not created....

mail.info
May 22 16:44:54 SV01 postfix/smtpd[18469]: connect from sw03.canardwc.local[10.0.1.7]
May 22 16:44:54 SV01 postfix/smtpd[18469]: D42BD25D86: client=sw03.canardwc.local[10.0.1.7]
May 22 16:44:54 SV01 postfix/smtpd[18469]: disconnect from sw03.canardwc.local[10.0.1.7]
May 22 16:44:54 SV01 postfix/smtp[18482]: 9C36825DE1: to=<sebastien@xxxxxx.fr>, relay=10.0.1.7[10.0.1.7]:25, delay=0.32, delays=0.01/0/0.05/0.26, dsn=2.6.0, status=sent (250 2.6.0 10596 bytes received in 00:00:00; Message id CTO45822 accepted for delivery)
May 22 16:44:54 SV01 postfix/qmgr[5863]: 9C36825DE1: removed
May 22 16:48:14 SV01 postfix/anvil[18471]: statistics: max connection rate 11/60s for (smtp:10.0.1.7) at May 22 16:44:54
May 22 16:48:14 SV01 postfix/anvil[18471]: statistics: max connection count 1 for (smtp:10.0.1.7) at May 22 16:44:41
May 22 16:48:14 SV01 postfix/anvil[18471]: statistics: max cache size 1 at May 22 16:44:41
May 22 16:56:20 SV01 postfix/master[5860]: terminating on signal 15
May 22 16:56:20 SV01 postfix/master[18617]: daemon started -- version 2.5.1, configuration /etc/postfix
May 22 16:57:07 SV01 postfix/smtpd[18677]: connect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:07 SV01 postfix/smtpd[18677]: 8071425D86: client=sw03.canardwc.local[10.0.1.7]
May 22 16:57:07 SV01 postfix/smtpd[18677]: disconnect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:07 SV01 postfix/smtpd[18677]: connect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:07 SV01 postfix/smtpd[18677]: B374A25D86: client=sw03.canardwc.local[10.0.1.7]
May 22 16:57:07 SV01 postfix/cleanup[18682]: B374A25D86: message-id=<B7DE0419E385374C913FEA4C694F943D01EBE62D@ps0ma il01.lenumero.local>
May 22 16:57:07 SV01 postfix/qmgr[18620]: B374A25D86: from=<Sebastien.Wenske@xxxxxx.fr>, size=6784, nrcpt=1 (queue active)
May 22 16:57:07 SV01 postfix/smtpd[18677]: disconnect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:10 SV01 postfix/smtpd[18688]: connect from localhost[127.0.0.1]
May 22 16:57:10 SV01 postfix/smtpd[18688]: 4370325DE1: client=localhost[127.0.0.1]
May 22 16:57:10 SV01 postfix/cleanup[18682]: 4370325DE1: message-id=<B7DE0419E385374C913FEA4C694F943D01EBE62D@ps0ma il01.lenumero.local>
May 22 16:57:10 SV01 postfix/qmgr[18620]: 4370325DE1: from=<Sebastien.Wenske@xxxxxx.fr>, size=7241, nrcpt=1 (queue active)
May 22 16:57:10 SV01 postfix/smtpd[18688]: disconnect from localhost[127.0.0.1]
May 22 16:57:10 SV01 amavis[5880]: (05880-09) Passed CLEAN, LOCAL [10.0.1.7] [84.207.23.137] <Sebastien.Wenske@xxxxxx.fr> -> <sebastien@xxxxxx.fr>, Message-ID: <B7DE0419E385374C913FEA4C694F943D01EBE62D@ps0mail0 1.lenumero.local>, mail_id: rHigWfHepDAS, Hits: 0.796, size: 6784, queued_as: 4370325DE1, 2516 ms
May 22 16:57:10 SV01 postfix/smtp[18683]: B374A25D86: to=<sebastien@xxxxxx.fr>, relay=127.0.0.1[127.0.0.1]:10024, delay=2.6, delays=0.06/0.01/0.02/2.5, dsn=2.0.0, status=sent (250 2.0.0 Ok: queued as 4370325DE1)
May 22 16:57:10 SV01 postfix/qmgr[18620]: B374A25D86: removed
May 22 16:57:10 SV01 postfix/smtpd[18677]: connect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:10 SV01 postfix/smtpd[18677]: 7EB0B25D86: client=sw03.canardwc.local[10.0.1.7]
May 22 16:57:10 SV01 postfix/smtpd[18677]: disconnect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:10 SV01 postfix/smtp[18689]: 4370325DE1: to=<sebastien@xxxxxx.fr>, relay=10.0.1.7[10.0.1.7]:25, delay=0.33, delays=0.02/0.02/0.03/0.26, dsn=2.6.0, status=sent (250 2.6.0 7241 bytes received in 00:00:00; Message id CTA76537 accepted for delivery)
May 22 16:57:10 SV01 postfix/qmgr[18620]: 4370325DE1: removed
May 22 16:57:10 SV01 postfix/smtpd[18677]: connect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:10 SV01 postfix/smtpd[18677]: BBC3625D86: client=sw03.canardwc.local[10.0.1.7]
May 22 16:57:10 SV01 postfix/cleanup[18682]: BBC3625D86: message-id=<B7DE0419E385374C913FEA4C694F943D01EBE62D@ps0ma il01.lenumero.local>
May 22 16:57:10 SV01 postfix/qmgr[18620]: BBC3625D86: from=<Sebastien.Wenske@xxxxxx.fr>, size=7626, nrcpt=1 (queue active)
May 22 16:57:10 SV01 postfix/smtpd[18677]: disconnect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:10 SV01 postfix/smtpd[18688]: connect from localhost[127.0.0.1]
May 22 16:57:10 SV01 postfix/smtpd[18688]: E120925DE1: client=localhost[127.0.0.1]
May 22 16:57:10 SV01 postfix/cleanup[18682]: E120925DE1: message-id=<B7DE0419E385374C913FEA4C694F943D01EBE62D@ps0ma il01.lenumero.local>
May 22 16:57:10 SV01 postfix/qmgr[18620]: E120925DE1: from=<Sebastien.Wenske@xxxxxx.fr>, size=8083, nrcpt=1 (queue active)
May 22 16:57:10 SV01 postfix/smtpd[18688]: disconnect from localhost[127.0.0.1]
May 22 16:57:10 SV01 amavis[5882]: (05882-09) Passed CLEAN, LOCAL [10.0.1.7] [84.207.23.137] <Sebastien.Wenske@xxxxxx.fr> -> <sebastien@xxxxxx.fr>, Message-ID: <B7DE0419E385374C913FEA4C694F943D01EBE62D@ps0mail0 1.lenumero.local>, mail_id: QXjbCWkSBZPI, Hits: 0.796, size: 7626, queued_as: E120925DE1, 126 ms
May 22 16:57:10 SV01 postfix/smtp[18683]: BBC3625D86: to=<sebastien@xxxxxx.fr>, relay=127.0.0.1[127.0.0.1]:10024, delay=0.18, delays=0.05/0/0.01/0.12, dsn=2.0.0, status=sent (250 2.0.0 Ok: queued as E120925DE1)
May 22 16:57:10 SV01 postfix/qmgr[18620]: BBC3625D86: removed
May 22 16:57:10 SV01 postfix/smtpd[18677]: connect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:11 SV01 postfix/smtpd[18677]: 1F55925D86: client=sw03.canardwc.local[10.0.1.7]
May 22 16:57:11 SV01 postfix/smtpd[18677]: disconnect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:11 SV01 postfix/smtp[18689]: E120925DE1: to=<sebastien@xxxxxx.fr>, relay=10.0.1.7[10.0.1.7]:25, delay=0.3, delays=0.01/0/0.03/0.26, dsn=2.6.0, status=sent (250 2.6.0 8083 bytes received in 00:00:00; Message id CTA37338 accepted for delivery)
May 22 16:57:11 SV01 postfix/qmgr[18620]: E120925DE1: removed
May 22 16:57:11 SV01 postfix/smtpd[18677]: connect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:11 SV01 postfix/smtpd[18677]: 6300825D86: client=sw03.canardwc.local[10.0.1.7]
May 22 16:57:11 SV01 postfix/cleanup[18682]: 6300825D86: message-id=<B7DE0419E385374C913FEA4C694F943D01EBE62D@ps0ma il01.lenumero.local>
May 22 16:57:11 SV01 postfix/qmgr[18620]: 6300825D86: from=<Sebastien.Wenske@xxxxxx.fr>, size=8468, nrcpt=1 (queue active)
May 22 16:57:11 SV01 postfix/smtpd[18677]: disconnect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:11 SV01 postfix/smtpd[18688]: connect from localhost[127.0.0.1]
May 22 16:57:11 SV01 postfix/smtpd[18688]: 85B8F25DE1: client=localhost[127.0.0.1]
May 22 16:57:11 SV01 postfix/cleanup[18682]: 85B8F25DE1: message-id=<B7DE0419E385374C913FEA4C694F943D01EBE62D@ps0ma il01.lenumero.local>
May 22 16:57:11 SV01 postfix/qmgr[18620]: 85B8F25DE1: from=<Sebastien.Wenske@xxxxxx.fr>, size=8925, nrcpt=1 (queue active)
May 22 16:57:11 SV01 postfix/smtpd[18688]: disconnect from localhost[127.0.0.1]
May 22 16:57:11 SV01 amavis[5880]: (05880-10) Passed CLEAN, LOCAL [10.0.1.7] [84.207.23.137] <Sebastien.Wenske@xxxxxx.fr> -> <sebastien@xxxxxx.fr>, Message-ID: <B7DE0419E385374C913FEA4C694F943D01EBE62D@ps0mail0 1.lenumero.local>, mail_id: z-GkR-f8js62, Hits: 0.796, size: 8468, queued_as: 85B8F25DE1, 102 ms
May 22 16:57:11 SV01 postfix/smtp[18683]: 6300825D86: to=<sebastien@xxxxxx.fr>, relay=127.0.0.1[127.0.0.1]:10024, delay=0.17, delays=0.07/0/0/0.1, dsn=2.0.0, status=sent (250 2.0.0 Ok: queued as 85B8F25DE1)
May 22 16:57:11 SV01 postfix/qmgr[18620]: 6300825D86: removed
May 22 16:57:11 SV01 postfix/smtpd[18677]: connect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:11 SV01 postfix/smtpd[18677]: B68D725D86: client=sw03.canardwc.local[10.0.1.7]
May 22 16:57:11 SV01 postfix/smtpd[18677]: disconnect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:11 SV01 postfix/smtp[18689]: 85B8F25DE1: to=<sebastien@xxxxxx.fr>, relay=10.0.1.7[10.0.1.7]:25, delay=0.29, delays=0.01/0/0.03/0.25, dsn=2.6.0, status=sent (250 2.6.0 8925 bytes received in 00:00:00; Message id CTA98238 accepted for delivery)
May 22 16:57:11 SV01 postfix/qmgr[18620]: 85B8F25DE1: removed
May 22 16:57:11 SV01 postfix/smtpd[18677]: connect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:11 SV01 postfix/smtpd[18677]: F3A2625D86: client=sw03.canardwc.local[10.0.1.7]
May 22 16:57:12 SV01 postfix/cleanup[18682]: F3A2625D86: message-id=<B7DE0419E385374C913FEA4C694F943D01EBE62D@ps0ma il01.lenumero.local>
May 22 16:57:12 SV01 postfix/qmgr[18620]: F3A2625D86: from=<Sebastien.Wenske@xxxxxx.fr>, size=9310, nrcpt=1 (queue active)
May 22 16:57:12 SV01 postfix/smtpd[18677]: disconnect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:12 SV01 postfix/smtpd[18688]: connect from localhost[127.0.0.1]
May 22 16:57:12 SV01 postfix/smtpd[18688]: 1F79425DE1: client=localhost[127.0.0.1]
May 22 16:57:12 SV01 postfix/cleanup[18682]: 1F79425DE1: message-id=<B7DE0419E385374C913FEA4C694F943D01EBE62D@ps0ma il01.lenumero.local>
May 22 16:57:12 SV01 postfix/qmgr[18620]: 1F79425DE1: from=<Sebastien.Wenske@xxxxxx.fr>, size=9767, nrcpt=1 (queue active)
May 22 16:57:12 SV01 postfix/smtpd[18688]: disconnect from localhost[127.0.0.1]
May 22 16:57:12 SV01 amavis[5882]: (05882-10) Passed CLEAN, LOCAL [10.0.1.7] [84.207.23.137] <Sebastien.Wenske@xxxxxx.fr> -> <sebastien@xxxxxx.fr>, Message-ID: <B7DE0419E385374C913FEA4C694F943D01EBE62D@ps0mail0 1.lenumero.local>, mail_id: WvN+XWBU-jel, Hits: 0.796, size: 9310, queued_as: 1F79425DE1, 110 ms
May 22 16:57:12 SV01 postfix/smtp[18683]: F3A2625D86: to=<sebastien@xxxxxx.fr>, relay=127.0.0.1[127.0.0.1]:10024, delay=0.16, delays=0.05/0/0/0.11, dsn=2.0.0, status=sent (250 2.0.0 Ok: queued as 1F79425DE1)
May 22 16:57:12 SV01 postfix/qmgr[18620]: F3A2625D86: removed
May 22 16:57:12 SV01 postfix/smtpd[18677]: connect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:12 SV01 postfix/smtpd[18677]: 576E625D86: client=sw03.canardwc.local[10.0.1.7]
May 22 16:57:12 SV01 postfix/smtpd[18677]: disconnect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:12 SV01 postfix/smtp[18689]: 1F79425DE1: to=<sebastien@xxxxxx.fr>, relay=10.0.1.7[10.0.1.7]:25, delay=0.33, delays=0.01/0/0.03/0.29, dsn=2.6.0, status=sent (250 2.6.0 9767 bytes received in 00:00:00; Message id CTA59239 accepted for delivery)
May 22 16:57:12 SV01 postfix/qmgr[18620]: 1F79425DE1: removed
May 22 16:57:12 SV01 postfix/smtpd[18677]: connect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:12 SV01 postfix/smtpd[18677]: 95FA125D86: client=sw03.canardwc.local[10.0.1.7]
May 22 16:57:12 SV01 postfix/cleanup[18682]: 95FA125D86: message-id=<B7DE0419E385374C913FEA4C694F943D01EBE62D@ps0ma il01.lenumero.local>
May 22 16:57:12 SV01 postfix/qmgr[18620]: 95FA125D86: from=<Sebastien.Wenske@xxxxxx.fr>, size=10152, nrcpt=1 (queue active)
May 22 16:57:12 SV01 postfix/smtpd[18677]: disconnect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:12 SV01 postfix/smtpd[18688]: connect from localhost[127.0.0.1]
May 22 16:57:12 SV01 postfix/smtpd[18688]: B6DAA25DE1: client=localhost[127.0.0.1]
May 22 16:57:12 SV01 postfix/cleanup[18682]: B6DAA25DE1: message-id=<B7DE0419E385374C913FEA4C694F943D01EBE62D@ps0ma il01.lenumero.local>
May 22 16:57:12 SV01 postfix/qmgr[18620]: B6DAA25DE1: from=<Sebastien.Wenske@xxxxxx.fr>, size=10609, nrcpt=1 (queue active)
May 22 16:57:12 SV01 postfix/smtpd[18688]: disconnect from localhost[127.0.0.1]
May 22 16:57:12 SV01 amavis[5880]: (05880-11) Passed CLEAN, LOCAL [10.0.1.7] [84.207.23.137] <Sebastien.Wenske@xxxxxx.fr> -> <sebastien@xxxxxx.fr>, Message-ID: <B7DE0419E385374C913FEA4C694F943D01EBE62D@ps0mail0 1.lenumero.local>, mail_id: 5xv672HCLORl, Hits: 0.796, size: 10152, queued_as: B6DAA25DE1, 104 ms
May 22 16:57:12 SV01 postfix/smtp[18683]: 95FA125D86: to=<sebastien@xxxxxx.fr>, relay=127.0.0.1[127.0.0.1]:10024, delay=0.16, delays=0.06/0/0/0.1, dsn=2.0.0, status=sent (250 2.0.0 Ok: queued as B6DAA25DE1)
May 22 16:57:12 SV01 postfix/qmgr[18620]: 95FA125D86: removed
May 22 16:57:12 SV01 postfix/smtpd[18677]: connect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:12 SV01 postfix/smtpd[18677]: E696E25D86: client=sw03.canardwc.local[10.0.1.7]
May 22 16:57:12 SV01 postfix/smtpd[18677]: disconnect from sw03.canardwc.local[10.0.1.7]
May 22 16:57:13 SV01 postfix/smtp[18689]: B6DAA25DE1: to=<sebastien@xxxxxx.fr>, relay=10.0.1.7[10.0.1.7]:25, delay=0.29, delays=0.01/0/0.03/0.26, dsn=2.6.0, status=sent (250 2.6.0 10609 bytes received in 00:00:00; Message id CTA18540 accepted for delivery)
May 22 16:57:13 SV01 postfix/qmgr[18620]: B6DAA25DE1: removed


Have someone the same issue with this howto ?

Best Regards,

Sebastian

[canardwc]

I've solved, the problem was I first understand that the "transport" table was for specify outgoing relay.... pfff

It works fine now.

Have a nice day :-)

[mikeyr]

Different problem but same howto.

I have mine working quite well with one exception, I can't remotely send a e-mail using SSL.

At work, sending mail and using the machine at home as my SMTP server, it won't send if I check SSL, it does work with TLS on port 25. I am not seeing errors in the logs. If I am on the machine of course it all works. I need to be able to send mail from work and I would like it to be SSL, just for that extra layer of security.

I can log in to CHECK mail with SSL no problem.

[falko]

Does your ISP maybe block port 465?

[mikeyr]

I called to double check and they claim not to be blocking any ports at all (although its at home, its a business account and supposed to be open to the world).

I can telnet to ports 25, 110 and 993 and get connected, 993 never returns which I assume is correct, it at least connects.

telnet mail.myhost.com 465
Connecting To mail.myhost.com...Could not open connection to the host, on
 port 465: Connect failed

So something else is not correct, this non-connect explains why nothing shows up in the logs. For now, I am using TLS but any ideas ?

netstat -tap does NOT show 465, it shows 10024, 10025, 3306, 80, 25, 993, 995, 110, 143, 22

[falko]

What's in /etc/postfix/master.cf?

[bentman78]

To back up the users mail, I would backup the MySQl database as well as the /home/vmail directories correct? in the event of a system meltdown i can reinstall and configure the postfix, courier...etc then restore the /home/vmail directory and I should be fine I'd assume?

[bentman78]

Originally Posted by mikeyr

I called to double check and they claim not to be blocking any ports at all (although its at home, its a business account and supposed to be open to the world).

I can telnet to ports 25, 110 and 993 and get connected, 993 never returns which I assume is correct, it at least connects.

telnet mail.myhost.com 465
Connecting To mail.myhost.com...Could not open connection to the host, on
 port 465: Connect failed

So something else is not correct, this non-connect explains why nothing shows up in the logs. For now, I am using TLS but any ideas ?

netstat -tap does NOT show 465, it shows 10024, 10025, 3306, 80, 25, 993, 995, 110, 143, 22

How's your IPTables and firewall configs? IPTables won't show up in the logs unless you're logging that particular rule.

Do you get any messages in the postfix logs at startup?

[falko]

Originally Posted by bentman78

To back up the users mail, I would backup the MySQl database as well as the /home/vmail directories correct? in the event of a system meltdown i can reinstall and configure the postfix, courier...etc then restore the /home/vmail directory and I should be fine I'd assume?

Yes, that should work.

[bentman78]

Originally Posted by falko

Yes, that should work.

I'm thinking I'd also have to restore the database as well.

Besides backing up the configs, is all the users mail kept in /home/vmail?