Keystore exception on Setting up alfresco 23.1.0 with MySQL database

kesavan — Tue, 04 Feb 2025 13:09:48 GMT

Below is my Compose file changes:

alfresco:
image: alfresco/alfresco-content-repository-community:23.1.0
#image: quay.io/alfresco/alfresco-content-repository:23.1
container_name: alfresco
ports:
- "8181:8080"
environment:
- DB_KIND=mysql
- DB_HOST=mysql
- DB_USERNAME=root
- DB_PASSWORD=sysadminPassword1
- DB_DATABASE=alfresco
- DB_DRIVER= com.mysql.cj.jdbc.Driver
- DB_URL= jdbc:mysql://mysql:3306/alfresco
- ALFRESCO_GLOBAL_PROPERTIES=/usr/local/tomcat/shared/classes/alfresco-global.properties
- JAVA_TOOL_OPTIONS="-Dencryption.keystore.type=JCEKS -Dencryption.cipherAlgorithm=DESede/CBC/PKCS5Padding -Dencryption.keyAlgorithm=DESede -Dencryption.keystore.location=/usr/local/tomcat/shared/classes/alfresco/extension/keystore/keystore -Dmetadata-keystore.password=mp6yc0UD9e -Dmetadata-keystore.aliases=metadata -Dmetadata-keystore.metadata.password=oKIWzVdEdA -Dmetadata-keystore.metadata.algorithm=DESede"
depends_on:
- mysql
volumes:
- /mnt/ghana/alfresco-data/alfresco-global.properties:/usr/local/tomcat/shared/classes/alfresco-global.properties
- /mnt/ghana/alfresco-data/jar/mysql-connector-java-8.0.29.jar:/usr/local/tomcat/lib/mysql-connector-java-8.0.29.jar
restart: always

alfresco-share:
image: alfresco/alfresco-share:23.1.0
container_name: alfresco-share
environment:
- SHARE_HOST=alfresco-share
- SHARE_PORT=8080
- ALFRESCO_HOST=alfresco
- ALFRESCO_PORT=8080
# volumes:
#- /mnt/ghana/alfresco-share-data:/usr/local/tomcat
ports:
- "8081:8080"
depends_on:
- alfresco

I am trying to configure the alfresco 23.1.0 with mysql
below is my alfresco-global.properties

dir.root=/usr/local/tomcat/alf_data

db.driver=com.mysql.cj.jdbc.Driver
db.url=jdbc:mysql://mysql:3306/alfresco?useUnicode=yes&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC
db.username=root
db.password=sysadminPassword1

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

### Initial admin password ###
alfresco_user_store.adminpassword=209c6174da490caeb422f3fa5a7ae634

dir.keystore=/usr/local/tomcat/shared/classes/alfresco/extension/keystore
encryption.keystore.type=JCEKS
encryption.keystore.password=mp6yc0UD9e

While starting the alfresco content repo facing below issue:

2025-02-04T12:55:07,356 [] WARN [context.support.XmlWebApplicationContext] [main] Exception encountered during context initialization - cancelling refresh atteeanCreationException: Error creating bean with name 'keyStore' defined in class path resource [alfresco/encryption-context.xml]: 01040002 Failed to initialize kshared/classes/alfresco/extension/keystore/keystore Provider: null Type: JCEKS -Dencryption.cipherAlgorithm=DESede/CBC/PKCS5Padding -Dencryption.keyAlgoion=/usr/local/tomcat/shared/classes/alfresco/extension/keystore/keystore -Dmetadata-keystore.password=mp6yc0UD9e -Dmetadata-keystore.aliases=metadata -Dmetadat-Dmetadata-keystore.metadata.algorithm=DESede
2025-02-04T12:55:07,374 [] ERROR [web.context.ContextLoader] [main] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'keyStore' defined in class path resource [alfresco/encryption-context.xmre:
Location: /usr/local/tomcat/shared/classes/alfresco/extension/keystore/keystore
Provider: null
Type: JCEKS -Dencryption.cipherAlgorithm=DESede/CBC/PKCS5Padding -Dencryption.keyAlgorithm=DESede -Dencryption.keystore.location=/usr/local/tomcat/sharedstore -Dmetadata-keystore.password=mp6yc0UD9e -Dmetadata-keystore.aliases=metadata -Dmetadata-keystore.metadata.password=oKIWzVdEdA -Dmetadata-keystore.metadat

Caused by: org.alfresco.error.AlfrescoRuntimeException: 01040000 Unable to intialise key store
Caused by: org.alfresco.error.AlfrescoRuntimeException: 01040001 Unable to load key store: /usr/local/tomcat/shared/classes/alfresco/extension/keystore/keystor

Caused by: java.security.KeyStoreException: JCEKS -Dencryption.cipherAlgorithm=DESede/CBC/PKCS5Padding -Dencryption.keyAlgorithm=DESede -Dencryption.keystore.loalfresco/extension/keystore/keystore -Dmetadata-keystore.password=mp6yc0UD9e -Dmetadata-keystore.aliases=metadata -Dmetadata-keystore.metadata.password=oKIWzVdEm=DESede not found

Caused by: java.security.NoSuchAlgorithmException: JCEKS -Dencryption.cipherAlgorithm=DESede/CBC/PKCS5Padding -Dencryption.keyAlgorithm=DESede -Dencryption.keyslasses/alfresco/extension/keystore/keystore -Dmetadata-keystore.password=mp6yc0UD9e -Dmetadata-keystore.aliases=metadata -Dmetadata-keystore.metadata.password=olgorithm=DESede KeyStore not available

When i tried to login using admin/ admin facing error refer attachment please

How to resolve this issue?

topic Keystore exception on Setting up alfresco 23.1.0 with MySQL database in Alfresco Forum

Keystore exception on Setting up alfresco 23.1.0 with MySQL database