topic Re: Troubles with Solr admin serching in Alfresco Archive

Troubles with Solr admin serching

vladislavlysov — Fri, 11 Nov 2011 06:09:31 GMT

Re: Troubles with Solr admin serching

mcasanket — Thu, 15 Dec 2011 05:57:53 GMT

Hi VladislavLysov,

When I fire a query from https://localhost:8443/solr/alfresco/admin/form.jsp like @cm\:name:"test" It is not showing any result! 😞

How can I know that It is connected with alfresco repository while using SOLR UI? Plz help.

Re: Troubles with Solr admin serching

mcasanket — Thu, 15 Dec 2011 06:43:03 GMT

Hello!!!
I was install Alfresco 4.0b and uploaded a few files(with .txt extension) through the Share. After that a was opened Solr admin at this URL http:\\localhost:8888\solr\alfresco\admin. Then I typed my query(for example - " @cm\:name:"green banana"") in the query field. I know - this file in Alfresco Share, i see him) But this query returned 0 documents. I think this is due to the fact that he was looking at some other location, not in Alfresco Repository.How can I ensure that my query returns a found documents downloaded from Alfresco Share?
P.S. If i type in query field this query "*:*", its returned next json


{
 "responseHeader":{
  "status":0,
  "QTime":15,
  "params":{
   "indent":"on",
   "start":"0",
   "q":"*:*",
   "rows":"10",
   "version":"2.2"}},
 "response":{"numFound":1658,"start":0,"docs":[
   {
    "INACLTXID":["1"],
    "ACLID":["1"],
    "ID":["ACL-1"]},
   {
    "INACLTXID":["1"],
    "ACLID":["2"],
    "ID":["ACL-2"]},
   {
    "INACLTXID":["1"],
    "ACLTXCOMMITTIME":["1320818862645"],
    "ACLTXID":["1"],
    "ID":["ACLTX-1"]},
   {
    "INACLTXID":["2"],
    "ACLID":["3"],
    "ID":["ACL-3"]},
   {
    "INACLTXID":["2"],
    "ACLID":["4"],
    "ID":["ACL-4"]},
   {
    "INACLTXID":["2"],
    "ACLTXCOMMITTIME":["1320818862942"],
    "ACLTXID":["2"],
    "ID":["ACLTX-2"]},
   {
    "INACLTXID":["3"],
    "READER":["GROUP_EVERYONE"],
    "ACLID":["5"],
    "ID":["ACL-5"]},
   {
    "INACLTXID":["3"],
    "ACLTXCOMMITTIME":["1320818863113"],
    "ACLTXID":["3"],
    "ID":["ACLTX-3"]},
   {
    "INACLTXID":["4"],
    "READER":["GROUP_EVERYONE"],
    "ACLID":["6"],
    "ID":["ACL-6"]},
   {
    "INACLTXID":["4"],
    "ACLTXCOMMITTIME":["1320818863145"],
    "ACLTXID":["4"],
    "ID":["ACLTX-4"]}]
 }}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Thank you.

Re: Troubles with Solr admin serching

openpj — Thu, 15 Dec 2011 08:43:30 GMT

Have you tried to execute the following query?


@cm\:name:"tes*"
‍‍‍

Hope this helps.

Re: Troubles with Solr admin serching

mcasanket — Fri, 16 Dec 2011 06:03:17 GMT

Hi,
I have tried what you suggested, but it returns the following result.

{
 "responseHeader":{
  "status":0,
  "QTime":0,
  "params":{
   "indent":"on",
   "start":"0",
   "q":"@cm\\:name:\"tes*\"",
   "rows":"10",
   "version":"2.2"}},
 "response":{"numFound":0,"start":0,"docs":[]
 }}‍‍‍‍‍‍‍‍‍‍‍‍

One more thing, my Alfresco 4.0 is using Solr now. but When I go to Solr home page https://localhost:8443/solr/alfresco/admin/ and try @cm\:name:"tes*" it returns the above response. I am not able to know that Whether it is connected with my alfresco repository or not. Also in my alfresco admin Console I am not able to see the Solr related page…. plz help

Have you tried to execute the following query?
@cm\:name:"tes*"
‍‍‍
Hope this helps.

Re: Troubles with Solr admin serching

jpfi — Fri, 16 Dec 2011 08:22:38 GMT

Hi,
you cannot directly executean Alfresco lucene/afts query string using default solr query component (via solr admin interface).
In this case you have to know how Alfresco's SolrUpdateHandler & FieldType indexes the document:
Warning: normally you won't query Solr directly, only via Alfresco's searchService, e.g. to ensure correct permission checks (filterQuery)
e.g. cm:name will be indexed in different ways with follwing Solr field names:
@{http://www.alfresco.org/model/content/1.0}name
@{http://www.alfresco.org/model/content/1.0}name.__
@{http://www.alfresco.org/model/content/1.0}name.__.u
@{http://www.alfresco.org/model/content/1.0}name.u
@{http://www.alfresco.org/model/content/1.0}name.sort

–> e.g. your query should look like

@\{http\://www.alfresco.org/model/content/1.0\}name:test‍

…I'm not sure about the escape chars "\"…
cheers, jan

Re: Troubles with Solr admin serching

mcasanket — Fri, 16 Dec 2011 09:56:20 GMT

Hi Jan,
   Thank you for your quick response.
   You wrote Solr Admin Interface… so you are talking about https://localhost:8443/solr/alfresco/admin/form.jsp?
   Does it mean that I can't query alfresco repository using Solr User interface?

One more thing, I am not seeing anything related to Solr in Share Admin console 😞

you cannot directly executean Alfresco lucene/afts query string using default solr query component (via solr admin interface).

Please help!

Re: Troubles with Solr admin serching

jpfi — Fri, 16 Dec 2011 14:27:55 GMT

Hi,
You can query Alfresco's solr index directly, but normally you shouldn't.
What's your use case?
Cheers, jan

Re: Troubles with Solr admin serching

mcasanket — Sat, 17 Dec 2011 09:40:05 GMT

Hi Jan,
Actually I want to Demonstrate the SOLR working with Alfresco Repository. So I tried to hit query from SOLR admin (https://localhost:8443/solr/alfresco/admin/form.jsp). But didn't get success…. 😞

Is there anything like SOLR admin Console in Alfresco shre Amdin Console…? I saw the Image in one post. When I hit the url localhost:8080/share/page/console/admin-console/solr showed in the Image it shows nothing… plz help….
[img]https://issues.alfresco.com/jira/secure/attachment/25881/solr_tool.png[/img]

You can query Alfresco's solr index directly, but normally you shouldn't.

Thanking you!

Re: Troubles with Solr admin serching

kbonnet — Tue, 03 Apr 2012 07:25:00 GMT

For all future readers. You can test your SOLR indexes via the SOLR admin, by using this url:

/solr/alfresco/afts?q="@{http://www.alfresco.org/model/content/1.0}name:'*''&indent=on

As said permissions are not filtered, so you cannot use this for developing.

Re: Troubles with Solr admin serching

andy — Tue, 03 Apr 2012 11:20:28 GMT

Hi

Please do not use the SOLR admin page to execute queries.
The default query language is not an Alfresco one and it knows nothing of the Alfresco data model.

You can do something like this direct to SOLR if you have to :

https://localhost:8443/solr/alfresco/afts?q=name:*

Or you can go to the share node browser in teh admin screens and run queries from there.

Andy