View Single Post
  #1   (View Single Post)  
Old 11th July 2009
DrKrall DrKrall is offline
New User
 
Join Date: May 2008
Location: LuleƄ - Sweden
Posts: 9
Default MySQL / Dovecot connection problem

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
Reply With Quote