courier-imap

Hello all,

Im just trying to set up my courier-imap with mysql authentication. Everything is working when I use 'authpam'. I can send and receive emails with help of postfix. My only problem is user authentication for imap using mysql database so users can access they email.
 select * from passwd;
+---------+-------+----------+--------------+------+------+------+---------+-----------------+-------+---------+
| id        | crypt | clear    | name         | uid  | gid  | home | maildir | defaultdelivery | quota | options |
+---------+-------+----------+--------------+------+------+------+---------+-----------------+-------+---------+
| user1 |       | password | user one | 1000 | 1000 | /home/user1     |         |                 |       |         |
+---------+-------+----------+--------------+------+------+------+---------+-----------------+-------+---------+

 settings in  /etc/courier/authmysqlrc

MYSQL_SERVER            localhost
MYSQL_USERNAME          admin
MYSQL_PASSWORD          password
MYSQL_DATABASE          courier_auth  
I'm sure that this four lines are correct and connection to database is working - 100% sure
MYSQL_USER_TABLE        passwd
#MYSQL_CRYPT_PWFIELD    crypt
MYSQL_CLEAR_PWFIELD     clear    
MYSQL_UID_FIELD         uid
MYSQL_GID_FIELD         gid
MYSQL_MAILDIR_FIELD     $HOME/Maildir

The log file :
Jun 30 16:21:50 service2 imaplogin: LOGIN FAILED, ip=[::ffff:127.0.0.1]

it does not tell much where is a problem however the connection to database is correct because I wil get different error!! So the problem is probably somewhere on id and clear field. I did try login by thinderbird as well as manually using telnet.

Anyone can see what I'm missing here?

thanks
LVL 10
LuxanaAsked:
Who is Participating?
 
DarthModCommented:
PAQed with points refunded (500)

DarthMod
Community Support Moderator
0
 
NopiusCommented:
fix your authmysqlrc, like:
MYSQL_LOGIN_FIELD       id
0
 
LuxanaAuthor Commented:
Hello Nopius,

Sorry for delay, my MYSQL_LOGIN_FIELD   is set to  'id' I just forgot to mention it in my question. Still did not find out what is the problem.

it seems that the problme is somewhere in authdaemon.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
LuxanaAuthor Commented:
I did start debugung with courier and I'm getting this error:

imapd: authdaemon: TEMPFAIL - no more modules will be tried

0
 
NopiusCommented:
Sorry, I have no more ideas
0
 
LuxanaAuthor Commented:
my either.. I did reasearch on the internet and it seems that there are more peaople which stuck with the same problem. Probably the way where to go is to find out how to debug authdaemon :-)
0
 
NopiusCommented:
btw my favorite configuration is sendmail+cyrus-imap, not postfix+courier :-)
0
 
LuxanaAuthor Commented:
hi,

It was a pain but I get it working. The problem is that config files are really sensitive to inappropriate use of TABS and SPACES:-))

 
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.