|
FreeBSD Ports and Packages Installation and upgrading of ports and packages on FreeBSD. |
|
Thread Tools | Display Modes |
|
|||
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 |
|
|||
Hi,
Probably 'postfix' user cannot login to the database, cause of a wrong password. Try to manually connect to the database from the command-line: Code:
mysql -u postfix -p Show you /usr/local/etc/dovecot.conf and /usr/local/etc/dovecont-sql.conf files. Regards, D
__________________
"I never think of the future. It comes soon enough." - A.E Useful links: FreeBSD Handbook | FreeBSD Developer's Handbook | The Porter's Handbook | PF User's Guide | unix-heaven.org |
|
|||
Quote:
But i found something about this problem at this page: http://wiki.dovecot.org/MysqlProblems Obviously i need to do this (i think): Quote:
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Postfix, Dovecot, spamassassin, mysql and maildrop | hamba | Guides | 3 | 20th May 2010 06:40 PM |
Maildir with Postfix/Dovecot/procmail/mutt | bsdperson | FreeBSD Ports and Packages | 3 | 8th July 2009 07:05 PM |
[DOVECOT] How to choose the ports? | Sunsawe | FreeBSD Ports and Packages | 2 | 7th July 2008 02:41 PM |
Problem with upgrading php5-pcre and php5-mysql | KernelPanic | FreeBSD Ports and Packages | 6 | 16th June 2008 10:00 PM |
postfix + dovecot LDA: bounce, user unknown | cbrace | FreeBSD General | 1 | 9th May 2008 05:19 PM |