Castell Computers

April 7, 2005

Using Gmail with GoldMine

by @ 1:01 pm. Filed under CRM, GoldMine, Technology

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.


**If you liked this article, you might also like:**


113 Comments to “Using Gmail with GoldMine”

  1. Doug Castell Says:

    FYI, I’ve been advised by others that port 465 is more correct for SSL on the SMTP side.. I’ve adjusted my own stunnel.conf accordingly and it does work better:

    my stunnel.conf
    —————————–
    client=yes

    [pop3]
    accept=9995
    connect=pop.gmail.com:995

    [smtp]
    accept=465
    connect=smtp.gmail.com:465
    —————————–

  2. nedwakeman Says:

    I’ve followed your example above - trying to use gmail with Goldmine 7.0 - and receive the following error message (any help gratefully received):

    Failed to open configuration file stunnel.conf

    Syntax:
    stunnel [filename] | -help | -version | -sockets | -install | -uninstall
    filename - use specified config file instead of stunnel.conf
    -fd n - read the config file from specified file descriptor
    -help - get config file help
    -version - display version and defaults
    -sockets - display default socket options
    -install - install NT service
    -uninstall - uninstall NT service

    2006.05.26 11:48:15 LOG3[668:380]: Server is down

  3. Doug Castell Says:

    most commonly, this issue is attributed to the stunnel.conf file being named stunel.conf.txt with windows hiding the .txt file extension from you. To correct this windows setting, open windows explorer and go to tools|options and the view tab there. On the view tab, find the option that says ‘hide file extensions of known file types’ and uncheck it. Then go check your stunnel.conf file. :)

  4. kevgsi Says:

    I configured exactly as shown and is not working. any tips.

  5. Doug Castell Says:

    What’s not working? There are a number of moving parts here.. Are you getting any specific error(s)?

  6. dschomaker Says:

    Thanks Doug. With a bit of fussing your tips worked great!

  7. yeagers Says:

    Doug, I have different ISPs for home and office. Home is Comcast and office is Qwest; would these same patches apply? How would you config this concept for the two different ISPs?

  8. Doug Castell Says:

    Do you mean you’re using Stunnel with two different accounts for thos two ISPs or are you simply configuring G-mail with it? If the latter, nothing special should need to be done.

  9. ethosadvisory Says:

    Goldmine times out with error message 10006. Must have something to do with my configuration for gmail access.

    Here is what I have done.

    Stunnel installed c:\stunnel\
    all files, including dll’s in c:\stunnel\
    created file c:\stunnel\stunnel.conf
    it reads:
    client=yes
    [pop3]
    accept=9995
    connect=pop.gmail.com:995
    [smtp]
    accept=465
    connect=smtp.gmail.com:465

    Logfile for stunnel.exe reads:

    2006.10.17 06:48:52 LOG5[2508:2532]: stunnel 4.16 on x86-pc-mingw32-gnu with OpenSSL 0.9.7e 25 Oct 2004
    2006.10.17 06:48:52 LOG5[2508:2532]: Threading:WIN32 SSL:ENGINE Sockets:SELECT,IPv6
    2006.10.17 06:48:52 LOG5[2508:3580]: No limit detected for the number of clients

    stunnel.exe shows 0 session(s)active

    GMail is set to accept POP3 (use it with Thunderbird)

    Goldmine is configured:

    POP3 server: pop.gmail.com

    Authentication: APOP

    SMTP server: smtp.gmail.com

    Advanced Options:

    POP3 server port: 9995
    SMTP server port: 465

    check box: The server requires authentication

    Login Plain

    Please let me know my errors, and thank you for taking a moment to do so.

  10. Doug Castell Says:

    For your gmail account, in GoldMine, you need to set the SMTP and POP3 servers to 127.0.0.1 (your own machine)

  11. ethosadvisory Says:

    Thanks Doug for your help. Using ipconfig, I determined the ip address for this laptop (192.168.1.102), entered as pop and smtp. Gmail refused the connection.

    “Goldmine cannot connect to your mailserver. Please verify your internet connections and pop3 settings. Socket returned error: connection refused. System error: 10061

    I am using Goldmine 6.5

    Product = GoldMine®
    License = D-0001-18198140
    Versions = GoldMine 6.50.40704, BDE 500 [4/11/1999], Windows NT 5.01.2600 Service Pack 2
    GoldMine EXE = c:\progra~1\goldmine\gmw6.exe
    BDE DLL Files = c:\program files\common files\borland shared\bde\
    TEMP Directory = c:\docume~1\poweru~1\locals~1\temp\
    System Files = c:\progra~1\goldmine\
    GoldMine Files = C:\PROGRA~1\GoldMine\GMBase\
    Contact Files = c:\program files\goldmine\common\
    Free Disk Space = C: 12,682 MB
    Memory (RAM) = 523 MB
    Open Cursors = 14
    Logged User = RAY [Master!]
    CAL LangDriver = DBWINUS0 [New RecID]
    Contact1 LangDriver = DBWINUS0 [New RecID]
    Tx32 version = 801

    Doug thanks!

    Ray

  12. ethosadvisory Says:

    Doug, skip all of the above…your remedy worked. I forgot to run stunnel.exe Apologies, and thanks for taking the time to reply and help. I am grateful.

    Sincerely,

    Ray Randall

  13. Doug Castell Says:

    No problem. Just keep in mind that while your laptop may be 192.168.1.102 right now, it coudl be .103 tomorrow… Use 127.0.0.1 to always be correct! :)

  14. va.ca Says:

    Hi Doug,

    I’m not too technical, but here goes…
    GM Version 6.70.50123

    I’m trying to adapt the GMAIL stunnel process above to my e-mail. I use bell sympatico, needs SSL. Before I tried the stunnel program, I could only receive e-mail in GM through my pop set as mail.virtualassistant.ca. Port 110. Here’s what I’ve done:

    Stunnel installed c:\stunnel\
    all files, including dll’s in c:\stunnel\
    created file c:\stunnel\stunnel.conf
    it reads:
    client=yes
    [pop3]
    accept=9995
    connect=mail.virtualassistant.ca:995
    [smtp]
    accept=465
    connect=smtphm.sympatico.ca:465

    I have ran stunnel.exe.

    Goldmine is configured:

    POP3 server: mail.virtualassistant.ca

    Authentication: PASS

    SMTP server: smtphm.sympatico.ca

    Advanced Options:

    POP3 server port: 9995
    SMTP server port: 465

    check box: The server requires authentication

    Login Plain

    Here’s the stunnel log:
    2006.10.18 12:00:38 LOG3[1236:2640]: Error resolving ‘pop.mail.virtualassistant.ca’: Neither nodename nor servname known (EAI_NONAME)
    Cannot resolve ‘pop.mail.virtualassistant.ca:995′ - delaying DNS lookup
    2006.10.18 12:00:38 LOG5[1236:2640]: stunnel 4.07 on x86-pc-mingw32-gnu WIN32+IPv6 with OpenSSL 0.9.7e 25 Oct 2004
    2006.10.18 12:00:38 LOG5[1236:1952]: No limit detected for the number of clients

    Here, when I try to receive e-mail I get:
    Socket returned error: Connection Refused, System Error 10061. Please verify your internet connection and settings.

    I see you suggest setting POP and SMTP to 127.0.0.1, but when I do this nothing works, when checking e-mail it says ‘connected to 127.0.0.1′ but seems to sit idol, when sending, same thing, but aborts “the socket was disconnected unexpectedly”

    Please help!
    Thank-you,
    Ken

  15. va.ca Says:

    oops, my stnnel.conf reads:

    client=yes
    [pop3]
    accept=9995
    connect=mail.virtualassistant.ca:995
    [smtp]
    accept=465
    connect=smtphm.sympatico.ca:465

    Thanks!

  16. va.ca Says:

    I closed stunnel, reopened it and here’s the log with the updated stunnel.conf:

    2006.10.18 12:25:07 LOG5[1868:2872]: stunnel 4.07 on x86-pc-mingw32-gnu WIN32+IPv6 with OpenSSL 0.9.7e 25 Oct 2004
    2006.10.18 12:25:07 LOG5[1868:3836]: No limit detected for the number of clients

    Receiving error: 10061 (as above)
    Sending error: time our 10060

    Thanks for your time and help.
    Ken

  17. Doug Castell Says:

    I suspect you only need SSL for SENDING mail. That being the case, concentrate on the SMTP settings and leave your POP settings as prescribed by your ISP.

    Make sure you set the SMTP server to 127.0.0.1 (always your own machine.. it’s like saying MY HOUSE as opposed to specifying your street address.)

    From there, if the socket was disconnected, it could be that the windows firewall, norton internet security, or some other think is getting in the way of the traffic. Check your firewall settings and make sure stunnel and/or the appropriate ports are available.

  18. va.ca Says:

    Thanks Doug,

    I have reset all the original POP settings and now receiving mail as before.

    I’ve changed the SMTP settings to 127.0.0.1 et al. I am sure they are correct. I’ve opened port 465 in windows firewall, disabled my router firewall and disabled my AVG 7.1.408 for testing…I’m still getting “the socket was disconnected unexpectedly” error. Is there somewhere else I should look?

    Your help is much appreciated!
    Ken

  19. Doug Castell Says:

    your router’s firewall isn’t involved. You can restore it to its original state. As for the windows firewall, I would disable it entirely for testing purposes here.

    Do you use the AVG e-mail plugin? I don’t, personally, but I know of others who DO use it and successfully use stunnel for their SSL needs.

    I’d think the only logical next step would be verifying your GoldMine SMTP settings (specifically, the advanced SMTP settings)

  20. va.ca Says:

    Yes, I do use the e-mail plugin.

    I disabled the windows firewall entirely with AVG off, same error :(

    Stunnel conf:
    client=yes
    [pop3]
    accept=110
    connect=mail.virtualassistant.ca:110
    [smtp]
    accept=465
    connect=127.0.0.1:465

    GM SMTP:
    Server:127.0.0.1

    Advanced:
    SMTP Server port: 465
    Required Auth: checked
    Login/Plain: checked
    Username: my ISP username (verified correct)
    Password: my ISP password (verified correct)

    Assuming these settings are correct, I’m taking a closer look at my DSL modem/router from sympatico.
    (the other router I disabled is after the modem) I suspect that I’ll need to open the port there…

    Thanks for all your help so far. Fingers are crossed!
    Ken

  21. Doug Castell Says:

    Nope, the router and modem have nothing to do with it as the request from GoldMine will never leave your computer for 127.0.0.1

    Are you sure your stunnel.conf file is really named stunnel.conf and not stunnel.conf.txt? Windows likes to hide file extensions, by default, you know.

  22. va.ca Says:

    Ouch, if that’s the case, I’m at a loss for what’s stopping this from working.

    I noted you mentioned that .txt to someone earlier, it definitely is set as .conf file type.

    Thanks,
    Ken

  23. Doug Castell Says:

    Well, honestly, I’m out of ideas as well. You might have me (or someone else) who’s done this before take a look at it directly (for a fee, of course) to see what might not be evident here.

  24. va.ca Says:

    Question - the whole reason I needed to try the stunnel is b/c my ISP requires SSL. The modem is from them and has a built-in firewall. Does that change you’re last response at all?

  25. Doug Castell Says:

    No, because, according to the logs you’ve posted, GoldMine never contacts stunnel for SMTP at all — therefore no traffic ever leaves your machine — therefore no traffic ever hits your router or dsl modem to be interfered with.

  26. va.ca Says:

    Ok - thanks for your help. I will might have to take you up on the assistance if I can’t figure this out (before I pull my remaining 30 hairs out)

    :)

  27. Petercwn Says:

    I have set up configuration as per suggestions above….my mail logs into 127.0.0.1 then just hangs there until timing out…any other settings I need to look at ? Thanks in advance. Stunnel log is below;
    2006.11.07 08:45:09 LOG5[3248:5768]: stunnel 4.16 on x86-pc-mingw32-gnu with OpenSSL 0.9.7i 14 Oct 2005
    2006.11.07 08:45:09 LOG5[3248:5768]: Threading:WIN32 SSL:ENGINE Sockets:SELECT,IPv6
    2006.11.07 08:45:09 LOG5[3248:4548]: No limit detected for the number of clients
    2006.11.07 08:46:11 LOG5[3248:4184]: ssmtp connected from 127.0.0.1:3383
    2006.11.07 08:47:03 LOG3[3248:4184]: SSL_accept: Peer suddenly disconnected
    2006.11.07 08:47:03 LOG5[3248:4184]: Connection reset: 0 bytes sent to SSL, 0 bytes sent to socket
    2006.11.07 08:47:05 LOG5[3248:3468]: ssmtp connected from 127.0.0.1:3398
    2006.11.07 08:48:07 LOG3[3248:3468]: SSL_accept: Peer suddenly disconnected
    2006.11.07 08:48:07 LOG5[3248:3468]: Connection reset: 0 bytes sent to SSL, 0 bytes sent to socket
    2006.11.07 08:48:18 LOG5[3248:4692]: ssmtp connected from 127.0.0.1:3407
    2006.11.07 08:48:33 LOG3[3248:4692]: SSL_accept: Peer suddenly disconnected
    2006.11.07 08:48:33 LOG5[3248:4692]: Connection reset: 0 bytes sent to SSL, 0 bytes sent to socket
    2006.11.07 08:48:36 LOG5[3248:3804]: ssmtp connected from 127.0.0.1:3409
    2006.11.07 08:48:49 LOG3[3248:3804]: SSL_accept: Peer suddenly disconnected
    2006.11.07 08:48:49 LOG5[3248:3804]: Connection reset: 0 bytes sent to SSL, 0 bytes sent to socket

  28. Doug Castell Says:

    Have you tried it with the windows firewall disabled?

  29. LP Says:

    Please help me! I tried all the above and can’t get my Gmail to work in GoldMine.

    WHAT SHOULD THE AUTHENTIFICATION CODE BE: PASS/APOP/SPA /MSN? I change the setting in gmail to enable pop3. Downloaded the other fiels and put them all into a folder in C:\stunnell.
    When you run the stunnel.exe should GoldMine be opened or closed? I tried it both ways and still didn’t work.

    The error I get when I run the stunnel.exe the error is:

    Failed to open configuration file stunnel.conf

    Syntax:
    stunnel [filename] | -help | -version | -sockets | -install | -uninstall
    filename - use specified config file instead of stunnel.conf
    -fd n - read the config file from specified file descriptor
    -help - get config file help
    -version - display version and defaults
    -sockets - display default socket options
    -install - install NT service
    -uninstall - uninstall NT service

    2007.01.26 08:58:37 LOG3[2968:3560]: Server is down
    *******************************
    My Stunnel.conf file is:
    client=yes

    [pop3]
    accept=9995
    connect=pop.gmail.com:995

    [smtp]
    accept=465
    connect=smtp.gmail.com:465

  30. LP Says:

    To add to that my stunnel file is just stunnel.conf and the firewall is turned off.

  31. Doug Castell Says:

    It really sounds like your stunnel.conf file is really named stunnel.conf.txt and windows is hiding the REAL extension from you.

    To correct it, open windows explorer and go to tools|options and then to the view tab and un-check the option to ‘hide file extensions for known file types.’

    Then re-check your stunnel.conf’s file name and correct it as necessary.

    It doesn’t matter which program you start first — as long as stunnel is running when you check/send your mail.

    As for the authentication method, I use PASS and it’s been working for almost two years. :)

  32. LP Says:

    Your a genious! I thought since I deleted the .txt and it was still there only once (not twice) that that was it. I am almost there. The stunnel.exe ran fine and I can GET my email - but I can’t send email. I went into gmail options and enabled the pop access for ALL messages.
    When trying to send the error is ” 5305.5.1 Authenification Required qlqsm5457663qbq”. There probably is just one more setting, right?

    If I turn off the computer then I presume that I will have to run the stunnel.exe again. Would you suggest putting the stunnel.exe in startup? Thanks a bunch.

  33. LP Says:

    How can you tell the the stunnel.exe is running? I looked in my Task manager and I didn’t see it running in Processes or Applications?

  34. Doug Castell Says:

    Shows up as stunnel.exe in my task scheduler and a little blue mailbox-ish thing in the system tray.

    As for the SMTP settings, there’s an area in the advanced Account settings in GoldMine (the screen you specified your port numbers on) wher eyou need to put in your gmail address and password for the SMTP authenticaition stuff.

  35. macouncider2 Says:

    I appreciate the help this topic includes. I am trying take advantage of gmails domain email option, and then pop it all to gm.
    Have installed as per above, service is running on win2003 server, but get the following error log:

    2007.03.15 10:54:41 LOG5[2196:2564]: stunnel 4.20 on x86-pc-mingw32-gnu with OpenSSL 0.9.8d 28 Sep 2006
    2007.03.15 10:54:41 LOG5[2196:2564]: Threading:WIN32 SSL:ENGINE Sockets:SELECT,IPv6
    2007.03.15 10:54:41 LOG5[2196:2212]: No limit detected for the number of clients
    2007.03.15 10:54:41 LOG3[2196:2212]: Error binding pop3s to 0.0.0.0:995
    2007.03.15 10:54:41 LOG3[2196:2212]: bind: Permission denied (WSAEACCES) (10013)

    2007.03.15 10:54:41 LOG3[2196:2212]: Server is down

    Any ideas on what I have missed? Need more info?

  36. Doug Castell Says:

    Make sure your stunnel.conf file has the following line in the [pop3] section:

    connect=pop.gmail.com:995

  37. macouncider2 Says:

    Yes, it is in: connect=pop.gmail.com:995

    I now have it working. Discovered batch file I was calling stunnel from did not have cd command to be in proper directory to run stunnel from. To debug, I put a pause at the end of the batch file, so DOS box remained open and i could see any errors.

    I have the batch file set to run as a scheduled task at system startup. By putting the stop command in, then starting it again in the next line, the batch file runs without error even if service is started…

    Run this on a machine that is always running, so anytime Goldmine is used, your gmail will pop/smtp to Goldmine.

    Here is my batch file:

    cd C:\Program Files\stunnel

    stunnel.exe -stop -quiet
    stunnel.exe -start -quiet
    stunnel.exe c:\stunnel\stunnel.conf

    rem set to run as scheduled task at sys startup on CIDER Win 2003 server
    rem allows goldmine to get gmail

    Thanks Doug for your insight.
    Best Regards: Keith

  38. Mab Says:

    I get an “incorrect user name or password” error message when I use Google Apps e-mail (using my own domain name instead of the gmail.com name). It works fine when I use Gmail. I have tried both the full e-mail and just the beginning part of the e-mail as username but got the same result.
    How do I make Google Apps e-mail work?
    Thanks in advance.

  39. Doug Castell Says:

    Sorry, but I’m not famiiar with the Google Apps e-mails. Pretty much any account that requires SSL is usable with this methodology, though.

    Are you sure the pop3/smtp servers in use in the stunnel.conf are appropriate for the Google Apps mail? They do seem to require your own domain…

  40. Mab Says:

    google apps use the same pop and smtp as Gmail ie pop.gmail.com and smtp.gmail.com. works well in outlook. the only difference is, i believe, in google apps, you have to use the full e-mail address as your user name.
    thanks.

  41. Doug Castell Says:

    Then make sure that, in GoldMine’s e-mail settings area, you go to the ACCOUNTS button and add/edit your e-mail address settings as opposed to simply entering the information on the Edit|Preferneces|Internet tab where GoldMine will truncate entire-address usernames (it assumes you’re doing something wrong.)

  42. Mab Says:

    Yes you’re right Doug. It works by going to GMs Advanced settings and changing the username to the full e-mail address.
    Thank again.

  43. dmack Says:

    This worked great! Thanks! Would this work at the server level so I don’t have to install for each user?

    Thanks!!

  44. Doug Castell Says:

    Yes! You can install it on one machine and then, for all your users, enter the machine name of that machine for the POP3/SMTP server name and it’ll work fine (assuming the stunnel ’server’ has it’s firewall and whatnot configured properly.)

  45. rpitts Says:

    I use gmail in Goldmine with the Stunnel thingy. I never have a problem sending from my office. However, I am currently at a hotel and connected through their wireless network and it’s not working (I sent some queued msgs then to make sure they went I sent an email to myself) but I never got a bounce-back message. I checked the badmail folder and there’s nothing there.

    Also earlier today I was working standalone (no internet connection) and was responding to emails and queuing them for delivery later. I accidentally hit send on one and it acted like it went, no bounce-back, etc.

    This is the Stunnel log from what I tried to send through the wireless:

    2007.05.17 19:22:16 LOG3[3196:3204]: Error resolving ‘pop.gmail.com’: Neither nodename nor servname known (EAI_NONAME)
    Cannot resolve ‘pop.gmail.com:995′ - delaying DNS lookup
    2007.05.17 19:22:16 LOG5[3196:3204]: stunnel 4.15 on x86-pc-mingw32-gnu with OpenSSL 0.9.7i 14 Oct 2005
    2007.05.17 19:22:16 LOG5[3196:3204]: Threading:WIN32 SSL:ENGINE Sockets:SELECT,IPv6
    2007.05.17 19:22:16 LOG5[3196:3284]: No limit detected for the number of clients
    2007.05.17 19:42:13 LOG5[3196:3784]: pop3s connected from 127.0.0.1:3134
    2007.05.17 19:42:14 LOG5[3196:3784]: Connection closed: 53 bytes sent to SSL, 117 bytes sent to socket
    2007.05.17 19:42:15 LOG5[3196:3584]: pop3s connected from 127.0.0.1:3139
    2007.05.17 19:42:37 LOG5[3196:3584]: Connection closed: 121 bytes sent to SSL, 9765 bytes sent to socket
    2007.05.17 19:42:37 LOG5[3196:2508]: pop3s connected from 127.0.0.1:3163
    2007.05.17 19:43:07 LOG5[3196:2508]: Connection closed: 110 bytes sent to SSL, 8427 bytes sent to socket
    2007.05.17 19:45:54 LOG5[3196:3688]: pop3s connected from 127.0.0.1:3376
    2007.05.17 19:45:55 LOG5[3196:3688]: Connection closed: 53 bytes sent to SSL, 117 bytes sent to socket
    2007.05.17 19:46:00 LOG5[3196:3820]: pop3s connected from 127.0.0.1:3382
    2007.05.17 19:46:06 LOG5[3196:3820]: Connection closed: 110 bytes sent to SSL, 8426 bytes sent to socket
    2007.05.17 19:46:06 LOG5[3196:3972]: pop3s connected from 127.0.0.1:3394
    2007.05.17 19:46:07 LOG5[3196:3972]: Connection closed: 53 bytes sent to SSL, 117 bytes sent to socket
    2007.05.17 19:46:16 LOG5[3196:704]: pop3s connected from 127.0.0.1:3412
    2007.05.17 19:46:21 LOG5[3196:704]: Connection closed: 131 bytes sent to SSL, 11927 bytes sent to socket
    2007.05.17 19:46:22 LOG5[3196:2344]: pop3s connected from 127.0.0.1:3424
    2007.05.17 19:46:27 LOG5[3196:2344]: Connection closed: 110 bytes sent to SSL, 8427 bytes sent to socket
    2007.05.17 19:46:32 LOG5[3196:3560]: pop3s connected from 127.0.0.1:3442
    2007.05.17 19:46:39 LOG5[3196:3560]: Connection closed: 53 bytes sent to SSL, 117 bytes sent to socket
    2007.05.17 19:46:43 LOG5[3196:3668]: pop3s connected from 127.0.0.1:3457
    2007.05.17 19:46:56 LOG5[3196:3668]: Connection closed: 131 bytes sent to SSL, 11927 bytes sent to socket
    2007.05.17 19:46:58 LOG5[3196:2280]: pop3s connected from 127.0.0.1:3474
    2007.05.17 19:47:24 LOG5[3196:2280]: Connection closed: 110 bytes sent to SSL, 8426 bytes sent to socket
    2007.05.17 19:48:44 LOG5[3196:4084]: pop3s connected from 127.0.0.1:3569
    2007.05.17 19:48:45 LOG5[3196:4084]: Connection closed: 53 bytes sent to SSL, 117 bytes sent to socket
    2007.05.17 19:49:27 LOG5[3196:3872]: pop3s connected from 127.0.0.1:3620
    2007.05.17 19:49:28 LOG5[3196:3872]: Connection closed: 53 bytes sent to SSL, 117 bytes sent to socket
    2007.05.17 19:50:22 LOG5[3196:3688]: pop3s connected from 127.0.0.1:3682
    2007.05.17 19:50:26 LOG5[3196:3688]: Connection closed: 53 bytes sent to SSL, 117 bytes sent to socket
    2007.05.17 19:50:30 LOG5[3196:1592]: pop3s connected from 127.0.0.1:3691
    2007.05.17 19:51:16 LOG5[3196:1592]: Connection closed: 116 bytes sent to SSL, 8432 bytes sent to socket
    2007.05.17 19:55:19 LOG5[3196:2508]: pop3s connected from 127.0.0.1:3955
    2007.05.17 19:55:25 LOG5[3196:2508]: Connection closed: 53 bytes sent to SSL, 117 bytes sent to socket
    2007.05.17 19:55:27 LOG5[3196:2608]: pop3s connected from 127.0.0.1:3968
    2007.05.17 19:55:33 LOG5[3196:2608]: Connection closed: 110 bytes sent to SSL, 8427 bytes sent to socket
    2007.05.17 20:09:47 LOG5[3196:2640]: pop3s connected from 127.0.0.1:1268
    2007.05.17 20:09:48 LOG5[3196:2640]: Connection closed: 53 bytes sent to SSL, 117 bytes sent to socket

    Can anyone provide any insight?

    Thanks

  46. Doug Castell Says:

    What if you try to PING pop.gmail.com ?

    Is it possible your antivirus is blocking it? I’ve seen Norton antivirus prevent e-mail from going out after more than one or two similar one go out quickly.. Something about ‘worm protection’…

  47. Virbonus Says:

    I just wanted to say thank you. I followed your instructions to the letter and was unsure how it would all work along with my installation of AVG. It works perfectly. Using GM 7.04 Corporate SQL.

  48. Doug Castell Says:

    Glad you like the hack! I use it myself every day! Support the Stunnel developer with a little donation on his site if it proves useful to you, long term! :)

  49. yoav Says:

    hi doug - thanks for the information. using it i am almost there (i think). I can currently send email but not receive it. goldmine says connected to 127.0.0.1 but its not recieving any email.

    the pop3 settings on goldmine that I have set are as follows:

    pop3 server: 127.0.0.1
    username: my gmail logon (without gmail.com)
    password: my gmail password
    autoreceive and autodelete: unchecked
    authentication: PASS
    email auto recieved from this account belongs to user: my goldmine logon name
    pop3 server port: 9995

    my stunnel text file reads:

    client=yes
    [pop3]
    accept=9995
    connect=pop.gmail.com:9995
    [smtp]
    accept=465
    connect=smtp.gmail.com:465

    in the stunnel log, there are a lot of lines that say:

    2007.08.09 17:20:32 LOG5[2956:3668]: pop3 connected from 127.0.0.1:3334
    2007.08.09 17:20:52 LOG3[2956:3668]: Failed to initialize remote connection

    many thanks in advance - any help is greatly appreciated

  50. Doug Castell Says:

    be sure to visit the settings of the gmail account online and enable POP3 access! :)

  51. yoav Says:

    hi - the gmail settings are set to enable POP3.

    are my goldmine settings correct? (listed above)

    Thanks

  52. Doug Castell Says:

    looks like you need to correct this line:
    connect=pop.gmail.com:9995
    to this:
    connect=pop.gmail.com:995

  53. yoav Says:

    thanks - all sorted

  54. jhurdman Says:

    Well, my problem is rather odd. We have a ten-user license of Goldmine, and several computers which all connect to the server to use it. Two of the computers cannot access e-mail using Goldmine. Actually, it’s worse than that. One of these two computers worked perfectly until today, and then it suddenly stopped working, giving an error message 2570.
    The other one works occasionally (maybe once or twice a week). It gives an error 10061. The settings in Goldmine work on any other computers, except for this computer. It first connects to a program called K9, and then to Stunnel (or not, on the second computer, as it isn’t really connecting to a secure connection). Everything appears to be the same as on other computers, except that it isn’t working.
    Better yet, it sends mail no problem, from both computers I think.

  55. Doug Castell Says:

    sounds like maybe a firewall issue (software or hardware firewall) or possibly an issue with the e-mail boxes in question (did the pop3 setting get turned off in the gmail options area?)

    Other than these thoughts, I’m not sure how much troubleshooting is practical in the comments of this article.. You might want to start a thread on the forum for better visibility! www.contactreview.net

  56. marc Says:

    Doug,

    Thanks much for the information.
    stunnel worked fine on my user’s terminal session.

    -marc

  57. DaveGiltinan Says:

    Hi Doug, Thanks for all the useful tips above. We’ve followed everything step by step but we’re having an interesting problem. Running Goldmine 5.7 trying to drop Gmail in (using Google Apps - would that make any difference) and each time we try to download email get error message saying “username and password not accepted.” When we go back into settings it’s as though Goldmine has changed the password because it’s now a 15 letter password instead of our 6 letter one! The 15 letter password is the same from internet tab through to accounts and advanced tab. Any ideas?
    Dave

  58. Doug Castell Says:

    GoldMine’s not changing your password. It just displays a bunch of asterisks instead of the same number as the characters in your password as a security measure.

  59. DaveGiltinan Says:

    Thanks Doug, I understand that Goldmine is not changing the actual password however for some reason when we enter our 6 digit password in Goldmine settings (the same one we use for Gmail) by the time we’ve okayed or applyed out, we go back in and there is 15 asterixs instead of 6. I just don’t understand where the 15 are coming from and it seems like that’s why I get the message “username or password not accepted.” Sorry if this isn’t clear.

  60. Doug Castell Says:

    The number of asterisks displayed by GoldMine does not coincide with the number of characters in the password — this is a security measure.

    Are you sure you have the correct username and password?

  61. Brush Says:

    Thanks you very much for the guide to using stunnel. Worked fine for me. Can I now modify GM so it will retrieve email from imap.googe.com. Their setup instructions are below. Thanks so much

    Configuring other mail clients
    You can use the following information to configure IMAP with many mail clients. If you encounter difficulties, we suggest contacting your mail client’s customer support department for further instructions — we’re unable to provide assistance with configuring mail clients not listed here.

    Incoming Mail (IMAP) Server - requires SSL: imap.gmail.com
    Use SSL: Yes
    Port: 993
    Outgoing Mail (SMTP) Server - requires TLS: smtp.gmail.com (use authentication)
    Use Authentication: Yes
    Use STARTTLS: Yes (some clients call this SSL)
    Port: 465 or 587
    Account Name: your Gmail username (including @gmail.com)
    Email Address: your full Gmail email address (username@gmail.com)
    Password: your Gmail password

    Please note that if your client does not support SMTP authentication, you won’t be able to send mail through your client using your Gmail address.

  62. Doug Castell Says:

    GoldMine doesn’t support IMAP, unfortunately, so you’ll need to use regular pop3 to retrieve your e-mail. Is there any particular reason you want IMAP?

    Regardless, keep an eye out for GoldMine 7.5 in January for exciting new developments regarding e-mail protocols!

  63. mikejdavidson21 Says:

    i have been using goldmine for about three months and could only get it to work with your help, but unfortunatley i can only send 500 email per day. so if i understand goldmine correctly each user can have their own email therefor i should be able send more emails by using different users, right? if so then i would have to set up each of the accounts like i did the first account. well i have tried to set up one other account and when i send an email it gives me an error message that says “a protocol ERROR has occured in logging in or retreiving messages:535 5.7.1 credentioals rejected 3sm5478213hsw.12″ what does this mean?

  64. Doug Castell Says:

    Your e-mail provider is likely limiting you. I am not sure whether the limitation is based on which e-mail account you’re sending from or whether it’s your IP address or… ? You’d have to discuss it with tech support from the ISP in question, in all likelihood.

  65. housebetty Says:

    I have followed all of the instructions from above and I still receive the following error messsage:

    goldmine cannot connect to your mail server please verify your internet connection and POP3 settings.

    socket returned error: connection refused
    System error 10061

    I have a folder c:/stunnel
    contains stunnel installer, stunnel.conf, libeay32.dll and libssl32.dll

    I changed my settings in gmail and my goldmine 6.0 set up is as follows:

    both smtp and pop3 servers are 127.0.0.1
    the pop3 server port is 9995
    the smtp server port is 465

    ther server requires authentication box is checked

    the “login/plain” box is checked

    I don’t know why it isn’t working! Any help you can offer would be greatly appreciated. I’m not very tech savvy but have followed the instructions… thank you sir.

  66. Doug Castell Says:

    can you post the contents of your stunnel.conf file? And are you definitely showing file extensions (so you know it’s not really stunnel.conf.txt?)

  67. Jzingg Says:

    Doug - outstanding! Used your stunnel info above and gmail/GM life is good. Thanks!!!!

  68. Rich.Godfrey Says:

    I think you are also an AVG Antivirus user. Have you configured AVG to scan your gmail e-mails as they are coming into GM? I can’t seem to get the AVG settings correct.

  69. Doug Castell Says:

    sure, my AVG scans my mail without any special configuration.. I turned off the free advertisement bit they like to add to the bottom of e-mail bodies, however.

  70. jeff1233 Says:

    Doug I am trying to set up my two different work emails on a server to work for 4 different stations and all of your tips aren’t working I am getting a message that reads, system error:10061 cant connet to internet or pop3 settings any ideas? do you do indivudual sessions

  71. Doug Castell Says:

    Sure I do remote sessions all the time. It’s basically what I do for a living. :)

    I’ll respond back to you via direct e-mail and we can schedule a time.

  72. jeff1233 Says:

    That sounds great doug, but do you know how to run two different email through stunnell off the same goldmine?

  73. Doug Castell Says:

    sure can! :)

  74. jmm Says:

    Doug,
    Happily, I can now read my Gmail in Goldmine 6.7 after setting up Stunnel according to your directions.

    However, it only imported Sep 2007 then stopped. I fixed this by setting GMAIL pop to be from now on instead of all.

    Why do you think this is? Is there a quantity limitation in Gmail? I have downloaded several hundred emails into goldmine from regular pop accounts so … not sure …

    Thank you,

    Jmm

  75. koriaky Says:

    I just recently (5 weeks ago) started using stunnel with GoldMine v6 and 2 days ago my users started getting the error “The socket was disconnected unexpectedly” when they tried to send e-mails (SMTP). We use AT&T’s SMTP servers. Here’s a copy of the stunnel.conf file…
    client = yes

    ; Service-level configuration

    [pop3s]
    accept = 995
    connect = pop.att.yahoo.com:995

    [imaps]
    accept = 993
    connect = 143

    [ssmtp]
    accept = 465
    connect = smtp.att.yahoo.com:465

    I’ve read the great solutions about and implemented a few, but I’m still receiving the error.
    Any help would be appreciated.

  76. koriaky Says:

    any yes we have set up the SMTP settings in GoldMine with the localhost IP addr (127.0.0.1)

  77. koriaky Says:

    here’s my log file…
    2008.09.21 18:06:30 LOG5[1628:1208]: stunnel 4.26 on x86-pc-mingw32-gnu with OpenSSL 0.9.8i 15 Sep 2008
    2008.09.21 18:06:30 LOG5[1628:1208]: Threading:WIN32 SSL:ENGINE Sockets:SELECT,IPv4
    2008.09.21 18:06:30 LOG5[1628:1188]: No limit detected for the number of clients
    2008.09.21 18:22:43 LOG5[1628:1588]: ssmtp accepted connection from 127.0.0.1:1237
    2008.09.21 18:22:43 LOG5[1628:1588]: ssmtp connected remote server from 192.168.2.200:1238
    2008.09.21 18:22:43 LOG3[1628:1588]: SSL_connect: 14094412: error:14094412:SSL routines:SSL3_READ_BYTES:sslv3 alert bad certificate
    2008.09.21 18:22:43 LOG5[1628:1588]: Connection reset: 0 bytes sent to SSL, 0 bytes sent to socket

  78. Doug Castell Says:

    sslv3 alert bad certificate

    this looks like an issue on the AT&T end.. I’d sit tight and see if it clears up on it’s own. A call to AT&T tech support maybe?

  79. koriaky Says:

    I called them yesterday and AT&T level 1 tech support said their servers were fine. I’ll see if I can escalate it to level 2.
    Is there any more info you could give me on the error? What I mean is, the “sslv3 alert bad certificate” message in my stunnel logs are stating that there is an issue with AT&T’s certificate or something wrong with stunnel?

  80. Doug Castell Says:

    here’s a where someone else encountered this issue and it was an issue on the ISP’s side and was corrected readily by the ISP.

    http://stunnel.mirt.net/pipermail/stunnel-users/2004-December/000200.html

    Good luck! let us know what happens!

  81. koriaky Says:

    Doug, did your recent response include a hyperlink?

  82. Doug Castell Says:

    It was supposed to. Looks like some draconian site security setting that I put in place at one point or another blocked it.

    Fixed it now, see above. ;)

  83. koriaky Says:

    Just got off the phone with AT&T level two support and they said the issue has to be at the client side. And, that their mail servers are handled by Yahoo not AT&T, so they are unable to make any server setting changes.

    In looking at the logs sslv3 alert bad cert error and the stunnel users page yesterday, I’m wondering if creating a SSL cert locally for each client is required?
    Anyone, using GM and stunnel, ever change the config file to point to their own ssl certs/keys?

    Link to the stunnel users pg -
    http://stunnel.mirt.net/pipermail/stunnel-users/2004-December/000199.html

    Additionally, in the page (listed above) the user had his config file accept line set up as 127.0.0.1 versus having the port number instead. Has anyone set it up this way and have it work?

    [pops.xs4all.nl:995]
    accept = 127.0.0.1:5000
    connect = pops.xs4all.nl:995
    delay = yes

    [pop.gmail.com:995]
    accept = 127.0.0.1:5003
    connect = pop.gmail.com:995
    delay = yes

  84. Doug Castell Says:

    I’ve never had to mess with cert stuff at all. Could you post your stunnel.conf file?

  85. koriaky Says:

    ____________________________
    Here’s my stunnel.conf file
    ————————————–
    Note: SMTP is not working, POP is good
    ————————————–

    ; Some options used here may not be adequate for your particular configuration

    ; Certificate/key is needed in server mode and optional in client mode

    ; The default certificate is provided only for testing and should not

    ; be used in a production environment

    cert = stunnel.pem

    ;key = stunnel.pem

    ; Some performance tunings

    socket = l:TCP_NODELAY=1

    socket = r:TCP_NODELAY=1

    ; Workaround for Eudora bug

    ;options = DONT_INSERT_EMPTY_FRAGMENTS

    ; Authentication stuff

    ;verify = 2

    ; Don’t forget to c_rehash CApath

    ;CApath = certs

    ; It’s often easier to use CAfile

    ;CAfile = certs.pem

    ; Don’t forget to c_rehash CRLpath
    ;CRLpath = crls
    ; Alternatively you can use CRLfile
    ;CRLfile = crls.pem
    ; Some debugging stuff useful for troubleshooting
    ;debug = 7
    ;output = stunnel.log
    ; Use it for client mode

    client = yes

    ; Service-level configuration

    [pop3s]
    accept = 995
    connect = pop.att.yahoo.com:995

    [imaps]
    accept = 993
    connect = 143

    [ssmtp]
    accept = 465
    connect = smtp.att.yahoo.com:465

    ;[https]
    ;accept = 443
    ;connect = 80
    ;TIMEOUTclose = 0
    ; vim:ft=dosini

  86. Doug Castell Says:

    try eliminating all lines above ‘client=yes’

  87. Nancy Norris Says:

    Doug,
    I am using GM 6.7.50123. My ISP went to gmail about 2 months ago and I have not been able to configure stunnel to work yet. I can get it send, but not retrieve, My stunnel.cong file reads:
    client=yes
    [pop3]
    accept=9995
    connect=pop.gmail.com:995
    [smtp]
    accept=465
    connect=smtp.gmail.com:465

    My log file reads:
    2008.10.17 19:55:29 LOG5[1096:336]: stunnel 4.25 on x86-pc-mingw32-gnu with OpenSSL 0.9.8h 28 May 2008
    2008.10.17 19:55:29 LOG5[1096:336]: Threading:WIN32 SSL:ENGINE Sockets:SELECT,IPv4
    2008.10.17 19:55:29 LOG5[1096:1328]: No limit detected for the number of clients
    2008.10.17 19:57:21 LOG5[1096:1128]: pop3s accepted connection from 127.0.0.1:1855
    2008.10.17 19:57:34 LOG3[1096:1128]: SSL_accept: Peer suddenly disconnected
    2008.10.17 19:57:34 LOG5[1096:1128]: Connection reset: 0 bytes sent to SSL, 0 bytes sent to socket
    2008.10.17 19:58:13 LOG5[1096:1192]: pop3s accepted connection from 127.0.0.1:1856
    2008.10.17 19:59:17 LOG3[1096:1192]: SSL_accept: Peer suddenly disconnected
    2008.10.17 19:59:17 LOG5[1096:1192]: Connection reset: 0 bytes sent to SSL, 0 bytes sent to socket
    2008.10.17 20:00:56 LOG5[1096:1172]: pop3s accepted connection from 127.0.0.1:1859
    2008.10.17 20:01:51 LOG3[1096:1172]: SSL_accept: Peer suddenly disconnected
    2008.10.17 20:01:51 LOG5[1096:1172]: Connection reset: 0 bytes sent to SSL, 0 bytes sent to socket
    2008.10.17 20:07:10 LOG5[1096:1152]: pop3s accepted connection from 127.0.0.1:1877
    2008.10.17 20:08:13 LOG3[1096:1152]: SSL_accept: Peer suddenly disconnected
    2008.10.17 20:08:13 LOG5[1096:1152]: Connection reset: 0 bytes sent to SSL, 0 bytes sent to socket

    Any advice would be greatly appreciated. Thanks
    Nancy

  88. Doug Castell Says:

    Sounds like either your windows firewall or some firewall/email ‘protection’ in your anti-virus tool is killing the connection shortly after it’s made. That config should work — and it appears that GoldMine is configured properly too since it’s connecting.

    Look around for other ’security’ on the machine and adjust as needed.

    What antivirus do you use?

  89. mac301 Says:

    My Stunnel and Gmail with gm6.7 has been working fine for well over a couple of years… Just today I can’t send email. Get “The socket was disconnected unexpectedly”

    This is my Log file:

    2008.10.21 19:44:35 LOG5[1208:1744]: stunnel 4.21 on x86-pc-mingw32-gnu with OpenSSL 0.9.8g 19 Oct 2007
    2008.10.21 19:44:35 LOG5[1208:1744]: Threading:WIN32 SSL:ENGINE Sockets:SELECT,IPv4
    2008.10.21 19:44:35 LOG5[1208:332]: No limit detected for the number of clients
    2008.10.21 19:45:58 LOG5[1208:1272]: ssmtp accepted connection from 127.0.0.1:1532
    2008.10.21 19:46:08 LOG5[1208:1272]: Connection reset: 0 bytes sent to SSL, 0 bytes sent to socket
    2008.10.21 19:50:50 LOG5[1208:1304]: pop3s accepted connection from 127.0.0.1:1574
    2008.10.21 19:50:50 LOG5[1208:1304]: pop3s connected remote server from 192.168.0.122:1575
    2008.10.21 19:50:57 LOG5[1208:1304]: Connection closed: 90 bytes sent to SSL, 3111 bytes sent to socket
    2008.10.21 19:53:55 LOG5[1208:344]: ssmtp accepted connection from 127.0.0.1:1620
    2008.10.21 19:54:05 LOG5[1208:344]: Connection reset: 0 bytes sent to SSL, 0 bytes sent to socket
    2008.10.21 19:56:02 LOG5[1208:1656]: ssmtp accepted connection from 127.0.0.1:1622
    2008.10.21 19:56:12 LOG5[1208:1656]: Connection reset: 0 bytes sent to SSL, 0 bytes sent to socket

    Any help would be greatly appreciated.

    Mike

  90. Doug Castell Says:

    looks like something external is cutting off communications between stunnel and the gmal server. Router? ISP? Firewall? Antivirus? Has anything in that area changed recently for you?

  91. sause Says:

    starting yesterday, Goldmine is getting the error “a protocol error occurred in logging in or retrieving messages” and then “-ERR problem retrieving messages’. Been using stunnel for some time, but now two machines are having a problem with att.yahoo as they are likely making changes at their servers.. and ideas to make this work? Again, had been using stunnel successfully for some time. Thanks for the product and helping!

  92. Doug Castell Says:

    what does your stunnel.conf look like? It may be that you were using port 25 and now need to go to 465 or.. ? Sometimes when ISP’s move over to SSL-only requirements, they leave port 25 available for a long time to allow for slow-response time from customers.

  93. mac301 Says:

    Doug,

    I’m trying to use a VPN (Hamachi).. to connect to my offsite server… All seems to work accept Stunnel/Goldmine email pop3 and gmail..

    Without the VPN I can login to a remote desktop and it works fine… but when I use the VPN connection I can not download gmail… other email accounts work fine.

    I get the following Error: Timed out waiting for a response from the server.

    This is my log file:
    2008.11.17 18:17:22 LOG5[3864:3916]: stunnel 4.21 on x86-pc-mingw32-gnu with OpenSSL 0.9.8g 19 Oct 2007
    2008.11.17 18:17:22 LOG5[3864:3916]: Threading:WIN32 SSL:ENGINE Sockets:SELECT,IPv6
    2008.11.17 18:17:22 LOG5[3864:356]: No limit detected for the number of clients
    2008.11.17 18:17:41 LOG5[3864:3828]: pop3s accepted connection from 127.0.0.1:1668
    2008.11.17 18:18:42 LOG3[3864:3828]: SSL_accept: Peer suddenly disconnected
    2008.11.17 18:18:42 LOG5[3864:3828]: Connection reset: 0 bytes sent to SSL, 0 bytes sent to socket
    2008.11.17 18:30:00 LOG5[3864:3068]: pop3s accepted connection from 127.0.0.1:1756
    2008.11.17 18:31:08 LOG3[3864:3068]: SSL_accept: Peer suddenly disconnected
    2008.11.17 18:31:08 LOG5[3864:3068]: Connection reset: 0 bytes sent to SSL, 0 bytes sent to socket
    2008.11.17 18:41:28 LOG5[3864:2688]: pop3s accepted connection from 127.0.0.1:1795
    2008.11.17 18:42:29 LOG3[3864:2688]: SSL_accept: Peer suddenly disconnected
    2008.11.17 18:42:29 LOG5[3864:2688]: Connection reset: 0 bytes sent to SSL, 0 bytes sent to socket
    2008.11.17 18:43:58 LOG5[3864:2512]: pop3s accepted connection from 127.0.0.1:1801
    2008.11.17 18:45:02 LOG3[3864:2512]: SSL_accept: Peer suddenly disconnected
    2008.11.17 18:45:02 LOG5[3864:2512]: Connection reset: 0 bytes sent to SSL, 0 bytes sent to socket

    Do I need to adjust something in the VPN software?

    Thanks, Mike

  94. Doug Castell Says:

    windows firewall enabled? Hamachi has some advanced settings regarding ‘common windows services’ etc.. maybe they’re set too restrictively?

  95. mac301 Says:

    Doug… Thanks.. Does this ini file tell you anything about the firewall?

    (((removed for security)))

    Mike

  96. Doug Castell Says:

    hamachi’s ini file doesn’t mean much to me.. I typically just use the options settings within the program to find the option relating to blocking/unblocking generic windows services or something to that effect. I forget the exact text of the option there, sorry.

  97. rsangari Says:

    I am running GM 6.7 and attempting t use yahoo as my mail server. I have downloaded and installed Stunnel 4.26 and have modified the stunnel.conf

    cert = stunnel.pem
    socket = l:TCP_NODELAY=1
    socket = r:TCP_NODELAY=1

    client = yes

    [pop3s]
    accept = 995
    connect = plus.pop.mail.yahoo.com:995

    [imaps]
    accept = 993
    connect = 143

    [ssmtp]
    accept = 465
    connect = plus.smtp.mail.yahoo.com:465

    I have configured the GM email client for pop/smtp to 127.0.0.1 and set the ports at 995 and 465. and put in the credential provided by yahoo for username and password.

    folllowing are my Stunnel logs:
    stunnel 4.26 on x86-pc-mingw32-gnu with OpenSSL 0.9.8i 15 Sep 2008
    Threading:WIN32 SSL:ENGINE Sockets:SELECT,IPv4
    No limit detected for the number of clients
    pop3s accepted connection from 127.0.0.1:1275
    pop3s connected remote server from 192.168.2.104:1276
    SSL_connect: 14094412: error:14094412:SSL routines:SSL3_READ_BYTES:sslv3 alert bad certificate
    Connection reset: 0 bytes sent to SSL, 0 bytes sent to socket

    Any ideas?

    Regards, Rudy

  98. Doug Castell Says:

    sure, remove the cert= line

  99. Apache Says:

    I’m trying
    I’ll put the consult in the frontrange forum too.

    I follow the instructions above step by step

    Finally I received the message :

    Se ha producido un error de protocolo al iniciar la sesión o recuperar mensajes

    -ERR [AUTH] Username and password not accepted

    The Stunnel Log :

    2009.03.03 14:08:19 LOG5[3392:3972]: stunnel 4.21 on x86-pc-mingw32-gnu with OpenSSL 0.9.8g 19 Oct 2007
    2009.03.03 14:08:19 LOG5[3392:3972]: Threading:WIN32 SSL:ENGINE Sockets:SELECT,IPv6
    2009.03.03 14:08:19 LOG5[3392:1500]: No limit detected for the number of clients
    2009.03.03 14:17:46 LOG5[3392:3416]: pop3 accepted connection from 127.0.0.1:2644
    2009.03.03 14:17:47 LOG5[3392:3416]: pop3 connected remote server from 192.168.2.3:2645
    2009.03.03 14:17:48 LOG5[3392:3416]: Connection closed: 41 bytes sent to SSL, 130 bytes sent to socket
    2009.03.03 14:19:52 LOG5[3392:3184]: pop3 accepted connection from 127.0.0.1:2661
    2009.03.03 14:19:52 LOG5[3392:3184]: pop3 connected remote server from 192.168.2.3:2662
    2009.03.03 14:19:53 LOG5[3392:3184]: Connection closed: 41 bytes sent to SSL, 130 bytes sent to socket
    2009.03.03 14:37:19 LOG5[3392:2712]: pop3 accepted connection from 127.0.0.1:2962
    2009.03.03 14:37:19 LOG5[3392:2712]: pop3 connected remote server from 192.168.2.3:2963
    2009.03.03 14:37:21 LOG5[3392:2712]: Connection closed: 41 bytes sent to SSL, 130 bytes sent to socket
    2009.03.03 14:37:27 LOG5[3392:1568]: pop3 accepted connection from 127.0.0.1:2964
    2009.03.03 14:37:27 LOG5[3392:1568]: pop3 connected remote server from 192.168.2.3:2965
    2009.03.03 14:37:28 LOG5[3392:1568]: Connection closed: 41 bytes sent to SSL, 130 bytes sent to socket

    I put the screenshots :

    [URL=http://img21.imageshack.us/my.php?image=greenshot20090303143836.jpg][IMG]http://img21.imageshack.us/img21/9960/greenshot20090303143836.th.jpg[/IMG][/URL]
    [URL=http://img9.imageshack.us/my.php?image=greenshot20090303143819.jpg][IMG]http://img9.imageshack.us/img9/7746/greenshot20090303143819.th.jpg[/IMG][/URL]
    [URL=http://img16.imageshack.us/my.php?image=greenshot20090303143806.jpg][IMG]http://img16.imageshack.us/img16/7514/greenshot20090303143806.th.jpg[/IMG][/URL]
    [URL=http://img16.imageshack.us/my.php?image=greenshot20090303141801.jpg][IMG]http://img16.imageshack.us/img16/2952/greenshot20090303141801.th.jpg[/IMG][/URL]
    [URL=http://img11.imageshack.us/my.php?image=greenshot20090303141654.jpg][IMG]http://img11.imageshack.us/img11/3477/greenshot20090303141654.th.jpg[/IMG][/URL]
    [URL=http://img16.imageshack.us/my.php?image=greenshot20090303141644.jpg][IMG]http://img16.imageshack.us/img16/218/greenshot20090303141644.th.jpg[/IMG][/URL]
    [URL=http://img9.imageshack.us/my.php?image=greenshot20090303144107.jpg][IMG]http://img9.imageshack.us/img9/1411/greenshot20090303144107.th.jpg[/IMG][/URL]

    I put a screenshot of other of my account for comparing

    Thanks
    Excuse my language. I’m from Canary Islands

  100. Doug Castell Says:

    sorry if it seems obvious, but double-check your username and password?

  101. GoldMineRealEstate Says:

    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

  102. Doug Castell Says:

    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. ;)

  103. wiesele Says:

    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

  104. Doug Castell Says:

    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.

  105. howard Says:

    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.

  106. howard Says:

    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.

  107. Doug Castell Says:

    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)

  108. BeauDog Says:

    Using GM 6.7 (single client; no server)

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

  109. Doug Castell Says:

    No, Stunnel allows GoldMine versions without native SSL support to access gmail via pop3 and SSL. IMAP is not part of the discussion.

  110. Apache Says:

    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

  111. ebupp Says:

    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?

  112. tmark Says:

    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?

  113. SugarHooves Says:

    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

Leave a Comment

You must be logged in to post a comment.

Castell Computers

links:

categories:

search site:

getting help:

request immediate remote desktop support:
Request Remote Desktop Support NOW

call 310.601.4738








e mail Doug

Send a Yahoo Instant Message

Send an ICQ instant message

Send an AOL Instant Message

login:

RSS feeds:

email alerts:

Subscribe

commenting:

buttons:

FrontRange Premier Partner

GoldMine

W-Mobile

MasterMine

View Doug Castell's profile on LinkedIn

Add to Technorati Favorites

Valid XHTML 1.0 Transitional

Creative Commons Attribution-Noncommercial-Share Alike 3.0 License

pspad

hacker glider

Jaguar Hosting Reseller

Pay for services with Paypal

27 queries. 0.196 seconds