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

[Morons]

Yes if you look at /etc/amavis/conf.d/20-debian_defaults (page 3 of the setup), there you can set the Hits: Carefull with this, it can become muddy! The curect setting will only tag if spam reaches 6.31.

Anycase I would leave it like this and add postgrey to sort te common spam.

[superman]

Hi there

Thanks for the reply.

I changed the values just to test, I made the tag to 1.0 and block to 2. and then sent a spam mail to the server.

here is the logs, Hits was 3.8 and the mail went through 100%...

Aug 19 17:16:32 roux amavis[12286]: (12286-01) Passed SPAMMY, [195.***.***.***] [196.209.201.152] <riaan@testdomain.com> -> <riaan@domain.com>, Message-ID: <48AAE448.5080506@testdomain.com>, mail_id: hpXpeoDqAGbC, Hits: 3.852, size: 23185, queued_as: 4249B23840C, 6813 ms
Aug 19 17:16:32 roux postfix/smtp[12467]: D5DB123840B: to=<riaan@domain.com>, relay=127.0.0.1[127.0.0.1]:10024, delay=7.4, delays=0.61/0.01/0.01/6.8, dsn=2.0.0, status=sent (250 2.0.0 Ok: queued as 4249B23840C)
Aug 19 17:16:32 roux postfix/qmgr[12445]: D5DB123840B: removed
Aug 19 17:16:32 roux postfix/virtual[12475]: 4249B23840C: to=<riaan@domain.com>, relay=virtual, delay=0.05, delays=0.02/0.02/0/0.02, dsn=2.0.0, status=sent (delivered to maildir)
Aug 19 17:16:32 roux postfix/qmgr[12445]: 4249B23840C: removed


Is the something I am missing?

Also can you tell me if there is a way to add things to a white and black list?

many thanks for your help.

About the postgrey how do I add that?

Sorry but I am a bit new to this :-(

[iWarior]

Hello, All!

I'm working in x64 Ubuntu Server 8.04, and have very strange problem with Postfix + MySQL. I'm install and config Postfix by this HowTo: http://www.howtoforge.com/virtual-us...ail-ubuntu8.04

All seems like a works:

# netstat -tap 

tcp        0      0 localhost:10024         *:*                     LISTEN      4908/amavisd (maste
tcp        0      0 localhost:10025         *:*                     LISTEN      13043/master
tcp        0      0 localhost:mysql         *:*                     LISTEN      10152/mysqld
tcp        0      0 *:www                   *:*                     LISTEN      5699/apache2
tcp        0      0 example.com:domain          *:*                     LISTEN      4849/named
tcp        0      0 localhost:domain        *:*                     LISTEN      4849/named
tcp        0      0 *:smtp                  *:*                     LISTEN      13043/master
tcp        0      0 localhost:953           *:*                     LISTEN      4849/named
tcp6       0      0 [::]:imaps              [::]:*                  LISTEN      5427/couriertcpd
tcp6       0      0 [::]:pop3s              [::]:*                  LISTEN      5461/couriertcpd
tcp6       0      0 [::]:pop3               [::]:*                  LISTEN      5441/couriertcpd
tcp6       0      0 [::]:imap2              [::]:*                  LISTEN      5407/couriertcpd
tcp6       0      0 [::]:domain             [::]:*                  LISTEN      4849/named

I'm put all info in to mysql tables, configure *.cf-files, clam, antispam etc

But postfix work very strange (not create mail folder, only receive mail's and so one). After long debug, i'm understand, that problem in mysql query from *.cf files – in %s variable (http://www.postfix.org/mysql_table.5.html). In this variable, in this situation, must be e-mail address of e-mail recipient (eg: admin@example.com), But...

If I'm write in mysql-virtual_mailboxes.cf

query = SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') FROM users WHERE email = '%s'

in mysql log file I see, that %s = example.com

But, if I'm write (only for test of course ):

query = SELECT '%s'

I'm see in %s place my admin@example.com

I'm really don't understand, whats happen, and why in the same place I have different results...

Any ideas?..

[falko]

Are there any errors in your mail log?

[rc1985]

Hello!
Im getting this error (mail.err and mail.log) when trying to access pop3. I followed this tutorial bellow:

mail.err

Nov 3 13:45:04 li43-94 courierpop3login: authentication error: Input/output error
Nov 3 13:52:37 li43-94 courierpop3login: authentication error: Input/output error
Nov 3 13:54:17 li43-94 courierpop3login: authentication error: Input/output error
Nov 3 13:54:57 li43-94 courierpop3login: authentication error: Input/output error
Nov 3 13:55:31 li43-94 courierpop3login: authentication error: Input/output error
Nov 3 14:01:13 li43-94 courierpop3login: authentication error: Input/output error
Nov 3 14:05:04 li43-94 courierpop3login: authentication error: Input/output error
Nov 3 14:08:20 li43-94 courierpop3login: authentication error: Input/output error
Nov 3 14:08:45 li43-94 courierpop3login: authentication error: Input/output error
Nov 3 14:14:51 li43-94 courierpop3login: authentication error: Input/output error
Nov 3 14:15:09 li43-94 courierpop3login: authentication error: Input/output error
Nov 3 14:25:04 li43-94 courierpop3login: authentication error: Input/output error
Nov 3 14:35:04 li43-94 courierpop3login: authentication error: Input/output error
Nov 3 14:45:04 li43-94 courierpop3login: authentication error: Input/output error

mail.log

Nov 3 16:11:37 li43-94 postfix/smtpd[17949]: warning: 000: hostname 189107039153.user.xxxxxx.xxx.xx verification failed: Name or service not known
Nov 3 11:11:37 li43-94 postfix/smtpd[17949]: connect from unknown[189.107.39.153]
Nov 3 16:11:44 li43-94 courierpop3login: LOGIN FAILED, user=fantasma, ip=[::ffff:189.107.39.153]
Nov 3 11:11:47 li43-94 postfix/smtpd[17949]: disconnect from unknown[189.107.39.153]
Nov 3 16:15:07 li43-94 postfix/anvil[17951]: statistics: max connection rate 1/60s for (smtp:189.107.39.153) at Nov 3 16:11:37
Nov 3 11:15:07 li43-94 postfix/anvil[17951]: statistics: max connection count 1 for (smtp:189.107.39.153) at Nov 3 11:11:37
Nov 3 11:15:07 li43-94 postfix/anvil[17951]: statistics: max cache size 1 at Nov 3 11:11:37

http://www.howtoforge.com/virtual_us...debian_etch_p1

thanks

[superman]

Hi there.

Try to reinstall courier-imap, I had the same error and I reinstall it, sorted my issue.

Superman

[Marc-Andre]

Hi,

i followed the howto to the letter, but i got the last times complains from clients that they're missing some eMails. I figured out that the forwarding doesn't work as it should.

My test case is following : i send from my gmail account to the postmaster address of my domain, which is in the forwarding table and should forward to my real address.

In the mail.log i have that:

Nov 10 16:07:42 intrepid postfix/smtpd[32213]: connect from nf-out-0910.google.com[64.233.182.184]
Nov 10 16:07:42 intrepid postfix/smtpd[32213]: 357C62E6D8: client=nf-out-0910.google.com[64.233.182.184]
Nov 10 16:07:42 intrepid postfix/cleanup[31933]: 357C62E6D8: message-id=<267a75300811100707xac4d33ej130d647e2e9bc4f7@mail.gmail.com>
Nov 10 16:07:42 intrepid postfix/qmgr[30649]: 357C62E6D8: from=<marcandre.appel@gmail.com>, size=2469, nrcpt=1 (queue active)
Nov 10 16:07:42 intrepid amavis[31282]: (31282-14) ESMTP::10024 /var/lib/amavis/tmp/amavis-20081110T155440-31282: <marcandre.appel@gmail.com> -> <postmaster@marc-andre.cc> SIZE=2469 Received: from intrepid.sudimage.net ([127.0.0.1]) by localhost (intrepid.sudimage.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP for <postmaster@marc-andre.cc>; Mon, 10 Nov 2008 16:07:42 +0100 (CET)
Nov 10 16:07:42 intrepid amavis[31282]: (31282-14) Checking: ix5cj-iZz7dw [64.233.182.184] <marcandre.appel@gmail.com> -> <postmaster@marc-andre.cc>
Nov 10 16:07:44 intrepid postfix/smtpd[30666]: connect from localhost.localdomain[127.0.0.1]
Nov 10 16:07:44 intrepid postfix/smtpd[30666]: 8A5142E763: client=localhost.localdomain[127.0.0.1]
Nov 10 16:07:44 intrepid postfix/cleanup[31933]: 8A5142E763: message-id=<267a75300811100707xac4d33ej130d647e2e9bc4f7@mail.gmail.com>
Nov 10 16:07:44 intrepid postfix/qmgr[30649]: 8A5142E763: from=<marcandre.appel@gmail.com>, size=2957, nrcpt=1 (queue active)
Nov 10 16:07:44 intrepid postfix/smtpd[30666]: disconnect from localhost.localdomain[127.0.0.1]
Nov 10 16:07:44 intrepid amavis[31282]: (31282-14) FWD via SMTP: <marcandre.appel@gmail.com> -> <postmaster@marc-andre.cc>,BODY=7BIT 250 2.6.0 Ok, id=31282-14, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as 8A5142E763
Nov 10 16:07:44 intrepid amavis[31282]: (31282-14) Passed CLEAN, [64.233.182.184] [64.233.182.184] <marcandre.appel@gmail.com> -> <postmaster@marc-andre.cc>, Message-ID: <267a75300811100707xac4d33ej130d647e2e9bc4f7@mail.gmail.com>, mail_id: ix5cj-iZz7dw, Hits: -2.599, size: 2469, queued_as: 8A5142E763, 2336 ms
Nov 10 16:07:44 intrepid postfix/smtp[32218]: 357C62E6D8: to=<postmaster@marc-andre.cc>, relay=127.0.0.1[127.0.0.1]:10024, delay=2.4, delays=0.04/0/0/2.3, dsn=2.0.0, status=sent (250 2.0.0 Ok: queued as 8A5142E763)
Nov 10 16:07:44 intrepid postfix/qmgr[30649]: 357C62E6D8: removed
Nov 10 16:07:44 intrepid postfix/virtual[30667]: 8A5142E763: to=<postmaster@marc-andre.cc>, relay=virtual, delay=0.03, delays=0.01/0/0/0.03, dsn=5.1.1, status=bounced (unknown user: "postmaster@marc-andre.cc")
Nov 10 16:07:44 intrepid postfix/cleanup[31933]: 92B4B2E6D8: message-id=<20081110150744.92B4B2E6D8@intrepid.sudimage.net>
Nov 10 16:07:44 intrepid postfix/bounce[32222]: 8A5142E763: sender non-delivery notification: 92B4B2E6D8
Nov 10 16:07:44 intrepid postfix/qmgr[30649]: 92B4B2E6D8: from=<>, size=4863, nrcpt=1 (queue active)
Nov 10 16:07:44 intrepid postfix/qmgr[30649]: 8A5142E763: removed
Nov 10 16:07:45 intrepid postfix/smtp[32223]: 92B4B2E6D8: to=<marcandre.appel@gmail.com>, relay=gmail-smtp-in.l.google.com[72.14.221.114]:25, delay=0.48, delays=0.01/0/0.08/0.39, dsn=2.0.0, status=sent (250 2.0.0 OK 1226329665 4si10414336fgg.4)
Nov 10 16:07:45 intrepid postfix/qmgr[30649]: 92B4B2E6D8: removed

It's like postfix doesn't check the forwardings table.

Where can the error be? Everything else is working just fine.

Thanks in advance,

Marc-André

[falko]

Is there an alias for postmaster in /etc/aliases? Please create one that sends the postmaster emails to one of your working email accounts so that you can read the bounce emails. They may tell you more about the problem.

[ikaros]

What should I do to be able to access squirrelmail via https://...?
Doing the obvious, uncommenting the last section of /etc/apach2/conf.d/squirrelmail.conf , doesn't do the trick.

[...]
# users will prefer a simple URL like http://webmail.example.com
#<VirtualHost 1.2.3.4>
#  DocumentRoot /usr/share/squirrelmail
#  ServerName webmail.example.com
#</VirtualHost>

# redirect to https when available (thanks omen@descolada.dartmouth.edu)
#
#  Note: There are multiple ways to do this, and which one is suitable for
#  your site's configuration depends. Consult the apache documentation if
#  you're unsure, as this example might not work everywhere.
#
#<IfModule mod_rewrite.c>
#  <IfModule mod_ssl.c>
#    <Location /squirrelmail>
#      RewriteEngine on
#      RewriteCond %{HTTPS} !^on$ [NC]
#      RewriteRule . https://%{HTTP_HOST}%{REQUEST_URI}  [L]
#    </Location>
#  </IfModule>
#</IfModule>

Maybe mod_rewrite and mod_ssl aren't installed. How do I check the installed Apache's modules?

[falko]

Run

a2enmod rewrite
a2enmod ssl
/etc/init.d/apache2 restart