emailing from 4D Server?

Bill Weale (4/10/14 12:02PM)
David Adams (4/11/14 10:05AM)
Phil Persinger (4/11/14 2:18PM)
Bill Weale (4/24/14 7:50AM)

Bill Weale (4/10/14 12:02 PM)

Is this a good idea?

How does one manage the possibility of modal dialogs, particularly if
they involve network issues, on the server machine if errors are
encountered during the execution of the IC email functions? Are there
any differences in this area between versions (PC) 11, 12 and 13?

I ask because one site of mine is going to start mandating SSL email
only and only from fixed IP addresses. And most clients run DHCP.

Thanks,

Bill

William W. Weale, III

Business Owners Support, LLC.

Operations Analysis
MIS Advising
Decision Support Systems

David Adams (4/11/14 10:05 AM)

<CAPXPcQu9_xyCJWW_s-Qrm=zOEvUyWfTxKpR1BrgVuAjc6DL+fQ@mail.gmail.com>

color><param>00000,0000,DDEE/param>OOn Fri, Apr 11, 2014 at 9:47 AM,
Joshua Fletcher <JFletcher@... wrote:
/color>
color><param>00000,0000,DDEE/param>--Possibility for errors on the
server = bad
-Possibility for dialogs on the server = bad
-Possibility for server instability = increased
-Store procedures are single threaded = less efficient
/color>
color><param>00000,0000,DDEE/param>GGood idea? Depends on your
situation. Is it convenient? ?Certainly.
/color>
I'm currently (and timidly) trying out sending mail from a Mac server
with
*very* low volumes of mail. If you follow up on suggestions from Kirk
and
Josh and build a mail queue, it won't be hard to switch to a background
process on a client machine. The idea being that you store pending
messages
in records, have a process (or processes) send them out and record the
results. It's a pretty natural way to handle emails out of a database,
gives you a place to store error results, and lets you decide if you
want
to keep sent mails or delete them.

Tip: I'm storing the 'send from' address and credentials in a table
called
[Online_Account] that I can also use for FTP, etc. log-ons. I got
tired of
making special-purpose tables for different sorts of services. I
encrypt
any stored passwords that are needed. Apple has been moving towards a
consolidated accounts interface and I've found it convenient as a user.

color><param>00000,0000,DDEE/param>CConsider a "slave" 4D Remote
session with static IP address (or DHCP
reservation). ?This way the data access to the email table is
pre-emptive
/color>aand
color><param>00000,0000,DDEE/param>tthe email processing won't affect
the server.
/color>
In a related question: SendGrid? Any experience or opinions? I've been
struggling a bit with GMail's SMTP servers and gotten inconsistent
results.
Now that my test account has two-factor enabled with Gmail, forget it.
I'm
suspecting that some of my problems come from M4DICEs (Mysterious 4DIC
Errors.) I'm hoping for something reliable and low-hassle.

Phil Persinger (4/11/14 2:18 PM)

I have been running a 4D Client email spooler for 8-9 years.
The spooler periodically timestamps a record.
If(Current time-Saved time > constant duration) when user tries to
send mail (s)he gets a Restart 4D Spooler prompt.

It's stupid but efficient.

Phil Persinger

Bill Weale (4/24/14 7:50 AM)

I wasn't and I'm not sure...

8-)

Bill

On Apr 23, 2014, at 4:30 PM, Dave Nasralla wrote:

color><param>00000,0000,DDEE/param>HHi Bill,

I know this is an old thread, but why would you get modal windows on
the
Server? I send email from our server all the time and simply trap the
errors and report them or record them.

dave

On Fri, Apr 11, 2014 at 10:50 AM, Bill Weale
<bill.weale@...
/color><color><param>8826F,0000,8219/param>....
I have to admit I just don't have the knowledge/confidence I'd like to
have that virtually all possible comm errors can be gracefully managed
when
emailing from the server machine. I'm hoping at the very least I can
get
one client machine on fixed addressing for this.
...
/color><color><param>00000,0000,DDEE/param>
/color>

Reply to this message

Summary created 4/24/14 at 8:11AM by Intellex Corporation

Comments welcome at: feedback@intellexcorp.com