[courier-users] Help with a login issue (migration from sendmail)

[Marcio Merlone]

Dears,

I need a help with a migration from sendmail to postfix issue. I'll use courier to provide pop and imap access to maildirs.

I currently have about 40.000 sendmail (passwd) mail accounts and using sendmail virtual domain style, where I map addresses to real accounts via virtusertable, like this:

[EMAIL PROTECTED] xpto123

where xpto123 is a passwd account. The point is that the whole of those 40K accounts use xpto123 to log to pop server. Now, I want them to use their address to login, but such change must be done smoothly so I won't overcharge my call-center.

My question is if there is a way to make users login using either their id (xpto123) OR address ([EMAIL PROTECTED]). I notice that the mysql query sent by courier is something like this:

SELECT id, crypt, "", uid, gid, home, maildir, quota, name FROM users WHERE id = "xpto123"

It should be something like this:

SELECT id, crypt, "", uid, gid, home, maildir, quota, name FROM users WHERE id = "xpto123" OR address='xpto123'

so, if this user change his account information on his MUA, it would send the query

SELECT id, crypt, "", uid, gid, home, maildir, quota, name FROM users WHERE id = "[EMAIL PROTECTED]" OR address='[EMAIL PROTECTED]'

and so login either way. Is there an easy way to do this or will I have to hack the c code to achieve this behavior? I've played around with MYSQL_SELECT_CLAUSE but did not work.

Thanks for any idea, comments, RTFM in advance.

Regards,

--
Marcio Merlone



-------------------------------------------------------
This sf.net email is sponsored by: Influence the future of Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) program now. http://ads.sourceforge.net/cgi-bin/redirect.pl?sunm0002en

_______________________________________________
courier-users mailing list
[EMAIL PROTECTED]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users