Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
HELP - can't login to mysql from courier-imap
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
Moriah
Advocate
Advocate


Joined: 27 Mar 2004
Posts: 2351
Location: Kentucky

PostPosted: Tue Sep 03, 2013 11:45 pm    Post subject: HELP - can't login to mysql from courier-imap Reply with quote

I am trying to set up a mail server using the directions found at:

http://wiki.gentoo.org/wiki/User:SwifT/Wikified_but_not_merged_documents/Virtual_mail_HOWTO

I am having problems logging in to mysql from courier-imap. The syslog at /var/log/messages reads:
Code:

Sep  3 19:39:23 hophni imapd: Connection, ip=[127.0.0.1]
Sep  3 19:39:23 hophni authdaemond: failed to connect to mysql server (server=localhost, userid=mailsql): Access denied for user 'mailsql'@'localhost' (using password: YES)
Sep  3 19:39:23 hophni imapd: LOGIN FAILED, user=root@elilabs.com, ip=[127.0.0.1]
Sep  3 19:39:28 hophni imapd: LOGOUT, ip=[127.0.0.1], rcvd=55, sent=332


My password does contain some weird characters, including the # character, so I tried to find all the places it occurs in the config files and surrounded it with double quotes ("), but it still fails.

Did I miss something, or is this caused by something else?
_________________
The MyWord KJV Bible tool is at http://www.elilabs.com/~myword

Foghorn Leghorn is a Warner Bros. cartoon character.


Last edited by Moriah on Thu Oct 03, 2013 2:29 am; edited 2 times in total
Back to top
View user's profile Send private message
nativemad
Developer
Developer


Joined: 30 Aug 2004
Posts: 918
Location: Switzerland

PostPosted: Wed Sep 04, 2013 5:28 pm    Post subject: Reply with quote

Hi,

have you done the mysql-grant part (from the wiki) with a flush privileges afterwards?
Are you able to login from the console with `mysql -u mailsql mailsql`?
Maybe you should try it with a simpler password to get sure it's just that....

HTH, cheers
_________________
Power to the people!
Back to top
View user's profile Send private message
Moriah
Advocate
Advocate


Joined: 27 Mar 2004
Posts: 2351
Location: Kentucky

PostPosted: Mon Sep 16, 2013 8:11 pm    Post subject: Reply with quote

Yes, I can log in from the command line with mysql -u mailsql mailsql, which is why I suspect my password is borking the parser for the imap config files...

PS Sorry about the late response, but other things have taken priority over this. :(
_________________
The MyWord KJV Bible tool is at http://www.elilabs.com/~myword

Foghorn Leghorn is a Warner Bros. cartoon character.
Back to top
View user's profile Send private message
nativemad
Developer
Developer


Joined: 30 Aug 2004
Posts: 918
Location: Switzerland

PostPosted: Tue Sep 17, 2013 4:54 am    Post subject: Reply with quote

Yeah, live is sometimes a b!#!#, as well as courier-imap when it comes to passwords! I once searched for hours and it was just a whitespace behind the password in the configfile!
I'd recommend dovecot over courier any time...
_________________
Power to the people!
Back to top
View user's profile Send private message
Moriah
Advocate
Advocate


Joined: 27 Mar 2004
Posts: 2351
Location: Kentucky

PostPosted: Thu Oct 03, 2013 2:15 am    Post subject: Reply with quote

Finally got time to get back to this problem today. I changed the password and it still doesn't work. :evil:
_________________
The MyWord KJV Bible tool is at http://www.elilabs.com/~myword

Foghorn Leghorn is a Warner Bros. cartoon character.
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