#1  
Old 6th June 2011, 17:59
syduck syduck is offline
Junior Member
 
Join Date: Jun 2011
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default Courier-auth username syntax

Hi,

I have a The Perfect Server - CentOS installed.
I am migrating users over, the thing is all the mail usernames on the old server are user+domain.com.

So to make it easyer for my users I am wondering if theres a way to allow mail authentication with the default 'user@domain.com' as well as 'user+domain.com'.

Ive been playing with the authmysqlrc and MYSQL_SELECT_CLAUSE but cant seem to get it right.

Any insight would be appreciated, Thanks!
Reply With Quote
Sponsored Links
  #2  
Old 6th June 2011, 21:17
syduck syduck is offline
Junior Member
 
Join Date: Jun 2011
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default Solved

Hey guys,

After fooling around with it for a couple of hours I've figured it out.

I edited /etc/authlib/authmysqlrc

added:

MYSQL_SELECT_CLAUSE SELECT email,password,"",uid,gid,homedir,maildir,quota,"" ,concat('disableimap=',disableimap,',disablepop3=' ,disablepop3) FROM mail_user WHERE email = '$(local_part)@$(domain)' or email2 = '$(local_part)'

Then added email2 column to the mail_user table in the dbispconfig database and filled the rows with the user+domain.com usernames.

tested with multiple accounts using both types of usernames in outlook.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you configure SquirrelMail with ISPConfig 3 adobe Installation/Configuration 8 9th January 2009 11:22
proFTPd passive mode problems bisbell Server Operation 8 6th August 2008 21:12
Frustrated with ISPConfig install! woozyerdaddee Installation/Configuration 4 19th May 2006 03:38
Installation Fails... :( cyberstorm Installation/Configuration 1 15th January 2006 18:07
Install stop at uuwish, UUDeview SeaWolf Installation/Configuration 6 4th October 2005 23:53


All times are GMT +2. The time now is 16:02.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.