View Single Post
  #12  
Old 30th July 2009, 12:00
Mark_NL Mark_NL is offline
Senior Member
 
Join Date: Sep 2008
Location: The Netherlands
Posts: 912
Thanks: 12
Thanked 99 Times in 95 Posts
Default

Ah we're getting closer!

Your /etc/courier/authmysqlrc is not correct ..

You've ADDED the lines specified in the how-to .. instead of replaced them (lazy ass! ;-))

they (for example) read:
MYSQL_DATABASE mail

then about 40-50 lines lower there's another line that looks pretty familiar ;-)
MYSQL_DATABASE mysql

so i'd say it overrides the previous, thus checking the wrong db .. that also counts for passwd crypt field etc ..

so do what the how-to tells you (and you probably didn't do 1on1 :P):

1. cp /etc/courier/authmysqlrc /etc/courier/authmysqlrc_orig
2. cat /dev/null > /etc/courier/authmysqlrc

Then open /etc/courier/authmysqlrc and put the following lines into it:
Code:
MYSQL_SERVER localhost
MYSQL_USERNAME webm2slt
MYSQL_PASSWORD webmaster2slt
MYSQL_PORT 0
MYSQL_DATABASE mail
MYSQL_USER_TABLE users
MYSQL_CRYPT_PWFIELD password
#MYSQL_CLEAR_PWFIELD password
MYSQL_UID_FIELD 5000
MYSQL_GID_FIELD 5000
MYSQL_LOGIN_FIELD email
MYSQL_HOME_FIELD "/home/vmail"
MYSQL_MAILDIR_FIELD CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
#MYSQL_NAME_FIELD
MYSQL_QUOTA_FIELD quota
and for the hell of it, restart all related services:
Code:
/etc/init.d/courier-authdaemon restart
/etc/init.d/courier-imap restart
/etc/init.d/courier-imap-ssl restart
/etc/init.d/courier-pop restart
/etc/init.d/courier-pop-ssl restart
the cool thing about the how-to's on this site, is that when you follow them EXACTLY .. in every letter, it'll always work.
If you skip / slack on one part .. you're asking for problems (UNLESS you really know what you're doing ;-))
Reply With Quote