[Dovecot] [ rc28 ] dict{} seems to be ignored

[Emiliano Gabrielli (aka AlberT)]

On Monday 02 April 2007 14:58, Timo Sirainen wrote:
> On 2.4.2007, at 14.13, Emiliano Gabrielli (aka AlberT) wrote:
> > On Monday 02 April 2007 12:30, Timo Sirainen wrote:
> >> Sorry, but your reply is way too vague for me to even guess what the
> >> problem could be. Show me the exact settings you have. Show
> >> dovecot-sql.conf, your SQL tables and contents of one user's row.
> >> Maybe
> >> even set mail_debug=yes and show what the logs say. Then I can point
> >> exactly where the problem is without having to guess.
> >
> > uh?.. but I have attached also the output of dovecot -n ... some
> > msgs ago in the thread as you asked ..
>
> dovecot -n unfortunately doesn't show dovecot-sql.conf's contents.
> Maybe in Dovecot v2.0 it'll do that. :)
>

:-)  sorry 

> > CONCAT('maildir:storage=', CEIL(quota/1000)) AS userdb_quota FROM
> > mailbox WHERE username = '_test_ at XXXXXXX.it'
>
> There is the "maildir". It should say "dict" there instead if you
> want it to use dict. So change it from user_query.

dovecot: Apr 02 16:11:36 Error: IMAP(_test_ at XXXXXXX.it): dict quota: URI missing from parameters: dict:storage=10240

maybe I have totally misundestood how this plugin works ... ;-(


this is the lines in my dovecot.cof:
dict {
  quotadict = mysql:/etc/dovecot/dovecot-dict-quota.conf
}
plugin {
  quota = dict:storage=20480:messages=1000 proxy::quotadict
}


dovecot-dict-quota.conf  has only the mysql connection, table and field settings, no connection problem appears in the logs...


and here are the SQL queries in the dovecot-sql.conf:

user_query = SELECT 10000 AS uid, 10000 AS gid, '/var/vmail/domains/%d/%n' as home, 
             'maildir:/var/vmail/domains/%d/%n' as mail, 
             CONCAT('maildir:storage=', 
             CEIL(quota/1000)) AS quota 
             FROM mailbox WHERE username = '%u' AND active = '1'

password_query = SELECT username as user, password, 
                 '/var/vmail/domains/%d/%n' as userdb_home, 
                 'maildir:/var/vmail/domains/%d/%n' as userdb_mail, 
                 10000 AS userdb_uid, 10000 AS userdb_gid, 
                 CONCAT('maildir:storage=', CEIL(quota/1000)) AS userdb_quota 
                 FROM mailbox WHERE username = '%u'

These are 1 per line, I wrapped it only for readability ...

thank again


-- 
<?php echo '     Emiliano Gabrielli (aka AlberT)     ',"\n",
'                GrUSP founder  - ZCE                ',"\n",
' AlberT_at_SuperAlberT_it   -   www.SuperAlberT.it  ',"\n",
'  IRC:    #php,#AES azzurra.com ',"\n",'ICQ: 158591185'; ?>