Sending email through gmail SSL

In reviewing the mail_open() function which creates the email object, I am not seeing the option to a) use SSL and b) set the port. Both are required to send email via gmail (without creating an SPF record and adding the sending ip to the Google Apps whitelist).

Are there options I'm not seeing?

thanks,

Hank

When using linux as a server you can install ssmtp:

http://www.cyberciti.biz/tips/linux-...smarthost.html

Alternatively configure sendmail with TLS support that will relay through google.

http://www.linuxha.com/other/sendmail/gmail.html

Thanks: this one looks easiest. :)

Hi Guys

Also having problems with sending mail. This is not SSL - it is a simple mail forwarding service that we have been using for ages (AuthSMTP.com) & they are really good (no silly limits).

m_open = mailopen(lSMTPServer,lSMTPUser,lSMTPPass,"SMTP")
m_mailOK = mailsend(fromname, tonames, ccnames, subject, msg, attachments)

When we can call mailsend() but we get the following error :

MAILERROR = '513 5.0.0 Your email system must authenticate before sending mail: XM_ERR:81.149'

As with many providers, there is a second set of credentials required to authenticate the service - is there a place we can put those ?

Thanks

SpringBox

Where would you normally specify different credentials. This is SMTP which should only require username and password.

Does it require the password to be encrypted in some way? E.g MD5

Hi Barry

We agree - will send you the details by pm. Wonder if you can shed any light on it.

Could it be ports? Valid non ssl ports for this SMTP forwarder are 23, 26, 2525, 25

Thanks

SpringBox

You are not the first to have this problem apparently.

The issue appears to be related to running x32 applications on x64.

There is a discussion and solution to it here on stack overflow.
http://stackoverflow.com/questions/2...ndows-7-64-bit

There is a hotfix from Microsoft for this.
http://support.microsoft.com/kb/980681

Please backup or try this in a VM first.

Thanks Barry

Will try this later today

SpringBox

Can you also look in the registry and see if this key has something defined to handle MAPI.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows Messaging Subsystem

This is *normally* setup when you have outlook installed which is used as the MAPI provider to send mail.

You should something like this using regedit.

Attachment 599

Ignore everything i said about MAPI. I now realize you are just using SMTP which is OS independent. My apologies, MAPI is another thing altogether in our code and should not have any affect on this.

You may need to check your firewall and make sure port 25 is open for sending.

Also, please let me see the code that you are using to send the email.

You need to make sure you issue:

mailOpen()
mailSend()
mailclose()

You need to make sure that you have indeed enabled SMTP on your email ISP.

If this is google there have been recent changes made which reject emails that are not from trusted domains. These are setup in the SPF records for your email domain.

Details about SPF can be found here.
http://en.wikipedia.org/wiki/Sender_Policy_Framework

It would appear that mailOpen() is not succeeding so when you execute mailsend() it fails saying that you are not logged in.

The easiest way to check that you can indeed login to the email system is by using telnet.

These links will help you troubleshoot it.

http://technet.microsoft.com/en-us/l...exchg.65).aspx

and

http://www.port25.com/how-to-check-a...net-session-2/

Hi Barry

The problem NON SSL mailsend() code as follows :


m_open = mailopen(lSMTPServer,lSMTPUser,lSMTPPass,"SMTP")

if not m_open
dialog box mailerror()
return
endif

// send the mail
fromname = "forwarding@xxx.co.uk"
tonames = "sales@xxx.co.uk"
ccnames = ""
subject = "For your information"
msg = "This is a test email"
attachments = ""
m_mailOK = mailsend(fromname, tonames, ccnames, subject, msg, attachments)

wait window 'Mail send status - ' + IIF(m_mailOK = .T., 'Success', 'Failed') timeout 3

if not m_mailOK
messagebox(mailerror())
endif


We cant see any reason why this should not work. Firewalls etc are all open for SMTP send. SMTP is enabled on ISP. Works fine from VFP.

What are we missing? mailopen() returns .T. but mailsend() fails. Will send you the live passwords etc by pm so you can try.

Thanks in advance

SpringBox

I have fixed this in the next build. Give it a whirl.

mailOpen() now takes an (optional) last parameter which is the port to use (default is 25).

Note that the username and password for SMTP needs to be base64 so use the base64_encode() function.

To test SMTP connectivity you can use telnet.

On Windows 7 the telnet client is disabled by default.

To enable it follow the steps detailed here.
http://social.technet.microsoft.com/...et-client.aspx

Details of SMTP commands can be found here.
http://technet.microsoft.com/en-us/m...workssmtp.aspx