topic Solr Stop working after setting SSL (Alfresco 5.2) in Alfresco Forum

Solr Stop working after setting SSL (Alfresco 5.2)

gerardo-jumper — Fri, 31 Jul 2020 16:01:29 GMT

Hi everyone!

I have problems with Solr after setting my own SSL.

Documents Don´t show up on the Document's Dashlet (Dashboard view), a "Error loading items" message appear.

Searches doesn´t give any result.

I tried to perform a full reindex following this steps: https://docs.alfresco.com/5.0/concepts/search-fts-config.html

This is my tomcat server configuration:

    <Connector port="80" URIEncoding="UTF-8" protocol="HTTP/1.1"
               connectionTimeout="20000"
               redirectPort="443" maxHttpHeaderSize="32768" />
  
    <Connector port="8009" URIEncoding="UTF-8" protocol="AJP/1.3" redirectPort="443" />

    <Connector port="443" URIEncoding="UTF-8" protocol="org.apache.coyote.http11.Http11Protocol" SSLEnabled="true"
               maxThreads="150" scheme="https" keystoreFile="/opt/alfresco-community/alf_data/keystore/ssl.keystore" keystorePass="xxxxxxx" keystoreType="JCEKS"
 secure="true" connectionTimeout="240000" truststoreFile="/opt/alfresco-community/alf_data/keystore/ssl.truststore" truststorePass="xxxxxxxx" truststoreType="JCEKS"
               clientAuth="want" sslProtocol="TLS" allowUnsafeLegacyRenegotiation="true" maxHttpHeaderSize="32768" maxSavePostSize="-1" />

And this is the Solr log:

2020-07-31 00:00:00,052 ERROR [org.alfresco.solr.tracker.AbstractTracker] Model tracking failed
java.net.ConnectException: Connection refused (Connection refused)
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
        at java.net.Socket.connect(Socket.java:589)
        at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:668)
        at sun.security.ssl.SSLSocketImpl.<init>(SSLSocketImpl.java:472)
        at sun.security.ssl.SSLSocketFactoryImpl.createSocket(SSLSocketFactoryImpl.java:153)
        at org.alfresco.encryption.ssl.AuthSSLProtocolSocketFactory.createSocket(AuthSSLProtocolSocketFactory.java:168)
        at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:707)
        at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.open(MultiThreadedHttpConnectionManager.java:1361)
        at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:387)
        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.httpclient.AbstractHttpClient.executeMethod(AbstractHttpClient.java:135)
        at org.alfresco.httpclient.AbstractHttpClient.sendRemoteRequest(AbstractHttpClient.java:111)
        at org.alfresco.httpclient.HttpClientFactory$HttpsClient.sendRequest(HttpClientFactory.java:408)
        at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.java:1178)
        at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.java:256)
        at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:214)
        at org.alfresco.solr.tracker.ModelTracker.ensureFirstModelSync(ModelTracker.java:236)
        at org.alfresco.solr.component.EnsureModelsComponent.prepare(EnsureModelsComponent.java:87)
        at org.apache.solr.handler.component.AlfrescoSearchHandler.handleRequestBody(AlfrescoSearchHandler.java:292)
        at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:135)
        at org.alfresco.solr.Cloud.getResponse(Cloud.java:165)
        at org.alfresco.solr.Cloud.getSolrDocumentList(Cloud.java:149)
        at org.alfresco.solr.SolrInformationServer.getDocsWithUncleanContent(SolrInformationServer.java:722)
        at org.alfresco.solr.tracker.ContentTracker.doTrack(ContentTracker.java:81)
        at org.alfresco.solr.tracker.AbstractTracker.track(AbstractTracker.java:190)
        at org.alfresco.solr.tracker.TrackerJob.execute(TrackerJob.java:54)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)

I hope you could help me, I am lost!

Thank you all.

Re: Solr Stop working after setting SSL (Alfresco 5.2)

angelborroy — Fri, 31 Jul 2020 16:39:43 GMT

You need also the SSL configuration in the SOLR part.

Are you using SOLR 6?

https://docs.alfresco.com/5.2/tasks/solr6-install.html

Re: Solr Stop working after setting SSL (Alfresco 5.2)

gerardo-jumper — Fri, 31 Jul 2020 17:51:37 GMT

thank you for answer.

I'm using SOLR4, I have this configuration in SOLR part:

<alfresco-home>/solr4/workspace-SpacesStore/conf/solrcore.properties

data.dir.root=/opt/alfresco-community/alf_data/solr4/index
data.dir.store=workspace/SpacesStore
enable.alfresco.tracking=true

#
# Alfresco version
#
alfresco.version=5.2.0 (r@scm-revision@-b@build-number@)
                                                                                                                                                                                                                                                                                                                                                                                                                                      #
# Properties loaded during alfresco tracking
#

alfresco.host=localhost
alfresco.port=443
alfresco.port.ssl=8443
alfresco.baseUrl=/alfresco
alfresco.cron=0/15 * * * * ? *
alfresco.stores=workspace://SpacesStore
#alfresco.index.transformContent=false
#alfresco.ignore.datatype.1=d:content
alfresco.lag=1000
alfresco.hole.retention=3600000
# alfresco.hole.check.after is not used yet
# It will reduce the hole checking load
alfresco.hole.check.after=300000
alfresco.batch.count=1000
alfresco.recordUnindexedNodes=true

# encryption

# none, https
alfresco.secureComms=https
# ssl
alfresco.encryption.ssl.keystore.type=JCEKS
alfresco.encryption.ssl.keystore.provider=
alfresco.encryption.ssl.keystore.location=ssl.repo.client.keystore
alfresco.encryption.ssl.keystore.passwordFileLocation=ssl-keystore-passwords.properties
alfresco.encryption.ssl.truststore.type=JCEKS alfresco.encryption.ssl.truststore.provider=
alfresco.encryption.ssl.truststore.location=ssl.repo.client.truststore
alfresco.encryption.ssl.truststore.passwordFileLocation=ssl-truststore-passwords.properties

<alfresco-home>/solr4/workspace-SpacesStore/conf/solrcore.properties

data.dir.root=C:/alfresco2/alf_data/solr4/index
data.dir.store=archive/SpacesStore
enable.alfresco.tracking=true

#
# Alfresco version
#
alfresco.version=5.2.0 (r@scm-revision@-b@build-number@)


#
# Properties loaded during alfresco tracking
#

alfresco.host=localhost
alfresco.port=443
alfresco.port.ssl=8443
alfresco.baseUrl=/alfresco
alfresco.cron=0/15 * * * * ? *
alfresco.stores=archive://SpacesStore
#alfresco.index.transformContent=false
#alfresco.ignore.datatype.1=d:content
alfresco.lag=1000
alfresco.hole.retention=3600000
# alfresco.hole.check.after is not used yet
# It will reduce the hole checking load
alfresco.hole.check.after=300000
alfresco.batch.count=1000
alfresco.recordUnindexedNodes=true

# encryption

# none, https
alfresco.secureComms=https
# ssl
alfresco.encryption.ssl.keystore.type=JCEKS
alfresco.encryption.ssl.keystore.provider=
alfresco.encryption.ssl.keystore.location=ssl.repo.client.keystore
alfresco.encryption.ssl.keystore.passwordFileLocation=ssl-keystore-passwords.properties
alfresco.encryption.ssl.truststore.type=JCEKS                                                                                                                                                                      alfresco.encryption.ssl.truststore.provider=
alfresco.encryption.ssl.truststore.location=ssl.repo.client.truststore
alfresco.encryption.ssl.truststore.passwordFileLocation=ssl-truststore-passwords.properties

I don't know what I am missing

Re: Solr Stop working after setting SSL (Alfresco 5.2)

REDOUANE10 — Mon, 28 Mar 2022 18:27:20 GMT

Bonjour,

J'ai le meme probléme, si quelqu'un a une solution merci de nous aider SVP !