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_@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_@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'; ?>