Re: [Exim] SQL-based SMTP AUTH.

Top Page
Delete this message
Reply to this message
Author: Eric Renfro
Date:  
To: exim-users
Subject: Re: [Exim] SQL-based SMTP AUTH.
On Wednesday 23 October 2002 01:46 pm, Eric Renfro wrote:
> Correction:
>
> The first CRAM-MD5 AUTH works for the first user that attempts it. After
> that, the same user, or any other user can't AUTH and succeed, with
> CRAM-MD5. Waiting ~10 minutes and trying again, and it begins working,
> once.
>
> Seems like a cache problem?


I did a debug on this problem, and it's showing here:

Process 17668 is handling incoming connection from [192.168.1.10]
LOG: smtp_connection MAIN
  SMTP connection from myrddincd.com [192.168.1.10] (TCP/IP connection count =
1)
Process 17668 is ready for new message
search_open: pgsql "NULL"
search_find: file="NULL"
  key="SELECT passwd FROM users WHERE userid = 'erenfro'" partial=-1
LRU list:
internal_search_find: file="NULL"
  type=pgsql key="SELECT passwd FROM users WHERE userid = 'erenfro'"
database lookup required for SELECT passwd FROM users WHERE userid = 'erenfro'
PGSQL query: SELECT passwd FROM users WHERE userid = 'erenfro'
PGSQL new connection: host=localhost port= database=dbmail user=%delimited%
lookup yielded: %%correct passwd%%%
CRAM-MD5: user name = erenfro
          challenge = <17668.1035403747@???>
          received  = 14aea5a3f869e7aff15853be27f26bca
          digest    = 14aea5a3f869e7aff15853be27f26bca


That's the first successfull lookup.

Process 17696 is handling incoming connection from [192.168.1.10]
LOG: smtp_connection MAIN
  SMTP connection from myrddincd.com [192.168.1.10] (TCP/IP connection count =
1)
Process 17696 is ready for new message
search_open: pgsql "NULL"
search_find: file="NULL"
  key="SELECT passwd FROM users WHERE userid = 'erenfro'" partial=-1
LRU list:
internal_search_find: file="NULL"
  type=pgsql key="SELECT passwd FROM users WHERE userid = 'erenfro'"
database lookup required for SELECT passwd FROM users WHERE userid = 'erenfro'
PGSQL query: SELECT passwd FROM users WHERE userid = 'erenfro'
PGSQL new connection: host=localhost port= database=dbmail user=%delimited%
lookup yielded: %%%correct passwd%%%
CRAM-MD5: user name = erenfro
          challenge = <17696.1035403810@???>
          received  = 5cb4301be6c19a10bc555491921cf89e
          digest    = 6ba2869e37c4d041dafb41c538de1407
LOG: MAIN REJECT
  Authentication failed for myrddincd.com (ginseng.myrddincd.com)
[192.168.1.10] (psi-jack): 535 Incorrect authentication data (set_id=erenfro)
LOG: smtp_connection MAIN
  SMTP connection from myrddincd.com (ginseng.myrddincd.com) [192.168.1.10]
closed by QUIT
search_tidyup called
close PGSQL connection: localhost/dbmail/proxyuser


This is just after making the previous succession, and just about any number
of times afterwards, until ~10 minutes from the prior success.

Pay attention to the received, and the digest being completely different.

--
Eric Renfro
Myrddin Computers & Designs - CEO/President
Sales: sales@???
Fax: (775) 243-4535