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
>>[EMAIL PROTECTED] for the local part
>>[EMAIL PROTECTED] for the domain
>>
>>And the users must put [EMAIL PROTECTED] 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:
>>>[EMAIL PROTECTED]). From <"[EMAIL PROTECTED]"@w**.pl>
>>>(host=NULL [192.168.0.2]) for [EMAIL PROTECTED]
>>>2006-10-21 20:01:54 1GbLAB-00018P-NT <= "[EMAIL PROTECTED]"@w**.pl
>>>H=(xavras) [192.168.0.2] P=esmtpa A=auth_plain:[EMAIL PROTECTED]
>>>S=1199
>>>[EMAIL PROTECTED]
>>>
>>>--
>>>|_|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,
--
## List details at http://www.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://www.exim.org/eximwiki/
