[Dovecot] Dovecot + MySQL no auth
I haven't been able to login to my mail server using MySQL authentication and I believe I've found the issue. My POP log says: dovecot: Jun 07 09:58:56 Error: auth(default): sql(dylan@domain.com,127.0.0.1): Password query must return a field named "password" dovecot: Jun 07 09:58:56 Info: pop3-login: Disconnected [127.0.0.1]
The password field in MySQL is called "passwd". Am I to understand that there is no way around this? I must rename the field to "password"?
My config files all check out. I'm pretty sure I'm at a road block here. Any help would be greatly appreciated. Also, aren't there anough Dovecot users to warrant a forum and/or IRC channel? I cant seem to find either (but thank you for the mailing list!).
Thanks all for any help! Dylan
On Fri, 2005-06-24 at 14:04 -0700, Dylan Baxter wrote:
The password field in MySQL is called "passwd". Am I to understand that there is no way around this? I must rename the field to "password"?
Just use SELECT passwd AS password, .... WHERE ... as your SQL statement.
johannes
SWEET! Thank you Johannes!
Also, thank you Allen for the IRC channel, and you're right. Forums do suck. I just didn't expect such a quick reply on this mailing list! ;)
Again, thanks!
Dylan
IRC channel: irc.freenode.net #dovecot
Forum: forums are stupid ;-)
On 6/24/05, Dylan Baxter <dylan_baxter@hotmail.com> wrote:
I haven't been able to login to my mail server using MySQL authentication and I believe I've found the issue. My POP log says: dovecot: Jun 07 09:58:56 Error: auth(default): sql(dylan@domain.com,127.0.0.1): Password query must return a field named "password" dovecot: Jun 07 09:58:56 Info: pop3-login: Disconnected [127.0.0.1]
The password field in MySQL is called "passwd". Am I to understand that there is no way around this? I must rename the field to "password"?
My config files all check out. I'm pretty sure I'm at a road block here. Any help would be greatly appreciated. Also, aren't there anough Dovecot users to warrant a forum and/or IRC channel? I cant seem to find either (but thank you for the mailing list!).
Thanks all for any help! Dylan
--
To avoid being added to my spam filter:
- Utilize list replies unless otherwise requested.
- If you DO send me a personal email, use english.
- HTML isn't cute. It belongs on the web, not in my inbox.
On 25.6.2005, at 00:47, Allen Parker wrote:
IRC channel: irc.freenode.net #dovecot
Just thought I'd say something about this:
I've been idling there also but I mostly ignore all "helpdesk-questions" (ie. pretty much everything I see there). It's just too easy to waste a lot of time answering them in IRC, and quite often people will figure out the solution themselves if they aren't given the answer immediately. Or answering questions which have a simple answer isn't too bad, but trying to answer something that requires a lot of explanations is.
Of course, other people are welcome to waste as much time there answering questions as they want, but so far it's been pretty quiet in there :)
One thing where IRC is pretty useful is when trying to debug some problem that I can't reproduce myself. For example some long debugging threads in this list might have been solved faster using IRC, assuming the people involved had time to debug it at the same time.
And if you're trying to modify Dovecot's sources I'm happy to help you with that in the IRC channel too :)
participants (4)
-
Allen Parker
-
Dylan Baxter
-
Johannes Berg
-
Timo Sirainen