[exim] MySQL Auth with SHA1 passwords?

Top Page
Delete this message
Reply to this message
Author: Fabien Wang
Date:  
To: exim-users
Subject: [exim] MySQL Auth with SHA1 passwords?
Hello,

Currently using Exim version 4.80.1 #2,

I'm using mysql authentification, it works great with plaintext passwords.

I would like to use it with SHA1 encoded passwords, is it possible? If
yes, how?

Here is my current config on the authenticators part:

#plain:
# driver = plaintext
# public_name = PLAIN
# server_prompts = :
# server_condition = "${if and { \
#                      {!eq{$2}{}} \
#                      {!eq{$3}{}} \
#                      {eq{$3}{${lookup mysql{SELECT password FROM 
mailboxes WHERE ( domain = \
#                '${domain:$2}' \
#                AND username = '${local_part:$2}')}{$value}fail}} }} 
{yes}{no}}"
# server_set_id = $2
#
#login:
#  driver = plaintext
#  public_name = LOGIN
#  server_prompts = "Username:: : Password::"
#  server_condition = "${if and { \
#                      {!eq{$1}{}} \
#                      {!eq{$2}{}} \
#                      {eq{$2}{${lookup mysql{SELECT password FROM 
mailboxes WHERE  (domain =\
#                      '${domain:$1}' \
#                AND username = '${local_part:$1}')}{$value}fail}} }} 
{yes}{no}}"
#  server_set_id = $1