LibreOffice Online and nginx

[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=jdbcostgresql://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

[wshomeworker10]

Finally got it working.

Next question: Is the 'X' at the top right of the libreoffice window supposed to close the window?

I assume it's supposed to - but it doesn't, it just closes the file.

[wshomeworker10]

This appears to be a feature of LibreOffice Online.