shkking0516 opened a new issue, #7795:
URL: https://github.com/apache/hop/issues/7795

   ### Apache Hop version?
   
   2.18.1
   
   ### Java version?
   
   Microsoft OpenJDK 21.0.12
   
   ### Operating system
   
   Windows
   
   ### What happened?
   
   ### Apache Hop version
   
   2.18.1
   
   ### Java version
   
   Microsoft OpenJDK 21.0.12
   
   ### Operating system
   
   Windows Server
   
   ### What happened?
   
   Salesforce Username/Password authentication works correctly through an 
explicit HTTP proxy.
   
   Salesforce OAuth JWT metadata connection test also succeeds and an access 
token is obtained successfully.
   
   However, when a Salesforce Input transform is executed using the OAuth JWT 
metadata connection, Hop fails to connect to the Salesforce instance SOAP 
endpoint:
   
   https://ahnlab.my.salesforce.com/services/Soap/u/64.0
   
   The error is:
   
   java.net.ConnectException: Connection timed out: getsockopt
   
   The same instance URL is reachable successfully through the configured proxy 
using curl and returns HTTP 405, which is expected because the SOAP endpoint 
only allows POST.
   
   It appears that the PartnerConnection created after the OAuth JWT token 
exchange does not inherit or use the configured JVM HTTP proxy settings.
   
   ### Expected behavior
   
   The Salesforce SOAP PartnerConnection created after OAuth JWT token exchange 
should use the configured JVM HTTP/HTTPS proxy settings, in the same way as the 
Username/Password Salesforce connection.
   
   ### Steps to reproduce
   
   1. Run Apache Hop with the following JVM options:
   
   ```text
   -Dhttp.proxyHost=172.25.1.15
   -Dhttp.proxyPort=3128
   -Dhttps.proxyHost=172.25.1.15
   -Dhttps.proxyPort=3128
   
   2. Create a Salesforce metadata connection using Username/Password.
   3. Execute a Salesforce Input transform.
   4. Confirm that data is returned successfully.
   5. Create a Salesforce metadata connection using OAuth JWT Bearer.
   6. Confirm that Test Connection succeeds.
   7. Execute the same Salesforce Input transform using the OAuth JWT 
connection.
   8. The transform times out while connecting to the returned Salesforce 
instance URL.
   
   Relevant log
   com.sforce.ws.ConnectionException:
   Failed to send request to
   https://ahnlab.my.salesforce.com/services/Soap/u/64.0
   
   Caused by:
   java.net.ConnectException:
   Connection timed out: getsockopt
   Additional information
   
   Proxy connectivity to the Salesforce instance URL was verified successfully:
   
   curl -vk -x http://172.25.1.15:3128 \
   https://ahnlab.my.salesforce.com/services/Soap/u/64.0
   
   Result:
   
   HTTP/1.1 200 Connection Established
   HTTP/2 405
   Only POST allowed
   
   This confirms that the Salesforce instance endpoint is reachable through the 
proxy.
   
   ### Issue Priority
   
   Priority: 2
   
   ### Issue Component
   
   Component: Transforms


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to