Skip to main content

Hey everyone,

Im running into the following problem:

I am using the import_api of Indicium to import an Excel file via our own universal application. For this, I have two HTTP connectors in my process flow. One for setting up the staging table and one for committing the staging table.

We want the HTTP connectors go to the following URL’s:

https://host_name/indicium/iam/my_appl/my_parent_table(1)/detail_my_detail_table/stage_import

https://host_name/indicium/iam/appl_staged_import_my_table(<guid>)/commit

Through insomnia this works fine and well.

 

However when try to run this in our application through the following process flow:

 

 

We get the following indicium logs message:

2024-08-05T11:52:23.5801350+02:00 2ERR] Process action "http_connector_staging" in process flow "read_premium_prolongation" in application 13 threw an exception. (dedd009e)

System.Net.WebException: The SSL connection could not be established, see inner exception.

 ---> System.Net.Http.HttpRequestException: The SSL connection could not be established, see inner exception.

 ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host..

 ---> System.Net.Sockets.SocketException (10054): An existing connection was forcibly closed by the remote host.

 

Since this process action is executed by indicium on the webserver I think the problem lies in that we use the https://host_name/indicium instead of https://ip_address/indicium. Since the https://host_name/indicium cannot be called from the webserver itself.

However we cant use https://ip_address/indicium since the web certificate for a SSL connection is applied on the host name and not the ip address. This results in an unsecure connection

If we try to use the https://ip_address/indicium/iam/my_appl/my_parent_table(1)/detail_my_detail_table/stage_import

We get the following message:

System.Net.WebException: The SSL connection could not be established, see inner exception.

 ---> System.Net.Http.HttpRequestException: The SSL connection could not be established, see inner exception.

 ---> System.Security.Authentication.AuthenticationException: The remote certificate is invalid according to the validation procedure: RemoteCertificateNameMismatch

 

And I believe it’s not possible to create a (SSL) certificate for an ip_address to make this connection possible.

 

What can I do to get the import API to work through a process flow executed by indicium via a HTTPS call?

 

With kind regards,

Jeffrey

Hi Jeffrey,

You should be able to use the hostname but probably this does not work due to some DNS settings.

From your own develop machine, you are probably allowed to go to “https://<server>”, for instance “https://dvdb-dev.thinkwise.com”.

If you try to do this from the browser on your server, it probably does not work. 

If that is the case, you should be able to configure some internal DNS in your network to make sure it can resolve the DNS name.

 

You can even cheat by adding a line on the server to this file: C:\windows\system32\drivers\etc\hosts. If you add 127.0.0.1 dvdb-dev.thinkwise.com it probably starts working.

But I do recommend setting up some internal DNS record on your DNS server. You should probably ask someone from your IT infra department.

Regards,

Dick van den Brink


Hey Dick,

 

Editing the hosts file works.

I'll take it up with the IT department to fix it in the DNS

Thanks for the quick response.

 

With kind regards,

Jeffrey