SMTP SSL?

[andrewbadera]

Is it possible to set Fortress to use SSL to connect to the specified SMTP server? We're using GMail, which of course needs both a specific port AND SSL in order to send mail from remote clients.

[jeremy_sg]

Yes, but you have to manually tweak the setting in the sgmaster database with the following SQL.

UPDATE [sgmaster].dbo.sgmastersettings SET smtpusessl=N'True'

[andrewbadera]

yeah, I'd done that ... and now I've tried both 465 and 587 ... and I'm still not getting any email.

I don't seem to see any errors in any logs ... but they're scattered all over the place, maybe I'm not looking in the right one?

[jeremy_sg]

If there are any errors, they would be logged in theVault server log file.

I'll try to set this up myself to see if I can get it working.

[andrewbadera]

definitely been all over that log, no sign of errors.

[jeremy_sg]

I got this working on my dev box. The settings in sgmastersettings are:

smtpserver = smtp.gmail.com
smtpserverport = 25
smtpusessl = True
smtpauthenticationtype = 1
smtpusername = myaccount@gmail.com
smtppassword = plaintextpassword
smtpfromaddress = myaccount@gmail.com

My tests only worked when I made sure to remove any periods in my gmail username.

[andrewbadera]

using port 25, really? interesting, will give it a try later tonight, thanks for looking.

[andrewbadera]

Weird. It does in fact work with port 25. Thinking about it, I think I've run into that with other non-standard GMail clients, like mobile stuff, and headless processes. Apparently the other ports are only recommendations, not requirements. Hopefully they don't choose to change that anytime soon. I wonder why it won't connect on the GMail-specified ports however.

Thanks for looking into this.

[jeremy_sg]

I'm glad it worked for you.