topic Re: Alfresco 4.0 Solr problem in Alfresco Archive

Alfresco 4.0 Solr problem

mcasanket — Wed, 14 Dec 2011 06:12:37 GMT

Hi all, I have just installed alfresco 4.0 and I want to use Solr in my project. I have put the following lines in my global.prop file and it is working fine. Does it mean the SOLR is working?### Solr indexing ###index.subsystem.name=solrdir.keystore=${dir.root}/keystoresolr.port.ssl=8443## newly

Re: Alfresco 4.0 Solr problem

jpfi — Wed, 14 Dec 2011 08:25:35 GMT

Hi,
I guess you you have to escape the first ":" if your're using lucene and not alfresco-fts:
–> @cm\:name:sanket'
Cheers, jan

Re: Alfresco 4.0 Solr problem

mcasanket — Wed, 14 Dec 2011 09:37:19 GMT

Thanks for your reply!
When I run the query form browser https://localhost:8443/solr/alfresco/admin/ I am getting either no error but shows numFounds=0 or the exception which is in main topic.

Hi,
I guess you you have to escape the first ":" if your're using lucene and not alfresco-fts:
–> @cm\:name:sanket'
Cheers, jan

Thank you!

Re: Alfresco 4.0 Solr problem

jpfi — Wed, 14 Dec 2011 10:04:33 GMT

Hi,
You cannot run the query straight from https://localhost:8443/solr/alfresco/admin/ because you've to use the right query component (alfresco adds its own here).
If you use the default one via the solr web interface you've to tweak your search expression…e.g. @{http://www.alfresco.org/model/content/1.0}name:sanket
perhaps you've to escape some chars like @\{http\://www.alfresco.org/model/content/1.0\}name:sanket
That is only a quick hack, you cannot execute this query from alfresco!
Cheers, Jan

Re: Alfresco 4.0 Solr problem

mcasanket — Wed, 14 Dec 2011 10:43:11 GMT

Hi Jan,
Thanks for your quick response! The other thing I wanted to know, I am able to log in in alfresco and share both. But How can I identify that the queries are run by SOLR or the old way before SOLR.

However I have set the following things in my glob.prop file.
### Solr indexing ###
index.subsystem.name=solr
dir.keystore=${dir.root}/keystore
solr.port.ssl=8443
## newly added.
solr.host=localhost
solr.port=8080
# default keystores location
dir.keystore=classpath:alfresco/keystore

encryption.ssl.keystore.location=${dir.keystore}/ssl.keystore
encryption.ssl.keystore.provider=
encryption.ssl.keystore.type=JCEKS
encryption.ssl.keystore.keyMetaData.location=${dir.keystore}/ssl-keystore-passwords.properties

encryption.ssl.truststore.location=${dir.keystore}/ssl.truststore
encryption.ssl.truststore.provider=
encryption.ssl.truststore.type=JCEKS
encryption.ssl.truststore.keyMetaData.location=${dir.keystore}/ssl-truststore-passwords.properties

Hi,
You cannot run the query straight from https://localhost:8443/solr/alfresco/admin/ because you've to use the right query component (alfresco adds its own here).
If you use the default one via the solr web interface you've to tweak your search expression…e.g. @{http://www.alfresco.org/model/content/1.0}name:sanket
perhaps you've to escape some chars like @\{http\://www.alfresco.org/model/content/1.0\}name:sanket
That is only a quick hack, you cannot execute this query from alfresco!
Cheers, Jan

Re: Alfresco 4.0 Solr problem

jpfi — Wed, 14 Dec 2011 10:58:47 GMT

Hi,
just enable debug logging in log4j.properties:
log4j.logger.org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient=debug

Cheers, Jan

Re: Alfresco 4.0 Solr problem

mcasanket — Wed, 14 Dec 2011 12:01:27 GMT

Hi Jan,
    I have enabled the debugging in both the log4j.prop files.

    C:\AlfrescoSolr\tomcat\webapps\share\WEB-INF\classes\log4j.properties
    C:\AlfrescoSolr\tomcat\webapps\alfresco\WEB-INF\classes\log4j.properties

But whenever I do any operation like log in, going into site or clicking on any link. It doesn't print anything on console.

Hi,
just enable debug logging in log4j.properties:
log4j.logger.org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient=debug

Cheers, Jan

Re: Alfresco 4.0 Solr problem

mcasanket — Wed, 14 Dec 2011 12:27:21 GMT

Hi,

One more thing to add, When I go to https://localhost:8443/solr/alfresco/admin/ping it shows me the following result.

{"responseHeader":{"status":0,"QTime":16,"params":{"echoParams":"all","echoParams":"all","q":"solrpingquery","qt":"standard"}},"status":"OK"}

Does it mean that Solr is not working properly?

Thanking you!

Re: Alfresco 4.0 Solr problem

jpfi — Wed, 14 Dec 2011 12:40:12 GMT

Hi,
your solr is up & running. But the question is if your alfresco-solr connection is working properly.
if you activated solr as search subsytem (index.subsystem.name=solr), activated (log4j.logger.org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient=debug) & execute a search in Share you should view some logs…
jan

Re: Alfresco 4.0 Solr problem

mcasanket — Thu, 15 Dec 2011 05:44:33 GMT

Hey Thank you so much Jan,

I made a mistake yesterday while enabling a log in log4j file (Spelling mistake) ops: and that was the reason the logs were not getting printed.
Today when I correct that spelling error It shows me logs when I click any link or search something in Share!

Logs:

 2011-12-15 11:00:40,433  DEBUG [impl.solr.SolrQueryHTTPClient] [http-8080-8]    with: {"textAttributes":[],"allAttributes":[],"templates":[],
brary//*\" +@cm\\:modified:[2011\\-12\\-8T00\\:00\\:00.000 TO 2011\\-12\\-15T23\\:59\\:59.999] +@cm\\:modifier:\"admin\" +TYPE:\"cm:content\"
rum\" -TYPE:\"fm:topic\" -TYPE:\"fm:post\" +(TYPE:\"content\" OR TYPE:\"app:filelink\" OR TYPE:\"folder\")","locales":["en_US"],"defaultNamesp
SFieldOperator":"OR","defaultFTSOperator":"OR","filter":"|AUTHORITY:\"GROUP_ALFRESCO_ADMINISTRATORS\" |AUTHORITY:\"GROUP_EMAIL_CONTRIBUTORS\"
\" |AUTHORITY:\"GROUP_site_swsdp_SiteManager\" |AUTHORITY:\"ROLE_ADMINISTRATOR\" |AUTHORITY:\"ROLE_AUTHENTICATED\""}
 2011-12-15 11:00:40,433  DEBUG [impl.solr.SolrQueryHTTPClient] [http-8080-8] Got: 1 in 1469 ms‍‍‍‍‍‍

It means my alfresco and share both are using SOLR now. Jan when I run the SOLR UI (https://localhost:8443/solr/alfresco/admin/) It is not working properly… like simple query @cm\:name:"sanket" is not working… Even I don't know that whether it is able to connect to the repository or not! :? How can I know that?

Hi,
your solr is up & running. But the question is if your alfresco-solr connection is working properly.
if you activated solr as search subsytem (index.subsystem.name=solr), activated (log4j.logger.org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient=debug) & execute a search in Share you should view some logs…
jan

Thank you!

Re: Alfresco 4.0 Solr problem

mcasanket — Thu, 15 Dec 2011 06:16:13 GMT

Hi,
I am not able to see the SOLR in Admin Colsole.. How can I make it enable…? I am using Alfresco 4.0a.

I just saw one post in that he has uploaded the Image.

The Image URL is : https://issues.alfresco.com/jira/secure/attachment/25881/solr_tool.png

[img]https://issues.alfresco.com/jira/secure/attachment/25881/solr_tool.png[/img]

Please help…