topic Re: Problem installing Alfresco Content Services 7.1 on Windows Server 2016 in Alfresco Forum

Problem installing Alfresco Content Services 7.1 on Windows Server 2016

YanFeiHu — Tue, 22 Feb 2022 09:19:31 GMT

Hello Community,

I am trying to install Alfresco Content Services 7.1 on Windows server 2016, there had an error as below:

'org.alfresco.error.AlfrescoRuntimeException: 01200002 Keystores are invalid'.

And then You told me that I need to update two files as below;

‘alfresco-global.properties’ and ‘catalina.bat’.

Yes, I did this, but still had the same error.

So could you please tell me how to do now?

Thanks a lot!

Re: Problem installing Alfresco Content Services 7.1 on Windows Server 2016

abhinavmishra14 — Tue, 22 Feb 2022 20:57:27 GMT

Can you share the global properties and catalina.bat for review?

The error is indicating something else, see the last cause. Seems like not able to load the file and may be file is corrupted.

Re: Problem installing Alfresco Content Services 7.1 on Windows Server 2016

YanFeiHu — Wed, 23 Feb 2022 00:39:22 GMT

Hi Abhinav;

Thank you so much for your help!

Please refer to the following information.

Looking forward for your reply!

1, alfresco-global.properties
###############################
## Common Alfresco Properties #
###############################

dir.root=E:/alfresco-community-71/alf_data
dir.contentstore=${dir.root}/contentstore
dir.contentstore.deleted=${dir.root}/contentstore.deleted
dir.keystore=E:/alfresco-community-71/Tomcat/shared/classes/alfresco/extension/keystore

alfresco.context=alfresco
alfresco.host=127.0.0.1
alfresco.port=8080
alfresco.protocol=http

share.context=share
share.host=127.0.0.1
share.port=8080
share.protocol=http

db.driver=org.postgresql.Driver
db.username=alfresco
db.password=alfresco
db.name=alfresco
db.host=localhost
db.port=5432
db.url=jdbcostgresql://${db.host}:${db.port}/${db.name}
db.pool.max=275
db.pool.validate.query=SELECT 1

# UNKNOWN | TEST | BACKUP | PRODUCTION
system.serverMode=UNKNOWN

alfresco.rmi.services.port=50500
alfresco.rmi.services.host=0.0.0.0

alfresco_user_store.adminpassword=3dbde697d71690a769204beb12283678

notification.email.siteinvite=false

dir.license.external=E:/alfresco-community-71

solr.host=localhost
solr.port.ssl=8443
solr.base.url=/solr
index.subsystem.name=solr6

security.anyDenyDenies=false

smart.folders.enabled=false

alfresco.jmx.connector.enabled=false

## AMQ And Transformation services
localTransform.core-aio.url=http://localhost:8090/
local.transform.service.enabled=true
messaging.broker.url=tcp://localhost:61616
messaging.subsystem.autoStart=true
#If you have setup username and password for AMQ, then set the below properties. In my case i have kept default admin/admin
messaging.broker.username=admin
messaging.broker.password=admin

### FTP Server Configuration ###
ftp.port=2121
ftp.enabled=true
ftp.server.enables=true

2, catalina.bat

if not "%JSSE_OPTS%" == "" goto gotJsseOpts
set "JSSE_OPTS=-Djdk.tls.ephemeralDHKeySize=2048"
:gotJsseOpts
set "JAVA_OPTS=%JAVA_OPTS% %JSSE_OPTS%"

rem Register custom URL handlers
rem Do this here so custom URL handles (specifically 'war:...') can be used in the security policy
set "JAVA_OPTS=%JAVA_OPTS% -Djava.protocol.handler.pkgs=org.apache.catalina.webresources"
set "JAVA_TOOL_OPTIONS=-Dencryption.keystore.type=JCEKS -Dencryption.cipherAlgorithm=DESede/CBC/PKCS5Padding -Dencryption.keyAlgorithm=DESede -Dencryption.keystore.location=${dir.keystore}/metadata-keystore/keystore -Dmetadata-keystore.password=mp6yc0UD9e -Dmetadata-keystore.aliases=metadata -Dmetadata-keystore.metadata.password=oKIWzVdEdA -Dmetadata-keystore.metadata.algorithm=DESede"

3, catalina.properties

package.access=sun.,org.apache.catalina.,org.apache.coyote.,org.apache.jasper.,org.apache.tomcat.

package.definition=sun.,java.,org.apache.catalina.,org.apache.coyote.,\
org.apache.jasper.,org.apache.naming.,org.apache.tomcat.

common.loader="${catalina.base}/lib","${catalina.base}/lib/*.jar","${catalina.home}/lib","${catalina.home}/lib/*.jar"

server.loader=

shared.loader=${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar

4, alfresco.log

2022-02-23 08:23:09,137 WARN [org.alfresco.heartbeat.datasender.HBDataSenderServiceBuilder] [main] Setting the Heartbeat sender cron with property 'heartbeat.sender.cronExpression' is no longer supported.
2022-02-23 08:23:09,309 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Ignoring script patch (post-Hibernate): patch.db-V4.2-metadata-query-indexes
2022-02-23 08:23:09,309 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Ignoring script patch (post-Hibernate): patch.db-V5.1-metadata-query-indexes
2022-02-23 08:23:09,309 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Ignoring script patch (post-Hibernate): patch.db-V5.2-remove-jbpm-tables-from-db
2022-02-23 08:23:09,319 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Ignoring script patch (post-Hibernate): patch.db-V6.3-add-indexes-node-transaction
2022-02-23 08:23:09,319 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Ignoring script patch (post-Hibernate): patch.db-V7.1.0-remove-alf_server-table
2022-02-23 08:23:09,513 INFO [org.alfresco.repo.admin] [main] Using database URL 'jdbcostgresql://localhost:5432/alfresco' with user 'alfresco'.
2022-02-23 08:23:09,513 INFO [org.alfresco.repo.admin] [main] Connected to database PostgreSQL version 13.6
2022-02-23 08:23:12,810 ERROR [org.alfresco.repo.content.transform.LocalTransformServiceRegistry] [QuartzScheduler_Worker-2] Transformer "officeToImageViaPdf" references the transformOptions (pdfRendererOptions) which do not exist. Read from resource alfresco/transforms/0100-basePipelines.json
2022-02-23 08:23:12,810 ERROR [org.alfresco.repo.content.transform.LocalTransformServiceRegistry] [QuartzScheduler_Worker-2] Transformer "pdfToImageViaPng" references the transformOptions (pdfRendererOptions) which do not exist. Read from resource alfresco/transforms/0100-basePipelines.json

2022-02-23 08:23:12,810 WARN [org.alfresco.repo.content.transform.LocalTransformServiceRegistry] [QuartzScheduler_Worker-2] Transformer "rfc822ToPdf" ignored as step transforms ("rfc822", "libreoffice") do not exist. Read from resource alfresco/transforms/0100-basePipelines.json
2022-02-23 08:23:12,810 WARN [org.alfresco.repo.content.transform.LocalTransformServiceRegistry] [QuartzScheduler_Worker-2] Transformer "htmlToPdfViaTXT" ignored as step transforms ("string", "libreoffice") do not exist. Read from resource alfresco/transforms/0100-basePipelines.json
2022-02-23 08:23:12,810 ERROR [org.alfresco.repo.content.transform.LocalTransformServiceRegistry] [QuartzScheduler_Worker-1] Transformer "pdfToImageViaPng" references the transformOptions (pdfRendererOptions) which do not exist. Read from resource alfresco/transforms/0100-basePipelines.json
2022-02-23 08:23:12,810 ERROR [org.alfresco.repo.content.transform.LocalTransformServiceRegistry] [QuartzScheduler_Worker-1] Transformer "iWorksToImageViaJpg" references the transformOptions (imageMagickOptions) which do not exist. Read from resource alfresco/transforms/0100-basePipelines.json
2022-02-23 08:23:12,810 ERROR [org.alfresco.repo.content.transform.LocalTransformServiceRegistry] [QuartzScheduler_Worker-1] Transformer "outlookMsg2Image" references the transformOptions (pdfRendererOptions) which do not exist. Read from resource alfresco/transforms/0100-basePipelines.json
2022-02-23 08:23:12,810 ERROR [org.alfresco.repo.content.transform.LocalTransformServiceRegistry] [QuartzScheduler_Worker-1] Transformer "outlookMsg2Pdf" references the transformOptions (tikaOptions) which do not exist. Read from resource alfresco/transforms/0100-basePipelines.json
2022-02-23 08:23:12,810 ERROR [org.alfresco.repo.content.transform.LocalTransformServiceRegistry] [QuartzScheduler_Worker-1] Transformer "rfc822ToImage" references the transformOptions (pdfRendererOptions) which do not exist. Read from resource alfresco/transforms/0100-basePipelines.json
2022-02-23 08:23:12,810 ERROR [org.alfresco.repo.content.transform.LocalTransformServiceRegistry] [QuartzScheduler_Worker-1] Transformer "textToImageViaPdf" references the transformOptions (pdfRendererOptions) which do not exist. Read from resource alfresco/transforms/0100-basePipelines.json
2022-02-23 08:23:12,810 ERROR [org.alfresco.repo.content.transform.LocalTransformServiceRegistry] [QuartzScheduler_Worker-1] Transformer "ooXmlToImageViaText" references the transformOptions (pdfRendererOptions) which do not exist. Read from resource alfresco/transforms/0100-basePipelines.json
2022-02-23 08:23:12,810 ERROR [org.alfresco.repo.content.transform.LocalTransformServiceRegistry] [QuartzScheduler_Worker-1] Transformer "archiveToImageViaText" references the transformOptions (pdfRendererOptions) which do not exist. Read from resource alfresco/transforms/0100-basePipelines.json
2022-02-23 08:23:12,810 ERROR [org.alfresco.repo.content.transform.LocalTransformServiceRegistry] [QuartzScheduler_Worker-1] Transformer "ooXmlToPdfViaText" references the transformOptions (tikaOptions) which do not exist. Read from resource alfresco/transforms/0100-basePipelines.json
2022-02-23 08:23:12,810 ERROR [org.alfresco.repo.content.transform.LocalTransformServiceRegistry] [QuartzScheduler_Worker-1] Transformer "archiveToPdfViaText2" references the transformOptions (archiveOptions) which do not exist. Read from resource alfresco/transforms/0100-basePipelines.json
2022-02-23 08:23:12,810 ERROR [org.alfresco.repo.content.transform.LocalTransformServiceRegistry] [QuartzScheduler_Worker-1] Transformer "libreofficeToPdfBoxViaPdf" references the transformOptions (pdfboxOptions) which do not exist. Read from resource alfresco/transforms/0100-basePipelines.json
2022-02-23 08:23:12,810 ERROR [org.alfresco.repo.content.transform.LocalTransformServiceRegistry] [QuartzScheduler_Worker-1] Transformer "textBasedToImageViaText" references the transformOptions (pdfRendererOptions) which do not exist. Read from resource alfresco/transforms/0100-basePipelines.json
2022-02-23 08:23:12,810 ERROR [org.alfresco.repo.content.transform.LocalTransformServiceRegistry] [QuartzScheduler_Worker-1] Transformer "outlookMsgToLibreofficeViaText" references the transformOptions (tikaOptions) which do not exist. Read from resource alfresco/transforms/0100-basePipelines.json
2022-02-23 08:23:12,810 ERROR [org.alfresco.repo.content.transform.LocalTransformServiceRegistry] [QuartzScheduler_Worker-1] Transformer "htmlToImageViaTXT" references the transformOptions (pdfRendererOptions) which do not exist. Read from resource alfresco/transforms/0100-basePipelines.json
2022-02-23 08:23:12,810 WARN [org.alfresco.repo.content.transform.LocalTransformServiceRegistry] [QuartzScheduler_Worker-1] Transformer "rfc822ToPdf" ignored as step transforms ("rfc822", "libreoffice") do not exist. Read from resource alfresco/transforms/0100-basePipelines.json
2022-02-23 08:23:12,810 WARN [org.alfresco.repo.content.transform.LocalTransformServiceRegistry] [QuartzScheduler_Worker-1] Transformer "htmlToPdfViaTXT" ignored as step transforms ("string", "libreoffice") do not exist. Read from resource alfresco/transforms/0100-basePipelines.json
2022-02-23 08:23:13,138 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [main] Starting 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1]
2022-02-23 08:23:13,195 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [main] Startup of 'Authentication' subsystem, ID: [Authentication, managed, alfrescoNtlm1] complete
2022-02-23 08:23:14,973 INFO [org.springframework.extensions.webscripts.TemplateProcessorRegistry] [main] Registered template processor Repository Template Processor for extension ftl
2022-02-23 08:23:14,989 INFO [org.springframework.extensions.webscripts.ScriptProcessorRegistry] [main] Registered script processor Repository Script Processor for extension js
2022-02-23 08:23:16,855 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [main] Starting 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted]
2022-02-23 08:23:16,871 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] [main] Startup of 'ContentStore' subsystem, ID: [ContentStore, managed, unencrypted] complete
2022-02-23 08:23:16,969 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Connecting to database: jdbcostgresql://localhost:5432/alfresco, UserName=alfresco, PostgreSQL JDBC Driver
2022-02-23 08:23:16,969 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Schema managed by database dialect org.alfresco.repo.domain.dialect.PostgreSQLDialect.
2022-02-23 08:23:17,187 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Applied patches detected: 10
2022-02-23 08:23:17,229 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Checking and patching Alfresco tables took 42 ms
2022-02-23 08:23:17,264 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Activiti tables need to be checked for patches
2022-02-23 08:23:17,281 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Checking and patching Activiti tables took 17 ms
2022-02-23 08:23:17,307 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Checking that all patches have been applied took 26 ms
2022-02-23 08:23:17,307 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] Updating the DB schema took 338 ms
2022-02-23 08:23:17,307 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] [main] No changes were made to the schema.
2022-02-23 08:23:17,375 ERROR [org.springframework.web.context.ContextLoader] [main] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 01230004 Keystores are invalid
at org.alfresco.encryption.EncryptionChecker$1.execute(EncryptionChecker.java:78)
at org.alfresco.encryption.EncryptionChecker$1.execute(EncryptionChecker.java:1)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:450)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:319)
at org.alfresco.encryption.EncryptionChecker.onBootstrap(EncryptionChecker.java:67)
at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:232)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:197)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:217)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:421)
at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:378)
at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:938)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:586)
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:401)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:292)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:103)
at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:70)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4768)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:345)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:476)
Caused by: org.alfresco.error.AlfrescoRuntimeException: 01230003 Failed to create key: metadata
in key store:
Location: E:/alfresco-community-71/Tomcat/shared/classes/alfresco/extension/keystore/keystore
Provider: null
Type: pkcs12
at org.alfresco.encryption.AlfrescoKeyStoreImpl.createKey(AlfrescoKeyStoreImpl.java:664)
at org.alfresco.encryption.AlfrescoKeyStoreImpl.validateKeys(AlfrescoKeyStoreImpl.java:915)
at org.alfresco.encryption.AlfrescoKeyStoreImpl.validateKeys(AlfrescoKeyStoreImpl.java:188)
at org.alfresco.encryption.KeyStoreChecker.validateKeyStores(KeyStoreChecker.java:49)
at org.alfresco.encryption.EncryptionChecker$1.execute(EncryptionChecker.java:73)
... 57 more
Caused by: org.alfresco.error.AlfrescoRuntimeException: 01230002 Unable to get secret key: no key information is provided
at org.alfresco.encryption.AlfrescoKeyStoreImpl.getSecretKey(AlfrescoKeyStoreImpl.java:775)
at org.alfresco.encryption.AlfrescoKeyStoreImpl.createKey(AlfrescoKeyStoreImpl.java:642)
... 61 more
2022-02-23 08:23:17,482 WARN [org.springframework.web.context.support.XmlWebApplicationContext] [main] Exception thrown from ApplicationListener handling ContextClosedEvent
java.lang.NullPointerException
at org.alfresco.repo.workflow.activiti.ActivitiEngineInitializer.onShutdown(ActivitiEngineInitializer.java:65)
at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:67)
at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:232)

Re: Problem installing Alfresco Content Services 7.1 on Windows Server 2016

YanFeiHu — Wed, 23 Feb 2022 00:54:49 GMT

Hi Abhinav;

Please refer the alfresco.log as below.

alfresco.log

Re: Problem installing Alfresco Content Services 7.1 on Windows Server 2016

sp2 — Wed, 23 Feb 2022 03:35:06 GMT

Please provide full path catalina.bat instead of {dir.keystore} and try.

Re: Problem installing Alfresco Content Services 7.1 on Windows Server 2016

YanFeiHu — Wed, 23 Feb 2022 04:02:59 GMT

Hi sanjaybandhniya

Thank you for your help!

Yes, I did but it not works.

set "JAVA_TOOL_OPTIONS=-Dencryption.keystore.type=JCEKS -Dencryption.cipherAlgorithm=DESede/CBC/PKCS5Padding -Dencryption.keyAlgorithm=DESede -Dencryption.keystore.location=E:/alfresco-community-71/Tomcat/shared/classes/alfresco/extension/keystore/metadata-keystore/keystore -Dmetadata-keystore.password=mp6yc0UD9e -Dmetadata-keystore.aliases=metadata -Dmetadata-keystore.metadata.password=oKIWzVdEdA -Dmetadata-keystore.metadata.algorithm=DESede"

Re: Problem installing Alfresco Content Services 7.1 on Windows Server 2016

abhinavmishra14 — Thu, 24 Feb 2022 22:14:55 GMT

This setting should be more than enough for it work, but i see its not working for you.

set "JAVA_TOOL_OPTIONS=-Dencryption.keystore.type=JCEKS -Dencryption.cipherAlgorithm=DESede/CBC/PKCS5Padding -Dencryption.keyAlgorithm=DESede -Dencryption.keystore.location=E:/alfresco-community-71/Tomcat/shared/classes/alfresco/extension/keystore/metadata-keystore/keystore -Dmetadata-keystore.password=mp6yc0UD9e -Dmetadata-keystore.aliases=metadata -Dmetadata-keystore.metadata.password=oKIWzVdEdA -Dmetadata-keystore.metadata.algorithm=DESede"

Hopefully you have also copied the files to correct folder (considering no typos in the names in the path): E:/alfresco-community-71/Tomcat/shared/classes/alfresco/extension/keystore

This is the possible fix for the error you are getting, but strangely you still get the error so not sure what could be happening behind scene. Here are another threads with same issues: https://hub.alfresco.com/t5/alfresco-content-services-forum/failed-to-create-key-metadata/td-p/309871

https://hub.alfresco.com/t5/alfresco-content-services-forum/getting-error-while-starting-acs-7-0-keystores-are-invalid/m-p/306500/highlight/true#M23919

Here is a sample properties and catalina.bat examples:

https://github.com/abhinavmishra14/alfresco7-solr-localtransform-dist-setup/blob/main/windows-platform/alfresco-community70/tomcat/shared/classes/alfresco-global.properties

https://github.com/abhinavmishra14/alfresco7-solr-localtransform-dist-setup/blob/main/windows-platform/alfresco-community70/tomcat/bin/catalina.bat

Re: Problem installing Alfresco Content Services 7.1 on Windows Server 2016

YanFeiHu — Wed, 02 Mar 2022 14:40:48 GMT

Hi;

Please see the picture as below, is that right?