You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@chemistry.apache.org by Neza Guillaine <gn...@gmail.com> on 2016/05/18 16:03:43 UTC
Requesting for help in querying sharepoint 2010 Via CMIS workbench
Hi Devs and Florian,
My name is Neza. I am writing request for your help in cmis.
I had tried using cmis workbench to query documents from the alfresco side
and it work perfectly, but when I moved to the sharepoint side, every
single thing i do in my query return a: Runtime: Unauthorized exception. IT
seems that queried from sharepoint are not being interpreted. Even if I do
something very basic lile:
SELECT * from cmis:document.
This have been running me crazy, I googled alot around since monday and did
not et any answer to my case. A few suggestions but nothing let me to the
solution.
If you have already encountered this issue or can provide help, I would
appreciate.
My cmis workbench is: 0.13.0 and SP 2010.
Regards,
Neza
Re: Requesting for help in querying sharepoint 2010 Via CMIS workbench
Posted by Neza Guillaine <gn...@gmail.com>.
Dear Florian,
Thank you soo much for youe help. I found out the solution to make it work
in SP2010, I found that adding the
NTLM authentication is a must to make cmis parse the query results from
SP10. otherwise it will never work.
I will continue using this approach (query) and get all the properties as I
need them.
Regards,
Neza
On Thu, Jun 2, 2016 at 1:35 PM, Neza Guillaine <gn...@gmail.com> wrote:
> Sorry I meant I already tried it in SP2013 and the query result worked
> very well. but when I switched to SP2010, it did not work as intended.
>
> Regards,
> Neza
>
> On Thu, Jun 2, 2016 at 12:05 PM, Neza Guillaine <gn...@gmail.com> wrote:
>
>> Dear Florian,
>>
>> Thanks for the quick response,
>> I already tried the queryresult with 2010 and I was very happy with what
>> i was getting as a way of manilupating my repo to give me any property i
>> wanted. but when i moved to my production repo which has SP2010. It
>> couldn't accept to execute the query and again it was throwing an
>> unauthorized expection. I am completely stuck on the query option in SP2010
>> and which is why I am finding ways to iterate through my repo using
>> getFolderTree and descendants. I don't know what I will do to make my
>> opencmis work with SP2010 on queries.
>>
>> Thanks.
>> Neza
>>
>> On Thu, Jun 2, 2016 at 11:13 AM, Florian Müller <fm...@apache.org> wrote:
>>
>>> Hi Neza,
>>>
>>> Since getFolderTree and getDescendants are not supported by SharePoint
>>> you have to either walk through the hierarchy with getChildren or use a
>>> query ("SELECT * FROM cmis:documents").
>>> I would prefer the query over getChildren and would not advise to use
>>> getFolderTree or getDescendants even if it would be supported.
>>> (getDescendants delivers everything in your repository in one response
>>> if you call it on the root folder. Depending on your repository that can be
>>> a lot! I've seen getDescendants responses of a few hundred MB. It works but
>>> it took some time to generate the response on the server side and to read
>>> it on the client side. The overall user experience was ... not good).
>>>
>>> Using a query has the advantage that you can page the results and
>>> therefore deal with a really large number of documents in your repository.
>>> If you need Document objects instead of QueryResult objects, checkout the
>>> method Session.queryObjects(...).
>>>
>>>
>>> - Florian
>>>
>>>
>>>
>>> Hi Florian and opencmis devs
>>>>
>>>> I hope this email finds you well.
>>>> I have been trying use opencmis to try to navigate my sharepoint 2010
>>>> repository.
>>>> I was reading on the dev guide but Ic ouldn't see how to navigate and
>>>> see all documents on my repository.
>>>>
>>>> My request is:
>>>>
>>>> I am connecting to my repository in eclipse, I want to be able to view
>>>> all documents in the folders and subfolders on that root repository.
>>>> What I saw is that the getFolderTree capability seem to not be
>>>> supported in SP 2010. Is there any way for using the api to get all
>>>> documents for a root folder? I don't want to use the QueryResult.
>>>>
>>>> Any help will be appreciated. I really need to get that list of
>>>> documents.
>>>>
>>>> Thanks.
>>>> Neza
>>>>
>>>> On Fri, May 20, 2016 at 8:20 PM, Florian Müller <fm...@apache.org>
>>>> wrote:
>>>>
>>>> Hi Neza,
>>>>>
>>>>> SharePoint has its quirks and OpenCMIS provides workarounds for a
>>>>> few
>>>>> issues, but in general OpenCMIS is working fine with SharePoint.
>>>>>
>>>>> What authentication method are you using?
>>>>> Basic authentication and Kerberos are known to work (if correctly
>>>>> configured on the server side).
>>>>> NTLM is not working. At first glance it seem to work, but eventually
>>>>> HTTP POST requests (like query) will fail.
>>>>>
>>>>> - Florian
>>>>>
>>>>> Hi Devs and Florian,
>>>>>>
>>>>>> My name is Neza. I am writing request for your help in cmis.
>>>>>> I had tried using cmis workbench to query documents from the
>>>>>>
>>>>> alfresco side
>>>>>
>>>>>> and it work perfectly, but when I moved to the sharepoint side,
>>>>>>
>>>>> every
>>>>>
>>>>>> single thing i do in my query return a: Runtime: Unauthorized
>>>>>>
>>>>> exception. IT
>>>>>
>>>>>> seems that queried from sharepoint are not being interpreted. Even
>>>>>>
>>>>> if I do
>>>>>
>>>>>> something very basic lile:
>>>>>>
>>>>>> SELECT * from cmis:document.
>>>>>>
>>>>>> This have been running me crazy, I googled alot around since
>>>>>>
>>>>> monday and did
>>>>>
>>>>>> not et any answer to my case. A few suggestions but nothing let me
>>>>>>
>>>>> to the
>>>>>
>>>>>> solution.
>>>>>>
>>>>>> If you have already encountered this issue or can provide help, I
>>>>>>
>>>>> would
>>>>>
>>>>>> appreciate.
>>>>>> My cmis workbench is: 0.13.0 and SP 2010.
>>>>>>
>>>>>> Regards,
>>>>>> Neza
>>>>>>
>>>>>>
>>
>
Re: Requesting for help in querying sharepoint 2010 Via CMIS workbench
Posted by Neza Guillaine <gn...@gmail.com>.
Sorry I meant I already tried it in SP2013 and the query result worked very
well. but when I switched to SP2010, it did not work as intended.
Regards,
Neza
On Thu, Jun 2, 2016 at 12:05 PM, Neza Guillaine <gn...@gmail.com> wrote:
> Dear Florian,
>
> Thanks for the quick response,
> I already tried the queryresult with 2010 and I was very happy with what i
> was getting as a way of manilupating my repo to give me any property i
> wanted. but when i moved to my production repo which has SP2010. It
> couldn't accept to execute the query and again it was throwing an
> unauthorized expection. I am completely stuck on the query option in SP2010
> and which is why I am finding ways to iterate through my repo using
> getFolderTree and descendants. I don't know what I will do to make my
> opencmis work with SP2010 on queries.
>
> Thanks.
> Neza
>
> On Thu, Jun 2, 2016 at 11:13 AM, Florian Müller <fm...@apache.org> wrote:
>
>> Hi Neza,
>>
>> Since getFolderTree and getDescendants are not supported by SharePoint
>> you have to either walk through the hierarchy with getChildren or use a
>> query ("SELECT * FROM cmis:documents").
>> I would prefer the query over getChildren and would not advise to use
>> getFolderTree or getDescendants even if it would be supported.
>> (getDescendants delivers everything in your repository in one response if
>> you call it on the root folder. Depending on your repository that can be a
>> lot! I've seen getDescendants responses of a few hundred MB. It works but
>> it took some time to generate the response on the server side and to read
>> it on the client side. The overall user experience was ... not good).
>>
>> Using a query has the advantage that you can page the results and
>> therefore deal with a really large number of documents in your repository.
>> If you need Document objects instead of QueryResult objects, checkout the
>> method Session.queryObjects(...).
>>
>>
>> - Florian
>>
>>
>>
>> Hi Florian and opencmis devs
>>>
>>> I hope this email finds you well.
>>> I have been trying use opencmis to try to navigate my sharepoint 2010
>>> repository.
>>> I was reading on the dev guide but Ic ouldn't see how to navigate and
>>> see all documents on my repository.
>>>
>>> My request is:
>>>
>>> I am connecting to my repository in eclipse, I want to be able to view
>>> all documents in the folders and subfolders on that root repository.
>>> What I saw is that the getFolderTree capability seem to not be
>>> supported in SP 2010. Is there any way for using the api to get all
>>> documents for a root folder? I don't want to use the QueryResult.
>>>
>>> Any help will be appreciated. I really need to get that list of
>>> documents.
>>>
>>> Thanks.
>>> Neza
>>>
>>> On Fri, May 20, 2016 at 8:20 PM, Florian Müller <fm...@apache.org>
>>> wrote:
>>>
>>> Hi Neza,
>>>>
>>>> SharePoint has its quirks and OpenCMIS provides workarounds for a
>>>> few
>>>> issues, but in general OpenCMIS is working fine with SharePoint.
>>>>
>>>> What authentication method are you using?
>>>> Basic authentication and Kerberos are known to work (if correctly
>>>> configured on the server side).
>>>> NTLM is not working. At first glance it seem to work, but eventually
>>>> HTTP POST requests (like query) will fail.
>>>>
>>>> - Florian
>>>>
>>>> Hi Devs and Florian,
>>>>>
>>>>> My name is Neza. I am writing request for your help in cmis.
>>>>> I had tried using cmis workbench to query documents from the
>>>>>
>>>> alfresco side
>>>>
>>>>> and it work perfectly, but when I moved to the sharepoint side,
>>>>>
>>>> every
>>>>
>>>>> single thing i do in my query return a: Runtime: Unauthorized
>>>>>
>>>> exception. IT
>>>>
>>>>> seems that queried from sharepoint are not being interpreted. Even
>>>>>
>>>> if I do
>>>>
>>>>> something very basic lile:
>>>>>
>>>>> SELECT * from cmis:document.
>>>>>
>>>>> This have been running me crazy, I googled alot around since
>>>>>
>>>> monday and did
>>>>
>>>>> not et any answer to my case. A few suggestions but nothing let me
>>>>>
>>>> to the
>>>>
>>>>> solution.
>>>>>
>>>>> If you have already encountered this issue or can provide help, I
>>>>>
>>>> would
>>>>
>>>>> appreciate.
>>>>> My cmis workbench is: 0.13.0 and SP 2010.
>>>>>
>>>>> Regards,
>>>>> Neza
>>>>>
>>>>>
>
Re: Requesting for help in querying sharepoint 2010 Via CMIS workbench
Posted by Neza Guillaine <gn...@gmail.com>.
Dear Florian,
Thanks for the quick response,
I already tried the queryresult with 2010 and I was very happy with what i
was getting as a way of manilupating my repo to give me any property i
wanted. but when i moved to my production repo which has SP2010. It
couldn't accept to execute the query and again it was throwing an
unauthorized expection. I am completely stuck on the query option in SP2010
and which is why I am finding ways to iterate through my repo using
getFolderTree and descendants. I don't know what I will do to make my
opencmis work with SP2010 on queries.
Thanks.
Neza
On Thu, Jun 2, 2016 at 11:13 AM, Florian Müller <fm...@apache.org> wrote:
> Hi Neza,
>
> Since getFolderTree and getDescendants are not supported by SharePoint you
> have to either walk through the hierarchy with getChildren or use a query
> ("SELECT * FROM cmis:documents").
> I would prefer the query over getChildren and would not advise to use
> getFolderTree or getDescendants even if it would be supported.
> (getDescendants delivers everything in your repository in one response if
> you call it on the root folder. Depending on your repository that can be a
> lot! I've seen getDescendants responses of a few hundred MB. It works but
> it took some time to generate the response on the server side and to read
> it on the client side. The overall user experience was ... not good).
>
> Using a query has the advantage that you can page the results and
> therefore deal with a really large number of documents in your repository.
> If you need Document objects instead of QueryResult objects, checkout the
> method Session.queryObjects(...).
>
>
> - Florian
>
>
>
> Hi Florian and opencmis devs
>>
>> I hope this email finds you well.
>> I have been trying use opencmis to try to navigate my sharepoint 2010
>> repository.
>> I was reading on the dev guide but Ic ouldn't see how to navigate and
>> see all documents on my repository.
>>
>> My request is:
>>
>> I am connecting to my repository in eclipse, I want to be able to view
>> all documents in the folders and subfolders on that root repository.
>> What I saw is that the getFolderTree capability seem to not be
>> supported in SP 2010. Is there any way for using the api to get all
>> documents for a root folder? I don't want to use the QueryResult.
>>
>> Any help will be appreciated. I really need to get that list of
>> documents.
>>
>> Thanks.
>> Neza
>>
>> On Fri, May 20, 2016 at 8:20 PM, Florian Müller <fm...@apache.org>
>> wrote:
>>
>> Hi Neza,
>>>
>>> SharePoint has its quirks and OpenCMIS provides workarounds for a
>>> few
>>> issues, but in general OpenCMIS is working fine with SharePoint.
>>>
>>> What authentication method are you using?
>>> Basic authentication and Kerberos are known to work (if correctly
>>> configured on the server side).
>>> NTLM is not working. At first glance it seem to work, but eventually
>>> HTTP POST requests (like query) will fail.
>>>
>>> - Florian
>>>
>>> Hi Devs and Florian,
>>>>
>>>> My name is Neza. I am writing request for your help in cmis.
>>>> I had tried using cmis workbench to query documents from the
>>>>
>>> alfresco side
>>>
>>>> and it work perfectly, but when I moved to the sharepoint side,
>>>>
>>> every
>>>
>>>> single thing i do in my query return a: Runtime: Unauthorized
>>>>
>>> exception. IT
>>>
>>>> seems that queried from sharepoint are not being interpreted. Even
>>>>
>>> if I do
>>>
>>>> something very basic lile:
>>>>
>>>> SELECT * from cmis:document.
>>>>
>>>> This have been running me crazy, I googled alot around since
>>>>
>>> monday and did
>>>
>>>> not et any answer to my case. A few suggestions but nothing let me
>>>>
>>> to the
>>>
>>>> solution.
>>>>
>>>> If you have already encountered this issue or can provide help, I
>>>>
>>> would
>>>
>>>> appreciate.
>>>> My cmis workbench is: 0.13.0 and SP 2010.
>>>>
>>>> Regards,
>>>> Neza
>>>>
>>>>
Re: Requesting for help in querying sharepoint 2010 Via CMIS
workbench
Posted by Florian Müller <fm...@apache.org>.
Hi Neza,
Since getFolderTree and getDescendants are not supported by SharePoint
you have to either walk through the hierarchy with getChildren or use a
query ("SELECT * FROM cmis:documents").
I would prefer the query over getChildren and would not advise to use
getFolderTree or getDescendants even if it would be supported.
(getDescendants delivers everything in your repository in one response
if you call it on the root folder. Depending on your repository that can
be a lot! I've seen getDescendants responses of a few hundred MB. It
works but it took some time to generate the response on the server side
and to read it on the client side. The overall user experience was ...
not good).
Using a query has the advantage that you can page the results and
therefore deal with a really large number of documents in your
repository. If you need Document objects instead of QueryResult objects,
checkout the method Session.queryObjects(...).
- Florian
> Hi Florian and opencmis devs
>
> I hope this email finds you well.
> I have been trying use opencmis to try to navigate my sharepoint 2010
> repository.
> I was reading on the dev guide but Ic ouldn't see how to navigate and
> see all documents on my repository.
>
> My request is:
>
> I am connecting to my repository in eclipse, I want to be able to view
> all documents in the folders and subfolders on that root repository.
> What I saw is that the getFolderTree capability seem to not be
> supported in SP 2010. Is there any way for using the api to get all
> documents for a root folder? I don't want to use the QueryResult.
>
> Any help will be appreciated. I really need to get that list of
> documents.
>
> Thanks.
> Neza
>
> On Fri, May 20, 2016 at 8:20 PM, Florian M�ller <fm...@apache.org>
> wrote:
>
>> Hi Neza,
>>
>> SharePoint has its quirks and OpenCMIS provides workarounds for a
>> few
>> issues, but in general OpenCMIS is working fine with SharePoint.
>>
>> What authentication method are you using?
>> Basic authentication and Kerberos are known to work (if correctly
>> configured on the server side).
>> NTLM is not working. At first glance it seem to work, but eventually
>> HTTP POST requests (like query) will fail.
>>
>> - Florian
>>
>>> Hi Devs and Florian,
>>>
>>> My name is Neza. I am writing request for your help in cmis.
>>> I had tried using cmis workbench to query documents from the
>> alfresco side
>>> and it work perfectly, but when I moved to the sharepoint side,
>> every
>>> single thing i do in my query return a: Runtime: Unauthorized
>> exception. IT
>>> seems that queried from sharepoint are not being interpreted. Even
>> if I do
>>> something very basic lile:
>>>
>>> SELECT * from cmis:document.
>>>
>>> This have been running me crazy, I googled alot around since
>> monday and did
>>> not et any answer to my case. A few suggestions but nothing let me
>> to the
>>> solution.
>>>
>>> If you have already encountered this issue or can provide help, I
>> would
>>> appreciate.
>>> My cmis workbench is: 0.13.0 and SP 2010.
>>>
>>> Regards,
>>> Neza
>>>
Re: Requesting for help in querying sharepoint 2010 Via CMIS workbench
Posted by Neza Guillaine <gn...@gmail.com>.
Hi Florian and opencmis devs
I hope this email finds you well.
I have been trying use opencmis to try to navigate my sharepoint 2010
repository.
I was reading on the dev guide but Ic ouldn't see how to navigate and see
all documents on my repository.
My request is:
I am connecting to my repository in eclipse, I want to be able to view all
documents in the folders and subfolders on that root repository. What I saw
is that the getFolderTree capability seem to not be supported in SP 2010.
Is there any way for using the api to get all documents for a root folder?
I don't want to use the QueryResult.
Any help will be appreciated. I really need to get that list of documents.
Thanks.
Neza
On Fri, May 20, 2016 at 8:20 PM, Florian Müller <fm...@apache.org> wrote:
> Hi Neza,
>
> SharePoint has its quirks and OpenCMIS provides workarounds for a few
> issues, but in general OpenCMIS is working fine with SharePoint.
>
> What authentication method are you using?
> Basic authentication and Kerberos are known to work (if correctly
> configured on the server side).
> NTLM is not working. At first glance it seem to work, but eventually
> HTTP POST requests (like query) will fail.
>
>
> - Florian
>
>
> > Hi Devs and Florian,
> >
> > My name is Neza. I am writing request for your help in cmis.
> > I had tried using cmis workbench to query documents from the alfresco
> side
> > and it work perfectly, but when I moved to the sharepoint side, every
> > single thing i do in my query return a: Runtime: Unauthorized exception.
> IT
> > seems that queried from sharepoint are not being interpreted. Even if I
> do
> > something very basic lile:
> >
> > SELECT * from cmis:document.
> >
> > This have been running me crazy, I googled alot around since monday and
> did
> > not et any answer to my case. A few suggestions but nothing let me to the
> > solution.
> >
> > If you have already encountered this issue or can provide help, I would
> > appreciate.
> > My cmis workbench is: 0.13.0 and SP 2010.
> >
> > Regards,
> > Neza
> >
>
Re: Requesting for help in querying sharepoint 2010 Via CMIS workbench
Posted by Neza Guillaine <gn...@gmail.com>.
Dear Florian,
Thank you soo much for your help. I followed your instructions, removed the
line as suggested, I am successfully authenticated but I keep getting the
unauthorized error when using the query browser to query documents.
I suspect maybe at this level it has to do with the latest version of
workbench which I am using. I will try to downgrade the workbench and
continue other tests to see where the problem might really be.
Regards,
Neza
On Mon, May 23, 2016 at 10:41 AM, Florian Müller <fm...@apache.org> wrote:
> Hi Neza,
>
> SharePoint 2010 has a few more issues than SharePoint 2013, but it is
> working too.
>
> How do you connect with the CMIS Workbench? Are you using the Basic tab or
> the Expert tab?
> I would recommend the Expert tab. Select "SharePoint 2010 AtomPub" and
> remove this line:
>
>>
>> org.apache.chemistry.opencmis.binding.auth.classname=org.apache.chemistry.opencmis.client.bindings.spi.NTLMAuthenticationProvider
>>
>
> Queries are POST requests. Can you try a different POST request and see if
> that is also failing. (For example, try creating a folder.)
>
>
> - Florian
>
>
>
> Dear Florian,
>>
>> Thanks for the response.
>>
>> I am using SharePoint 2010 and the authentication method used is standard.
>> I am successfully being authenticated but my queries are the ones failing.
>> I had done several other tests with Sharepoint 2013, using the same
>> authentication method and all of the queries are working perfectly.
>> However
>> this seems like a SharePoint 2010 issue. OpenCMIS is configured on the
>> server side. Unless If I have missed some steps.
>>
>> I haven't tried using the Kerberos authentication to see. but when you say
>> SharePoint is known to work with basic and Kerberos authentication; are
>> you
>> referring to all versions of SharePoint? or just the SharePoint 2013
>> server
>> version? It's very hard for us to migrate all of our data from the 2010
>> version to the 2013 version. that's why having opencmis working with the
>> Sharepoint 2010 is what we want. especially for querying documents.
>>
>> Thank you again for your feedback.
>>
>>
>>
>> On Fri, May 20, 2016 at 8:20 PM, Florian Müller <fm...@apache.org> wrote:
>>
>> Hi Neza,
>>>
>>> SharePoint has its quirks and OpenCMIS provides workarounds for a few
>>> issues, but in general OpenCMIS is working fine with SharePoint.
>>>
>>> What authentication method are you using?
>>> Basic authentication and Kerberos are known to work (if correctly
>>> configured on the server side).
>>> NTLM is not working. At first glance it seem to work, but eventually
>>> HTTP POST requests (like query) will fail.
>>>
>>>
>>> - Florian
>>>
>>>
>>> > Hi Devs and Florian,
>>> >
>>> > My name is Neza. I am writing request for your help in cmis.
>>> > I had tried using cmis workbench to query documents from the alfresco
>>> side
>>> > and it work perfectly, but when I moved to the sharepoint side, every
>>> > single thing i do in my query return a: Runtime: Unauthorized
>>> exception.
>>> IT
>>> > seems that queried from sharepoint are not being interpreted. Even if I
>>> do
>>> > something very basic lile:
>>> >
>>> > SELECT * from cmis:document.
>>> >
>>> > This have been running me crazy, I googled alot around since monday and
>>> did
>>> > not et any answer to my case. A few suggestions but nothing let me to
>>> the
>>> > solution.
>>> >
>>> > If you have already encountered this issue or can provide help, I would
>>> > appreciate.
>>> > My cmis workbench is: 0.13.0 and SP 2010.
>>> >
>>> > Regards,
>>> > Neza
>>> >
>>>
>>>
Re: Requesting for help in querying sharepoint 2010 Via CMIS
workbench
Posted by Florian Müller <fm...@apache.org>.
Hi Neza,
SharePoint 2010 has a few more issues than SharePoint 2013, but it is
working too.
How do you connect with the CMIS Workbench? Are you using the Basic tab
or the Expert tab?
I would recommend the Expert tab. Select "SharePoint 2010 AtomPub" and
remove this line:
> org.apache.chemistry.opencmis.binding.auth.classname=org.apache.chemistry.opencmis.client.bindings.spi.NTLMAuthenticationProvider
Queries are POST requests. Can you try a different POST request and see
if that is also failing. (For example, try creating a folder.)
- Florian
> Dear Florian,
>
> Thanks for the response.
>
> I am using SharePoint 2010 and the authentication method used is
> standard.
> I am successfully being authenticated but my queries are the ones
> failing.
> I had done several other tests with Sharepoint 2013, using the same
> authentication method and all of the queries are working perfectly.
> However
> this seems like a SharePoint 2010 issue. OpenCMIS is configured on the
> server side. Unless If I have missed some steps.
>
> I haven't tried using the Kerberos authentication to see. but when you
> say
> SharePoint is known to work with basic and Kerberos authentication; are
> you
> referring to all versions of SharePoint? or just the SharePoint 2013
> server
> version? It's very hard for us to migrate all of our data from the 2010
> version to the 2013 version. that's why having opencmis working with
> the
> Sharepoint 2010 is what we want. especially for querying documents.
>
> Thank you again for your feedback.
>
>
>
> On Fri, May 20, 2016 at 8:20 PM, Florian M�ller <fm...@apache.org>
> wrote:
>
>> Hi Neza,
>>
>> SharePoint has its quirks and OpenCMIS provides workarounds for a few
>> issues, but in general OpenCMIS is working fine with SharePoint.
>>
>> What authentication method are you using?
>> Basic authentication and Kerberos are known to work (if correctly
>> configured on the server side).
>> NTLM is not working. At first glance it seem to work, but eventually
>> HTTP POST requests (like query) will fail.
>>
>>
>> - Florian
>>
>>
>> > Hi Devs and Florian,
>> >
>> > My name is Neza. I am writing request for your help in cmis.
>> > I had tried using cmis workbench to query documents from the alfresco
>> side
>> > and it work perfectly, but when I moved to the sharepoint side, every
>> > single thing i do in my query return a: Runtime: Unauthorized exception.
>> IT
>> > seems that queried from sharepoint are not being interpreted. Even if I
>> do
>> > something very basic lile:
>> >
>> > SELECT * from cmis:document.
>> >
>> > This have been running me crazy, I googled alot around since monday and
>> did
>> > not et any answer to my case. A few suggestions but nothing let me to the
>> > solution.
>> >
>> > If you have already encountered this issue or can provide help, I would
>> > appreciate.
>> > My cmis workbench is: 0.13.0 and SP 2010.
>> >
>> > Regards,
>> > Neza
>> >
>>
Re: Requesting for help in querying sharepoint 2010 Via CMIS workbench
Posted by Neza Guillaine <gn...@gmail.com>.
Dear Florian,
Thanks for the response.
I am using SharePoint 2010 and the authentication method used is standard.
I am successfully being authenticated but my queries are the ones failing.
I had done several other tests with Sharepoint 2013, using the same
authentication method and all of the queries are working perfectly. However
this seems like a SharePoint 2010 issue. OpenCMIS is configured on the
server side. Unless If I have missed some steps.
I haven't tried using the Kerberos authentication to see. but when you say
SharePoint is known to work with basic and Kerberos authentication; are you
referring to all versions of SharePoint? or just the SharePoint 2013 server
version? It's very hard for us to migrate all of our data from the 2010
version to the 2013 version. that's why having opencmis working with the
Sharepoint 2010 is what we want. especially for querying documents.
Thank you again for your feedback.
On Fri, May 20, 2016 at 8:20 PM, Florian Müller <fm...@apache.org> wrote:
> Hi Neza,
>
> SharePoint has its quirks and OpenCMIS provides workarounds for a few
> issues, but in general OpenCMIS is working fine with SharePoint.
>
> What authentication method are you using?
> Basic authentication and Kerberos are known to work (if correctly
> configured on the server side).
> NTLM is not working. At first glance it seem to work, but eventually
> HTTP POST requests (like query) will fail.
>
>
> - Florian
>
>
> > Hi Devs and Florian,
> >
> > My name is Neza. I am writing request for your help in cmis.
> > I had tried using cmis workbench to query documents from the alfresco
> side
> > and it work perfectly, but when I moved to the sharepoint side, every
> > single thing i do in my query return a: Runtime: Unauthorized exception.
> IT
> > seems that queried from sharepoint are not being interpreted. Even if I
> do
> > something very basic lile:
> >
> > SELECT * from cmis:document.
> >
> > This have been running me crazy, I googled alot around since monday and
> did
> > not et any answer to my case. A few suggestions but nothing let me to the
> > solution.
> >
> > If you have already encountered this issue or can provide help, I would
> > appreciate.
> > My cmis workbench is: 0.13.0 and SP 2010.
> >
> > Regards,
> > Neza
> >
>
Re: Requesting for help in querying sharepoint 2010 Via CMIS
workbench
Posted by Florian Müller <fm...@apache.org>.
Hi Neza,
SharePoint has its quirks and OpenCMIS provides workarounds for a few
issues, but in general OpenCMIS is working fine with SharePoint.
What authentication method are you using?
Basic authentication and Kerberos are known to work (if correctly
configured on the server side).
NTLM is not working. At first glance it seem to work, but eventually
HTTP POST requests (like query) will fail.
- Florian
> Hi Devs and Florian,
>
> My name is Neza. I am writing request for your help in cmis.
> I had tried using cmis workbench to query documents from the alfresco side
> and it work perfectly, but when I moved to the sharepoint side, every
> single thing i do in my query return a: Runtime: Unauthorized exception. IT
> seems that queried from sharepoint are not being interpreted. Even if I do
> something very basic lile:
>
> SELECT * from cmis:document.
>
> This have been running me crazy, I googled alot around since monday and did
> not et any answer to my case. A few suggestions but nothing let me to the
> solution.
>
> If you have already encountered this issue or can provide help, I would
> appreciate.
> My cmis workbench is: 0.13.0 and SP 2010.
>
> Regards,
> Neza
>