AnsweredAssumed Answered

Mysql Connectivity issue

Question asked by yuva on Nov 20, 2017
Latest reply on Nov 21, 2017 by yuva

Hi

I have created a new alfresco all-in-one project with sdk 2.2, I tried to connect with mysql as a database. So, I changed the following things in alfresco-global.properties.

### database connection properties ###
db.driver=org.gjt.mm.mysql.Driver
# db.driver=org.postgresql.Driver
db.username=root
db.password=root
db.name=alfresco
db.url=jdbc:mysql://localhost:5432/${db.name}  
#?useUnicode=yes&characterEncoding=UTF-8
# db.url=jdbc:postgresql://localhost:5432/${db.name}
# Note: your database must also be able to accept at least this many connections.  Please see your database documentation for instructions on how to configure this.
db.pool.max=100
db.pool.validate.query=SELECT 1
db.port=3306

 

when I start my server, I got this below issues. Can anyone help me to connect my projecct with mysql.

Log :

 

INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug
logging for this logger for a complete list of JARs that were scanned but no TLD
s were found in them. Skipping unneeded JARs during scanning can improve startup
 time and JSP compilation time.
Nov 20, 2017 4:07:45 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deployment of web application directory C:\alfresco-community\tomcat\webap
ps\manager has finished in 155 ms
2017-11-20 16:07:45,912  INFO  [solr.component.AsyncBuildSuggestComponent] [Sugg
estor-alfresco-1] Loaded suggester shingleBasedSuggestions, took 852 ms
 Nov 20, 2017 4:07:45 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-apr-8080"]
Nov 20, 2017 4:07:45 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-apr-8009"]
Nov 20, 2017 4:07:45 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8443"]
Nov 20, 2017 4:07:45 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 23040 ms
2017-11-20 16:08:01,276  ERROR [solr.tracker.AbstractTracker] [org.alfresco.solr
.AlfrescoCoreAdminHandler@4237c6e6_Worker-1] Model tracking failed
 org.alfresco.error.AlfrescoRuntimeException: 10200000 GetModelsDiff return stat
us is 404
        at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.ja
va:1181)
        at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.j
ava:256)
        at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:
214)
        at org.alfresco.solr.tracker.ModelTracker.ensureFirstModelSync(ModelTrac
ker.java:236)
        at org.alfresco.solr.tracker.CoreWatcherJob.registerForCore(CoreWatcherJ
ob.java:145)
        at org.alfresco.solr.tracker.CoreWatcherJob.execute(CoreWatcherJob.java:
82)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:563)
2017-11-20 16:08:01,356  ERROR [solr.tracker.AbstractTracker] [org.alfresco.solr
.AlfrescoCoreAdminHandler@4237c6e6_Worker-2] Tracking failed
 java.net.SocketException: Software caused connection abort: recv failed
        at java.net.SocketInputStream.socketRead0(Native Method)
        at java.net.SocketInputStream.socketRead(Unknown Source)
        at java.net.SocketInputStream.read(Unknown Source)
        at java.net.SocketInputStream.read(Unknown Source)
        at sun.security.ssl.InputRecord.readFully(Unknown Source)
        at sun.security.ssl.InputRecord.read(Unknown Source)
        at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
        at sun.security.ssl.SSLSocketImpl.readDataRecord(Unknown Source)
        at sun.security.ssl.AppInputStream.read(Unknown Source)
        at java.io.BufferedInputStream.fill(Unknown Source)
        at java.io.BufferedInputStream.read(Unknown Source)
        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$Http
ConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413)
        at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMetho
dBase.java:1973)
        at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodB
ase.java:1735)
        at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.j
ava:1098)
        at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(Htt
pMethodDirector.java:398)
        at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMe
thodDirector.java:171)
        at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.jav
a:397)
        at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.jav
a:323)
        at org.alfresco.httpclient.AbstractHttpClient.executeMethod(AbstractHttp
Client.java:135)
        at org.alfresco.httpclient.AbstractHttpClient.sendRemoteRequest(Abstract
HttpClient.java:111)
        at org.alfresco.httpclient.HttpClientFactory$HttpsClient.sendRequest(Htt
pClientFactory.java:408)
        at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.ja
va:1178)
        at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.j
ava:256)
        at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:
214)
        at org.alfresco.solr.tracker.ModelTracker.doTrack(ModelTracker.java:174)

 

        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.j
ava:563)
2017-11-20 16:09:12,416  ERROR [solr.tracker.AbstractTracker] [org.alfresco.solr
.AlfrescoCoreAdminHandler@4237c6e6_Worker-1] Model tracking failed
 org.alfresco.error.AlfrescoRuntimeException: 10200001 GetModelsDiff return stat
us is 404
        at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.ja
va:1181)
        at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.j
ava:256)
        at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:
214)
        at org.alfresco.solr.tracker.ModelTracker.ensureFirstModelSync(ModelTrac
ker.java:236)
        at org.alfresco.solr.tracker.CoreWatcherJob.registerForCore(CoreWatcherJ
ob.java:145)
        at org.alfresco.solr.tracker.CoreWatcherJob.execute(CoreWatcherJob.java:
82)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:563)
2017-11-20 16:09:15,248  ERROR [solr.tracker.AbstractTracker] [org.alfresco.solr
.AlfrescoCoreAdminHandler@4237c6e6_Worker-11] Tracking failed
 org.alfresco.error.AlfrescoRuntimeException: 10200003 api/solr/aclchangesets re
turn status:404
        at org.alfresco.solr.client.SOLRAPIClient.getAclChangeSets(SOLRAPIClient
.java:169)
        at org.alfresco.solr.tracker.AclTracker.checkRepoAndIndexConsistency(Acl
Tracker.java:354)
        at org.alfresco.solr.tracker.AclTracker.trackRepository(AclTracker.java:
320)
        at org.alfresco.solr.tracker.AclTracker.doTrack(AclTracker.java:111)
        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.j
ava:563)
2017-11-20 16:09:15,258  ERROR [solr.tracker.AbstractTracker] [org.alfresco.solr
.AlfrescoCoreAdminHandler@4237c6e6_Worker-13] Model tracking failed
 org.alfresco.error.AlfrescoRuntimeException: 10200004 GetModelsDiff return stat
us is 404
        at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.ja
va:1181)
        at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.j
ava:256)
        at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:
214)
        at org.alfresco.solr.tracker.ModelTracker.ensureFirstModelSync(ModelTrac
ker.java:236)
        at org.alfresco.solr.component.EnsureModelsComponent.prepare(EnsureModel
sComponent.java:87)
        at org.apache.solr.handler.component.AlfrescoSearchHandler.handleRequest
Body(AlfrescoSearchHandler.java:292)
        at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandl
erBase.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(Sol
rInformationServer.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.j
ava:563)
2017-11-20 16:09:15,637  ERROR [solr.tracker.AbstractTracker] [org.alfresco.solr
.AlfrescoCoreAdminHandler@4237c6e6_Worker-12] Tracking failed
 org.alfresco.error.AlfrescoRuntimeException: 10200002 api/solr/aclchangesets re
turn status:404
        at org.alfresco.solr.client.SOLRAPIClient.getAclChangeSets(SOLRAPIClient
.java:169)
        at org.alfresco.solr.tracker.AclTracker.checkRepoAndIndexConsistency(Acl
Tracker.java:354)
        at org.alfresco.solr.tracker.AclTracker.trackRepository(AclTracker.java:
320)
        at org.alfresco.solr.tracker.AclTracker.doTrack(AclTracker.java:111)
        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.j
ava:563)
2017-11-20 16:09:15,680  ERROR [solr.tracker.AbstractTracker] [org.alfresco.solr
.AlfrescoCoreAdminHandler@4237c6e6_Worker-10] Tracking failed
 java.net.SocketException: Software caused connection abort: recv failed
        at java.net.SocketInputStream.socketRead0(Native Method)
        at java.net.SocketInputStream.socketRead(Unknown Source)
        at java.net.SocketInputStream.read(Unknown Source)
        at java.net.SocketInputStream.read(Unknown Source)
        at sun.security.ssl.InputRecord.readFully(Unknown Source)
        at sun.security.ssl.InputRecord.read(Unknown Source)
        at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
        at sun.security.ssl.SSLSocketImpl.readDataRecord(Unknown Source)
        at sun.security.ssl.AppInputStream.read(Unknown Source)
        at java.io.BufferedInputStream.fill(Unknown Source)
        at java.io.BufferedInputStream.read(Unknown Source)
        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$Http
ConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413)
        at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMetho
dBase.java:1973)
        at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodB
ase.java:1735)
        at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.j
ava:1098)
        at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(Htt
pMethodDirector.java:398)
        at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMe
thodDirector.java:171)
        at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.jav
a:397)
        at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.jav
a:323)
        at org.alfresco.httpclient.AbstractHttpClient.executeMethod(AbstractHttp
Client.java:135)
        at org.alfresco.httpclient.AbstractHttpClient.sendRemoteRequest(Abstract
HttpClient.java:111)
        at org.alfresco.httpclient.HttpClientFactory$HttpsClient.sendRequest(Htt
pClientFactory.java:408)
        at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.ja
va:1178)
        at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.j
ava:256)
        at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:
214)
        at org.alfresco.solr.tracker.ModelTracker.doTrack(ModelTracker.java:174)

 

        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.j
ava:563)
2017-11-20 16:09:15,690  ERROR [solr.tracker.AbstractTracker] [org.alfresco.solr
.AlfrescoCoreAdminHandler@4237c6e6_Worker-14] Model tracking failed
 java.net.SocketException: Software caused connection abort: recv failed
        at java.net.SocketInputStream.socketRead0(Native Method)
        at java.net.SocketInputStream.socketRead(Unknown Source)
        at java.net.SocketInputStream.read(Unknown Source)
        at java.net.SocketInputStream.read(Unknown Source)
        at sun.security.ssl.InputRecord.readFully(Unknown Source)
        at sun.security.ssl.InputRecord.read(Unknown Source)
        at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
        at sun.security.ssl.SSLSocketImpl.readDataRecord(Unknown Source)
        at sun.security.ssl.AppInputStream.read(Unknown Source)
        at java.io.BufferedInputStream.fill(Unknown Source)
        at java.io.BufferedInputStream.read(Unknown Source)
        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$Http
ConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413)
        at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMetho
dBase.java:1973)
        at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodB
ase.java:1735)
        at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.j
ava:1098)
        at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(Htt
pMethodDirector.java:398)
        at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMe
thodDirector.java:171)
        at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.jav
a:397)
        at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.jav
a:323)
        at org.alfresco.httpclient.AbstractHttpClient.executeMethod(AbstractHttp
Client.java:135)
        at org.alfresco.httpclient.AbstractHttpClient.sendRemoteRequest(Abstract
HttpClient.java:111)
        at org.alfresco.httpclient.HttpClientFactory$HttpsClient.sendRequest(Htt
pClientFactory.java:408)
        at org.alfresco.solr.client.SOLRAPIClient.getModelsDiff(SOLRAPIClient.ja
va:1178)
        at org.alfresco.solr.tracker.ModelTracker.trackModelsImpl(ModelTracker.j
ava:256)
        at org.alfresco.solr.tracker.ModelTracker.trackModels(ModelTracker.java:
214)
        at org.alfresco.solr.tracker.ModelTracker.ensureFirstModelSync(ModelTrac
ker.java:236)
        at org.alfresco.solr.component.EnsureModelsComponent.prepare(EnsureModel
sComponent.java:87)
        at org.apache.solr.handler.component.AlfrescoSearchHandler.handleRequest
Body(AlfrescoSearchHandler.java:292)
        at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandl
erBase.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(Sol
rInformationServer.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.j
ava:563)

Outcomes