Hello again :),
I try to use dictionary proxy server to replace my precedent configuration (direct use of dict in plugin quota).
Before, i have this configuration in my dovecot.conf :
## Dictionary server settings dict { }
## Plugin settings plugin { # quota = 10 Mo quota = dict:storage=10240 mysql:/etc/dovecot/dict-quota.conf }
And after, to use proxy, I have this configuration in my dovecot.conf :
## Dictionary server settings dict { quota = mysql:/etc/dovecot/dict-quota.conf }
## Plugin settings plugin { # quota = 10 Mo quota = dict:storage=10240 proxy::quota }
My dict-quota.conf doesn't change :
connect = host=localhost dbname=dovecot user=dovecot table = quota select_field = current where_field = path username_field = username
My dovecot.info file :
dovecot: 2006-07-23 15:07:01 Info: IMAP(test): Effective uid=1019, gid=1019 dovecot: 2006-07-23 15:07:01 Info: IMAP(test): Loading modules from directory: /usr/lib/dovecot/modules/imap dovecot: 2006-07-23 15:07:01 Info: IMAP(test): Module loaded: /usr/lib/dovecot/modules/imap/lib01_quota_plugin.so dovecot: 2006-07-23 15:07:01 Info: IMAP(test): Module loaded: /usr/lib/dovecot/modules/imap/lib02_imap_quota_plugin.so dovecot: 2006-07-23 15:07:01 Info: IMAP(test): maildir: data=/home/test/Mail dovecot: 2006-07-23 15:07:01 Info: IMAP(test): maildir: root=/home/test/Mail, index=/home/test/Mail, control=, inbox= dovecot: 2006-07-23 15:07:01 Info: IMAP(test): dict quota: uri = proxy::quota dovecot: 2006-07-23 15:07:01 Info: IMAP(test): dict quota: byte limit = 10485760 dovecot: 2006-07-23 15:07:01 Info: IMAP(test): dict quota: count limit = 0 dovecot: 2006-07-23 15:07:01 Info: imap-login: Login: user=<test>, method=plain, rip=82.228.176.60, lip=192.168.1.60
When i use the proxy configuration, i have this error :
dovecot: 2006-07-23 15:07:51 Error: dict: sql dict: commit failed: Not connected to database dovecot: 2006-07-23 15:07:51 Error: IMAP(test): dict_quota: Couldn't update quota dovecot: 2006-07-23 15:07:51 Error: dict: sql dict: commit failed: Not connected to database dovecot: 2006-07-23 15:07:51 Error: IMAP(test): dict_quota: Couldn't update quota dovecot: 2006-07-23 15:07:51 Error: dict: sql dict: commit failed: Not connected to database dovecot: 2006-07-23 15:07:51 Error: IMAP(test): dict_quota: Couldn't update quota dovecot: 2006-07-23 15:07:52 Error: dict: sql dict: commit failed: Not connected to database dovecot: 2006-07-23 15:07:52 Error: IMAP(test): dict_quota: Couldn't update quota
And in MySQL log :
060723 15:07:01 460 Connect Accès refusé pour l'utilisateur: 'dovecot'@'@localhost' (mot de passe: NON) 060723 15:07:45 461 Connect Accès refusé pour l'utilisateur: 'dovecot'@'@localhost' (mot de passe: NON)
It try to connect with 'dovecot'@'@localhost'... But it will be 'dovecot'@'localhost'. No ?
Thanks for your help,
Mikaël,