Skip to main content

Hi

I want to configure IFS9 with proxy server to expose b2b/b2e URL to internet.
So I created new domain: pp.nazwa.pl with redirection on proxy server to application server(SSL Offloading HTTPS -> Proxy -> HTTP).
On proxy trusted certificate was uploaded. Everything works fine beside two our customizations which make connection to outside https URL(https://aaa.pl and https://bbb.pl) and get data.

What I did:

  • IFS9 reconfiguration done. SSL is off, redirect URL is set to: https://pp.nazwa.pl
  • ACL list is configured: for *.pp.nazwa.pl for port 443, 58443
  • Oracle version: WINDOWS DB BUNDLE PATCH 12.1.0.2.170418(64bit):25632533
  • Oracle wallet created and all certificate chain imported for pp.nazwa.pl without last one *.nazwa.pl
  • plsqlap_environment_tab: CONN_STR -> https://pp.nazwa.pl/fndext/soapgateway, SSL_WALLET_PATH -> file:C:\Oracle\owm and also SSL_WALLET_PASSWORD(is it needed?)

... but I have got still error:

  • ORA-29273: HTTP request failed
  • ORA-29259: end-of-input reached

for this select statement:
SELECT utl_http.request('https://pp.nazwa.pl/fndext/soapgateway', null, 'file:C:\Oracle\owm', 'ifsmanager2022!') FROM dual; 

Web services are properly listed on https://pp.nazwa.pl/fndext/soapgateway
Standard configuration without proxy http://prod.local.domain:58080 works well

What should i check?Should I import external URL(https://aaa.pl and https://bbb.pl) certificates to proxy server?

I am not very familiar with SSL /TLS connection. Any ideas?

Terms & ConditionsCookie settings