Questions[courier](server)

In /etc/courier/authmysqlrc, I have

MYSQL_QUOTA_FIELD CONCAT(quota, 'S')

But connecting to the account via RoundCube or Thunderbird with the Display Quota plugin shows an unlimited/unknown quota. In the quota field, I have entered 1000000, and this table/row is otherwise working perfectly for authentication.

I enabled mysql logging and checked the query log for the query that courier is executing for auth. When I execute it myself it works fine and correctly returns "1000000s" for the quota.

I'm using Ubuntu Server 12.04. Any ideas?

I'm doing some tests with a brand new Ubuntu Server 11.10 installation.
I installed postfix and courier-pop for pop3 and, from what I could gather, it looks like courier doesn't support mbox filetype but only Maildir format.
So I've created a user with his home in /home/username, with maildirmake.courier I created the directory structure in /var/mail/username and set the correct rights and owner.

I sent some test mail to the new account and all works like a charm. Postfix created the new email in /var/mail/username/new

The problem is that I can't download the email via pop3 without creating a symbolic link from /home/username/Maildir to /var/mail/username/.

Now, the problem is that not all users have their own home folder, so the symlink thing won't obviously work.

This is the directory set in /etc/postfix/main.cf:

mail_spool_directory = /var/mail/

and this is for the courier's conf file:

MAILDIRPATH=Maildir

I tried to change to something like /var/mail/ or /var/mail/$USER but didn't work either.

I'm probably missing something in courier-pop's configuration.

Any ideas?

So far I'm using self-signed certificates, but decided to at least consider getting the "real" one.

So far I noticed that internal formats of the certificated are a bit different, that is:

• http (nginx) certificate has only CERTIFICATE part (with base64 encoded content) and KEY with also only base64 content
• smtp (exim) crt file contains certificate textual information (issuer, subject, algorithm, dates, and so on), plus CERTIFICATE block with base64 data, while the .key file for exim contains only base64 encoded key
• imap/pop3 (courier) .pem file contains key (base64), certificate info (textual), and certificate itself (base64).

Can I get any "web" certificate from thawte or some company like this, and from this (and key file) generate all formats that I need for nginx, exim4 and courier, or do I need to get separate certificates, or is it something else entirely?

I've been searching for a resource on how to do this but not having much luck.

I am running a working MTA/MUA that is based on Postfix and Courier with MySQL as a backend for virtual users. I based my system on the following article:

https://help.ubuntu.com/community/PostfixCompleteVirtualMailSystemHowto

It was great up until the empty sections! My SMTP/IMAP setup is working great, and I managed to get SpamAssassin and ClamAV installed as well with some separate documentation I found online.

What I need help with is setting up Postfix to use Procmail as the mailbox_command so that it will work with virtual users. I want to be able to define different Procmail rules for each virtual user separately. I've read the Postfix documentation, and as I understand it the default functionality for mailbox_command will only work for local (non-virtual) users.

Thanks in advance!

UPDATE:

Since this post, I've come to realize that mailbox_command is not tenable. Instead I found a way to do this using transport_maps. Read my own answer below.

I am looking for tips on improving IMAP search performance using Courier IMAP. The current version is 4.2.1. Unlike in the question "Fast search for IMAP?", I'm specifically looking for server side improvements.

Access performance is already quite good on fairly large accounts, but search is slow. Is there some kind of tool / add-on that can be used to generate good indices for the various interesting mail fields?