Dotaz: Dovecot mysql

[HrabalVojta]

3.2.0-4-686-pae #1 SMP Debian 3.2.51-1 i686 GNU/Linux

mail.err

dovecot: auth-worker(7626): Error: mysql(localhost): Connect failed to database (postfix): Access denied for user 'postfix'@'localhost' (using password: YES) - waiting for 25 seconds before retry

/etc/dovecot/dovecot-mysql.conf.ext

driver = mysql
connect = host=localhost dbname=postfix user=postfix password=yyyyyyyyyyyyyyyy
default_pass_scheme = MD5-CRYPT
user_query = SELECT '/home/vmail/%d/%n' as home, 3000 AS uid, 3000 AS gid FROM mailbox WHERE username = '%u'
password_query = SELECT password FROM mailbox WHERE username = '%u'

virutal_maps

hosts = 127.0.0.1
user = postfix
password = yyyyyyyyyyyyyyyy
dbname = postfix
query = SELECT domain FROM domain WHERE domain='%s' and backupmx = 1

hosts = 127.0.0.1
user = postfix
password = yyyyyyyyyyyyyyyy
dbname = postfix
query = SELECT goto FROM alias WHERE address='%s' AND active = 1

hosts = 127.0.0.1
user = postfix
password = yyyyyyyyyyyyyyyy
dbname = postfix
query = SELECT domain FROM domain WHERE domain='%s' and backupmx = 0 and active = 1

hosts = 127.0.0.1
user = postfix
password = yyyyyyyyyyyyyyyy
dbname = postfix
query = SELECT maildir FROM mailbox WHERE username='%s' AND active = 1

---

---

Odpovědi

[NN]

 Connect failed to database (postfix): Access denied for user 'postfix'@'localhost

[HrabalVojta]

Vše je a bylo nastaveno správně, ale vygenerované heslo obsahovalo znak #.

Musím říct, že to byla pořádná detektivka