RE: [Exim] Problems with recipient verification - Continued.…

Αρχική Σελίδα
Delete this message
Reply to this message
Συντάκτης: Stephen D. Malenshek
Ημερομηνία:  
Προς: exim-users
Αντικείμενο: RE: [Exim] Problems with recipient verification - Continued.....
Okay I made some changes and I believe I have this down to the problem
areas....

Every time I turn on the sender verification in the acl, I get the
following.

2003-08-18 03:16:22 SMTP connection from [208.189.209.18]:56568 (TCP/IP
connection count = 1)
2003-08-18 03:16:23 H=mta01.dmz.ftsm.vlnx.net [208.189.209.18]:56568
F=<stephen@???> rejected RCPT <stephen@???>
2003-08-18 03:16:23 SMTP protocol error in "DATA"
H=mta01.dmz.ftsm.vlnx.net [208.189.209.18]:56568 valid RCPT command must
precede DATA
2003-08-18 03:16:23 H=mta01.dmz.ftsm.vlnx.net [208.189.209.18]:56568
incomplete transaction (QUIT) from <stephen@???>
2003-08-18 03:16:23 SMTP connection from mta01.dmz.ftsm.vlnx.net
[208.189.209.18]:56568 closed by QUIT

If I comment out the sender verification and the localparts section
below, it delivers like there is no tomorrow..... Also if I do a
recipient verification, it also fails.

remote_forward:
        driver                          = manualroute
        transport                       = remote_smtp
        check_local_user
        local_parts = ${lookup pgsql {select username, domainname from
users where \
        username = '${quote_pgsql:$local_part}' \
        AND domainname = '${quote_pgsql:$domain}' \
        AND acctstatus = '1'}{$value}fail}
        domains                         = +domains_primary :
+domains_backup
        route_data                      = LOCAL_RELAY_HOST
        ignore_target_hosts = 127.0.0.0/8 : 192.168.0.0/16


I apologize that I can not figure this out, and that I keep posting
these annoying messages, but I have to get this working. Thanks.


-----Original Message-----
From: exim-users-admin@??? [mailto:exim-users-admin@exim.org] On
Behalf Of Stephen D. Malenshek
Sent: Monday, August 18, 2003 2:03 AM
To: exim-users@???
Subject: Re: [Exim] Problems with recipient verification -
Continued.....

I added the following for incoming recipient verification. It just
seems to me that something is missing. This is the complete router
section.

begin routers

# domain_literal:
# driver = ipliteral
# domains = ! +local_domains
# transport = remote_smtp

remote_delivery:
        driver = dnslookup
        transport = remote_smtp
        check_local_user
        local_parts = ${lookup pgsql {select username,domainname from
users where \
            username = '${quote_pgsql:$local_part}' \
            AND domainname = '${quote_pgsql:$domain}' \
            AND acctstatus = '1'}fail}
        domains                         = ! +domains_primary


remote_forward:
        driver                          = manualroute
        transport                       = remote_smtp
        domains                         = +domains_primary :
+domains_backup
        route_data                      = LOCAL_RELAY_HOST
        ignore_target_hosts             = 127.0.0.0/8 : 192.168.0.0/16


system_aliases:
        driver                          = redirect
        allow_fail
        allow_defer
        data = ${lookup pgsql {select alias from aliases where \
            alias = '${quote_pgsql:$local_part}' \
            AND domainname = '${quote_pgsql:$domain}'}fail}
        # user                          = exim
        file_transport                  = address_file
        pipe_transport                  = address_pipe


userforward:
        driver                          = redirect
        check_local_user
        file                            = $home/.forward
        no_verify
        no_expn
        check_ancestor
        # allow_filter
        file_transport                  = address_file
        pipe_transport                  = address_pipe
        reply_transport                 = address_reply


localuser:
        driver                          = manualroute
        transport                       = remote_smtp
        route_data                      = LOCAL_RELAY_HOST
        cannot_route_message            = Unknown user


Let me known your thoughts. Thanks.

-----Original Message-----
From: Stephen D. Malenshek
Sent: Monday, August 18, 2003 1:17 AM
To: 'ODHIAMBO G. Washington'
Cc: exim-users@???
Subject: RE: [Exim] Problems with recipient verification

The following is specified... I just did not include it, and I have
referenced those sections several times, evidently I am just too dense
to figure it out.


hide pgsql_servers = XXX.XXX.XXX.XX/XXXXXXXXX/XXXXXXXXX/XXXXXXXXXX

Let me know if you think of something else I might be missing... I
really need to get this fixed.

-----Original Message-----
From: exim-users-admin@??? [mailto:exim-users-admin@exim.org] On
Behalf Of ODHIAMBO G. Washington
Sent: Monday, August 18, 2003 1:05 AM
To: Stephen D. Malenshek
Cc: exim-users@???
Subject: Re: [Exim] Problems with recipient verification

* Stephen D. Malenshek <smalenshek@???> [20030818 06:55]:
wrote:
> I am using 4.21 and doing SQL lookup to a PostgreSQL database. I have
> the following in the configuration:
>

[...]

> I can not for the life of me figure out why it is not verifying if the
> user exists. You can send a message to an account that does not exist
> and it will deliver it anyway. I do not understand this..... Please
> let me know as soon as possible. I have an ISP and the mail spool is
> getting pretty ugle. :)




This is simple, unless I am lost since I haven't tested 4.21.

You _simply_ have not specified the SQL server connection parameters.

Look at spec.txt, sections 9.17 - 9.19 are your friends. Kindly read
_ALL_ those sections (andI mean it for a very good reason) before you
proceed!!


-Wash

--
Odhiambo Washington   <wash@???>  "The box said 'Requires
Wananchi Online Ltd.  www.wananchi.com      Windows 95, NT, or better,'
Tel: +254 2 313985-9  +254 2 313922         so I installed FreeBSD."
GSM: +254 72 743223   +254 733 744121       This sig is McQ!  :-)



"I may not be totally perfect, but parts of me are excellent."
        -- Ashleigh Brilliant


--

## List details at http://www.exim.org/mailman/listinfo/exim-users Exim
details at http://www.exim.org/ ##


--

## List details at http://www.exim.org/mailman/listinfo/exim-users Exim
details at http://www.exim.org/ ##