Connection problem on MS OFFICE Addin for OpenKM CE 6.3.11

[man999jack]

Hi, I am using OpenKM CE 6.3.11. As I would to integrate the usage with microsoft office 2016, I also installed MS Offic OKM Addin 6.1.2 . In the Configuration dialog, I have to choose Com 6.0+ for "OpenKM Version" and use http address for "Host". Is it possible to connect through HTTPS or by REST? Thank you.

[jllort]

It is possible connect with SSL ( https ). What is the problem with your connection, share a screenshot with your configuration parameters and should be a log file in "My Documents/OpenKM" folder what maybe describe better the problem.

[man999jack]

Configuration
111E8B4E-406F-4535-B60F-86E5F1E52F51.jpeg (29.7 KiB) Viewed 2249 times

I use the above configuration where my okm server ip is 192.168.56.101. If i press “Test”, rhe following error is prompted

Connection failed
D5E8B36E-5D5B-47D8-B87F-36462FD60EEA.jpeg (6.37 KiB) Viewed 2249 times

I also attached the log file for your information. Thank you for your help.

[pherrera]

Hi,

Check that you have the correct version of the add-in: https://docs.openkm.com/kcenter/view/mi ... patibility

In your case, it is up to you to use version 6.1.3 of the Ad-in.
You can see the documentation for the add-in configuration:https://docs.openkm.com/kcenter/view/mi ... .9andupper

And the installer has it here (final part in Utilities): https://www.openkm.com/en/download.html or http://download.openkm.com/okm/com/msad ... -6.1.3.zip

Remember to uninstall version 6.1.2 from the control panel and just proceed with the installation of 6.1.3.

Regards,

[man999jack]

Thank you for your reply. I have also tried version 6.1.3 but it‘s still unable to connect by https.

[jllort]

Share the log for better understanding ( will find it in your My documents\OpenKM folder )

[man999jack]

I attached the log of using version 6.1.2 in my previous post. I also attached the log of 6.1.3 in here for your reference.

WordAddinLog_6_1_3.pdf

(47.08 KiB) Downloaded 109 times

It is strange that I could access my openkm server via HTTPS with using web browser (eg Chrome). But it failed with using the MS office addin. Is there any setting or configuration that I have missed?

Thanks again for your attention.

[jllort]

In the log, I do not see any kind of error.
After you set credentials in the configuration windows to have the option to check. Click on the check button -> did you receive an error there?

[man999jack]

Yes, I did press the “Test” button after inputting the credentials. An error “Connection test failed!!!” was shown, like I posted at #53265 before.

[jllort]

In the OpenKM configuratoin window at the value of version, is the option "Com 6.0+" the greatest or do you have a big one? try with the biggest

[man999jack]

I think “Com 6.0+” is the greatest one. This is the available choices:

2D72D18C-1311-4E9A-8BD1-5B3C1F390382.jpeg (53.22 KiB) Viewed 1910 times

I have tried each of them anyway. With using HTTP, only “Com 6.0+” could successfully establish the connection. With using HTTPS, all of them shows “Connection test failed!!!”.

[pherrera]

Hi,

Only use version 6.1.3, 6.1.2 is not compatible with your version of OpenKM.

If it does not connect via https it is because you need to configure the correct security protocol on your server, with TLS 1.2 and TSL1.3 it should work, if not, add TLS1.0 and TLS1.1.

[man999jack]

Thanks for your insight. You are right that this is about the TLS version. By using wireshake, i found that the office addon program try to initiate TLS 1.0 connection, which is not allowed by the server….

May I ask if there is any plan to update the addon program so that it support TLS 1.2 or above? Thank you.

[pherrera]

Hi,

The next version of the SDK for .net will be released with version 4.7.2 of the NETFramework and will allow working with the TLS1.3 protocol.
Meanwhile, you will have to configure the TLS 1.0 protocol on your server.