topic Re: Can't get through proxy server in Talend Studio

Can't get through proxy server

Anonymous — Sat, 16 Nov 2024 14:21:39 GMT

I can't get through my company proxy server. I know the problem is proxy related because everything works fine when I try running the job at home (no proxy). The job is a simple data pull from Salesforce.com to a flat file.
FWIW, when I scan for update, that fails too with a network error (sorry I tried to copy the error message but TOS would let me copy the text from the dialog box).
Here's the SNIPED output from
"Help -> About Talend Open Studio -> Configuration Details".
As you can see I've got something entered for the proxy.

http.nonProxyHosts=localhost|127.0.0.1
http.proxyHost=proxy.my_company.com <--- I changed the domain name for security reasons
http.proxyPort=8080
http.proxySet=true
.
<snip>
.
/instance/org.eclipse.core.net/proxyData/HTTP/host=proxy.my_company.com
.
<snip>
.
/instance/org.eclipse.core.net/proxyData/HTTP/hasAuth=false
.
<snip>
.
/instance/org.eclipse.core.net/proxyData/HTTP/port=8080

FWIW, here's the error message when I run my job (notice timeout error);

Starting job test at 16:09 22/05/2008.
Exception in component tSalesforceInput_1
AxisFault
 faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
 faultSubcode: 
 faultString: java.net.ConnectException: Connection timed out: connect
 faultActor: 
 faultNode: 
 faultDetail: 
	{http://xml.apache.org/axis/}stackTrace:java.net.ConnectException: Connection timed out: connect
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.PlainSocketImpl.doConnect(Unknown Source)
	at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
	at java.net.PlainSocketImpl.connect(Unknown Source)
	at java.net.SocksSocketImpl.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at com.sun.net.ssl.internal.ssl.SSLSocketImpl.connect(Unknown Source)
	at com.sun.net.ssl.internal.ssl.SSLSocketImpl.<init>(Unknown Source)
	at com.sun.net.ssl.internal.ssl.SSLSocketFactoryImpl.createSocket(Unknown Source)
	at org.apache.axis.components.net.JSSESocketFactory.create(JSSESocketFactory.java:92)
	at org.apache.axis.transport.http.HTTPSender.getSocket(HTTPSender.java:191)
	at org.apache.axis.transport.http.HTTPSender.writeToSocket(HTTPSender.java:404)
	at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:138)
	at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
	at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
	at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
	at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)
	at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
	at org.apache.axis.client.Call.invoke(Call.java:2767)
	at org.apache.axis.client.Call.invoke(Call.java:2443)
	at org.apache.axis.client.Call.invoke(Call.java:2366)
	at org.apache.axis.client.Call.invoke(Call.java:1812)
	at com.sforce.soap.partner.SoapBindingStub.login(SoapBindingStub.java:1934)
	at org.talend.salesforce.SforceManagementImpl.login(SforceManagementImpl.java:85)
	at java_test.test_0_1.test.tSalesforceInput_1Process(test.java:250)
	at java_test.test_0_1.test.runJobInTOS(test.java:605)
	at java_test.test_0_1.test.main(test.java:523)
	{http://xml.apache.org/axis/}hostname:MBARFIELDGX620
java.net.ConnectException: Connection timed out: connect
	at org.apache.axis.AxisFault.makeFault(AxisFault.java:101)
	at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:154)
	at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
	at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
	at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
	at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)
	at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
	at org.apache.axis.client.Call.invoke(Call.java:2767)
	at org.apache.axis.client.Call.invoke(Call.java:2443)
	at org.apache.axis.client.Call.invoke(Call.java:2366)
	at org.apache.axis.client.Call.invoke(Call.java:1812)
	at com.sforce.soap.partner.SoapBindingStub.login(SoapBindingStub.java:1934)
	at org.talend.salesforce.SforceManagementImpl.login(SforceManagementImpl.java:85)
	at java_test.test_0_1.test.tSalesforceInput_1Process(test.java:250)
	at java_test.test_0_1.test.runJobInTOS(test.java:605)
	at java_test.test_0_1.test.main(test.java:523)
Caused by: java.net.ConnectException: Connection timed out: connect
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.PlainSocketImpl.doConnect(Unknown Source)
	at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
	at java.net.PlainSocketImpl.connect(Unknown Source)
	at java.net.SocksSocketImpl.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at com.sun.net.ssl.internal.ssl.SSLSocketImpl.connect(Unknown Source)
	at com.sun.net.ssl.internal.ssl.SSLSocketImpl.<init>(Unknown Source)
	at com.sun.net.ssl.internal.ssl.SSLSocketFactoryImpl.createSocket(Unknown Source)
	at org.apache.axis.components.net.JSSESocketFactory.create(JSSESocketFactory.java:92)
	at org.apache.axis.transport.http.HTTPSender.getSocket(HTTPSender.java:191)
	at org.apache.axis.transport.http.HTTPSender.writeToSocket(HTTPSender.java:404)
	at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:138)
	... 14 more
Job test ended at 16:10 22/05/2008.

Re: Can't get through proxy server

Anonymous — Fri, 23 May 2008 03:25:35 GMT

Hello
Which version of TOS are you using?
Best regards

shong

Re: Can't get through proxy server

Anonymous — Fri, 23 May 2008 03:39:39 GMT

I'm using version 2.3.3 (both Windows & Linux)

Re: Can't get through proxy server

Anonymous — Sat, 24 May 2008 22:44:49 GMT

The TOS proxy configuration is totally independant from the job execution.
Please report a new feature in our bugtracker on the Salesforce component.
HTH

Re: Can't get through proxy server

Anonymous — Tue, 27 May 2008 21:27:59 GMT

I'm sorry if I'm not making this clear, but I'm not sure if you understand the issue. Bear with me as I'm new to TOS.
I'll restate the problem and limit myself to the simplest case.
I have installed version 2.4 RC2 (I have the same problem with ALL versions of TOS) (Windows & Linux). My office is behind a proxy server. I can't communicate past the proxy server while using/in TOS. Here are some screen shots when I try to update TOS.
This is the dialog box after selecting Help->Software Updates->Find and Install

I click on the Finish button and then get this dialog box

After 30 -60 seconds the dialog box displays this message

My first post in this thread lists the all (?) the variables for the TOS proxy settings. This is the dialog box I entered the values into after a fresh install.

I entered my proxy address in the following format (no quotes);
"proxy.my_company.com"
I entered my port number in the following format (no quotes);
"8080"
When I try this from my network at home without a proxy server or the proxy settings, it works fine.
TIA,
Mike

Re: Can't get through proxy server

Anonymous — Tue, 27 May 2008 23:36:23 GMT

Hello,
It's not really easy to explain.
As you may know, Talend is a Code Generator.
Even if sometime you run your code in TOS, the final goal is to export it as an independant unit.
So the code generated by Talend Open Studio is extremely independant from Talend Open Studio "application".
Moreover, your proxy settings are maybe not the same on TOS client side than in your running job.
That's why there is no relation.
In order to connect to Salesforce through a proxy, you will need a new feature in tSalesForce component.
Do you see what I mean ?

Re: Can't get through proxy server

Anonymous — Wed, 28 May 2008 15:26:52 GMT

Yes I understand that TOS is a code generator and that the resulting code is independent of TOS. The generated code must deal with the proxy, not the TOS "application" (but it would be nice if it did ).
What I still don't understand is why I can't traverse the proxy to upgrade TOS as outlined in my prior post.
Also, would you suggest I open a new feature request in bugtracker for generated code to traverse a proxy? This affects more than just Salesforce, example - any database server on the other side of a proxy.
Thanks for you patience and help,
Mike