[Dovecot] Dovecot + virtual users
Hi,
I'm running FreeBSD, Dovecot, Postfix (virtual users), MySQL, Squirrelmail. I have installed squirrelmail-quota_usage-plugin, but I cannot make it work. It mentions "If you have an IMAP server with QUOTA Extension capability...". In dovecot.conf I have enabled "mail_plugins = quota" near protocol pop3 and protocol lda, near protocol imap I have "mail_plugins = quota imap_quota". Near " plugin { ..." I have "quota = maildir:storage=204800". I think that the problem of why I don't see quota in Squirrelmail is in file dovecot-sql near user_query. I have my users mailboxes in such format: /usr/local/virtual/domain.tld/username and my user_query looks like this: user_query = SELECT maildir, 125 AS uid, 125 AS gid, concat('maildir:storage=', quota) AS quota FROM mailbox WHERE username = '%u' AND active = '1', I think that in my user_query I'm missing something. I do not get any errors in the dovecot and dovecot-debug logs, everything works fine, but I still can't see quota.
bichumo wrote:
Hi,
I'm running FreeBSD, Dovecot, Postfix (virtual users), MySQL, Squirrelmail. I have installed squirrelmail-quota_usage-plugin, but I cannot make it work. It mentions "If you have an IMAP server with QUOTA Extension capability...". In dovecot.conf I have enabled "mail_plugins = quota" near protocol pop3 and protocol lda, near protocol imap I have "mail_plugins = quota imap_quota". Near " plugin { ..." I have "quota = maildir:storage=204800". I think that the problem of why I don't see quota in Squirrelmail is in file dovecot-sql near user_query. I have my users mailboxes in such format: /usr/local/virtual/domain.tld/username and my user_query looks like this: user_query = SELECT maildir, 125 AS uid, 125 AS gid, concat('maildir:storage=', quota) AS quota FROM mailbox WHERE username = '%u' AND active = '1', I think that in my user_query I'm missing something. I do not get any errors in the dovecot and dovecot-debug logs, everything works fine, but I still can't see quota.
Solved.
What was wrong? I will run the same set of programs on Linux and don't want to run in the same problem. Do you mind sharing your solution?
TNX Egbert Jan
-----Original Message----- From: dovecot-bounces+egbert=vandenbussche.nl@dovecot.org [mailto:dovecot-bounces+egbert=vandenbussche.nl@dovecot.org] On Behalf Of bichumo Sent: Thursday, September 13, 2007 8:00 PM To: dovecot@dovecot.org Subject: Re: [Dovecot] Dovecot + virtual users
bichumo wrote:
Hi,
I'm running FreeBSD, Dovecot, Postfix (virtual users), MySQL, Squirrelmail. I have installed squirrelmail-quota_usage-plugin, but I cannot make it work. It mentions "If you have an IMAP server with QUOTA Extension capability...". In dovecot.conf I have enabled "mail_plugins = quota" near protocol pop3 and protocol lda, near protocol imap I have "mail_plugins = quota imap_quota". Near " plugin { ..." I have "quota = maildir:storage=204800". I think that the problem of why I don't see quota in Squirrelmail is in file dovecot-sql near user_query. I have my users mailboxes in such format: /usr/local/virtual/domain.tld/username and my user_query looks like this: user_query = SELECT maildir, 125 AS uid, 125 AS gid, concat('maildir:storage=', quota) AS quota FROM mailbox WHERE username = '%u' AND active = '1', I think that in my user_query I'm missing something. I do not get any errors in the dovecot and dovecot-debug logs, everything works fine, but I still can't see quota.
Solved.
On 2007-09-13 21:00:23 +0300, bichumo wrote:
I'm running FreeBSD, Dovecot, Postfix (virtual users), MySQL, Squirrelmail. I have installed squirrelmail-quota_usage-plugin, but I cannot make it work. It mentions "If you have an IMAP server with QUOTA Extension capability...". In dovecot.conf I have enabled "mail_plugins = quota" near protocol pop3 and protocol lda, near protocol imap I have "mail_plugins = quota imap_quota". Near " plugin { ..." I have "quota = maildir:storage=204800". I think that the problem of why I don't see quota in Squirrelmail is in file dovecot-sql near user_query. I have my users mailboxes in such format: /usr/local/virtual/domain.tld/username and my user_query looks like this: user_query = SELECT maildir, 125 AS uid, 125 AS gid, concat('maildir:storage=', quota) AS quota FROM mailbox WHERE username = '%u' AND active = '1', I think that in my user_query I'm missing something. I do not get any errors in the dovecot and dovecot-debug logs, everything works fine, but I still can't see quota.
Solved.
maybe you want to mention how your solved the issues. others might search the mail archive and would find your solution.
darix-- openSUSE - SUSE Linux is my linux openSUSE is good for you www.opensuse.org
participants (3)
-
bichumo
-
Egbert Jan
-
Marcus Rueckert