Hi all,
My current environment :
Alfresco Share v5.2.f (r137983-b22, Aikau 1.0.101.10, Spring Surf 5.2.f, Spring WebScripts 6.15, Freemarker 2.3.20-alfresco-patched, Rhino 1.7R4-alfresco-patched, Yui 2.9.0-alfresco-20141223)
Alfresco Community v5.2.0 (re21f2be5-b22) schema 10057
Installed from alfresco-community-installer-201707-linux-x64.bin on server Centos 7.3 , MySQL 5.7 at /opt/alfresco-community folder
This is my /opt/alfresco-community/tomcat/shared/classes/alfresco-global.properties
###############################
## Common Alfresco Properties #
###############################
dir.root=/opt/alfresco-community/alf_data
# my contentstore is mounted from a NAS nfs shared folder to /opt/contentstore
dir.contentstore=/opt/contentstore
alfresco.context=alfresco
alfresco.host=ecm.mydomain.com
alfresco.port=80
alfresco.protocol=http
share.context=share
share.host=ecm.mydomain.com
share.port=80
share.protocol=http
### database connection properties ###
db.driver=com.mysql.jdbc.Driver
db.username=alfresco
db.password=******
db.name=alfresco
db.url=jdbc:mysql://localhost:3306/alfresco?useUnicode=yes&characterEncoding=UTF-8&useSSL=false
# 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=500
db.pool.validate.query=SELECT 1
# The server mode. Set value here
# UNKNOWN | TEST | BACKUP | PRODUCTION
system.serverMode=UNKNOWN
### FTP Server Configuration ###
ftp.port=21
### RMI registry port for JMX ###
alfresco.rmi.services.port=50500
### External executable locations ###
ooo.exe=/opt/alfresco-community/libreoffice/program/soffice.bin
ooo.enabled=true
ooo.port=8100
img.root=/opt/alfresco-community/common
img.dyn=${img.root}/lib
img.exe=${img.root}/bin/convert
alfresco-pdf-renderer.root=/opt/alfresco-community/common/alfresco-pdf-renderer
alfresco-pdf-renderer.exe=${alfresco-pdf-renderer.root}/alfresco-pdf-renderer
jodconverter.enabled=false
jodconverter.officeHome=/opt/alfresco-community/libreoffice
jodconverter.portNumbers=8100
### Active Directory
authentication.chain=alfinst:alfrescoNtlm,ldap1:ldap-ad
ntlm.authentication.sso.enabled=false
ldap.authentication.allowGuestLogin=false
ldap.authentication.userNameFormat=%s@mydomain.com
ldap.authentication.java.naming.provider.url=ldap://192.168.7.103:389
ldap.authentication.defaultAdministratorUserNames=Administrator
ldap.synchronization.java.naming.security.principal=user@mydomain.com
ldap.synchronization.java.naming.security.credentials=******
ldap.synchronization.active=true
#user
ldap.synchronization.userSearchBase=OU\=Central Management,DC\=mydomain,DC\=com
ldap.synchronization.userIdAttributeName=sAMAccountName
ldap.synchronization.userFirstNameAttributeName=givenName
ldap.synchronization.userLastNameAttributeName=sn
ldap.synchronization.userEmailAttributeName=mail
#group
ldap.synchronization.groupSearchBase=OU\=Groups,OU\=Central Management,DC\=mydomain,DC\=com
# Sync
synchronization.synchronizeChangesOnly=false
synchronization.allowDeletions=true
synchronization.syncWhenMissingPeopleLogIn=true
synchronization.syncOnStartup=true
synchronization.import.cron=0 */30 * * * ?
ldap.synchronization.enableProgressEstimation=true
### Initial admin password ###
alfresco_user_store.adminpassword=******
### E-mail site invitation setting ###
notification.email.siteinvite=false
### License location ###
dir.license.external=/opt/alfresco-community
### Solr indexing ###
#solr6
#dir.keystore=${dir.root}/keystore
solr.host=localhost
index.subsystem.name=solr6
solr.secureComms=none
solr.port=8983
### Allow extended ResultSet processing
security.anyDenyDenies=false
### SMTP Exchange
mail.host=smtp.office365.com
mail.port=587
mail.username=user@mydomain.com
mail.password=******
mail.from.default=ecm@mydomain.com
mail.from.enabled=true
mail.encoding=UTF-8
mail.header=
mail.protocol=smtps
mail.smtp.starttls.enable=true
mail.smtp.auth=true
mail.smtp.timeout=30000
# Additional Java Mail properties for SMTPS protocol
mail.smtps.auth=true
mail.smtps.starttls.enable=true
### E-mail site invitation setting ###
notification.email.siteinvite=true
## SMTP SEND EMAIL TEST ###
mail.testmessage.send=true
mail.testmessage.to=jack@mydomain.com
#mail.testmessage.to=ecm@mydomain.com
mail.testmessage.subject=Outbound SMTP
mail.testmessage.text=The Outbound SMTP email subsystem is working
### Smart Folders Config Properties ###
smart.folders.enabled=false
### Remote JMX (Default: disabled) ###
alfresco.jmx.connector.enabled=false
I'm planning to upgrade to 7.1.0 and migrate it to run with docker-compose and MySQL 8.0.26 as below
Stage 1 : Install a new 7.1.0 instance with docker-compose on an Ubuntu-latest in folder /opt/alfresco-community
/opt/alfresco-community/docker-compose.yml
version: "3"
services:
alfresco:
image: docker.io/alfresco/alfresco-content-repository-community:7.1.0
container_name: alfresco
mem_limit: 2g
environment:
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
JAVA_OPTS: >-
-Ddb.driver=com.mysql.cj.jdbc.Driver -Ddb.username=alfresco
-Ddb.password=****** -Ddb.url=jdbc:mysql://mysql:3306/alfresco
-Dsolr.host=solr6 -Dsolr.port=8983 -Dsolr.http.connection.timeout=1000
-Dsolr.secureComms=secret -Dsolr.sharedSecret=secret
-Dsolr.base.url=/solr -Dindex.subsystem.name=solr6
-Dshare.host=127.0.0.1 -Dshare.port=8080 -Dalfresco.host=localhost
-Dalfresco.port=8080 -Dcsrf.filter.enabled=false
-Daos.baseUrlOverwrite=http://localhost:8080/alfresco/aos
-Dmessaging.broker.url="failover:(nio://activemq:61616)?timeout=3000&jms.useCompression=true"
-Ddeployment.method=DOCKER_COMPOSE
-DlocalTransform.core-aio.url=http://transform-core-aio:8090/
-XX:MinRAMPercentage=50 -XX:MaxRAMPercentage=80
TZ: Asia/Ho_Chi_Minh
volumes:
- ./mysql-connector-java-8.0.26.jar:/usr/local/tomcat/lib/mysql-connector-java-8.0.26.jar
- ./tomcat/alfresco-global.properties:/usr/local/tomcat/shared/classes/alfresco-global.properties
- ./tomcat/alf_data:/usr/local/tomcat/alf_data
- ./tomcat/logs:/usr/local/tomcat/logs
transform-core-aio:
image: alfresco/alfresco-transform-core-aio:2.5.3
container_name: transform-core-aio
mem_limit: 1536m
environment:
TZ: Asia/Ho_Chi_Minh
JAVA_OPTS: " -XX:MinRAMPercentage=50 -XX:MaxRAMPercentage=80"
ports:
- "8090:8090"
share:
image: docker.io/alfresco/alfresco-share:7.1.0.1
container_name: share
mem_limit: 2g
environment:
REPO_HOST: "alfresco"
REPO_PORT: "8080"
JAVA_OPTS: >-
-XX:MinRAMPercentage=50 -XX:MaxRAMPercentage=80
-Dalfresco.host=localhost -Dalfresco.port=8080
-Dalfresco.context=alfresco -Dalfresco.protocol=http
TZ: Asia/Ho_Chi_Minh
mysql:
image: mysql:8.0.26
container_name: mysql
mem_limit: 512m
environment:
- TZ=Asia/Ho_Chi_Minh
- MYSQL_ROOT_PASSWORD=******
- MYSQL_PASSWORD=******
- MYSQL_USER=alfresco
- MYSQL_DATABASE=alfresco
ports:
- "3306:3306"
volumes:
- ./mysqldata:/var/lib/mysql
solr6:
image: alfresco/alfresco-search-services:2.0.2
container_name: solr6
mem_limit: 2g
environment:
TZ: Asia/Ho_Chi_Minh
# Solr needs to know how to register itself with Alfresco
SOLR_ALFRESCO_HOST: "alfresco"
SOLR_ALFRESCO_PORT: "8080"
# Alfresco needs to know how to call solr
SOLR_SOLR_HOST: "solr6"
SOLR_SOLR_PORT: "8983"
# Create the default alfresco and archive cores
SOLR_CREATE_ALFRESCO_DEFAULTS: "alfresco,archive"
# HTTPS or SECRET
ALFRESCO_SECURE_COMMS: "secret"
# SHARED SECRET VALUE
JAVA_TOOL_OPTIONS: >-
-Dalfresco.secureComms.secret=secret
ports:
- "8083:8983" # Browser port
volumes:
- ./alfresco-search-services/data:/opt/alfresco-search-services/data
activemq:
image: alfresco/alfresco-activemq:5.16.1
container_name: activemq
mem_limit: 1g
ports:
- "8161:8161" # Web Console
- "5672:5672" # AMQP
- "61616:61616" # OpenWire
- "61613:61613" # STOMP
volumes:
- ./activemq/data:/opt/activemq/data
environment:
TZ: Asia/Ho_Chi_Minh
content-app:
image: alfresco/alfresco-content-app:2.7.0
container_name: content-app
mem_limit: 128m
environment:
TZ: Asia/Ho_Chi_Minh
APP_BASE_SHARE_URL: "http://localhost:8080/aca/#/preview/s"
proxy:
image: alfresco/alfresco-acs-nginx:3.4.2
container_name: proxy
mem_limit: 128m
environment:
TZ: Asia/Ho_Chi_Minh
DISABLE_PROMETHEUS: "true"
DISABLE_SYNCSERVICE: "true"
DISABLE_ADW: "true"
DISABLE_CONTROL_CENTER: "true"
ENABLE_CONTENT_APP: "true"
depends_on:
- alfresco
- content-app
ports:
- "80:80"
links:
- content-app
- alfresco
- share
volumes:
- ./nginx/nginx.conf:/etc/nginx/nginx.conftomcat/alfresco-global.properties
# The server mode. Set value here
# UNKNOWN | TEST | BACKUP | PRODUCTION
system.serverMode=PRODUCTION
### Active Directory
authentication.chain=alfinst:alfrescoNtlm,ldap1:ldap-ad
ntlm.authentication.sso.enabled=false
ldap.authentication.allowGuestLogin=false
ldap.authentication.userNameFormat=%s@mydomain.com
ldap.authentication.java.naming.provider.url=ldap://192.168.7.103:389
ldap.authentication.defaultAdministratorUserNames=Administrator
ldap.synchronization.java.naming.security.principal=user@mydomain.com
ldap.synchronization.java.naming.security.credentials=******
ldap.synchronization.active=true
#user
ldap.synchronization.userSearchBase=OU\=Central Management,DC\=mydomain,DC\=com
ldap.synchronization.userIdAttributeName=sAMAccountName
ldap.synchronization.userFirstNameAttributeName=givenName
ldap.synchronization.userLastNameAttributeName=sn
ldap.synchronization.userEmailAttributeName=mail
#group
ldap.synchronization.groupSearchBase=OU\=Groups,OU\=Central Management,DC\=mydomain,DC\=com
# Sync
synchronization.synchronizeChangesOnly=false
synchronization.allowDeletions=true
synchronization.syncWhenMissingPeopleLogIn=true
synchronization.syncOnStartup=true
synchronization.import.cron=0 */30 * * * ?
ldap.synchronization.enableProgressEstimation=true
### Initial admin password ###
alfresco_user_store.adminpassword=******
### E-mail site invitation setting ###
notification.email.siteinvite=false
### SMTP Exchange
mail.host=smtp.office365.com
mail.port=587
mail.username=user@mydomain.com
mail.password=******
mail.from.default=ecm@mydomain.com
mail.from.enabled=true
mail.encoding=UTF-8
mail.header=
mail.protocol=smtps
mail.smtp.starttls.enable=true
mail.smtp.auth=true
mail.smtp.timeout=30000
# Additional Java Mail properties for SMTPS protocol
mail.smtps.auth=true
mail.smtps.starttls.enable=true
### E-mail site invitation setting ###
notification.email.siteinvite=true
## SMTP SEND EMAIL TEST ###
mail.testmessage.send=true
mail.testmessage.to=jack@mydomain.com
#mail.testmessage.to=ecm@mydomain.com
mail.testmessage.subject=Outbound SMTP
mail.testmessage.text=The Outbound SMTP email subsystem is working