LotusNotes-Google Calendar Synchronizer / Discussion / Open Discussion: Connection Refused

David Cryans - 2014-11-18

Hi!

Has anyone seen this before? I've worked on it since this morning.
(I was using Calsync, but since November 17th, Google enforced Api v3)

I'm getting a connection refused when syncing.

I know my credentials are good, I got them when using internet by USB tethering on my phone.

When I connect back to my office's network and run the "GCalConnectivityTest", I get a connection refused.

Thank you!

Here's the log:
=== Get list of Google calendars.
There was a problem connecting to Google Calendar.
java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.security.ssl.SSLSocketImpl.connect(Unknown Source)
at sun.net.NetworkClient.doConnect(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.<init>(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.New(Unknown Source)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown Source)
at sun.net.www.protocol.https.HttpsURLConnectionImpl.connect(Unknown Source)
at com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:93)
at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:965)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientReq
uest.java:410)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientReq
uest.java:343)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.jav
a:460)
at gcalconnectivitytest.GCalConnectivityTest.main(GCalConnectivityTest.java:101)

=== Connectivity test FAILED!

Last edit: David Cryans 2014-11-18

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Michael Belt - 2014-11-19

A lot of programs using Google Calendar API went off-line on the 17th. Calsync did. Calendar Widget did.

https://sourceforge.net/p/lntogoogle/discussion/1072332/thread/506390fc/?limit=25#c11a

https://wordpress.org/support/topic/403-forbidden-on-cal-url-deprecated-api

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Michael Belt - 2014-11-19

I download v 2.5.5 & it seems to be fixed.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dean Hill - 2014-11-20

David,

I haven't seen that particular error before.
Please post the full output from running GCalConnectivityTest.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

David Cryans - 2014-12-04

Hi Dean,

Thank you for the quick reply. I will come here more often.

Complete output from GCalConnectivityTest:
Log form LNSync 2.6 will follow

Note: If this is your first time running this application, a web browser window
should open and ask you to allow access to your Google Calendar.
You need to press Accept then return to this window to see the test results.
Press enter to continue...

=== Setting up for test.
dÚc. 04, 2014 9:22:53 AM com.google.api.client.util.store.FileDataStoreFactory setPermissionsToOwnerOnly
AVERTISSEMENT: unable to change permissions for everybody: J:\LNGoogleCalSync\GCalConnectivityTest - 1
dÚc. 04, 2014 9:22:53 AM com.google.api.client.util.store.FileDataStoreFactory setPermissionsToOwnerOnly
AVERTISSEMENT: unable to change permissions for owner: J:\LNGoogleCalSync\GCalConnectivityTest - 1
Success

=== Using Client ID to create credential.
Success

=== Get list of Google calendars.
There was a problem connecting to Google Calendar.
java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.security.ssl.SSLSocketImpl.connect(Unknown Source)
at sun.net.NetworkClient.doConnect(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.<init>(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.New(Unknown Source)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(Unknown Source)
at sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(Unknown Source)
at com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:77)
at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:965)
at com.google.api.client.auth.oauth2.TokenRequest.executeUnparsed(TokenRequest.java:283)
at com.google.api.client.auth.oauth2.TokenRequest.execute(TokenRequest.java:307)
at com.google.api.client.auth.oauth2.Credential.executeRefreshToken(Credential.java:570)
at com.google.api.client.auth.oauth2.Credential.refreshToken(Credential.java:489)
at com.google.api.client.auth.oauth2.Credential.intercept(Credential.java:217)
at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:859)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientReq
uest.java:410)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientReq
uest.java:343)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.jav
a:460)
at gcalconnectivitytest.GCalConnectivityTest.main(GCalConnectivityTest.java:101)

=== Connectivity test FAILED!
Try reading the Troubleshooting section of HelpFile.html.
This help file is included with the main LNGS application.
If you need additional help, post to the Open Discussion forum:
https://sourceforge.net/projects/lngooglecalsync/forums

LNSync 2.6 Log:

Starting sync - 14-12-04 09:03:41
Date range: 14-12-03 thru 14-12-05 (-1 to +1 days)
Getting Lotus Notes calendar entries (13.9 s)
6 Lotus entries found within date range
Logging into Google (2.0 s)

=== ERROR ===
There was an error synchronizing.
See Troubleshooting in the Help file.
This screen output is also in lngsync.log.
lngs.util.LngsException: Unable to create Google calendar.

at lngs.google.GoogleManager.connect(GoogleManager.java:169) at lngs.MainGUI.doSync(MainGUI.java:365) at lngs.MainGUI$SyncSwingWorker.doInBackground(MainGUI.java:491) at lngs.MainGUI$SyncSwingWorker.doInBackground(MainGUI.java:481) at javax.swing.SwingWorker$1.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at javax.swing.SwingWorker.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)

Caused by: java.net.ConnectException: Connection refused: connect

at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method) at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source) at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source) at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source) at java.net.AbstractPlainSocketImpl.connect(Unknown Source) at java.net.PlainSocketImpl.connect(Unknown Source) at java.net.SocksSocketImpl.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at sun.security.ssl.SSLSocketImpl.connect(Unknown Source) at sun.net.NetworkClient.doConnect(Unknown Source) at sun.net.www.http.HttpClient.openServer(Unknown Source) at sun.net.www.http.HttpClient.openServer(Unknown Source) at sun.net.www.protocol.https.HttpsClient.<init>(Unknown Source) at sun.net.www.protocol.https.HttpsClient.New(Unknown Source) at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(Unknown Source) at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source) at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown Source) at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(Unknown Source) at sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(Unknown Source) at com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:77) at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:965) at com.google.api.client.auth.oauth2.TokenRequest.executeUnparsed(TokenRequest.java:283) at com.google.api.client.auth.oauth2.TokenRequest.execute(TokenRequest.java:307) at com.google.api.client.auth.oauth2.Credential.executeRefreshToken(Credential.java:570) at com.google.api.client.auth.oauth2.Credential.refreshToken(Credential.java:489) at com.google.api.client.auth.oauth2.Credential.intercept(Credential.java:217) at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:859) at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:410) at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:343) at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:460) at lngs.google.GoogleManager.createCalendar(GoogleManager.java:214) at lngs.google.GoogleManager.connect(GoogleManager.java:167) ... 9 more

Finished sync (15.9 s total) - 14-12-04 09:03:57

Last edit: David Cryans 2014-12-04
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dean Hill - 2014-12-10

David,

Are you running on a work network? Does it use a proxy server?

Can you try running GCalConnTest on a home or public network and post the output?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

David Cryans - 2014-12-11

Hi Dean,

Yes my work network has some protection, it blocks mail.google.com, but doesn't block www.google.com/calendar.

I don't know what type of protection is used.
It's not a proxy that I can set up in Chrome or Internet Explorer or LNSync.

There is no problem on a home network except that I can't access Lotus Notes outside of the work network.

Is there a way to know which URL LNSync was using when I got a Connection Refused?

Is there a way to do a deferred Sync?
- Load data from Lotus in a file or memory
- Let me change to another network
- Send to google

Thank you again for your time!

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dean Hill - 2014-12-16

Let's try to verify your proxy information by using TCPView from Microsoft: http://technet.microsoft.com/en-us/sysinternals/bb897437.

Just unzip and run it. Then browse to Google Calendar. In TCPView, under "Process" look for your browser (e.g. iexplor.exe). The proxy address should be under "Remote Address", e.g. "tus-proxy.ext.com". Enter that proxy address and port in LNGS.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

David Cryans - 2014-12-17

Wow, nice tool!

So there is a proxy: secproxyp2.ext.cie.com on remote port 8080. (ext = external)

I tried it in LNSync, with and without the port, with and without my username/password.

I see javaw.exe in TCPView still uses dommsg01.int.cie.com (int = internal)

That's a fancy proxy, I'm a Mainframe guy, I'm trying to Google search my way through it, but I'm probably not searching with the right words.

Starting sync - 14-12-17 09:18:36
Application Version: 2.6
OS: Windows 7 6.1 x86
Java: 1.7.0_71 Oracle Corporation
Java Home: C:\Program Files (x86)\Java\jre7
Java Classpath: J:\LNGoogleCalSync\LNGoogleCalSync 2.6\lngsync.jar
Java Library Path: C:\Program Files (x86)\Java\jre7\bin;C:\windows\Sun\Java\bin;C:\windows\system32;C:\windows;C:\windows\system32;C:\windows;C:\windows\System32\Wbem;C:\windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\E!PC\;C:\Program Files (x86)\IDM Computer Solutions\UltraEdit-32\;C:\Program Files (x86)\Lotus\Notes;J:\LNGoogleCalSync\lib;C:\Program Files (x86)\Java\jre7\bin;.
Local Server: false
Destination Calendar: videotron
Local Date Format: aa-MM-jj
Server Date Format: Detect
Use Proxy: true
Use Proxy Username: true
Sync On Startup: false
Sync All Subjects To Value: false
Sync Location and Room: true
Sync Description: true
Sync Alarms: true
Sync Days In Past: 1
Sync Days In Future: 1
Date range: 14-12-16 thru 14-12-18 (-1 to +1 days)
Getting Lotus Notes calendar entries
Using Detected Server Date Format: yyyy-MM-dd
Calendar query: SELECT (!@IsAvailable($Conflict) & @IsAvailable(CalendarDateTime) & (@Explode(CalendarDateTime) *= @Explode(@TextToTime("2014-12-16 - 2014-12-18"))))
Number of query results: 5
Getting Lotus Notes calendar entries (done in 5.3 s)
5 Lotus entries found within date range
Lotus Version: Release 8.5.3FP5|August 01, 2013
Logging into Google
Found Client ID file: J:\LNGoogleCalSync\LNGoogleCalSync 2.6\client_secret_810645997807-pfq71oiu5b5cvglk20fr2r8434d065bt.apps.googleusercontent.com.json
Logging into Google (done in 1.2 s)

=== ERROR ===
There was an error synchronizing.
See Troubleshooting in the Help file.
This screen output is also in lngsync.log.
lngs.util.LngsException: Unable to create Google calendar.
at lngs.google.GoogleManager.connect(GoogleManager.java:169)
at lngs.MainGUI.doSync(MainGUI.java:365)
at lngs.MainGUI$SyncSwingWorker.doInBackground(MainGUI.java:491)
at lngs.MainGUI$SyncSwingWorker.doInBackground(MainGUI.java:481)
at javax.swing.SwingWorker$1.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at javax.swing.SwingWorker.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.security.ssl.SSLSocketImpl.connect(Unknown Source)
at sun.net.NetworkClient.doConnect(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.<init>(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.New(Unknown Source)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(Unknown Source)
at sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(Unknown Source)
at com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:77)
at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:965)
at com.google.api.client.auth.oauth2.TokenRequest.executeUnparsed(TokenRequest.java:283)
at com.google.api.client.auth.oauth2.TokenRequest.execute(TokenRequest.java:307)
at com.google.api.client.auth.oauth2.Credential.executeRefreshToken(Credential.java:570)
at com.google.api.client.auth.oauth2.Credential.refreshToken(Credential.java:489)
at com.google.api.client.auth.oauth2.Credential.intercept(Credential.java:217)
at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:859)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:410)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:343)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:460)
at lngs.google.GoogleManager.createCalendar(GoogleManager.java:214)
at lngs.google.GoogleManager.connect(GoogleManager.java:167)
... 9 more

Finished sync (6.6 s total) - 14-12-17 09:18:43

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dean Hill - 2014-12-22

I found a bug in LNGS where it wasn't picking up changes to the proxy name and port.
Please replace your current lngsync.jar file with the attached version.

Then re-run your tests:

So there is a proxy: secproxyp2.ext.cie.com on remote port 8080. (ext = external)
I tried it in LNSync, with and without the port, with and without my username/password.

lngsync.jar

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

David Cryans - 2014-12-30

Happy New Year!

Will share with peers ASAP.

Donated a small contribution, please keep this app running!

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dean Hill - 2015-01-01

Thanks for the donation David. :-)

So, did the new jar file fix your proxy problem?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

David Cryans - 2015-01-05

Yes it did!

Thank you a thousand times for your support :)

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Connection Refused

Forums

Help

Connection Refused document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

Connection Refused