AnsweredAssumed Answered

LibreOffice Online and nginx

Question asked by wshomeworker10 on Jul 16, 2019
Latest reply on Jul 17, 2019 by wshomeworker10

Hi,I'm having trouble getting Libreoffice Online to work with Alfresco and nginx (Failed to read document from storage.) and (ERR WOPI::CheckFileInfo failed with 404 Not Found) errors.

 

The /etc/nginx/conf.d/alfresco.domain.conf is:

 

server {
client_max_body_size 10G;
server_name alfresco.mydomain;

listen 443;

ssl on;

ssl_certificate /etc/ssl/wildcard_mydomain/wildcard_mydomain.chain;
ssl_certificate_key /etc/ssl/wildcard_mydomain/wildcard_mydomain.key;

rewrite ^/$ /share;

root /opt/alfresco-community/tomcat/webapps/share/;

location / {
# root /opt/alfresco-community/tomcat/webapps/share/;

proxy_pass https://localhost:8443;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_set_header Host $http_host;
proxy_set_header X-Forwarded-Proto https;
proxy_redirect off;
proxy_connect_timeout 240;
proxy_send_timeout 240;
proxy_read_timeout 240;
proxy_buffering off;
}

# static files
location ^~ /loleaflet {
proxy_pass https://alfresco.mydomain:9980;
proxy_set_header Host $http_host;
}

# WOPI discovery URL
location ^~ /hosting/discovery {
proxy_pass https://alfresco.mydomain:9980;
proxy_set_header Host $http_host;
}

# Capabilities
location ^~ /hosting/capabilities {
proxy_pass https://alfresco.mydomain:9980;
proxy_set_header Host $http_host;
}

# main websocket
location ~ ^/lool/(.*)/ws$ {
proxy_pass https://alfresco.mydomain:9980;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection "Upgrade";
proxy_set_header Host $http_host;
proxy_read_timeout 36000s;
}

# download, presentation and image upload
location ~ ^/lool {
proxy_pass https://alfresco.mydomain:9980;
proxy_set_header Host $http_host;
}

# Admin Console websocket
location ^~ /lool/adminws {
proxy_pass https://alfresco.mydomain:9980;
proxy_set_header Upgrade $http_upgrade;
proxy_set_header Connection "Upgrade";
proxy_set_header Host $http_host;
proxy_read_timeout 36000s;
}
}

 

the alfresco_global.properties file is:

 

 

###############################
## Common Alfresco Properties #
###############################

dir.root=/opt/alfresco-community/alf_data

alfresco.context=alfresco
alfresco.host=alfresco.mydomain
alfresco.port=443
alfresco.protocol=https

share.context=share
share.host=alfresco.mydomain
share.port=443
share.protocol=https

### database connection properties ###
db.driver=org.postgresql.Driver
db.username=alfresco
db.password=password
db.name=alfresco
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=275
db.pool.validate.query=SELECT 1

# The server mode. Set value here
# UNKNOWN | TEST | BACKUP | PRODUCTION
system.serverMode=PRODUCTION

### 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

### Initial admin password ###
alfresco_user_store.adminpassword=anotherpassword

### E-mail site invitation setting ###
notification.email.siteinvite=true

### License location ###
dir.license.external=/opt/alfresco-community

### Solr indexing ###
index.subsystem.name=solr4
dir.keystore=${dir.root}/keystore
solr.host=localhost
solr.port.ssl=8443

### Allow extended ResultSet processing
security.anyDenyDenies=false

### Smart Folders Config Properties ###
smart.folders.enabled=false

### Remote JMX (Default: disabled) ###
alfresco.jmx.connector.enabled=false


#AD integration
activities.feed.max.ageMins=1440
imap.mail.from.default=alfresco@mydomain
imap.mail.to.default=alfresco@mydomain
mail.host=mailout.tstechnology.net
mail.port=25
mail.from.default=alfresco@mydomain
alfresco.authentication.allowGuestLogin=false
authentication.chain=ldap-ad1:ldap-ad,alfrescoNtlm1:alfrescoNtlm
ldap.authentication.active=true
ldap.authentication.allowGuestLogin=false
ldap.authentication.userNameFormat=%s@mydomain
ldap.authentication.java.naming.provider.url=ldap://192.168.10.11:389
ldap.authentication.java.naming.security.authentication=simple
ldap.authentication.defaultAdministratorUserNames=Administrator,alfresco
ldap.synchronization.active=true
ldap.synchronization.java.naming.security.authentication=simple
ldap.synchronization.java.naming.security.principal=alfresco@mydomain
ldap.synchronization.java.naming.security.credentials=Naming
ldap.synchronization.groupSearchBase=OU\=CCCUSERS,DC\=mydomain,DC\=domain
ldap.synchronization.userSearchBase=OU\=CCCUSERS,dc\=mydomain,dc\=domain

# For Libreoffice Online
lool.wopi.url=https://alfresco.mydomain:9980
lool.wopi.url.discovery=https://alfresco.mydomain:9980/hosting/discovery
lool.wopi.alfresco.host=https://alfresco.mydomain/alfresco

opencmis.maxContentSize=6120

 

(Domains,user and passwords obfuscated).

 

Can anybody spot what I've got wrong?

 

Thanks

 

Steve

Outcomes