Courier IMAP quota problem

View: New views
3 Messages — Rating Filter:   Alert me  

Courier IMAP quota problem

by sjachym :: Rate this Message:

| View Threaded | Show Only this Message

Hi all, 

I've configured a courier-imap 4.4.0-2 server with mysql support +
Postfix-2.5.5 (+VDA patch) + courier-authlib 0.61.0-1+lenny1
I need to make quotas working on my Debian Lenny x86_64 distrib. Concerning postfix --> no problems, when I reach the quota limit, it warns. But concerning Courier-IMAP, I use roundcube and squirrelmail webmail that uses the imap command GETQUOTAROOT INBOX but it returns everytime nothing. According the imap rfc2087, I should have something like that: Example: A003 GETQUOTAROOT INBOX * QUOTAROOT INBOX "" * QUOTA "" (STORAGE 10 512) A003 OK Getquota completed But I obtain every time that: QUOT1 GETQUOTAROOT "INBOX" * QUOTAROOT "INBOX" "ROOT" * QUOTA "ROOT" QUOT1 OK GETQUOTAROOT Ok.

concerning my courier-imap configuration, I've
# cat /etc/courier/authmysqlrc  | grep QUOTA
##NAME: MYSQL_QUOTA_FIELD:0
# Define MYSQL_QUOTA_FIELD to be the name of the field that can optionally
MYSQL_QUOTA_FIELD      quota
#MYSQL_QUOTA_FIELD concat(quota,'S') #--> Change in mysql log the query, but not the result
                  596 Query     SELECT username, password, "", '1001', '1001', '/var/mail/virtual/', maildir, concat(quota,'S'), name, "" FROM mailbox WHERE username = 'seb@...
                  605 Query     SELECT username, password, "", '1001', '1001', '/var/mail/virtual/', maildir, quota, name, "" FROM mailbox WHERE username = 'seb@...
concerning my courier-imap capability, I've
* OK [CAPABILITY IMAP4rev1 UIDPLUS CHILDREN NAMESPACE THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA IDLE ACL ACL2=UNION] Courier-IMAP ready. Copyright 1998-2008 Double Precision, Inc.  See COPYING for distribution information.

and according authtest, I've something like that
[root@... www]# authtest seb@...
Authentication succeeded.
     Authenticated: seb@...  (uid 1001, gid 1001)
    Home Directory: /var/mail/virtual/
           Maildir: myhost.com/seb@...myhost.com/seb@...
             Quota: 2097152 #--> Which is exactly what I should have as a result of ( 2Mo )
Encrypted Password: $1$190b4d59$TocWPHqN/iCLdVI8y6BMD.
Cleartext Password: (none)
           Options: (none) What's wrong ? Thanks in advance for any kind of help. Cheers. Sebastien
 

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
Courier-imap mailing list
Courier-imap@...
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-imap

Re: Courier IMAP quota problem

by sjachym :: Rate this Message:

| View Threaded | Show Only this Message

Does anyone has already correctly working quotas with courier-imap + mysql ?
My anwser response at imap question "GETQUOTAROOT INBOX" are not return STORAGE, and quota percentage is not display in quota client mail...
... must migrate to dovecot ?
 
# dpkg -l | grep courier
ii  courier-authdaemon                  0.61.0-1+lenny1              Courier authentication daemon
ii  courier-authlib                     0.61.0-1+lenny1              Courier authentication library
ii  courier-authlib-mysql               0.61.0-1+lenny1              MySQL support for the Courier authentication library
ii  courier-authlib-userdb              0.61.0-1+lenny1              userdb support for the Courier authentication library
ii  courier-base                        0.60.0-2                     Courier mail server - base system
ii  courier-imap                        4.4.0-2                      Courier mail server - IMAP server
ii  courier-pop                         0.60.0-2                     Courier mail server - POP3 server

Sent: Saturday, December 03, 2011 10:47 PM
Subject: [Courier-imap] Courier IMAP quota problem

Hi all, 

I've configured a courier-imap 4.4.0-2 server with mysql support +
Postfix-2.5.5 (+VDA patch) + courier-authlib 0.61.0-1+lenny1
I need to make quotas working on my Debian Lenny x86_64 distrib. Concerning postfix --> no problems, when I reach the quota limit, it warns. But concerning Courier-IMAP, I use roundcube and squirrelmail webmail that uses the imap command GETQUOTAROOT INBOX but it returns everytime nothing. According the imap rfc2087, I should have something like that: Example: A003 GETQUOTAROOT INBOX * QUOTAROOT INBOX "" * QUOTA "" (STORAGE 10 512) A003 OK Getquota completed But I obtain every time that: QUOT1 GETQUOTAROOT "INBOX" * QUOTAROOT "INBOX" "ROOT" * QUOTA "ROOT" QUOT1 OK GETQUOTAROOT Ok.

concerning my courier-imap configuration, I've
# cat /etc/courier/authmysqlrc  | grep QUOTA
##NAME: MYSQL_QUOTA_FIELD:0
# Define MYSQL_QUOTA_FIELD to be the name of the field that can optionally
MYSQL_QUOTA_FIELD      quota
#MYSQL_QUOTA_FIELD concat(quota,'S') #--> Change in mysql log the query, but not the result
                  596 Query     SELECT username, password, "", '1001', '1001', '/var/mail/virtual/', maildir, concat(quota,'S'), name, "" FROM mailbox WHERE username = 'seb@...
                  605 Query     SELECT username, password, "", '1001', '1001', '/var/mail/virtual/', maildir, quota, name, "" FROM mailbox WHERE username = 'seb@...
concerning my courier-imap capability, I've
* OK [CAPABILITY IMAP4rev1 UIDPLUS CHILDREN NAMESPACE THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA IDLE ACL ACL2=UNION] Courier-IMAP ready. Copyright 1998-2008 Double Precision, Inc.  See COPYING for distribution information.

and according authtest, I've something like that
[root@... www]# authtest seb@...
Authentication succeeded.
     Authenticated: seb@...  (uid 1001, gid 1001)
    Home Directory: /var/mail/virtual/
           Maildir: myhost.com/seb@...myhost.com/seb@...
             Quota: 2097152 #--> Which is exactly what I should have as a result of ( 2Mo )
Encrypted Password: $1$190b4d59$TocWPHqN/iCLdVI8y6BMD.
Cleartext Password: (none)
           Options: (none) What's wrong ? Thanks in advance for any kind of help. Cheers. Sebastien
 

------------------------------------------------------------------------------
Learn Windows Azure Live!  Tuesday, Dec 13, 2011
Microsoft is holding a special Learn Windows Azure training event for
developers. It will provide a great way to learn Windows Azure and what it
provides. You can attend the event by watching it streamed LIVE online.  
Learn more at http://p.sf.net/sfu/ms-windowsazure
_______________________________________________
Courier-imap mailing list
Courier-imap@...
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-imap

Re: Courier IMAP quota problem

by Sam Varshavchik :: Rate this Message:

| View Threaded | Show Only this Message

sjachym@... writes:

> [root@... www]# authtest <URL:mailto:seb@...>seb@...
> Authentication succeeded.
>  
>      Authenticated: <URL:mailto:seb@...>seb@...  (uid 1001, gid
>  1001)
>     Home Directory: /var/mail/virtual/
>  
>            Maildir: <URL:mailto:myhost.com/seb@.../>myhost.com/seb@myh
> ost.com/<URL:mailto:myhost.com/seb@.../>
>              Quota: 2097152     #--
That looks wrong. The quota setting should be terminated by 'S', as  
described in README.maildirquota.html




------------------------------------------------------------------------------
Learn Windows Azure Live!  Tuesday, Dec 13, 2011
Microsoft is holding a special Learn Windows Azure training event for
developers. It will provide a great way to learn Windows Azure and what it
provides. You can attend the event by watching it streamed LIVE online.  
Learn more at http://p.sf.net/sfu/ms-windowsazure
_______________________________________________
Courier-imap mailing list
Courier-imap@...
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-imap

attachment0 (205 bytes) Download Attachment