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

Discussion in 'HOWTO-Related Questions' started by canardwc, May 22, 2008.

  1. canardwc

    canardwc New Member

    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@ps0mail01.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@ps0mail01.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@ps0mail01.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@ps0mail01.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@ps0mail01.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@ps0mail01.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@ps0mail01.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@ps0mail01.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@ps0mail01.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@ps0mail01.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@ps0mail01.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@ps0mail01.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@ps0mail01.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@ps0mail01.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@ps0mail01.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
     
  2. canardwc

    canardwc New Member

    oups

    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 :)
     
  3. mikeyr

    mikeyr New Member

    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.
     
  4. falko

    falko Super Moderator ISPConfig Developer

    Does your ISP maybe block port 465?
     
  5. mikeyr

    mikeyr New Member

    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.

    Code:
    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
     
    Last edited: May 23, 2008
  6. falko

    falko Super Moderator ISPConfig Developer

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

    bentman78 New Member

    Different question

    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?
     
  8. bentman78

    bentman78 New Member

    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?
     
  9. falko

    falko Super Moderator ISPConfig Developer

    Yes, that should work. :)
     
  10. bentman78

    bentman78 New Member

    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?
     
  11. falko

    falko Super Moderator ISPConfig Developer

    Yes, that's right.
     
  12. bentman78

    bentman78 New Member

    Thanks for the replies Falko.

    Would you suggest Tar for backing up the /home/vmail directory?
     
  13. falko

    falko Super Moderator ISPConfig Developer

    Yes. You can do it like this:
    Code:
    cd /home
    tar -pczf vmail.tar.gz vmail/
     

Share This Page