mikael a écrit :
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 ?
I find my error : My mysql user ('dovecot') has a pasword :D So i have modified my "dict-quota.conf" file like this (add the password value) :
connect = host=localhost dbname=dovecot user=dovecot password=<MYPASSWORD> table = quota select_field = current where_field = path username_field = username
And I have modified the password field in mysql.user table (MySQL version 5) to use old style password (dovecot use old style ? dovecot can't connect without the use of old style) :
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('<MYPASSWORD>')WHERE User='dovecot'; mysql> FLUSH PRIVILEGES;
And it works... In fact, i have only connexion... I can't really use quota :'(
Now, I have another problem : i use the proxy conf with dict, and i have two mail accounts (system) "user1" and "user2". When i use thunderbird to read user1 mailbox, the first query to det quota is with the username "user1". It's OK :
492 Query SELECT current FROM quota WHERE path = 'quota/storage' AND username = 'user1' 492 Query BEGIN;INSERT INTO quota (current, path, username) VALUES ('quota/storage', 0, 'user1') ON DUPLICATE KEY UPDATE current = current + 0;COMMIT
I don't understant the second query "BEGIN;...;COMMIT". what is the role of this query ? But the "INSERT" is it OK ? I think it will be "INSERT INTO quota (path, current, username)" and not "INSERT INTO quota (current, path, username)", because path is a varchar(255) ('quota/storage') and current is an integer (0). No ?
My real problem isn't here... When i would like to read the user2 mailbox, the query to get the user2 quota is the same that the query for user1 !? For my user2, the query is :
492 Query SELECT current FROM quota WHERE path = 'quota/storage' AND username = 'user1' 492 Query BEGIN;INSERT INTO quota (current, path, username) VALUES ('quota/storage', 0, 'user1') ON DUPLICATE KEY UPDATE current = current + 0;COMMIT
When i restart Thunderbird and read first the user2 mailbox, the query is :
492 Query SELECT current FROM quota WHERE path = 'quota/storage' AND username = 'user2' 492 Query BEGIN;INSERT INTO quota (current, path, username) VALUES ('quota/storage', 0, 'user2') ON DUPLICATE KEY UPDATE current = current + 0;COMMIT
And this query is for user2 and user1 !..
How the dovecot quota mechanism works with dict ???
Thanks,
Mikaël,