As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
We have DB and application on different servers.
Any changes we are missing do let us know.
Thanks,'
Neha
Can you upload the log file?
Hi ,
As for connecting to postgres DB on another server we renamed alfresco-global.properties.sample file to alfresco-global.properties.
Later when we tried adding custom changes like adding users to groups it was giving solr errorso we directly made entry in alfresco-global.properties
### Solr indexing ###index.subsystem.name=solr4
it was working till then but when we tried to add custom workflow now Tomcat is not starting as its connected to bpmn.xml file. On reverting these changes area is working.
PFB logs:
alfresco.log
2017-03-21 20:02:44,788 INFO [org.alfresco.repo.admin] [localhost-startStop-1] Using database URL 'jdbcostgresql://10.182.93.76:5445/alfresco' with user 'alfresco'.2017-03-21 20:02:44,788 INFO [org.alfresco.repo.admin] [localhost-startStop-1] Connected to database PostgreSQL version 9.3.152017-03-21 20:02:52,272 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Ignoring script patch (post-Hibernate): patch.db-V4.2-metadata-query-indexes2017-03-21 20:02:52,272 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Ignoring script patch (post-Hibernate): patch.db-V5.1-metadata-query-indexes2017-03-21 20:03:04,147 INFO [org.springframework.extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor Repository Template Processor for extension ftl2017-03-21 20:03:04,163 INFO [org.springframework.extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor Repository Script Processor for extension js2017-03-21 20:03:07,413 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]2017-03-21 20:03:07,491 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted] complete2017-03-21 20:03:07,553 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Connecting to database: jdbcostgresql://10.182.93.76:5445/alfresco, UserName=alfresco, PostgreSQL Native Driver2017-03-21 20:03:07,553 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] Schema managed by database dialect org.hibernate.dialect.PostgreSQLDialect.2017-03-21 20:03:09,960 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [localhost-startStop-1] No changes were made to the schema.2017-03-21 20:03:11,475 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]2017-03-21 20:03:11,944 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1] complete2017-03-21 20:03:15,569 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'thirdparty' subsystem, ID: [thirdparty, default]2017-03-21 20:03:15,663 ERROR [org.alfresco.repo.content.transform.magick.AbstractImageMagickContentTransformerWorker] [localhost-startStop-1] ImageMagickContentTransformerWorker not available: 02210001 Failed to perform ImageMagick transformation: Execution result: os: Windows Server 2012 R2 command: ./ImageMagick/bin/convert F:\alfresco-community\tomcat\temp\Alfresco\ImageMagickContentTransformerWorker_init_source_6434968105053035640.gif F:\alfresco-community\tomcat\temp\Alfresco\ImageMagickContentTransformerWorker_init_target_1936543517542057440.png succeeded: false exit code: 1 out: err: Cannot run program "./ImageMagick/bin/convert": CreateProcess error=2, The system cannot find the file specified2017-03-21 20:03:15,678 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'thirdparty' subsystem, ID: [thirdparty, default] complete2017-03-21 20:03:15,678 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'OOoDirect' subsystem, ID: [OOoDirect, default]2017-03-21 20:03:15,991 ERROR [org.alfresco.util.exec.RuntimeExecBootstrapBean] [localhost-startStop-1] Bootstrap command failed: Execution result: os: Windows Server 2012 R2 command: soffice -accept=socket,host=127.0.0.1,port=8100;urp;StarOffice.ServiceManager -env:UserInstallation=file:///F:/alfresco-community/alf_data/oouser -headless -nocrashreport -nofirststartwizard -nologo -norestore succeeded: false exit code: 2 out: err: Cannot run program "soffice": CreateProcess error=2, The system cannot find the file specified2017-03-21 20:03:18,132 WARN [org.alfresco.util.OpenOfficeConnectionTester] [localhost-startStop-1] An initial OpenOffice connection could not be established.2017-03-21 20:03:18,132 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'OOoDirect' subsystem, ID: [OOoDirect, default] complete2017-03-21 20:03:18,147 WARN [org.alfresco.repo.admin.ConfigurationChecker] [localhost-startStop-1] The Alfresco 'dir.root' property is set to a relative path './alf_data'. 'dir.root' should be overridden to point to a specific folder.2017-03-21 20:03:18,147 INFO [org.alfresco.repo.admin.ConfigurationChecker] [localhost-startStop-1] The Alfresco root data directory ('dir.root') is: .\alf_data2017-03-21 20:03:18,147 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'Search' subsystem, ID: [Search, managed, noindex]2017-03-21 20:03:18,444 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'Search' subsystem, ID: [Search, managed, noindex] complete2017-03-21 20:03:18,491 INFO [org.alfresco.repo.admin.patch.PatchExecuter] [localhost-startStop-1] Checking for patches to apply ...2017-03-21 20:03:19,288 INFO [org.alfresco.repo.admin.patch.PatchExecuter] [localhost-startStop-1] No patches were required.2017-03-21 20:03:19,335 INFO [org.alfresco.repo.module.ModuleServiceImpl] [localhost-startStop-1] Found 1 module package(s).2017-03-21 20:03:19,507 INFO [org.alfresco.repo.module.ModuleServiceImpl] [localhost-startStop-1] Starting module 'alfresco-share-services' version 5.2.0.2017-03-21 20:03:19,632 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'fileServers' subsystem, ID: [fileServers, default]2017-03-21 20:03:20,053 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]2017-03-21 20:03:20,100 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete2017-03-21 20:03:20,257 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'fileServers' subsystem, ID: [fileServers, default] complete2017-03-21 20:03:20,257 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'imap' subsystem, ID: [imap, default]2017-03-21 20:03:20,397 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'imap' subsystem, ID: [imap, default] complete2017-03-21 20:03:20,397 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'email' subsystem, ID: [email, outbound]2017-03-21 20:03:21,038 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'email' subsystem, ID: [email, outbound] complete2017-03-21 20:03:21,038 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'email' subsystem, ID: [email, inbound]2017-03-21 20:03:21,147 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'email' subsystem, ID: [email, inbound] complete2017-03-21 20:03:21,147 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'Subscriptions' subsystem, ID: [Subscriptions, default]2017-03-21 20:03:21,178 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'Subscriptions' subsystem, ID: [Subscriptions, default] complete2017-03-21 20:03:21,225 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'Synchronization' subsystem, ID: [Synchronization, default]2017-03-21 20:03:21,428 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'Synchronization' subsystem, ID: [Synchronization, default] complete2017-03-21 20:03:21,522 INFO [org.alfresco.service.descriptor.DescriptorService] [localhost-startStop-1] Alfresco JVM - v1.8.0_65-b17; maximum heap size 4079.375MB2017-03-21 20:03:21,538 INFO [org.alfresco.service.descriptor.DescriptorService] [localhost-startStop-1] Server Mode :UNKNOWN2017-03-21 20:03:21,538 INFO [org.alfresco.service.descriptor.DescriptorService] [localhost-startStop-1] Alfresco started (Community). Current version: 5.1.0 (r127059-b7) schema 10,001. Originally installed version: 5.1.0 (r127059-b7) schema 10,001.2017-03-21 20:03:21,538 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'ActivitiesFeed' subsystem, ID: [ActivitiesFeed, default]2017-03-21 20:03:21,913 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'ActivitiesFeed' subsystem, ID: [ActivitiesFeed, default] complete2017-03-21 20:03:21,913 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Starting 'Replication' subsystem, ID: [Replication, default]2017-03-21 20:03:21,944 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [localhost-startStop-1] Startup of 'Replication' subsystem, ID: [Replication, default] complete2017-03-21 20:03:36,960 INFO [org.springframework.extensions.webscripts.DeclarativeRegistry] [asynchronouslyRefreshedCacheThreadPool1] Registered 396 Web Scripts (+0 failed), 546 URLs2017-03-21 20:03:36,960 INFO [org.springframework.extensions.webscripts.DeclarativeRegistry] [asynchronouslyRefreshedCacheThreadPool1] Registered 1 Package Description Documents (+0 failed) 2017-03-21 20:03:36,960 INFO [org.springframework.extensions.webscripts.DeclarativeRegistry] [asynchronouslyRefreshedCacheThreadPool1] Registered 0 Schema Description Documents (+0 failed) 2017-03-21 20:03:42,538 INFO [org.springframework.extensions.webscripts.DeclarativeRegistry] [localhost-startStop-1] Registered 396 Web Scripts (+0 failed), 546 URLs2017-03-21 20:03:42,538 INFO [org.springframework.extensions.webscripts.DeclarativeRegistry] [localhost-startStop-1] Registered 1 Package Description Documents (+0 failed) 2017-03-21 20:03:42,538 INFO [org.springframework.extensions.webscripts.DeclarativeRegistry] [localhost-startStop-1] Registered 0 Schema Description Documents (+0 failed) 2017-03-21 20:03:42,538 INFO [org.springframework.extensions.webscripts.AbstractRuntimeContainer] [localhost-startStop-1] Initialised Repository Web Script Container (in 17266.11ms)2017-03-21 20:03:42,585 INFO [org.springframework.extensions.webscripts.TemplateProcessorRegistry] [localhost-startStop-1] Registered template processor freemarker for extension ftl2017-03-21 20:03:42,585 INFO [org.springframework.extensions.webscripts.ScriptProcessorRegistry] [localhost-startStop-1] Registered script processor javascript for extension js
In alfrescotomcat-stderr.2017-03-21.log:
2017-03-21 20:02:15 Commons Daemon procrun stderr initializedMar 21, 2017 8:02:16 PM org.apache.catalina.core.AprLifecycleListener lifecycleEventINFO: Loaded APR based Apache Tomcat Native library 1.1.32 using APR version 1.5.1.Mar 21, 2017 8:02:16 PM org.apache.catalina.core.AprLifecycleListener lifecycleEventINFO: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].Mar 21, 2017 8:02:17 PM org.apache.catalina.core.AprLifecycleListener initializeSSLINFO: OpenSSL successfully initialized (OpenSSL 1.0.1j 15 Oct 2014)Mar 21, 2017 8:02:17 PM org.apache.coyote.AbstractProtocol initINFO: Initializing ProtocolHandler ["http-apr-8080"]Mar 21, 2017 8:02:18 PM org.apache.coyote.AbstractProtocol initINFO: Initializing ProtocolHandler ["ajp-apr-8009"]Mar 21, 2017 8:02:18 PM org.apache.coyote.AbstractProtocol initINFO: Initializing ProtocolHandler ["http-bio-8443"]Mar 21, 2017 8:02:18 PM org.apache.catalina.startup.Catalina loadINFO: Initialization processed in 2620 msMar 21, 2017 8:02:18 PM org.apache.catalina.core.StandardService startInternalINFO: Starting service CatalinaMar 21, 2017 8:02:18 PM org.apache.catalina.core.StandardEngine startInternalINFO: Starting Servlet Engine: Apache Tomcat/7.0.xMar 21, 2017 8:02:32 PM org.apache.catalina.startup.TaglibUriRule bodyINFO: TLD skipped. URI: http://java.sun.com/jstl/core_rt is already definedMar 21, 2017 8:02:32 PM org.apache.catalina.startup.TaglibUriRule bodyINFO: TLD skipped. URI: http://java.sun.com/jstl/core is already definedMar 21, 2017 8:02:32 PM org.apache.catalina.startup.TaglibUriRule bodyINFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/core is already definedMar 21, 2017 8:02:32 PM org.apache.catalina.startup.TaglibUriRule bodyINFO: TLD skipped. URI: http://java.sun.com/jstl/fmt_rt is already definedMar 21, 2017 8:02:32 PM org.apache.catalina.startup.TaglibUriRule bodyINFO: TLD skipped. URI: http://java.sun.com/jstl/fmt is already definedMar 21, 2017 8:02:32 PM org.apache.catalina.startup.TaglibUriRule bodyINFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/fmt is already definedMar 21, 2017 8:02:32 PM org.apache.catalina.startup.TaglibUriRule bodyINFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/functions is already definedMar 21, 2017 8:02:32 PM org.apache.catalina.startup.TaglibUriRule bodyINFO: TLD skipped. URI: http://jakarta.apache.org/taglibs/standard/permittedTaglibs is already definedMar 21, 2017 8:02:32 PM org.apache.catalina.startup.TaglibUriRule bodyINFO: TLD skipped. URI: http://jakarta.apache.org/taglibs/standard/scriptfree is already definedMar 21, 2017 8:02:32 PM org.apache.catalina.startup.TaglibUriRule bodyINFO: TLD skipped. URI: http://java.sun.com/jstl/sql_rt is already definedMar 21, 2017 8:02:32 PM org.apache.catalina.startup.TaglibUriRule bodyINFO: TLD skipped. URI: http://java.sun.com/jstl/sql is already definedMar 21, 2017 8:02:32 PM org.apache.catalina.startup.TaglibUriRule bodyINFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/sql is already definedMar 21, 2017 8:02:32 PM org.apache.catalina.startup.TaglibUriRule bodyINFO: TLD skipped. URI: http://java.sun.com/jstl/xml_rt is already definedMar 21, 2017 8:02:32 PM org.apache.catalina.startup.TaglibUriRule bodyINFO: TLD skipped. URI: http://java.sun.com/jstl/xml is already definedMar 21, 2017 8:02:32 PM org.apache.catalina.startup.TaglibUriRule bodyINFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/xml is already definedMar 21, 2017 8:02:32 PM org.apache.catalina.core.ApplicationContext logINFO: No Spring WebApplicationInitializer types detected on classpathMar 21, 2017 8:02:33 PM org.apache.catalina.core.ApplicationContext logINFO: Initializing Spring root WebApplicationContext
