well.. i havnt worked with exim and spam assisasin but i use courier as my imap/pop client and it autenticates to a mysql db… umm ill paste my config below.. im on debian tho, here goes:

the authdamonrc file contains a few other things but the important part is

authmodulelist="authmysql"

broken:/etc/courier# cat authmysqlrc 
MYSQL_SERVER broken.our-lan.com
MYSQL_USERNAME <removed for="" obvious="" reasons="">MYSQL_PASSWORD <removed from="" obvious="" reasons="">MYSQL_PORT 0 
MYSQL_DATABASE hosting
MYSQL_SELECT_CLAUSE  SELECT mailUsers.email, '' , users.password, "5000", "5000", "/home/hosting/", CONCAT( SUBSTRING_INDEX( users.email, '@' , -1 ) , '/mail/', SUBSTRING_INDEX( users.email, '@', 1 ) , '/' ) , '' , concat( users.fname,' ',users.lname ) , NULL, CONCAT("allowimap=",mailUsers.allowimap,",allowpop3=",mailUsers.allowpop3,",allowwebmail=",mailUsers.allowwebmail) FROM mailUsers, users WHERE mailUsers.email = users.email AND mailUsers.email = '$(local_part)@$(domain)'
DEFAULT_DOMAIN our-lan.com
broken:/etc/courier#</removed></removed> 

and the bottom thing is my sepcial query to do my stuff, but the default select and stuff one works just as well

my old one without that stuff might help better

broken:/etc/courier# egrep -v '^$|^#' authmysqlrc.bkp 
MYSQL_SERVER            manticore.kodium.net
MYSQL_USERNAME          <removed>MYSQL_PASSWORD          <removed>MYSQL_PORT              0
MYSQL_OPT               0
MYSQL_DATABASE          mail-service
MYSQL_USER_TABLE        users
MYSQL_CLEAR_PWFIELD     clear
MYSQL_UID_FIELD         5000
MYSQL_GID_FIELD         5000
MYSQL_LOGIN_FIELD       email
MYSQL_HOME_FIELD "/home/vmail"
MYSQL_MAILDIR_FIELD     concat(email,'/')</removed></removed> 

hope this helps somewhat, but yeah u have to make authdameonrc point to authmysqlrc so that it uses them ysql stuff.. not sure how u configure it for pam tho

cheers

NF

Cheers for taking the time for the reply, I was under the impression that I was supposed to make courier-imap with some sort of mysql condition because it just didn't seem to work, but I will try your way.

cheers.

so my understanding of how courier works is when u connect to the courier imap server, it passes ur username/pass onto the courier-auth system, which does its shitnitz and returns to the courier-imap what it can cant do etc.. ie let u in, give u access to blah etc, so u shouldnt need to compile courier-imap differently, maybe the courier-authdameon so that it uses different methods but yeah, umm have a look at this

http://workaround.org/articles/ispmail-sarge

okay, cool bro, it sounds good that i don't have to re-install courier-imap :) thanks for the link, i'm going to have a look at it.

do you (or anyone out there) know where a log file is or something so that i can see tried and failed attempts for courier, i'd like to be able to see the password entered and the one expected if you know what i mean. so ican test it through a telnet connection or something.

thanks for all your help.

on debian stuff goes to /var/log/daemon.log or /var/log/auth.log cause its a failed auth request

cheers

NF

arrggghh, still not working, i can send email and it gets to the right place, but retrieving it is still giving me grief.

i tried paring down my authmysqlrc file to bare minimums, does it look alright to everyone out there?:

MYSQL_SERVER            localhost
MYSQL_USERNAME          <private>
MYSQL_PASSWORD          <private>
MYSQL_SOCKET           /var/lib/mysql/mysql.sock
MYSQL_PORT              0
MYSQL_OPT               0
MYSQL_DATABASE          exim
MYSQL_USER_TABLE        boxauth
MYSQL_CLEAR_PWFIELD     boxpwd
MYSQL_UID_FIELD         27
MYSQL_GID_FIELD         27
MYSQL_LOGIN_FIELD       boxname
MYSQL_HOME_FIELD "/var/spool/virtual_mail"
MYSQL_MAILDIR_FIELD     concat(boxname,'/')</private></private>

pretty sure there are no extra spaces anywhere and shit. also made sure it is using the correct authmodulelist="authmysql"

i just keep getting 'unable to connect to server' whenever i try from an email program like outlook. I can telnet in on port 143 though, but haven't worked out how to check the mailboxes through this yet.

also, i believe i should have imap disabled in /etc/xinetd.d/, i first tried this by altering the file, but now i have renamed it altogether. so that port is freed from xinetd so that courier0imp can use it - is this correct anybody?

thanks in advance for any input.

one other thing, the failed attempts do not seem to be cropping up in the

/var/log/maillog

/var/log/messages

logs, any redhat users out there know where else to look for this sort of thing?

cheers.

fixed thanks, we had a firewall setting which disallowed connecting on port 143 :oops: