07-16-2019 08:43 AM
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=httpsshare.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-rendererjodconverter.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/alfrescoopencmis.maxContentSize=6120
(Domains,user and passwords obfuscated).
Can anybody spot what I've got wrong?
Thanks
Steve
07-17-2019 05:29 AM
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.
07-17-2019 12:13 PM
This appears to be a feature of LibreOffice Online.
Explore our Alfresco products with the links below. Use labels to filter content by product module.