I followed the guide FreeBSD-Postfix-MySQL-SpamAssassin-Maia-Virtual Setup (
http://www.purplehat.org/?page_id=4). And now i have some problems. Obviously it has something to do with Dovecot not connecting to MySQL. Anyone have any suggestions of the reason?
Here is a sample of the error from maillog.log:
Code:
Jul 11 00:11:03 mserver dovecot: auth(default): client in: AUTH 7 PLAIN service=pop3 lip=192.168.1.103 rip=192.168.1.1 lport=110 rport=21987 resp=
Jul 11 00:11:03 mserver dovecot: auth(default): client out: CONT 7
Jul 11 00:11:03 mserver dovecot: auth(default): client in: CONT 7 AHNlcnZlcmFkbWluQHN0ZWFsdGhjb25uZWN0LmNvbQA1UEZJNnkzbVpMMkMk
Jul 11 00:11:03 mserver dovecot: auth-worker(default): mysql: Connect failed to localhost (postfix): Access denied for user 'postfix'@'localhost' (using password: YES) - waiting for 75 seconds before retry
Jul 11 00:11:03 mserver dovecot: auth-worker(default): sql(user@domain.tld,192.168.1.1): query: SELECT password FROM mailbox WHERE username = 'user@domain.tld'
Jul 11 00:11:03 mserver dovecot: auth-worker(default): sql(user@domain.tld,192.168.1.1): Password query failed: Not connected to database
Jul 11 00:11:05 mserver dovecot: pop3-login: Disconnected (auth failed, 7 attempts): user=<user@domain.tld>, method=PLAIN, rip=192.168.1.1, lip=192.168.1.103
Jul 11 00:11:05 mserver dovecot: auth(default): client out: FAIL 7 user=user@domain.tld temp