Re: [exim] exim multi domains smtp problem

Stuart Gall wrote:

> On 22 Oct 2006, at 22:42, Stuart Gall wrote:
>
>
>>On 21 Oct 2006, at 23:11, Sysop wrote:
>>
>>
>>>I have problem with sending emails from exim smtp. All user acounts
>>>and
>>>password i have in mysql.
>>>I authenticated users by his email adres because i have several
>>>domains
>
>
> HANG ON A MINUTE.
>
>
>
>>>and the exim adding my primary_hostname to end of login/adres
>>>
>>>where i doing wrong ?
>>>
>>>exim.conf
>>>[...]
>>>auth_plain:
>>>driver = plaintext
>>>public_name = PLAIN
>
>
>
>>>server_condition = ${if crypteq{$3}
>>>{{md5}${lookup mysql{SELECT password FROM users
>>>WHERE login = '${quote_mysql:${local_part:$2}}'
>>>AND enabled = '1'}{$value}{*}}}{yes}{no}}
>>>
>
>
> Where are you specifing the domain ?
>
>
>>>server_prompts = :
>>>server_set_id = $2
>>>[...]
>>
>>I use
>>${lookup{${extract{1}{@}{$2} for the local part
>>${extract{2}{@}{$2}} for the domain
>>
>>And the users must put name@domain as their login
>>
>>
>>
>>>logs:
>>>
>>>2006-10-21 20:01:54 1GbLAB-00018P-NT SA: Action: scanned but
>>>message isn't
>>>spam: score=-2.0 required=5.0 (scanned in 15/15 secs | Message-Id:
>>>20061021195751.00005089@xavras). From <"maciek@f*****l.pl"@w**.pl>
>>>(host=NULL [192.168.0.2]) for admin@t**2.pl
>>>2006-10-21 20:01:54 1GbLAB-00018P-NT <= "maciek@f*****l.pl"@w**.pl
>>>H=(xavras) [192.168.0.2] P=esmtpa A=auth_plain:maciek@f*****l.pl
>>>S=1199
>>>id=20061021195751.00005089@xavras
>>>
>>>--
>>>|_|0|_| Maciej Friedel

And I have been trying to be quiet.......

- When using a DB, one *may* have UID:PWD that have nothing to do with a domain
and do not look like email addresses.

CAVEAT:

- That does not make it a good idea!!!

- One should *almost-certainly* include the $domain at least as part of the
SELECT's WHERE clause, and preferably as part of the ID, EVEN IF the UID part
is NOT the email address.

OTHERWISE the UID needs to be unique across all domains you host, which is not
fun when two customers both want 'sales@<mycompany.tld>'

HTH,