A while back, I got a Gmail account and enjoyed having it. I was, however, disappointed in the SSL requirement that kept it from being usable with my GoldMine. Gmail, like a number of other e-mail providers, has elected to REQUIRE SSL for their POP3 server.

To correct this and enable me to use these account(s) with GoldMine, I downloaded a free tool called Stunnel from this page

I found I also needed a couple of supporting files.
I downloaded all three items to a local folder I called c:\stunnel\ and created a text file in the folder. This file need to be named stunnel.conf. I put the following text into this file:

client=yes
[pop3]
accept=9995
connect=pop.gmail.com:995
[smtp]
accept=225
connect=smtp.gmail.com:25

…and then I ran Stunnel.exe.

Lastly, I added my Gmail address to GoldMine like I would any other e-mail address other than the fact that both the SMTP and POP3 servers are 127.0.0.1 and I had to go into the advanced area and modify the ports used by both pop3 and smtp to match what I defined in my stunnel.conf file (pop3=9995 and smtp=225 *note the additional digits!).

Finally, I had to go the Gmail account on the Gmail web page and go to my settings area and enable pop3 access. I found that enabling it for ‘all messages than come in from now on’ was the best option.
That was it. Now, as long as I run stunnel on my machine, I can use my Gmail accounts within GoldMine just like any other e-mail accounts!

NOTE: An informative thread in the GoldMine support forums that offers more recent information on this topic can be found here.

  1. Hi —

    Finally got around to addressing my own question about getting around SSL with Comcast by using sTunnel. Needed a thorough reading of this SSL/sTunnel thread as I, no surprise, complicated things, and got my GM copy, still v.6.70.70226, working for in/b & o/b email.

    The last key for me was getting the POP3 & SMTP GM server entries entered, ie.: 127.0.0.1.

    My end result conf.exe entry is:

    [comcast-pop3]
    client = yes
    accept = 127.0.0.1:995
    connect = mail.comcast.net:995

    [cocmast-smtp]
    client = yes
    accept = 127.0.0.1:465
    connect = smtp.comcast.net:465

    Works like a charm!

    John

    Thanks again for the steering and signposts you sent my way!

  2. Hi —

    Comcast in my area, Chicago, got around to forcing SSL in my area and with much trial and error during last couple weeks, I narrowed down that my GoldMine 6.70.70226 just does not like that. ONCE I narrowed down that issue I found this forum thread.

    Because there is a lot of traffic in this thread that I have glanced through I am wondering if there is a canned ‘guideline’ to correctly setting up and using stunnel with GoldMine buried within the forum or elsewhere that someone has created as a step-x-step fill-in-the-blanks process to an average user like myself without any corporate IT support?

    If you can point me in the right direction.

    Thanks.

    Let me know.

    John

  3. Tried stunnel on an old GM 6.6 dBase customer but cannot get it to work. Here’s the conf file settings:

    client=yes
    [pop3]
    accept = 9995
    connect = secure.emailsrvr.com:995

    [smtp]
    accept=465
    connect=secure.emailsrvr.com:465

    BTW – also tried with [pop3s] and [ssmtp] but still no luck. POP port in GM is set at 9995 and SMTP at 465.

    Log file reads:

    2012.02.28 11:26:22 LOG5[5800:2660]: stunnel 4.52 on x86-pc-mingw32-gnu platform
    2012.02.28 11:26:22 LOG5[5800:2660]: Compiled/running with OpenSSL 0.9.8s-fips 4 Jan 2012
    2012.02.28 11:26:22 LOG5[5800:2660]: Threading:WIN32 SSL:ENGINE,FIPS Auth:none Sockets:SELECT,IPv6
    2012.02.28 11:26:22 LOG5[5800:2660]: Reading configuration from file stunnel.conf
    2012.02.28 11:26:23 LOG5[5800:2660]: FIPS mode is enabled
    2012.02.28 11:26:23 LOG5[5800:2660]: Configuration successful
    2012.02.28 11:26:35 LOG5[5800:2660]: Reading configuration from file stunnel.conf
    2012.02.28 11:26:35 LOG5[5800:2660]: FIPS mode is enabled
    2012.02.28 11:26:35 LOG5[5800:2660]: Configuration successful

    So it appears everything should be working but GM still just hangs for a while and then says Timed out waiting for a response.

    Tried disabling A/V and Windows Firewall with no luck. Only thing that hasn’t been tried is to look at the router. Based on what you see above, does everything look ok so it’s probably a router thing?

  4. I found the information in this thread very helpful and had everything working untill recently. I can still retrive email from the server, but when I try to send an email I get an error saying “The Socket was Disconnected Unexpectedly.” The error occurs across all usernames but only on computers that have the most recent windows update installed on them.

    I have the most recent version of Stunnel installed. Is there any fix I can use short of running system restore and never installing that update again?

  5. I have installaed Stunnel :
    2010.07.03 20:05:28 LOG5[484:2388]: Reading configuration from file stunnel.conf
    2010.07.03 20:05:29 LOG5[484:2388]: Configuration successful
    2010.07.03 20:05:29 LOG5[484:2388]: No limit detected for the number of clients
    2010.07.03 20:05:29 LOG5[484:2388]: stunnel 4.33 on x86-pc-mingw32-gnu with OpenSSL 1.0.0 29 Mar 2010
    2010.07.03 20:05:29 LOG5[484:2388]: Threading:WIN32 SSL:ENGINE Sockets:SELECT,IPv6
    2010.07.03 20:05:38 LOG5[484:2388]: Reading configuration from file stunnel.conf
    2010.07.03 20:05:38 LOG5[484:2388]: Configuration successful

    The stunnel.conf :

    client=yes
    [pop3]
    accept=9995
    connect=pop.gmail.com:995
    [smtp]
    accept=225
    connect=smtp.gmail.com:25

    The installation directory was :
    Y:\GoldminePrg\Stunnel\

    Servidor POP
    127.0.0.1
    Servidor SMTP
    127.0.0.1

    Authentication PASO

    Puerto de Servidor POP3 : 9995
    Puerto de Servidor SMTP : 225

    Without mark in that screen the option :

    The server require authentification

    And I received the message :

    the socket was disconnected unexpectedly

    Notes :

    Above I see that some people use :

    465 instead of 225

    and in the google pop gmail configuration put 465 or 589 to the smtp value.

    What I am doing bad ?
    Best Regards

  6. Using GM 6.7 (single client; no server)

    Understood that Stunnel would enable GM to access GMail, via IMAP. Is this now possible?

  7. Check the RETURN ADDRESS for all of your e-mail accounts in GoldMine. And watch the FROM when sending, be sure to set it to the desired address (regardless of which is the current default)

  8. Weird problem. Took me forever to figure out what was going on with my email. When I use a Gmail account as my Default email, if I select a different account to email from, GM sends out the email but will say it is from my Default Gmail address. However, if I use an email address other than Gmail as my default, then I can send from other email accounts and it will show as being sent from the selected email address. Example: 123@gmail.com as the default. Send an email from 789@mysite.com and it will always say it came from 123@gmail.ocm. If I make 789@mysite.com the default, then I can send from other addresses such as 5678@othersite.com and it will show as from 5678@othersite.com. I run 6.70.70226 on a mini home network. GM is on a PC running XP Pro and I access it from 2 other PCs. I’ve used stunnel for years with no problems until recently. Stunnel is set the same on the computers:
    client=yes
    [pop3]
    accept=9995
    connect=pop.gmail.com:995
    [smtp]
    accept=465
    connect=smtp.gmail.com:465
    I’ve run full maintenance. Any ideas you have to help with this would be greatly appreciated.

  9. Weird problem. Took me forever to figure out what was going on with my email. When I use a Gmail account as my Default email, if I select a different account to email from, GM sends out the email but will say it is from my Default Gmail address. However, if I use an email address other than Gmail as my default, then I can send from other email accounts and it will show as being sent from the selected email address.

    Example: 123@gmail.com as the default. Send an email from 789@mysite.com and it will always say it came from 123@gmail.ocm. If I make 789@mysite.com the default, then I can send from other addresses such as 5678@othersite.com and it will show as from 5678@othersite.com. I run 6.70.70226 on a mini home network. GM is on a PC running XP Pro and I access it from 2 other PCs. I’ve used stunnel for years with no problems until recently.

    Stunnel is set the same on the computers:
    client=yes
    [pop3]
    accept=9995
    connect=pop.gmail.com:995
    [smtp]
    accept=465
    connect=smtp.gmail.com:465

    I’ve run full maintenance. Any ideas you have to help with this would be greatly appreciated.

  10. typically your pop3 server and smtp server in GoldMine will be 127.0.0.1 (or whatever machine is running stunnel for you.)

    the tunneling of that to gmail’s servers is taken care of in your stunnel config file.

  11. Hi Doug
    I cannot connect to my incomming email.
    I am using goldmine 5.7 & Gmail & Stunnel 4.21
    MCaffe anti virus and firewall

    Thanks
    Effie

    MY POP3 settings are
    pop.gmail.com
    Apop
    advance settings
    POP3 server port 9995

    Stunnel LOG
    2009.07.22 22:54:21 LOG5[5916:6356]: stunnel 4.21 on x86-pc-mingw32-gnu with OpenSSL 0.9.8g 19 Oct 2007
    2009.07.22 22:54:21 LOG5[5916:6356]: Threading:WIN32 SSL:ENGINE Sockets:SELECT,IPv6
    2009.07.22 22:54:21 LOG5[5916:4780]: No limit detected for the number of clients
    2009.07.22 22:55:27 LOG5[5916:1176]: smtp accepted connection from 127.0.0.1:57220
    2009.07.22 22:55:27 LOG5[5916:1176]: smtp connected remote server from 192.168.1.3:57221
    2009.07.22 22:55:31 LOG5[5916:1176]: Connection closed: 1076 bytes sent to SSL, 413 bytes sent to socket
    2009.07.22 23:06:40 LOG5[5916:4796]: smtp accepted connection from 127.0.0.1:57321
    2009.07.22 23:06:40 LOG5[5916:4796]: smtp connected remote server from 192.168.1.3:57322
    2009.07.22 23:06:43 LOG5[5916:4796]: Connection closed: 1095 bytes sent to SSL, 413 bytes sent to socket
    2009.07.22 23:22:30 LOG5[5916:3812]: smtp accepted connection from 127.0.0.1:57476
    2009.07.22 23:22:30 LOG5[5916:3812]: smtp connected remote server from 192.168.1.3:57477
    2009.07.22 23:22:35 LOG5[5916:3812]: Connection closed: 1105 bytes sent to SSL, 407 bytes sent to socket

  12. Sounds like maybe you have the service installed AND have it sitting in the windows startup folder. Remove the one from the startup folder. Note that even if you don’t fix this, it ought to work fine. 😉

  13. GoldMineRealEstate

    After installing Stunnel I get this msg when I boot up my laptop:

    Stunnel 4.2 on Win 32 (Stunnel)
    X Start Service: error 1056: an instance of the service is already running

Leave a Reply