dovecot - May 2010 - quota and postfix virtual users

hi everyone i have a mailserver working with postfix 2.5.1 vda and
virtual user with mysql and dovecot, everything is working fine but i want
to offer quota and i have a problem with that because the quota in
roundcube appear but calculate is wrong i need to delete the maildirsize
file to force to recalculate, what can i do??? in my dovecot i have imap{
quota imap_quota, in plugins section i have quota=maildir and trough the
file dovecot-sql.conf i have the select expression concat(...... as
quota_rule, thanks a lot, 

PD. sorry for my english im from south of
colombia - south america

Il 22/05/2010 04:28, gbotero at emailforall.no-ip.org ha
scritto:
>
>
> hi everyone i have a mailserver working with postfix 2.5.1 vda and
> virtual user with mysql and dovecot, everything is working fine but i want
> to offer quota and i have a problem with that because the quota in
> roundcube appear but calculate is wrong i need to delete the maildirsize
> file to force to recalculate, what can i do??? in my dovecot i have imap{
> quota imap_quota, in plugins section i have quota=maildir and trough the
> file dovecot-sql.conf i have the select expression concat(...... as
> quota_rule, thanks a lot,
>
> PD. sorry for my english im from south of
> colombia - south america
the query should be like this if u have quota counted in bytes:
CONCAT('*:bytes=',imap_quota) AS quota_rule


-- 
Simone Caruso
IT Consultant

hi guys, anyone have a virtual server working with postfix + dovecot +
roundcube + mysql + virtual domain + virtual users and quota working
because the quota is not good, the calculation is wrong i need to delete
the maildirsize file to force recalculate, how can i do? the email send and
receive fine the virtual users and domain users is fine....... help


postfix 2.3.3
dovecot 1.2.11
roundcube 0.3
mysql 5.0.7 

i need to solve
this please

Il 30/05/2010 14:12, gbotero at emailforall.no-ip.org ha
scritto:
>
>
> hi guys, anyone have a virtual server working with postfix + dovecot +
> roundcube + mysql + virtual domain + virtual users and quota working
> because the quota is not good, the calculation is wrong i need to delete
> the maildirsize file to force recalculate, how can i do? the email send and
> receive fine the virtual users and domain users is fine....... help
>
>
> postfix 2.3.3
> dovecot 1.2.11
> roundcube 0.3
> mysql 5.0.7
>
> i need to solve
> this please
>
>
i have a script that parses a recordset from mysql and exec this command for
each mailbox:
echo "x GETQUOTAROOT Inbox" | su vmail -c "USER=$ROW
/usr/sbin/dovecot --exec-mail imap "



-- 
Simone Caruso
IT Consultant
p.iva: 03045250838

hi, Simone Caruso, thanks for your answer but i have some questions i
test the script in the console and he works he read the quota pased by
mysql and then quota_rule ok but he update the maildirsize file??? and this
script have to be called from postfix or dovecot?? thanks for all, sorry
for my english ;) 

Guillermo Botero
Leticia, Amazonas -
Colombia
gbospina at gmail.com

Il 31/05/2010 03:07, gbotero at emailforall.no-ip.org ha
scritto:
>
>
> hi, Simone Caruso, thanks for your answer but i have some questions i
> test the script in the console and he works he read the quota pased by
> mysql and then quota_rule ok but he update the maildirsize file??? and this
> script have to be called from postfix or dovecot?? thanks for all, sorry
> for my english ;)
>
the command i gave you force quota calculation, i use it after spam-training
within a cron job.

-- 
Simone Caruso
IT Consultant
+39 349 65 90 805
p.iva: 03045250838