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/ ##
