topic Re: ConnectException from Solr in Alfresco Archive

ConnectException from Solr

nobby — Mon, 10 Oct 2011 17:04:34 GMT

Hi all,this exception fills catalina.out since it is thrown by a scheduled job:java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(Pla

Re: ConnectException from Solr

janv — Tue, 11 Oct 2011 09:10:22 GMT

This message indicates that the Alfresco SOLR server (=> CoreTracker) cannot connect back into to the Alfresco Repository server in order to poll for (changes that require) indexing. I assume you're using Community 4.0a - if so, is this a fresh install and did you use the installer to setup your system ?

Regards,
Jan

Re: ConnectException from Solr

nobby — Tue, 11 Oct 2011 09:25:41 GMT

Hi Jan,

This message indicates that the Alfresco SOLR server (=> CoreTracker) cannot connect back into to the Alfresco Repository server in order to poll for (changes that require) indexing.

thanks! Since the message is "connection refused", I assume that SOLR uses the wrong URI/port. Maybe the reason is that I use a custom port? Do I need to configure this somewhere?

I assume you're using Community 4.0a

Yes.

if so, is this a fresh install and did you use the installer to setup your system ?

Yes, I only customized the Tomcat ports and the Kerberos authentication settings.

Best regards,
Andreas

Re: ConnectException from Solr

nobby — Tue, 11 Oct 2011 09:29:46 GMT

I see a lot of references to the port in the webapp config files. Maybe I need to reinstall Alfresco and configure the port initially?


grep -r 8080 webapps/ | grep -v \.css | grep -v \.js
webapps/alfresco/WEB-INF/classes/alfresco-global.properties.sample:#alfresco.port=8080
webapps/alfresco/WEB-INF/classes/alfresco-global.properties.sample:#share.port=8080
webapps/alfresco/WEB-INF/classes/alfresco/repository.properties:repo.remote.url=http://localhost:8080/alfresco
webapps/alfresco/WEB-INF/classes/alfresco/repository.properties:solr.port=8080
webapps/alfresco/WEB-INF/classes/alfresco/subsystems/sysAdmin/default/sysadmin-parameter.properties:alfresco.port=8080
webapps/alfresco/WEB-INF/classes/alfresco/subsystems/sysAdmin/default/sysadmin-parameter.properties:share.port=8080
webapps/alfresco/WEB-INF/classes/alfresco/subsystems/Search/solr/solr-search.properties:solr.port=8080
webapps/alfresco/WEB-INF/classes/alfresco/web-client-config.xml:         <port>8080</port>
Binary file webapps/alfresco/WEB-INF/lib/standard.jar matches
webapps/alfresco/wsdl/authentication-service.wsdl:         <wsdlsoap:address location="http://localhost:8080/alfresco/api/AuthenticationService'/>
webapps/alfresco/wsdl/repository-service.wsdl:         <wsdlsoap:address location="http://localhost:8080/alfresco/api/RepositoryService'/>
webapps/alfresco/wsdl/administration-service.wsdl:          <wsdlsoap:address location="http://localhost:8080/alfresco/api/AdministrationService'/>
webapps/alfresco/wsdl/action-service.wsdl:          <wsdlsoap:address location="http://localhost:8080/alfresco/api/ActionService'/>
webapps/alfresco/wsdl/classification-service.wsdl:         <wsdlsoap:address location="http://localhost:8080/alfresco/api/ClassificationService'/>
webapps/alfresco/wsdl/access-control-service.wsdl:          <wsdlsoap:address location="http://localhost:8080/alfresco/api/AccessControlService'/>
webapps/alfresco/wsdl/dictionary-service.wsdl:         <wsdlsoap:address location="http://localhost:8080/alfresco/api/DictionaryService'/>
webapps/alfresco/wsdl/authoring-service.wsdl:         <wsdlsoap:address location="http://localhost:8080/alfresco/api/AuthoringService'/>
webapps/alfresco/wsdl/content-service.wsdl:         <wsdlsoap:address location="http://localhost:8080/alfresco/api/ContentService'/>
webapps/share/WEB-INF/classes/alfresco/share-documentlibrary-config.xml:      <repository-url>http://localhost:8080/alfresco</repository-url>
webapps/share/WEB-INF/classes/alfresco/share-cmis-config.xml:            <parameter key="org.apache.chemistry.opencmis.binding.atompub.url" value="http://localhost:8080/alfresco/cmisatom'/>
webapps/share/WEB-INF/classes/alfresco/share-config.xml:            <endpoint-url>http://localhost:8080/alfresco/activiti-admin</endpoint-url>
webapps/share/yui/swfplayer/assets/as/README.txt:   http://localhost:8080/share/yui/swfplayer/assets
webapps/share/yui/swfplayer/assets/as/SWFPlayer.as:         //load("http://localhost:8080/share/proxy/alfresco/api/node/content/workspace/SpacesStore/d90b9295-0e9e-4241-894d-ff4685107f83?a=true&alf_ticket=TICKET_e2d2ec15744338d4ddedbba6634cb69f7add69a5", false);
webapps/share/yui/swfplayer/assets/as/SWFPlayer.as:         load("http://localhost:8080/AVM2.swf", false);
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Best regards,
Andreas

Re: ConnectException from Solr

nobby — Tue, 11 Oct 2011 09:59:45 GMT

I changed the ports back to 8080/8443. Now the connection seems to succeed, but the certificate check fails:

unable to find valid certification path to requested target‍

Do I have to add the Tomcat certificate to the SOLR keystore? Is it this configuration entry?


### Solr indexing ###
index.subsystem.name=solr
dir.keystore=${dir.root}/keystore
‍‍‍‍‍

Where is the ${dir.root}?
What is the name of the keystore file?

TIA and best regards,
Andreas

Re: ConnectException from Solr

nobby — Tue, 11 Oct 2011 10:03:41 GMT

IIUC Alfresco tries to connect as a client to the SOLR server via SSL. Maybe I have to add the Tomcat cert to the Tomcat truststore so that it can connect to itself. I'll try this and report back.

Re: ConnectException from Solr

nobby — Tue, 11 Oct 2011 10:08:38 GMT

Unfortunately that didn't work.

Re: ConnectException from Solr

janv — Tue, 11 Oct 2011 12:25:13 GMT

Does the following help:

http://wiki.alfresco.com/wiki/Alfresco_And_SOLR

Regards,
Jan

ps. some additional info, if running in a dev env:

http://svn.alfresco.com/repos/alfresco-open-mirror/alfresco/HEAD/root/projects/solr/source/solr/instance/HowToSetUpSolr.txt

Re: ConnectException from Solr

paulhh — Tue, 11 Oct 2011 12:51:12 GMT

The installer is not substituting the SSL port property for Solr. You can do this manually in two locations within alf_data/solr:

archive-SpacesStore/conf/solrcore.properties
workspace-SpacesStore/conf/solrcore.properties

Also the port number should be set in tomcat/conf/server.xml in te connector with all the keystore parameters.

Paul.

Re: ConnectException from Solr

fstnboy — Thu, 17 Nov 2011 16:56:49 GMT

Hi,

I'm facing the same issue….

Nothing special in the installation, I used the keystore and truststore provided by Alfresco and followed the instructions on HowToSetUpSolr.txt, but I'm getting the same ConnectionRefused error thrown by the tracker.

I'm working with Alfresco Enterprise 4 Beta and have both under the same Tomcat instance…

Any clue on that?

Re: ConnectException from Solr

fstnboy — Thu, 17 Nov 2011 17:03:30 GMT

Not sure if this has anything to do with the issue but if I connect via JMX and go to Alfresco–>Configuration–>Search, I can see that all the attributes corresponding to tracker.alfresco.* and tracker.archive.* say Unavailable

Re: ConnectException from Solr

fstnboy — Mon, 21 Nov 2011 09:50:40 GMT

Moving up!

Anyone with the same problem with the Enterprise Beta version?
Any help?

Thanks?

Re: ConnectException from Solr

janv — Mon, 21 Nov 2011 10:40:06 GMT

Have you tried contacting Alfresco Support (since you're using Enterprise 4.0 Beta) ?

Regards,
Jan

Re: ConnectException from Solr

fstnboy — Tue, 22 Nov 2011 10:11:51 GMT

I did but still waiting….

Re: ConnectException from Solr

imisan — Sun, 11 Mar 2012 15:11:46 GMT

It seems that we have same problem. Using Alfresco Enterprise 4.0.0 wtih default SOLR enabled. We found that if there is more than 5 min delay between two search queries SOLR throws org.alfresco.repo.search.impl.lucene.LuceneQueryParserException which is caused by some SocketException. Partial stack trace is here:
   … 30 more
Caused by: org.alfresco.repo.search.impl.lucene.LuceneQueryParserException: 02110073
   at org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.executeQuery(SolrQueryHTTPClient.java:364)
   at org.alfresco.repo.search.impl.solr.SolrQueryLanguage.executeQuery(SolrQueryLanguage.java:49)
   at org.alfresco.repo.search.impl.solr.SolrSearchService.query(SolrSearchService.java:348)
   at org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:78)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.alfresco.repo.management.subsystems.SubsystemProxyFactory$1.invoke(SubsystemProxyFactory.java:65)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
   at $Proxy14.query(Unknown Source)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
   at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at com.agilent.datastore.audit.intrecept.DataStoreAuditMethodInterceptor.proceedWithAudit(DataStoreAuditMethodInterceptor.java:271)
   at com.agilent.datastore.audit.intrecept.DataStoreAuditMethodInterceptor.proceed(DataStoreAuditMethodInterceptor.java:182)
   at com.agilent.datastore.audit.intrecept.DataStoreAuditMethodInterceptor.invoke(DataStoreAuditMethodInterceptor.java:135)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
   at $Proxy14.query(Unknown Source)
   at org.alfresco.repo.jscript.Search.query(Search.java:801)
   … 49 more
Caused by: java.net.SocketException: Software caused connection abort: recv failed
   at java.net.SocketInputStream.socketRead0(Native Method)
   at java.net.SocketInputStream.read(SocketInputStream.java:129)
   at com.sun.net.ssl.internal.ssl.InputRecord.readFully(InputRecord.java:293)
   at com.sun.net.ssl.internal.ssl.InputRecord.read(InputRecord.java:331)
   at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:798)
   at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:755)
   at com.sun.net.ssl.internal.ssl.AppInputStream.read(AppInputStream.java:75)
   at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
   at java.io.BufferedInputStream.read(BufferedInputStream.java:237)
   at org.apache.commons.httpclient.HttpParser.readRawLine(HttpParser.java:78)
   at org.apache.commons.httpclient.HttpParser.readLine(HttpParser.java:106)
   at org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.java:1116)
   at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413)
   at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1973)
   at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1735)
   at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:1098)
   at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:398)
   at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171)
   at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)
   at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:323)
   at org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.executeQuery(SolrQueryHTTPClient.java:318)
   … 80 more

This is stably reproduced issue. Any of following queries (like first one) works good without any exceptions. We use Tomcat 6 and MS SQL Server 2008. Also it is fresh installation.

Re: ConnectException from Solr

ebrenes — Wed, 10 Jul 2019 20:06:41 GMT

I had this problem in my local environment and I solved it running solr without SSL.

This is from the Alfresco official documentation:

I only followed the steps 1,2 and 3, as I didn't have the web.xml config it asks to remove.

Alfresco uses SSL to secure communication between the repository server and the Solr 4 server. In this communication, SSL not only provides encryption, it is also used for authentication. This topic describes how to turn-off SSL and deactivate authentication between Alfresco repository and the Solr server.

Set the solr.secureComms property to none in the alfresco-global.properties file.
Ensure that the solr.port property is set to the correct non-SSL port of the application server in which Solr is running.
In the <solrRootDir>/archive-SpacesStore/conf/solrcore.properties file and <solrRootDir>/workspace-SpacesStore/conf/solrcore.properties file, do the following:Set the property alfresco.secureComms property to none.
Ensure that the alfresco.port property is set to the correct non-SSL port of the application server in which your repository is running.
In the repository <TOMCAT_HOME>/webapps/alfresco/WEB-INF/web.xml, remove the following configuration:<security-constraint>   <web-resource-collection>       <web-resource-name>SOLR</web-resource-name>       <url-pattern>/service/api/solr/*</url-pattern>   </web-resource-collection>    <auth-constraint>       <role-name>repoclient</role-name>   </auth-constraint>    <user-data-constraint>       <transport-guarantee>CONFIDENTIAL</transport-guarantee>   </user-data-constraint></security-constraint><security-constraint>   <web-resource-collection>       <web-resource-name>SOLR</web-resource-name>       <url-pattern>/s/api/solr/*</url-pattern>   </web-resource-collection>    <auth-constraint>       <role-name>repoclient</role-name>   </auth-constraint>    <user-data-constraint>       <transport-guarantee>CONFIDENTIAL</transport-guarantee>   </user-data-constraint></security-constraint><security-constraint>    <web-resource-collection>       <web-resource-name>SOLR</web-resource-name>       <url-pattern>/wcservice/api/solr/*</url-pattern>    </web-resource-collection>     <auth-constraint>       <role-name>repoclient</role-name>    </auth-constraint>     <user-data-constraint>       <transport-guarantee>CONFIDENTIAL</transport-guarantee>    </user-data-constraint></security-constraint><security-constraint>    <web-resource-collection>       <web-resource-name>SOLR</web-resource-name>       <url-pattern>/wcs/api/solr/*</url-pattern>    </web-resource-collection>     <auth-constraint>       <role-name>repoclient</role-name>    </auth-constraint>     <user-data-constraint>       <transport-guarantee>CONFIDENTIAL</transport-guarantee>    </user-data-constraint></security-constraint><login-config>    <auth-method>CLIENT-CERT</auth-method>    <realm-name>Repository</realm-name></login-config><security-role>    <role-name>repoclient</role-name></security-role>
In the Solr <TOMCAT_HOME>/webapps/solr4/WEB-INF/web.xml, remove the following configuration:<security-constraint>   <web-resource-collection>      <url-pattern>/*</url-pattern>   </web-resource-collection>   <auth-constraint>      <role-name>repository</role-name>   </auth-constraint>      <user-data-constraint>         <transport-guarantee>CONFIDENTIAL</transport-guarantee>      </user-data-constraint></security-constraint><login-config>   <auth-method>CLIENT-CERT</auth-method>      <realm-name>Solr</realm-name></login-config><security-role>   <role-name>repository</role-name></security-role>

If you decide to turn-off SSL and deactivate authentication between Alfresco repository and the Solr server, you need to protect your environment. For more information, see Configuring SSL for a production environment.

From solr web.xml (tomcat/webapps/solr4/WEB-INF/web.xml) I removed this filter:

<filter-name>X509AuthFilter</filter-name>

and the filter mapping

<filter-mapping>
    <filter-name>X509AuthFilter</filter-name>
    <url-pattern>/*</url-pattern>
</filter-mapping>