> Thanks, works great.. I've attached a copy of my config and a few mysql
> create commands. I got that magic click while working with exim. You know
> the one where everything makes sense.
>
> so check_local_user is basically like a preset /etc/passwd (and shadow)
> checker?
>
> All I need to get this thing cooking now is MySQL authentication. Any
> pointers. I didn't see anything in the config file about custom
> authentication like that.
>
We use the following for Microsoft Outlook Express clients.
######################################################################
# ACL CONFIGURATION #
# Specifies access control lists for incoming SMTP mail #
######################################################################
<Most of section snipped.>
# Accept if the message arrived over an authenticated connection, from
# any host. Again, these messages are usually from MUAs, so recipient
# verification is omitted.
accept authenticated = *
######################################################################
# AUTHENTICATION CONFIGURATION #
######################################################################
begin authenticators
fixed_login:
driver = plaintext
public_name = LOGIN
server_prompts = "Username:: : Password::"
server_condition = \
${lookup mysql{select if(count(*), "1", "0") \
from ciusers where email = '${quote_mysql:$1}' and \
password = '${quote_mysql:$2}'}}
server_set_id = $1
Hope this helps.
Regards
Clive Goodhead
Cornwall Internet Limited
--------------------------------------------------------------------------
Cornwall Internet Limited
Registered office: Montaza, Fore Street, Goldsithney, Penzance, Cornwall.
Registered in England, registered number 3387326.
--------------------------------------------------------------------------
