Courier MYSQL_QUOTA_FIELD isn't working

Posted by JoeCoder on Server Fault See other posts from Server Fault or by JoeCoder
Published on 2012-06-17T20:36:47Z Indexed on 2012/06/17 21:18 UTC
Read the original article Hit count: 325

Filed under:

imap

|

courier

|

ubuntu-12.04

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?

© Server Fault or respective owner

Related posts about imap

Why won't fetchmail work all of a sudden?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I ran a chmod 777 * on my home folder. (I know, I know. I'll never do it again.) Ever since then, fetchmail seems to be broken. I use it to fetch mail from an Exchange 2003 mailbox through DAVMail and OWA. The problem is that fetchmail complains about an "expunge mismatch" whenever I get a new… >>> More
Backup IMAP mail, then access via IMAP again

as seen on Super User - Search for 'Super User'
I am looking for a tool to backup an entire IMAP account and then expose that backup (read-only) via IMAP again. This would be perfect for backing up email from any provider, and allowing the backup to be accessed from any mail client even years after closing the account. I suspect this could be… >>> More
php imap get connection failed error

as seen on Stack Overflow - Search for 'Stack Overflow'
Warning: imap_open() [function.imap-open]: Couldn't open stream {imap.gmail.com:993/imap/ssl}INBOX in /home/happy/public_html/source/imap/fet_mail_from_email_add.php on line 7 can't connect: Can't connect to gmail-imap.l.google.com,993: Connection timed out my snippet is $mbox = imap_open("{imap… >>> More
wildcard ssl certificate - exchange 2010 - POP/IMAP problem

as seen on Server Fault - Search for 'Server Fault'
previously we have requested a wildcard ssl certificate from godaddy for our major domain. one of the reasons was the new established exchange server 2010. usually you require following names included in certificiate: FQDN (e.g. mail.whatever.com) Hostname (mail) Domain name (whatever.com) Autodiscover… >>> More
Backup Gmail using Mail.app and IMAP without redundancy

as seen on Super User - Search for 'Super User'
I don't care for actually using mail app, I use mostly the gmail interface and mail app just for offline, for quickly reading and eventually replying. Everything is working fine, I think I've followed every guide out there... Here's a great one. But I could find nothing about avoiding redundancy… >>> More

Related posts about courier

How to host multiple mail domains with courier?

as seen on Server Fault - Search for 'Server Fault'
I had my server set up with generic aliases in /etc/courier/aliases/users, which worked fine. But today I wanted to host some new domains, where addresses overlap. What I need is that [email protected] goes to account "dv", but [email protected] goes to account "d2". So I set up a new file containing… >>> More
Configure Courier IMAP to deliver mail to multiple hostnames

as seen on Server Fault - Search for 'Server Fault'
I have a courier IMAP server running on a private server at dreamhost. The private server's hostname is psxxxx.dreamhostps.com. I also have CNAME for the private server, call it mydomain.com. I want to send email to [email protected] and have it delivered to [email protected]. Right now… >>> More
Le tablet PC de Microsoft se dévoile, une vidéo présente Courier en action

as seen on Developper.com - Search for 'Developper.com'
Mise à jour du 09.03.2010 par Katleen Le tablet PC de Microsoft se dévoile, une vidéo présente Courier en action Les nouvelles sur Courier, la tablette de Microsoft, sont rares et se font attendre. Cependant, quelques rumeurs jugées fiables viennent d'apparaître et laissent entendre que l'appareil… >>> More
Adobe distiller: Cambria not found, using Courier.

as seen on Super User - Search for 'Super User'
Whenever I try to print to PDF from an MS Word 2007 document, I get this error: Cambria not found, using Courier. (Even though I believe I removed ALL occurrences of Cambria from the document) The pdf doesn't get produced actually, all I get is this error log file with that message. Edit: I… >>> More
ASP.NET Web API Exception Handling

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
When I talk about exceptions in my product team I often talk about two kind of exceptions, business and critical exceptions. Business exceptions are exceptions thrown based on “business rules”, for example if you aren’t allowed to do a purchase. Business exceptions in most case aren’t important to… >>> More