Trouble getting Libreoffice Online to work with Alfresco and nginx

cancel
Showing results for 
Search instead for 
Did you mean: 
wshomeworker10
Active Member II

Trouble getting Libreoffice Online to work with Alfresco and nginx

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.domain;

listen 443;

ssl on;

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

rewrite ^/$ /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://localhost:9980;
proxy_set_header Host $http_host;
}

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

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

# main websocket
location ~ ^/lool/(.*)/ws$ {
proxy_pass https://localhost: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://localhost:9980;
proxy_set_header Host $http_host;
}

# Admin Console websocket
location ^~ /lool/adminws {
proxy_pass https://localhost: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.domain
alfresco.port=443
alfresco.protocol=https

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

### database connection properties ###
db.driver=org.postgresql.Driver
db.username=zzzz
db.password=zzzzz
db.name=alfresco
db.url=jdbcSmiley Tongueostgresql://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=pass

### 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@domain
imap.mail.to.default=alfresco@domain
mail.host=mailout.tstechnology.net
mail.port=25
mail.from.default=alfresco@domain
alfresco.authentication.allowGuestLogin=false
authentication.chain=ldap-ad1:ldap-ad,alfrescoNtlm1:alfrescoNtlm
ldap.authentication.active=true
ldap.authentication.allowGuestLogin=false
ldap.authentication.userNameFormat=%s@domain
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@domain
ldap.synchronization.java.naming.security.credentials=zzzzzz
ldap.synchronization.groupSearchBase=OU\=CCCUSERS,DC\=zzzzzzz
ldap.synchronization.userSearchBase=OU\=CCCUSERS,dc\=zzzzz

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

opencmis.maxContentSize=6120

(Domains,user and passwords obfuscated).

Can anybody spot what I've got wrong?

Thanks

Steve

1 Reply
wshomeworker10
Active Member II

Re: Trouble getting Libreoffice Online to work with Alfresco and nginx

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.