Hello,

I have a new installation.

Everything seemed to be working fine until last night when I removed pop and imap protocols from dovecot.conf. Doing this seems to have broken RoundCube mail so I re-added them back to dovecot.conf.

However, now it seems that dovecot cannot connect to the MySQL database:

from dovecot.log:

Apr 06 20:36:52 dovecot: Warning: Killed with signal 15 (by pid=23523 uid=0 code=kill)
Apr 06 20:36:52 dovecot: Info: Dovecot v1.2.9 starting up (core dumps disabled)
Apr 06 20:37:14 dict: Error: mysql: Connect failed to localhost (iredadmin): Access denied for user 'iredadmin'@'localhost' (using password: YES) - waiting for 1 seconds before retry
Apr 06 20:37:14 dict: Error: dict sql lookup failed: Not connected to database
Apr 06 20:37:45 dict: Error: mysql: Connect failed to localhost (iredadmin): Access denied for user 'iredadmin'@'localhost' (using password: YES) - waiting for 75 seconds before retry
Apr 06 20:37:45 dict: Error: dict sql lookup failed: Not connected to database
Apr 06 20:37:45 dict: Error: dict sql lookup failed: Not connected to database

The odd thing is I never changed iredadmin's MySQL password. The crypt form of the password is in dovecot-used-quota.conf:

#
# File generated by iRedMail (2011.04.06.00.50.45):
#
# Version:  0.7.0
# Project:  http://www.iredmail.org/
#
# Community: http://www.iredmail.org/forum/
#

connect = host=localhost dbname=iredadmin user=iredadmin password=<crypted-pass>
map {
    pattern = priv/quota/storage
    table = used_quota
    username_field = username
    value_field = bytes
}
map {
    pattern = priv/quota/messages
    table = used_quota
    username_field = username
    value_field = messages
}

Using the iredadmin MySQL password I can manually log in to MySQL and use the iredadmin database:

root@machine:/etc/dovecot# mysql -uiredadmin -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9623
Server version: 5.1.41-3ubuntu12.10 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use iredadmin;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql>

How can I change the password for dovecot so it can connect?

How did it become changed after functioning for 24 hrs normally?

Thanks,
Phil