Please be sure to run "ant make-core-deps" since that downloads the newest OpenCMIS jars.
Karl On Fri, Aug 22, 2014 at 11:03 AM, Baptiste Berthier <[email protected]> wrote: > Thanks. I will try it > > Baptiste > > 2014-08-22 15:51 GMT+02:00 Karl Wright <[email protected]>: > > Hi Baptiste, >> >> Trunk has been updated to use OpenCMIS 0.11, which may fix your problem. >> Please give it a try. >> >> Thanks, >> Karl >> >> >> >> On Fri, Aug 22, 2014 at 9:34 AM, Karl Wright <[email protected]> wrote: >> >>> Hi Baptiste, >>> >>> The CMIS connector depends on Apache Chemistry as its client software. >>> It is possible that either we are behind the release cycle, or there are >>> bugs, in the version of Chemistry that we use. There is a ticket open for >>> upgrade; I will see if this can be done painlessly, and if so let's see if >>> that helps. >>> >>> Karl >>> >>> >>> >>> On Fri, Aug 22, 2014 at 9:26 AM, Baptiste Berthier < >>> [email protected]> wrote: >>> >>>> Hi, >>>> >>>> I have tested multiple CMIS request. I attach a document to show the >>>> results of my test cause I don't manage to index all internal metadata from >>>> Alfresco and I don't know why. >>>> >>>> thanks for your help >>>> >>>> Baptiste >>>> >>>> 2014-08-21 13:46 GMT+02:00 Karl Wright <[email protected]>: >>>> >>>> Hi Baptiste, >>>>> >>>>> The CMIS connector passes the query intact to the CMIS >>>>> implementation. If it sees "*" as any of the fields in the select, it >>>>> takes all metadata items it finds in the resultset. If the "select *" is >>>>> somehow canceling the join, then try "select d.*,e.*,*". If that doesn't >>>>> work, then document.getProperties() is simply not returning everything. >>>>> >>>>> Karl >>>>> >>>>> >>>>> >>>>> On Thu, Aug 21, 2014 at 7:15 AM, Baptiste Berthier < >>>>> [email protected]> wrote: >>>>> >>>>>> I tried it and the fields title or description aren't indexed. I have >>>>>> verified the result in Solr log message and there is not the title field >>>>>> or >>>>>> the description field while they appeared when I was testing the query in >>>>>> Chrome extension. I don't know why. >>>>>> Baptiste >>>>>> 2014-08-21 12:25 GMT+02:00 Karl Wright <[email protected]>: >>>>>> >>>>>> Hi Baptiste, >>>>>>> >>>>>>> Instead of "d.*,e.*", try just "*". The column selection in the >>>>>>> CMIS connector is not very smart. >>>>>>> >>>>>>> Karl >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Thu, Aug 21, 2014 at 3:18 AM, Baptiste Berthier < >>>>>>> [email protected]> wrote: >>>>>>> >>>>>>>> Hi >>>>>>>> >>>>>>>> In order to get the field that I want (for example description, >>>>>>>> title) with CMIS connector, I changed my CMIS request by using a join. >>>>>>>> Here >>>>>>>> is the CMIS request : >>>>>>>> >>>>>>>> SELECT d.*, e.* FROM cmis:document as d JOIN cmis:titled e ON >>>>>>>> d.cmis:objectId = e.cmis:objectId WHERE d.cmis:name LIKE 'doc.pdf' >>>>>>>> >>>>>>>> I have verified the result in Chrome and there is well the content >>>>>>>> of the description and title field. You can see it in the attach >>>>>>>> document. >>>>>>>> So I have written the request in MCF and launched crawling but >>>>>>>> nothing appears to be indexed in Solr. Do you think that that MCF >>>>>>>> supports >>>>>>>> CMIS request with join ? >>>>>>>> >>>>>>>> Thanks for your reply. It helps me a lot in my work. >>>>>>>> >>>>>>>> Baptiste >>>>>>>> >>>>>>>> >>>>>>>> 2014-08-20 15:46 GMT+02:00 Karl Wright <[email protected]>: >>>>>>>> >>>>>>>> Hi Baptiste, >>>>>>>>> >>>>>>>>> The current Alfresco connector will only work on older versions of >>>>>>>>> Alfresco. It will not work, for example, on Alfresco One. We are >>>>>>>>> trying >>>>>>>>> to field an alfresco connector based on the REST API, but that API >>>>>>>>> has not >>>>>>>>> apparently stabilized yet. >>>>>>>>> >>>>>>>>> Thanks, >>>>>>>>> Karl >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> On Wed, Aug 20, 2014 at 9:41 AM, Baptiste Berthier < >>>>>>>>> [email protected]> wrote: >>>>>>>>> >>>>>>>>>> Thanks a lot ! Indeed It works fine like that. To avoid to modify >>>>>>>>>> the Alfresco's CMIS implementation, do you think, that I can index >>>>>>>>>> all the >>>>>>>>>> metadata that I want, by using the Alfresco connector instead of CMIS >>>>>>>>>> connector ? >>>>>>>>>> >>>>>>>>>> Thanks a lot ! It works fine. I noticed that the properties of >>>>>>>>>> the document and certains Alfresco's metadata are all indexes by >>>>>>>>>> Solr under >>>>>>>>>> different field's name. >>>>>>>>>> >>>>>>>>>> Do you think, that it's possible to avoid to change the >>>>>>>>>> Alfresco's CMIS implementation by using the existing Alfresco >>>>>>>>>> connector >>>>>>>>>> instead of using CMIS connector ? >>>>>>>>>> >>>>>>>>>> Baptiste >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> 2014-08-20 12:06 GMT+02:00 Karl Wright <[email protected]>: >>>>>>>>>> >>>>>>>>>> Hi Baptiste, >>>>>>>>>>> >>>>>>>>>>> All the metadata names provided by the Alfresco CMIS >>>>>>>>>>> implementation seem to be prefixed with "cmis:". For example, >>>>>>>>>>> "cmis:createdBy" has a value of "admin". If you change your MCF >>>>>>>>>>> mappings >>>>>>>>>>> and/or Solr configuration to recognize these attribute names, they >>>>>>>>>>> will be >>>>>>>>>>> indexed. >>>>>>>>>>> >>>>>>>>>>> It does not appear that description or title are metadata that >>>>>>>>>>> Alfresco's CMIS implementation includes. ManifoldCF cannot fix that >>>>>>>>>>> because it is likely that it is Alfresco's implementation that is >>>>>>>>>>> incomplete. >>>>>>>>>>> >>>>>>>>>>> Karl >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On Wed, Aug 20, 2014 at 5:39 AM, Baptiste Berthier < >>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>> >>>>>>>>>>>> Hi >>>>>>>>>>>> >>>>>>>>>>>> I attached my Solr log messages. It seems that there is the id, >>>>>>>>>>>> the name, the mime type as metadata but nothing about the >>>>>>>>>>>> description or >>>>>>>>>>>> the title that we could find in Alfresco. I don't know why. I >>>>>>>>>>>> would like to >>>>>>>>>>>> know what is the difference between Schema section in List output >>>>>>>>>>>> connector >>>>>>>>>>>> and the Solr field mapping when I configure a job. It seems that >>>>>>>>>>>> the Solr >>>>>>>>>>>> field mapping doesn't enable me to match field from Alfresco with >>>>>>>>>>>> Solr >>>>>>>>>>>> field. >>>>>>>>>>>> I will be interesting in the MCF 1.7 RC2 when it will be >>>>>>>>>>>> available. >>>>>>>>>>>> Thanks >>>>>>>>>>>> Baptiste >>>>>>>>>>>> 2014-08-19 13:27 GMT+02:00 Karl Wright <[email protected]>: >>>>>>>>>>>> >>>>>>>>>>>> Hi Baptiste, >>>>>>>>>>>>> >>>>>>>>>>>>> I believe the problem is in how you have declared your Solr >>>>>>>>>>>>> schema. >>>>>>>>>>>>> >>>>>>>>>>>>> If you look at the Solr log messages, the INFO statements show >>>>>>>>>>>>> the information that ManifoldCF is sending to Solr. If that >>>>>>>>>>>>> includes >>>>>>>>>>>>> everything you are expecting, then the problem is on the Solr >>>>>>>>>>>>> side. If >>>>>>>>>>>>> not, it is on the ManifoldCF side. >>>>>>>>>>>>> >>>>>>>>>>>>> Also, I've recently fixed yet another issue with the CMIS >>>>>>>>>>>>> connector, so you will want MCF 1.7 RC2 when it is available. >>>>>>>>>>>>> >>>>>>>>>>>>> Thank you, >>>>>>>>>>>>> Karl >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> On Tue, Aug 19, 2014 at 7:10 AM, Baptiste Berthier < >>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> Hi >>>>>>>>>>>>>> >>>>>>>>>>>>>> Thanks a lot for the link that you sent me last day. I >>>>>>>>>>>>>> installed and tested MCF 1.7. I met some problems. I try to >>>>>>>>>>>>>> explain them in >>>>>>>>>>>>>> the attached document. >>>>>>>>>>>>>> Do you have an idea about the problem that I have ? >>>>>>>>>>>>>> >>>>>>>>>>>>>> Thanks >>>>>>>>>>>>>> >>>>>>>>>>>>>> Baptiste >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> 2014-08-12 8:11 GMT+02:00 Karl Wright <[email protected]>: >>>>>>>>>>>>>> >>>>>>>>>>>>>> Hi Baptiste, >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> You can download MCF 1.7 RC0 from: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> http://people.apache.org/~mingchun/apache-manifoldcf-1.7-RC0/ >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Please let me know what happens. >>>>>>>>>>>>>>> Karl >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> On Mon, Aug 11, 2014 at 8:45 AM, Baptiste Berthier < >>>>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> I am using Apache ManifoldCF 1.6.1 but if the version 1.7 >>>>>>>>>>>>>>>> is available in one or two days. I can wait. >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Thanks >>>>>>>>>>>>>>>> Baptiste >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> 2014-08-11 13:26 GMT+02:00 Karl Wright <[email protected]>: >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Hi Baptiste, >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> I strongly suggest waiting for the first ManifoldCF 1.7 >>>>>>>>>>>>>>>>> release candidate to be available for download. This should >>>>>>>>>>>>>>>>> be available >>>>>>>>>>>>>>>>> within a day or two. >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> The alternative is that I can attach a full patch to the >>>>>>>>>>>>>>>>> ticket from whatever version you are using to current trunk. >>>>>>>>>>>>>>>>> Please let me >>>>>>>>>>>>>>>>> know what your version is, first. >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> Thanks, >>>>>>>>>>>>>>>>> Karl >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> On Mon, Aug 11, 2014 at 6:46 AM, Baptiste Berthier < >>>>>>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> Thanks a lot. It works fine ! I have just one last >>>>>>>>>>>>>>>>>> question concerning the CMIS connector used with Alfresco to >>>>>>>>>>>>>>>>>> get all >>>>>>>>>>>>>>>>>> internal metadata affected to a document by Alfresco. I used >>>>>>>>>>>>>>>>>> this kind of >>>>>>>>>>>>>>>>>> cmis query : select * from cmis:document where cmis:name in >>>>>>>>>>>>>>>>>> ('doc.pdf') >>>>>>>>>>>>>>>>>> which doesn't work. So you advised me to use trunk to commit >>>>>>>>>>>>>>>>>> my application >>>>>>>>>>>>>>>>>> in order to be able to use the query but I cannot use trunk >>>>>>>>>>>>>>>>>> because of the >>>>>>>>>>>>>>>>>> internet restriction in my enterprise. >>>>>>>>>>>>>>>>>> So I'd like to know if it exists another query expression >>>>>>>>>>>>>>>>>> that enables me to do what I want. >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> Baptiste >>>>>>>>>>>>>>>>>> 2014-08-11 9:53 GMT+02:00 Karl Wright <[email protected] >>>>>>>>>>>>>>>>>> >: >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> Hi Baptiste, >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> See >>>>>>>>>>>>>>>>>>> http://manifoldcf.apache.org/release/trunk/en_US/how-to-build-and-deploy.html#Configuring+a+MySQL+database >>>>>>>>>>>>>>>>>>> . >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> The instructions are similar to configuration of >>>>>>>>>>>>>>>>>>> PostgreSQL, except that the properties.xml property >>>>>>>>>>>>>>>>>>> org.apache.manifoldcf.databaseimplementationclass should be >>>>>>>>>>>>>>>>>>> set to >>>>>>>>>>>>>>>>>>> "org.apache.manifoldcf.core.database.DBInterfaceMySQL". >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> Karl >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> On Mon, Aug 11, 2014 at 3:05 AM, Baptiste Berthier < >>>>>>>>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> Thanks for your answer. I have just one question. I >>>>>>>>>>>>>>>>>>>> have configured ManifoldCF to run on PostgreSQL but now I >>>>>>>>>>>>>>>>>>>> would like to run >>>>>>>>>>>>>>>>>>>> it on MySQL. I found a lot of documentation to configure >>>>>>>>>>>>>>>>>>>> it On Postgresql >>>>>>>>>>>>>>>>>>>> but nothing about the eventual possibility to configure it >>>>>>>>>>>>>>>>>>>> on MySQL. Is it >>>>>>>>>>>>>>>>>>>> possible to configure ManifoldCF on Mysql ? >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> Baptiste >>>>>>>>>>>>>>>>>>>> 2014-08-08 14:10 GMT+02:00 Karl Wright < >>>>>>>>>>>>>>>>>>>> [email protected]>: >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> Hi Baptiste, >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> The patch is not complete; other changes need to be >>>>>>>>>>>>>>>>>>>>> made as well to fix the ticket. But if you are using >>>>>>>>>>>>>>>>>>>>> trunk, you do not >>>>>>>>>>>>>>>>>>>>> need to apply any patch; it's already committed. >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> Thanks, >>>>>>>>>>>>>>>>>>>>> Karl >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> On Fri, Aug 8, 2014 at 7:36 AM, Baptiste Berthier < >>>>>>>>>>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> Hi, >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> I follow the answer of Karl Wright mentionned at >>>>>>>>>>>>>>>>>>>>>> https://issues.apache.org/jira/i#browse/CONNECTORS-1002 >>>>>>>>>>>>>>>>>>>>>> with this content : >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> So I understand that the internal metadata does not >>>>>>>>>>>>>>>>>>>>>> make it through from Alfresco into CMIS. >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> The CMIS connector working against an Alfresco >>>>>>>>>>>>>>>>>>>>>> repository depends completely on Alfresco's >>>>>>>>>>>>>>>>>>>>>> implementation of CMIS. It is >>>>>>>>>>>>>>>>>>>>>> not clear how complete Alfresco's implementation is. The >>>>>>>>>>>>>>>>>>>>>> CMIS connector >>>>>>>>>>>>>>>>>>>>>> code seems like it would definitely pick up most >>>>>>>>>>>>>>>>>>>>>> properties, PROVIDED they >>>>>>>>>>>>>>>>>>>>>> are explicitly mentioned in the CMIS query you provide: >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> //properties >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> List<Property<?>> properties = >>>>>>>>>>>>>>>>>>>>>> document.getProperties(); >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> String id = StringUtils.EMPTY; >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> for (Property<?> property : properties) { >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> String propertyId = property.getId(); >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> if(CmisRepositoryConnectorUtils.existsInSelectClause(cmisQuery, >>>>>>>>>>>>>>>>>>>>>> propertyId)){ >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> if (propertyId.endsWith(Constants.PARAM_OBJECT_ID)) >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> id = (String) property.getValue(); >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> This is from roughly line 1129 of >>>>>>>>>>>>>>>>>>>>>> CMISRepositoryConnector.java. If you can't figure out >>>>>>>>>>>>>>>>>>>>>> what is going on, you >>>>>>>>>>>>>>>>>>>>>> can modify this code to add System.out.println() >>>>>>>>>>>>>>>>>>>>>> statements that should >>>>>>>>>>>>>>>>>>>>>> shed some light on the problem. >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> Please also note that the CMIS connector may not be >>>>>>>>>>>>>>>>>>>>>> resilient against changes to the query string. To be >>>>>>>>>>>>>>>>>>>>>> sure, you may want to >>>>>>>>>>>>>>>>>>>>>> delete your old job and create a new job with the >>>>>>>>>>>>>>>>>>>>>> changed query string, to >>>>>>>>>>>>>>>>>>>>>> be sure everything that needs to be recrawled actually >>>>>>>>>>>>>>>>>>>>>> gets reprocessed. I >>>>>>>>>>>>>>>>>>>>>> will create a different ticket to cover that issue. >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> I have modified the code in ManifoldCF but when I >>>>>>>>>>>>>>>>>>>>>> compile with ant in the folder >>>>>>>>>>>>>>>>>>>>>> apache-manifoldcf-1.6.1\connector\cmis, I >>>>>>>>>>>>>>>>>>>>>> have the following error in >>>>>>>>>>>>>>>>>>>>>> CMISRepositoryConnector.java : >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> "error : cannot find symbol >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> [javac] >>>>>>>>>>>>>>>>>>>>>> if(CmisRepositoryConnectorUtils.existsInSelectClause(cmisQuery, >>>>>>>>>>>>>>>>>>>>>> propertyId)){ >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> [javac] symbol : variable cmisQuery >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> [javac] location : class CmisRepositoryConnector >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> [javac] 1 error >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> Build failed >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> I don't know what I have to do to correct this error >>>>>>>>>>>>>>>>>>>>>> which appears during compilation. >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> Thanks for your answer >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> Baptiste >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> >
