[AccessD] OT SMTP Local Server

Hi Borge

Sounds like port 25 could be blocked for outbound traffic by the ISP. You could check that at the ISP support.
Further, I would address the log file to FMS support, and also ask how to disable the automatic forward of the mail to their support account - that _must_ be possible!

You could also try to adjust your Outlook to use localhost (or 127.0.0.1) as smtp server - that's your local smtp server.

Finally, let me once again recommend the excellent tiny e-mail client Popcorn:

  http://www.tucows.com/preview/333653

It's free and offers a nice logging feature which lets you debug both in- and outbound communication. A must for your toolbox when debugging e-mail at clients! It even works with Gmail.

/gustav

>>> pcs at azizaz.com 08-06-2006 06:49 >>>
Dear List:

Background: An AccessXP database that along with FMS's Total 
Access Emailer creates HTML emails and broadcasts them using 
an SMTP email server running on Windows XP Service Pack 1.

I chose to use the third party software Total Access Emailer 
(TAE), as it easily enables me to create 'merge mail' 
between fields in a table and an HTML Email Master Document 
and sending out highly personalized HTML emails.

At home - when accessing internet through my ISP - I have no 
problem using the same SMTP on the ISP that I use for my 
Outlook Express accounts to also broadcast HTML emails from 
the access application.

But currently I am not 'at home' - I am in Shanghai, China 
hooking into the internet via broadband installed in my 
stepson's apartment using a WAN Miniport (PPPOE), a PPP 
Server Type, TCP/IP transport, PAP authentication, with No 
compression and PPP multilink framing set to Off (if that 
makes any sense to anyone)

Some findings:
>From my current setup here in Shanghai I can send out emails 
from my Outlook Express account using my ISP SMTP Server, 
provided I use authentication (same username and password as 
for the POP3 incoming mail server)
BUT - when I use the same settings on the Access 
application, I get 'Invalid SMTP Server Settings' error 
message when attempting to send an email...

So I think to myself, perhaps it's the SMTP on my ISP - and 
I try the free SMTP of Google's Gmail - I setup the Gmail 
SMTP settings for outgoing emails on my Outlook Express 
account:
SMTP server: smtp.gmail.com. 
Port: 465. 
Require SSL/STARTTLS: Yes. 
Require SMTP authentication: Yes. 
User name: your Gmail email address. 
Password: your Gmail password. 

No problems sending out email from Outlook Express

I use the settings on the Access Application, and instead of 
giving an invalid smtp server settings error message, the 
application just hangs using all of the cpu .....

At this point, I get on the FMS discussion list and here I 
find that:
TAE only supports an "open" SMTP Server that allows 
relaying - authentication as such is not supported - the 
Username and Password field on TAE available for setting up 
the parameters for the SMTP server to use is not for that 
kind of authentication but for something else (whatever that 
is!)

BUT, here is the suggested line of action from FMS: Create 
your OWN local SMTP server....

I do that following the instructions... and YES! the access 
application now behaves just like when at home .... 
broadcasting the emails nicely, easy and quickly..... I am 
happy as can be... having spent all of a good rainy Shanghai 
day on this problem....

BUT   :(
when I check my inbox to see the actual proof sitting there, 
there is nothing!!

HERE IS THE PROBLEM:
The emails ends up in the QUEUE Folder of 
C:\Inetpub\mailroot and there they apparantly sit forever....
Each email has the following type of files there:
NTFS_7e9d2b4001c68a9e0000000c.EML.STM   (type HTML document)
NTFS_7e9d2b4001c68a9e0000000c.EML   (type: Internet E-Mail 
Message)
NTFS_7e9d2b4001c68a9e0000000c.EML.STL (type: Certificate 
Trust List)

Now, the first two are created immediately, and the  third 
after a little while.
Periodically the Certificate Trust List file gets it Date 
Modified Datestamp updated

[[Also from having a look at the SMTP Logfile, I learn that 
when using TAE for every email broadcast the code adds an 
email to taemailersample at fmsinc.com (with from address being 
the same). Although this is - according to the support peope 
of FMS - only for testing the relay capability the data 
contained in the STM part gives cause for concern....]]

Question:
What do I need to do in order to get the local SMTP server 
to work properly? I have followed instructions for how to 
install a local SMTP server closely.
Particularly, on the Default SMTP Server Properties, General 
tab page for the IP Address I have three options:
(All Unassigned)
10.0.0.8  (the local computer, yes?)
218.82.191.35 (the dynamically assigned IP address by the 
broadband provider - it changes from session to session)

When using 10.0.0.8 or (All Unassigned) it works, in the 
sense that the emails end up the QUEUE folder :(
When using the dynamic IP address, I get an error or the 
application just hangs...

Would the problem have anything to do with missing 
Certificate Authority??

Or that I am not using the NTFS file structure on the 
harddrive?? (well, ....)

Or? 

Any and all responses appreciated, thanks!

regards
borge