View previous topic :: View next topic |
Author |
Message |
xenobyte n00b
Joined: 30 Nov 2011 Posts: 14
|
Posted: Fri Oct 12, 2012 1:17 pm Post subject: Dovecot/Postfix with MySQL |
|
|
Hi there, I'm running a Postfix/Dovecot combination with mysql after this guide here: http://en.gentoo-wiki.com/wiki/Mail_server_using_Postfix_and_Dovecot
Installation went fine so far, but I'm not able to login. First of all Dovecot was complaining about this
Code: |
2012-10-12T13:30:40.330320+02:00 t3227 dovecot: auth-worker(27440): Error: sql(xenobyte@domain.com,88.888.888.88): Password query failed: Table 'mailsql.users' doesn't exist (using built-in default password_query: SELECT username, domain, password FROM users WHERE username = '%n' AND domain = '%d')
|
(Please note, that I changed my real domain and ip-adress)
so... the table "users" doesn't exist, so I set "password_query" in /etc/dovecot/dovecot-sql.conf.ext to "SELECT password FROM mailbox WHERE username = '%n'
If I try to login with imap, there is this in /var/log/maillog
Code: |
2012-10-12T14:00:41.202515+02:00 t3227 dovecot: imap-login: Aborted login (no auth attempts in 0 secs): user=<>, rip=31.187.111.45, lip=18.254.5.76, session=<S8DSb9vLKgBQu28t>
|
(Please note. that user=<> is empty)
this works a bit better with pop3
Code: |
2012-10-12T14:52:17.328170+02:00 t3227 dovecot: pop3-login: Disconnected (auth failed, 1 attempts in 4 secs): user=<xenobyte@domain.com>, method=PLAIN, rip=81.44.11.21, lip=18.254.5.76, TLS: Disconnected, session=<hPsiKNzLgwBQu28V>
| but I still can't login
Is anyone able to help? _________________ Ich neige zur Redundanz und manchmal wiederhole ich mich auch |
|
Back to top |
|
|
cach0rr0 Bodhisattva
Joined: 13 Nov 2008 Posts: 4123 Location: Houston, Republic of Texas
|
Posted: Tue Oct 16, 2012 3:10 am Post subject: |
|
|
among the things i dont see on that wiki page, is any mention of the need to emerge postfix with USE="dovecot-sasl"
beyond that i dont have too much to suggest, as I'm not hugely keen on how that guide recommends setting things up - especially for those who *dont* need "virtual" users, dont need postfixadmin, etc. It also tells you absolutely nothing of the setup of dovecot itself, only the few pieces (supposedly) required to make postfix talk to dovecot. _________________ Lost configuring your system?
dump lspci -n here | see Pappy's guide | Link Stash |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|