Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Dovecot/Postfix with MySQL
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Networking & Security
View previous topic :: View next topic  
Author Message
xenobyte
n00b
n00b


Joined: 30 Nov 2011
Posts: 14

PostPosted: Fri Oct 12, 2012 1:17 pm    Post subject: Dovecot/Postfix with MySQL Reply with quote

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
View user's profile Send private message
cach0rr0
Moderator
Moderator


Joined: 13 Nov 2008
Posts: 4122
Location: Houston, Republic of Texas

PostPosted: Tue Oct 16, 2012 3:10 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Networking & Security All times are GMT
Page 1 of 1

 
Jump to:  
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