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=<[email protected]>, 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=<[email protected]>, 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=<[email protected]>, 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] <[email protected]> -> <[email protected]>, 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=<[email protected]>, 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=<[email protected]>, 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=<[email protected]>, 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=<[email protected]>, 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] <[email protected]> -> <[email protected]>, 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=<[email protected]>, 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=<[email protected]>, 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=<[email protected]>, 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=<[email protected]>, 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] <[email protected]> -> <[email protected]>, 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=<[email protected]>, 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=<[email protected]>, 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=<[email protected]>, 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=<[email protected]>, 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] <[email protected]> -> <[email protected]>, 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=<[email protected]>, 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=<[email protected]>, 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=<[email protected]>, 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=<[email protected]>, 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] <[email protected]> -> <[email protected]>, 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=<[email protected]>, 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=<[email protected]>, 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, May 22, 2008
    #1
  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 :)
     
    canardwc, May 22, 2008
    #2
  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.
     
    mikeyr, May 22, 2008
    #3
  4. falko

    falko Super Moderator Howtoforge Staff

    Does your ISP maybe block port 465?
     
    falko, May 23, 2008
    #4
  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
    mikeyr, May 23, 2008
    #5
  6. falko

    falko Super Moderator Howtoforge Staff

    What's in /etc/postfix/master.cf?
     
    falko, May 24, 2008
    #6
  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?
     
    bentman78, May 24, 2008
    #7
  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?
     
    bentman78, May 24, 2008
    #8
  9. falko

    falko Super Moderator Howtoforge Staff

    Yes, that should work. :)
     
    falko, May 25, 2008
    #9
  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?
     
    bentman78, May 27, 2008
    #10
  11. falko

    falko Super Moderator Howtoforge Staff

    Yes, that's right.
     
    falko, May 28, 2008
    #11
  12. bentman78

    bentman78 New Member

    Thanks for the replies Falko.

    Would you suggest Tar for backing up the /home/vmail directory?
     
    bentman78, May 28, 2008
    #12
  13. falko

    falko Super Moderator Howtoforge Staff

    Yes. You can do it like this:
    Code:
    cd /home
tar -pczf vmail.tar.gz vmail/
     
    falko, May 29, 2008
    #13

Share This Page