Setting up Yahoo, AT&T, SBCGlobal or Gmail in GoldMine (updated)
Posted by Deborah on August 12, 2008
Many email providers like Gmail, AT&T, Yahoo and SBCGlobal are moving to a secure sockets layer (SSL) method of securing email. GoldMine versions 6.7, 7.0 and 8.0 do not work directly with SSL but there is a way around that. (*See below for information on 7. 5)
1. Visit stunnel.org and choose Downloads. Select “Go to the download directory itself”. This will bring you to a directory – click on “win32″. Scroll down and find the most recent installer file which should be named similar to “stunnel-4.21-installer.exe”. Click on this file to download and save it to your computer. Run this executable to install the file.
2. Click Start | All Programs | Stunnel | Edit stunnel.conf
3. Modify as follows:
a. Find the line that reads
;client = yes
and remove the ;
b. modify the [pop3s] section as follows:
accept = 995
connect = “YOUR ISP SERVER NAME*”:995
(remove my quotes and plug in your ISP’s own pop server name, like pop.att.yahoo.com or ipostoffice.att.net
(A user of SBCGlobal told me that he needed to use 110 for the accept line but 995 in the connect line to retrieve email.)
c. modify the [ssmtp] section as follows:
accept = 465
connect = “YOUR ISP SERVER NAME*”:465
(remove my quotes and plug in your ISP’s own pop server name, like pop.att.yahoo.com or ipostoffice.att.net
The ports are standard, so they’re probably the ones your provider uses as well.
4. Now launch GoldMine and go to Edit\Preferences\Internet (Versions 6 or 7) or Tools\Options\Email (Version 8/Premium) and use “127.0.0.1″ in place of your POP/STMP server definitions on the accounts that require SSL. You can also use the server name, for example, mine is Solutus1.
5. Go to the Advanced Options window and set the ports to match the definitions you’ve just made in stunnel.conf. Also, you will probably have to activate the “This server requires authentication” option in the SMTP half of this window. Login/Plain worked fine for me.
6. Click Start>>All Programs>>Stunnel>>Service>>Install.
7. Click Start>>All Programs>>Stunnel>>Service>>Start.
(Thank you to Doug Castell for pointing me in the right direction.
*Update: Goldmine Version 7.5 has the ability to plug in SSL authentication. You no longer need the Stunnel workaround for GoldMine 7.5 It also has Windows login information (so if you change your password often, the email settings will use the new password without you having to change the Goldmine settings as well).
Jen said
Hi, I’m trying to set up Goldmine with a Google aps account. I’ve followed your instructions, but Goldmine keeps giving me this:
A protocol ERROR has occured in logging in or retrieving messages.
- ERR [AUTH] Username and password not accepted.
I’ve enabled pop within my gmail account, and have checked my username and password settings within Goldmine, but nothing works.
Also, my password is a 7 digit one, but when I go back into my Goldmine internet settings, it has 15 small *’s in the field. Is that normal?
Thanks for any help!
Jen
Jen said
I think I figured out the Error that I mentioned above, but now it’s saying:
535 5.7.1 Credentials rejected… I double and triple checked everything…
Why isn’t this working!?!?
Jen
Deborah said
You need to make sure the username and password are correct on the main account page and the SMTP login page under More Options.
As far as the password, Goldmine masks the password with the * to prevent hacking. That is normal.
Deborah said
I haven’t seen the “credentials” error before. There has got to be one piece missing. You put the “127.0.0.1″ in the server name area? Make sure the user name is the full email address.
Ken Thornton said
Stunnel worked great for me, just one question though. Can I use two of these stunnel profiles?
My home network will not send email on the same parameters as my work email. Typically I would change the default email account between home and work, but after having changed my home network to att now, it requires a different ssl setting. Can I run stunnel on one account with my work settings, and another one on a different account for my home settings?
Thanks for your input.
Ken
Deborah said
I haven’t tried multiple accounts. I would try to edit the section like this:
[pop3s]
accept = 995
accept = 95
connect = pop.gmail.com:995
connect = pop.whatever.com:95
and use a different port number for each account. Then set up Goldmine accounts for each port. Let me know what you find out.
Pat said
Trying to help a friend use sbcglobal email with Goldmine. Set it up as recommended, however, am not able to access the server.
The “127.0.0.1″ in place of the POP/STMP server definitions way displays an error that states “Connection refused. System error 10061.”
I also tried using the name of the computer and an error message states “Timed out waiting for response. System error 10060.”
Any thoughts?
Thanks so much in advance for any recommendations.
Pat
Deborah said
Make sure you are typing 127.0.0.1 in the server field. (Don’t use the quotes.)
Did you try ports 110 to accept and 995 to connect for SBCGlobal? Make sure they are changed in the stunnelconf file as well as Goldmine and each time you make a change to the Stunnel, you should stop and start it again.
Trevor said
Hi, Hope you have an idea for this error. I am using goldmine 6.7 and trying to connect to yahoo mail plus (pop3). Goldmine connects to 127.0.0.1 and soon after, the message “the socket was disconnected unexpectedly” I tried using 110 and 995 to accept and still no success. Any suggestions would be a great help. thanks trev
Deborah said
Trevor, can you paste the POP section of your stunnel.conf?
Trevor Finney said
Here it is… Thank you for your assistance. trevor
[pop3s]
accept = 995
connect = plus.pop.mail.yahoo:995
Deborah said
That looks right…I assume you got the POP server info from Yahoo…..did you verify the port is 995? Also, make sure you stop and then start the stunnel service.
Trevor Finney said
yes, port verified. started / stopped stunnel. even tried a few different versions. same result… “the socket was disconnected unexpectedly”. also tried swapping out 995 for 110.
trevor
Trevor Finney said
ok, fixed it. With Yahoo plus you have the option of not using the ssl protocol. set the incoming to 110 and the outgoing to 587 and avoid the entire ssl trap. stunnel is not required with these settings. Hope this helps someone else as well.
Deborah said
Thanks for the information!
Gina said
I am having the same issues with GoldMine 6.0 and new AT&T DSL, and am getting ready to download the Stunnel program. Once you have the Stunnel – does the email through GoldMine work exactly the same? Or do you have to run the stunnel program, at all times, when sending emails through GoldMine? If you could answer this, before I download, that would be helpful – thanks!
Deborah said
When you set it up, Stunnel runs in the background and just routes the port numbers. So basically Goldmine runs the same, you won’t know anything is different when retrieving email.
Tom said
As Trevor Finney did, I used the workaround for att.yahoo.net out=587, in=110 but I’m getting scolding messages from yahoo strongly suggesting I use SSL.
Is stunnel still the workaround?
Deborah said
Yes, Stunnel still works as a workaround – but Yahoo is right, Stunnel is not a SSL email client. What you will probably need to do eventually is change to a different ISP or email host or upgrade to Goldmine 7.5 or 8.5 which have SSL capabilities built in. (Goldmine 8.0 does not, but the upgrade to 8.5 should be happening this quarter.)
Guy said
Hi All,
I’ve done exactly what was to be set to have GMail imported in GM 6.7 and I still get the error :
A protocol ERROR has occured in logging in or retrieving messages.
- ERR [AUTH] Username and password not accepted.
As Jen previously encountered.
My user is the full email address@127.0.0.1
My Stunnel.log is :
[pop3s]
accept = 110
connect = pop.gmail.com:995
Since I tried the accept 995 and I got an error not even reaching GMail server as I do now.
I stop and started again the Stunnel service.
What else ? Jen how did you solve you AUTH problem ?
thanks
guy
Deborah said
Make sure the Ports are set correctly in Goldmine under Advanced settings. I guess I would try 110 and if that doesn’t work, 995. Although I have it working for gmail with 995 under Accept and Connect.
Also, check the Outgoing Server set up which is probably your ISP. If this is wrong you will also get an authentication error.
SamD said
I have not been able to get goldmine 6.7 to authenticate to att.yahoo.com using stunnel. Yes, I have tried all the configurations in the thread.
LeeH said
I too have tried to get GM 6.5 and att.yahoo.com running using stunnel. With the 127.0.0.1 in the server name and all the 995/465 setup, it does give any error messages. It does nothing!
Any other suggestions on getting att mail with GM?
LeeH said
correction…. It does not give any error messages!
Deborah said
It looks like the servers are pop.att.yahoo.com and smtp.att.yahoo.com.
Also, after changing the stunnel.conf, make sure to stop the service and then start the service again.
SamD said
Sorry, my message was meant to generically refer to the domain. I am using the correct servers. I am guessing that the signon information is not being properly transferred through Stunnel to the mail server or the secure socket is not being established.
LeeH said
I still cannit get stunnel to work..
here the config file
[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
GM will receieve or send log on to 127.0.0.1, they are set to 995 and 465 respectively.
Please help if you can…
LeeH said
Correction – stunnel will not receive or send e-mail