Re: [Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

2014-02-01 Thread Robert Schetterer
Am 01.02.2014 11:18, schrieb mayu: > The bytes col of quota2 table is in sync with squirrel(when the quota_rule = > *:storage=1G is added in dovecot) so why cant the quota col of mailbox table > can get sync with squirrel > ? squirrel takes quota from imap, postfixadmin sets the quota for each us

Re: [Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

2014-02-01 Thread mayu
The bytes col of quota2 table is in sync with squirrel(when the quota_rule = *:storage=1G is added in dovecot) so why cant the quota col of mailbox table can get sync with squirrel ? -- View this message in context: http://dovecot.2317879.n4.nabble.com/Postfixadmin-MySQL-Dovecot-2-and-quota-tp

Re: [Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

2014-02-01 Thread Robert Schetterer
Am 01.02.2014 10:58, schrieb mayu: > Thanks for the reply Robert . > > The Check_Quota plugin is install with compatibility plugin and I have > configured the config file of check_quota also . > > Still it is not working :( > you failed in config somewhere, i have Postfixadmin/MySQL/Dovecot2/sq

Re: [Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

2014-02-01 Thread mayu
Check_ quota is installed properly because SM show quota related info . > If the quota_rule = *:storage=1G is added .But when its removed SM does > not show quota info from postfixadmin . -- View this message in context: http://dovecot.2317879.n4.nabble.com/Postfixadmin-MySQL-Dovecot-2-and-

Re: [Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

2014-02-01 Thread mayu
Thanks for the reply Robert . The Check_Quota plugin is install with compatibility plugin and I have configured the config file of check_quota also . Still it is not working :( -- View this message in context: http://dovecot.2317879.n4.nabble.com/Postfixadmin-MySQL-Dovecot-2-and-quota-tp4421

Re: [Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

2014-02-01 Thread Robert Schetterer
Am 01.02.2014 10:26, schrieb mayu: > Hello LuKreme , > > So How can I achieve this .If I remove the quota_rule = *:storage=1G from > dovecot ,SM does not show any quota related info . > > I have used below link to configure it . > > http://serverstutorial.wordpress.com/2012/12/28/postfix-mysql-

Re: [Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

2014-02-01 Thread mayu
Hello LuKreme , So How can I achieve this .If I remove the quota_rule = *:storage=1G from dovecot ,SM does not show any quota related info . I have used below link to configure it . http://serverstutorial.wordpress.com/2012/12/28/postfix-mysql-postfixadmin-dovecot-roundcube-centos-5-7-updated/

Re: [Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

2014-02-01 Thread Robert Schetterer
Am 01.02.2014 10:20, schrieb mayu: > Thanks Benny for your reply . > > Postfixadmin is reflecting the used quota/assigned quota . Here used quota > means the message send by each user .Mysql quota2 table is storing the used > quota and messages count (send msg+the welcome message from postfix

Re: [Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

2014-02-01 Thread mayu
Thanks Benny for your reply . Postfixadmin is reflecting the used quota/assigned quota . Here used quota means the message send by each user .Mysql quota2 table is storing the used quota and messages count (send msg+the welcome message from postfix admin).The message count is not adding the in

Re: [Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

2014-01-31 Thread LuKreme
On 31 Jan 2014, at 09:52 , Benny Pedersen wrote: > On 2014-01-31 17:45, LuKreme wrote: >> On 31 Jan 2014, at 06:54 , mayu wrote: >>> The mysql table is fetching the data stored in postfixadmin ,But squirrel in >>> not fetching the quota value .If I add this line: quota_rule = *:storage=1G

Re: [Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

2014-01-31 Thread Benny Pedersen
On 2014-01-31 17:45, LuKreme wrote: On 31 Jan 2014, at 06:54 , mayu wrote: The mysql table is fetching the data stored in postfixadmin ,But squirrel in not fetching the quota value .If I add this line: quota_rule = *:storage=1G in conf.d/90-quota.conf file, it works, I mean squirrelmail gets

Re: [Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

2014-01-31 Thread LuKreme
On 31 Jan 2014, at 06:54 , mayu wrote: > The mysql table is fetching the data stored in postfixadmin ,But squirrel in > not fetching the quota value .If I add this line: >> quota_rule = *:storage=1G >> in conf.d/90-quota.conf file, it works, I mean squirrelmail gets and >> shows information (

Re: [Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

2014-01-31 Thread Benny Pedersen
On 2014-01-31 14:54, mayu wrote: I have a same problem what Matt has faced but the soln u provided to Matt was not helpful for me . lost tree here on that, but dovecot quotadict is just for showing quotas in postfixadmin, its not for displaying squotas in squirrelmail check that dovecot q

Re: [Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

2014-01-31 Thread mayu
Hi , I have a same problem what Matt has faced but the soln u provided to Matt was not helpful for me . I am using Postfixadmin ,Dovecot ,Squirrel ,postfix and check_quota plugin for showing quota value . The mysql table is fetching the data stored in postfixadmin ,But squirrel in not fetching

Re: [Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

2013-09-09 Thread Matt
>> userdb { >>args = uid=vmail gid=vmail home=/var/mail/vmail/%d/%n >>driver = static >> } Hum, forgot to modify this file > Dynamic extra fields like "userdb_quota_rule" from SQL would not > work with a static userdb, since static db is only able to return > static extra fields. > > Y

Re: [Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

2013-09-08 Thread Daniel Parthey
Hi Matt Am 08.09.2013 17:32, schrieb Matt: I've installed the Quota Display Extension in my Thunderbird (thanks for the plugin) and the progress bar remains desperately empty but it works with my Gmail account. This is exactly what was expected. Dovecot userdb doesn't know about your user spec

Re: [Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

2013-09-08 Thread Matt
Hi Daniel, Thanks for your quick feedback. I've installed the Quota Display Extension in my Thunderbird (thanks for the plugin) and the progress bar remains desperately empty but it works with my Gmail account. Sorry, I forgot the send my docevot -n previously: # 2.0.9: /etc/dovecot/dovecot.conf

Re: [Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

2013-09-08 Thread Daniel Parthey
Hi Matt, I forgot to mention that if you're using userdb prefetch, then you might need to use userdb_quota_rule instead of quota_rule in your user_query. Please have a look at the docs: http://wiki2.dovecot.org/Quota/Configuration Regards Daniel

Re: [Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

2013-09-08 Thread Daniel Parthey
Hi Matt, sounds like the quota is correctly updated in MySQL, but your roundcube isn't able to fetch quota information via IMAP. Can you reproduce this via telnet or another IMAP client (e.g. Thunderbird with Quota Display Extension)? Can you be so kind and post your whole dovecot config (dove

[Dovecot] Postfixadmin/MySQL/Dovecot 2 and quota

2013-09-08 Thread Matt
Hi all, I'm setting up a new email server based on the softwares list below: * Postfix * Dovecot 2.0.9 * MySQL * Postfixadmin 2.3.6 My current problem is I'm unsure whether quota feature is well configured or not. In order to test and validate, I use Roundcubemail GUI which provides perc