ZOHO integration in Community Edition 6.3.0

[Catscratch]

Hi,

I saw the new ZOHO integration feature in the changelog and wanted to test it. But right now, I got two problems.

1. What is the zoho.secret.key ?
I may only create an api key on the ZOHO website, but there is no secret key.

2. I can't use ZOHO
If I select e.g. an odt document, nothing about ZOHO shows up in the Tools menue. So, how may I use/activate ZOHO?

Regards.

[jllort]

I've update http://wiki.openkm.com/index.php/Zoho_Docs now is described how to enable it

[Catscratch]

Thank you!

But zoho.secret.key still remains in the documentation...what is it? On the ZOHO webseite there is no secret key option.

Anyway, I tried the ZOHO extension and it opens up documents very well. But on saving any changes it get:

Code: Select all

Error in saving content. Please retain a local copy at your end and try again later

The log file shows nothing interessting. Can you give me a hint whats going wrong here?

Thanks!

[jllort]

Take in mind zoho must be able to communicate to your server from internet. That mean your application.url must be configured with some url be available from internet to zoho. What I think is trying to say is that zoho server is not able to connect to openkm server to save document.

About zoho.secret.key I can not say much, there's about 1-2 years I've not created a zoho account. At the moment we wrote the documentation -> "You can obtain the user and password registering at http://zapi.zoho.com. Once registered and logged, you can request the API Key and the Secret Key. In the Zoho Dashboard you can also check how many edition request you have performed. ". I'm not sure now secret key be mandatory ? if you arrived to the point that zoho tries to save data and cannot ( without setting zoho key could indicate now is not mandatory or deprecated, but I'm not sure about it ).

[Catscratch]

Ok, first of all. My application url seems to be accessable from overall.
It looks like this: https://openkm.

And also there is no secret key in the ZOHO Dashboard.


So, do you have any advice, what the problem could be? Maybe something with the secure http connection (https)? And also, editing with ZOHO is working, but I can't save the documents back.

[baolinhtv]

i think secret key is authtoken

you can generate it here : https://www.zoho.com/creator/help/api/p ... token.html

but i still can't save it

my url is local ip 192.168.1.2:8080

[Catscratch]

I think auth token is only for ZOHO CRM.

But I found out, that you have to use a valid domain name for saving documents back. [1] Otherwise you'll get an error.

Also I found out, that there is a problem when using https-connections. [2] Regarding to this website, only specific certificates are working for ZOHO. I don't know, if there is a way to use certificates by other CA's.

[1] https://forums.zoho.com/topic/zoho-writ ... ng-problem
[2] https://apihelp.wiki.zoho.com/Zoho-API- ... pport.html

[baolinhtv]

I think auth token is only for ZOHO CRM.

But I found out, that you have to use a valid domain name for saving documents back. [1] Otherwise you'll get an error.

Also I found out, that there is a problem when using https-connections. [2] Regarding to this website, only specific certificates are working for ZOHO. I don't know, if there is a way to use certificates by other CA's.

[1] https://forums.zoho.com/topic/zoho-writ ... ng-problem
[2] https://apihelp.wiki.zoho.com/Zoho-API- ... pport.html

my server don't have domain, it only have internet ip address ... how to fix it ?

[Catscratch]

There is no way, since ZOHO doesn't allow the usage of IP adresses. Mabye you can use some kind of DNS service to redirect a hostname to your IP. You could use dyndns (but I think they stopped the free license model) or selfhost. Or if you got a fritzBox you can use myFritz. I think there are a lot of english providers, too. But I don't know any of them.

If you find a good one, let me know it.

[baolinhtv]

There is no way, since ZOHO doesn't allow the usage of IP adresses. Mabye you can use some kind of DNS service to redirect a hostname to your IP. You could use dyndns (but I think they stopped the free license model) or selfhost. Or if you got a fritzBox you can use myFritz. I think there are a lot of english providers, too. But I don't know any of them.

If you find a good one, let me know it.

If there is no way, i will test with noip.com .

[pavila]

ZOHO need to be able to connect to your OpenKM instance. So your OpenKM need to be visible from Internet.

[Catscratch]

Yes, I know. My instance is visible to the world. But like I wrote, it seems to be a problem with the https certificate.

Did you ever tested the ZOHO integration with a https connection or only with a http connection?

[jllort]

No sir, we've never tested with https connection. Do you see some error in catalina.log ?

[Catscratch]

I contacted the ZOHO support and they confirmed the certificate problem. We're together working on a solution, but the only way seems to be to extend the pool of working certificate authorities (CAs) on ZOHOs side. And they told me, that this could take a long time (about several weeks or months).

So right now I would say. ZOHO integration over https in openkm is not possible, if you do not use one of the specified CAs to sign your server certificate (which costs additional money).

[jllort]

Any news on it, post here and after all we will change documentation to advice about it other possible zoho users.