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 = '[EMAIL PROTECTED]'
>
> 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([EMAIL PROTECTED]): 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'; ?>
