HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   HOWTO-Related Questions (http://www.howtoforge.com/forums/forumdisplay.php?f=2)
-   -   Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 8.04) (http://www.howtoforge.com/forums/showthread.php?t=23544)

canardwc 22nd May 2008 17:06

Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 8.04)
 
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 22nd May 2008 17:18

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 :-)

mikeyr 22nd May 2008 19:55

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 23rd May 2008 12:29

Does your ISP maybe block port 465?

mikeyr 23rd May 2008 18:45

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

falko 24th May 2008 12:50

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

bentman78 24th May 2008 23:17

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 24th May 2008 23:19

Quote:

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.

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

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 25th May 2008 18:38

Quote:

Originally Posted by bentman78 (Post 127447)
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 27th May 2008 20:16

Quote:

Originally Posted by falko (Post 127568)
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?


All times are GMT +2. The time now is 16:59.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.