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

2 Apr 2007 · *not*

      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 ..
ok, I'll try to give you more infos:

mail_debug=yes  does *not* show any info about the "quota update" process,
but shows the correct quota for the user given by the userdb_quota:

dovecot: Apr 02 13:01:11 Info: auth(default): client in: AUTH   1       PLAIN   service=IMAP    lip=10.0.0.101  rip=10.0.0.102  resp=<hidden>
dovecot: Apr 02 13:01:11 Info: auth-worker(default): sql(_test_@XXXXXXX.it,10.0.0.102): query: SELECT username as user, password, '/var/vmail/domains/XXXXXXX.it/_test_' as userdb_home, 'maildir:/var/vmail/domains/XXXXXXX.it/_test_' as userdb_mail, 10000 AS userdb_uid, 10000 AS userdb_gid, CONCAT('maildir:storage=', CEIL(quota/1000)) AS userdb_quota FROM mailbox WHERE username = '_test_@XXXXXXX.it'
dovecot: Apr 02 13:01:11 Info: auth(default): client out: OK    1       user=_test_@XXXXXXX.it
dovecot: Apr 02 13:01:11 Info: auth(default): master in: REQUEST        17      17470   1
dovecot: Apr 02 13:01:11 Info: auth-worker(default): sql(_test_@XXXXXXX.it,10.0.0.102): SELECT 10000 AS uid, 10000 AS gid, '/var/vmail/domains/XXXXXXX.it/_test_' as home, 'maildir:/var/vmail/domains/XXXXXXX.it/_test_' as mail, CONCAT('maildir:storage=', CEIL(quota/1000)) AS quota FROM mailbox WHERE username = '_test_@XXXXXXX.it' AND active = '1'
dovecot: Apr 02 13:01:11 Info: auth(default): master out: USER  17      _test_@XXXXXXX.it   uid=10000       gid=10000       home=/var/vmail/domains/XXXXXXX.it/_test_     mail=maildir:/var/vmail/domains/XXXXXXX.it/_test_   quota=maildir:storage=10240
dovecot: Apr 02 13:01:11 Info: IMAP(_test_@XXXXXXX.it): Loading modules from directory: /usr/lib/dovecot/modules/imap
dovecot: Apr 02 13:01:11 Info: IMAP(_test_@XXXXXXX.it): Module loaded: /usr/lib/dovecot/modules/imap/lib10_quota_plugin.so
dovecot: Apr 02 13:01:11 Info: IMAP(_test_@XXXXXXX.it): Module loaded: /usr/lib/dovecot/modules/imap/lib11_imap_quota_plugin.so
dovecot: Apr 02 13:01:11 Info: IMAP(_test_@XXXXXXX.it): Effective uid=10000, gid=10000, home=/var/vmail/domains/XXXXXXX.it/_test_
dovecot: Apr 02 13:01:11 Info: IMAP(_test_@XXXXXXX.it): maildir: data=/var/vmail/domains/XXXXXXX.it/_test_
dovecot: Apr 02 13:01:11 Info: IMAP(_test_@XXXXXXX.it): maildir: root=/var/vmail/domains/XXXXXXX.it/_test_, index=/var/vmail/domains/XXXXXXX.it/_test_, control=, inbox=
dovecot: Apr 02 13:01:11 Info: imap-login: Login: user=<_test_@XXXXXXX.it>, method=PLAIN, rip=10.0.0.102, lip=10.0.0.101
dovecot: Apr 02 13:01:11 Info: auth(default): client in: AUTH   1       PLAIN   service=IMAP    lip=10.0.0.101  rip=10.0.0.102  resp=<hidden>
dovecot: Apr 02 13:01:11 Info: auth-worker(default): sql(_test_@XXXXXXX.it,10.0.0.102): query: SELECT username as user, password, '/var/vmail/domains/XXXXXXX.it/_test_' as userdb_home, 'maildir:/var/vmail/domains/XXXXXXX.it/_test_' as userdb_mail, 10000 AS userdb_uid, 10000 AS userdb_gid, CONCAT('maildir:storage=', CEIL(quota/1000)) AS userdb_quota FROM mailbox WHERE username = '_test_@XXXXXXX.it'
dovecot: Apr 02 13:01:11 Info: auth(default): client out: OK    1       user=_test_@XXXXXXX.it
dovecot: Apr 02 13:01:11 Info: auth(default): master in: REQUEST        18      17512   1
dovecot: Apr 02 13:01:11 Info: auth-worker(default): sql(_test_@XXXXXXX.it,10.0.0.102): SELECT 10000 AS uid, 10000 AS gid, '/var/vmail/domains/XXXXXXX.it/_test_' as home, 'maildir:/var/vmail/domains/XXXXXXX.it/_test_' as mail, CONCAT('maildir:storage=', CEIL(quota/1000)) AS quota FROM mailbox WHERE username = '_test_@XXXXXXX.it' AND active = '1'
dovecot: Apr 02 13:01:11 Info: auth(default): master out: USER  18      _test_@XXXXXXX.it   uid=10000       gid=10000       home=/var/vmail/domains/XXXXXXX.it/_test_     mail=maildir:/var/vmail/domains/XXXXXXX.it/_test_   quota=maildir:storage=10240
dovecot: Apr 02 13:01:11 Info: imap-login: Login: user=<_test_@XXXXXXX.it>, method=PLAIN, rip=10.0.0.102, lip=10.0.0.101
dovecot: Apr 02 13:01:11 Info: IMAP(_test_@XXXXXXX.it): Disconnected
dovecot: Apr 02 13:01:11 Info: IMAP(_test_@XXXXXXX.it): Loading modules from directory: /usr/lib/dovecot/modules/imap
dovecot: Apr 02 13:01:11 Info: IMAP(_test_@XXXXXXX.it): Module loaded: /usr/lib/dovecot/modules/imap/lib10_quota_plugin.so
dovecot: Apr 02 13:01:11 Info: IMAP(_test_@XXXXXXX.it): Module loaded: /usr/lib/dovecot/modules/imap/lib11_imap_quota_plugin.so
dovecot: Apr 02 13:01:11 Info: IMAP(_test_@XXXXXXX.it): Effective uid=10000, gid=10000, home=/var/vmail/domains/XXXXXXX.it/_test_
dovecot: Apr 02 13:01:11 Info: IMAP(_test_@XXXXXXX.it): maildir: data=/var/vmail/domains/XXXXXXX.it/_test_
dovecot: Apr 02 13:01:11 Info: IMAP(_test_@XXXXXXX.it): maildir: root=/var/vmail/domains/XXXXXXX.it/_test_, index=/var/vmail/domains/XXXXXXX.it/_test_, control=, inbox=
dovecot: Apr 02 13:01:11 Info: IMAP(_test_@XXXXXXX.it): Disconnected: Logged out

my conf is in the attached output of dovecont -n

the user's info are stored in the "mailbox" table:
CREATE TABLE mailbox (
id bigint(20) unsigned NOT NULL auto_increment,
username varchar(255) character set latin1 NOT NULL default '',
password varchar(255) character set latin1 NOT NULL default '',
name varchar(255) character set latin1 NOT NULL default '',
maildir varchar(255) character set latin1 NOT NULL default '',
quota int(10) NOT NULL default '10240000',
domain varchar(255) character set latin1 NOT NULL default '',
created datetime NOT NULL default '0000-00-00 00:00:00',
modified datetime NOT NULL default '0000-00-00 00:00:00',
active tinyint(1) NOT NULL default '1',
bypass_virus_checks char(1) character set latin1 default 'N',
bypass_spam_checks char(1) character set latin1 default 'N',
PRIMARY KEY  (username),
UNIQUE KEY id (id)

ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Postfix Admin - Virtual Mailboxes' AUTO_INCREMENT=46 ;
INSERT INTO mailbox VALUES (3, '_test_@XXXXXXXXXX.it', '$1$89fgsfdg$1KVXXv8EBWMr8AVOVt7D0.', 'User Name', 'XXXXXXX.it/_test_/', 51200000, 'XXXXXXX.it', '2006-05-05 18:22:46', '2007-03-26 19:12:22', 1, 'N', 'N');

the table I'd like to use for quota's info storage is:
CREATE TABLE quota (
username varchar(255) NOT NULL default '',
path varchar(245) NOT NULL default '',
current bigint(20) default NULL,
PRIMARY KEY  (username,path)

ENGINE=MyISAM DEFAULT CHARSET=latin1;

I hope now I gave enough infos :-))
thanks in advance, and sorry for previous messagesif they was poor of info ... really ;-(
<?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'; ?>