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 quotaok, 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 quotaupdated 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.
PGP.sig
Description: This is a digitally signed message part