On 3.4.2007, at 14.20, Emiliano Gabrielli (aka AlberT) wrote:

On Monday 02 April 2007 16:37, Timo Sirainen wrote:
So here should be:

CONCAT('dict:storage=2', ceil(quota/1000), ' proxy::quotadict') AS quota

ok, this is working some way (without the "2" in the storage= ... right?) ..

Right.

but I have still some things not clear... only some users have their quota
updated on the DB ...

Well, I don't know about this. Do they never get it? Setting mail_debug=yes should show in logs for those users if Dovecot sees all the quota settings.

in the wiki the quota table suggested structure uses 2 varchar (255) fields, with a PK on ... but the maximum allowed lenght for an index il only 500 ..
at least on my version of mysql ....

I suggest to correct in 255 for the user and 245 for the path :-)

Changed path to 100. It's never more than 14 characters currently.

Attachment: PGP.sig
Description: This is a digitally signed message part

Reply via email to