topic Re: Edit online not working in Alfresco Archive

Edit online not working

criskolkman — Wed, 16 Nov 2016 10:21:26 GMT

Hello,I don't know why but my previous post just got deleted...I installed a fresh CentOS 7 server with Alfresco Community using this guide:How to Install Alfresco Community Edition on RHEL/CentOS 7/6 and Debian 8 Everything seems to be working fine except the "Edit in Microsoft Office".When I click

Re: Edit online not working

kgastaldo — Wed, 16 Nov 2016 12:54:36 GMT

Hey Chris - Your other post wasn't deleted - just caught in the moderation queue. I've approved it and it's published over in ECM. I'll delete this one, as it is a duplicate now. Sorry about the delay!

Re: Edit online not working

criskolkman — Wed, 16 Nov 2016 13:00:45 GMT

Thanks for your answer.

Don't delete this one please because when I browse to the other one I get:

An unexpected error has occurred

Re: Edit online not working

kgastaldo — Wed, 16 Nov 2016 13:06:23 GMT

We're having issues with moderation. I'll just move this post over to ECM and delete the one that seems to be stuck!

Re: Edit online not working

afaust — Wed, 16 Nov 2016 13:39:07 GMT

When installing Alfresco did you use the 5.0.d version as indicated in the linked guide or did you use the newer 5.1.x or 2016xx GA releases? In that case the SharePoint support no longer has a separate port and thus the question for the port will not come up. SharePoint support now runs on the same ports as the web UI (default installer sets up ports 8080 and 8443).

It would be great if you could provide log output regarding your issue. Typically alfresco.log is relevant for SharePoint support. Additionally I always find that the access log can also be helpful in this case since that helps determine at what point an issue in the communication between browser / office app and Alfresco occurred.

Re: Edit online not working

criskolkman — Wed, 16 Nov 2016 13:51:43 GMT

Thanks for your answer!

No I used that guide but I indeed installed the newest version, so that would be the answer for not getting that Sharepoint port question

See the attachment for the complete alfresco.log

Re: Edit online not working

afaust — Thu, 17 Nov 2016 09:05:55 GMT

The log does not show anything related to Edit Online. Can you provide the access log as well?

Re: Edit online not working

criskolkman — Thu, 17 Nov 2016 09:14:58 GMT

Hello,

The access file is really big, maybe search words I can use to narrow it down a bit?

What I have to say is that I followed that guide but I didn't install the nginx server, only did the part of installing Alfresco.

Don't know if that's a problem?

Re: Edit online not working

criskolkman — Thu, 17 Nov 2016 09:47:11 GMT

Think the only things worth mentioning in the tomcat access logs are:

127.0.0.1 - - [17/Nov/2016:10:45:00 +0100] "GET /alfresco/service/api/solr/transactions?fromCommitTime=1479364732535&toCommitTime=1479368332535&maxResults=2000&baseUrl=%2Fsolr4%2Falfresco%2F&hostName=MY.DOMAIN.COM&template=&instance=0&numberOfShards=1&port=8081&stores=workspace%3A%2F%2FSpacesStore&isMaster=true&hasContent=true&shardMethod=MOD_ACL_ID&lastUpdated=1479375900351&lastIndexedChangeSetCommitTime=1479288280889&lastIndexedChangeSetId=15&lastIndexedTxCommitTime=1479332332535&lastIndexedTxId=56 HTTP/1.1" 200 115
127.0.0.1 - - [17/Nov/2016:10:45:00 +0100] "GET /alfresco/service/api/solr/transactions?fromCommitTime=1479368332535&toCommitTime=1479371932535&maxResults=2000&baseUrl=%2Fsolr4%2Farchive%2F&hostName=MY.DOMAIN.COM&template=&instance=0&numberOfShards=1&port=8081&stores=archive%3A%2F%2FSpacesStore&isMaster=true&hasContent=true&shardMethod=MOD_ACL_ID&lastUpdated=1479375900351&lastIndexedChangeSetCommitTime=1479288280889&lastIndexedChangeSetId=15&lastIndexedTxCommitTime=1479332332535&lastIndexedTxId=56 HTTP/1.1" 200 115
127.0.0.1 - - [17/Nov/2016:10:45:00 +0100] "GET /alfresco/service/api/solr/transactions?fromCommitTime=1479368332535&toCommitTime=1479371932535&maxResults=2000&baseUrl=%2Fsolr4%2Falfresco%2F&hostName=MY.DOMAIN.COM&template=&instance=0&numberOfShards=1&port=8081&stores=workspace%3A%2F%2FSpacesStore&isMaster=true&hasContent=true&shardMethod=MOD_ACL_ID&lastUpdated=1479375900351&lastIndexedChangeSetCommitTime=1479288280889&lastIndexedChangeSetId=15&lastIndexedTxCommitTime=1479332332535&lastIndexedTxId=56 HTTP/1.1" 200 115
127.0.0.1 - - [17/Nov/2016:10:45:00 +0100] "GET /alfresco/service/api/solr/transactions?fromCommitTime=1479371932535&toCommitTime=1479375532535&maxResults=2000&baseUrl=%2Fsolr4%2Falfresco%2F&hostName=MY.DOMAIN.COM&template=&instance=0&numberOfShards=1&port=8081&stores=workspace%3A%2F%2FSpacesStore&isMaster=true&hasContent=true&shardMethod=MOD_ACL_ID&lastUpdated=1479375900351&lastIndexedChangeSetCommitTime=1479288280889&lastIndexedChangeSetId=15&lastIndexedTxCommitTime=1479332332535&lastIndexedTxId=56 HTTP/1.1" 200 115
127.0.0.1 - - [17/Nov/2016:10:45:00 +0100] "GET /alfresco/service/api/solr/transactions?fromCommitTime=1479375532535&toCommitTime=1479379132535&maxResults=2000&baseUrl=%2Fsolr4%2Falfresco%2F&hostName=MY.DOMAIN.COM&template=&instance=0&numberOfShards=1&port=8081&stores=workspace%3A%2F%2FSpacesStore&isMaster=true&hasContent=true&shardMethod=MOD_ACL_ID&lastUpdated=1479375900351&lastIndexedChangeSetCommitTime=1479288280889&lastIndexedChangeSetId=15&lastIndexedTxCommitTime=1479332332535&lastIndexedTxId=56 HTTP/1.1" 200 115
127.0.0.1 - - [17/Nov/2016:10:45:00 +0100] "GET /alfresco/service/api/solr/transactions?fromCommitTime=1479371932535&toCommitTime=1479375532535&maxResults=2000&baseUrl=%2Fsolr4%2Farchive%2F&hostName=MY.DOMAIN.COM&template=&instance=0&numberOfShards=1&port=8081&stores=archive%3A%2F%2FSpacesStore&isMaster=true&hasContent=true&shardMethod=MOD_ACL_ID&lastUpdated=1479375900351&lastIndexedChangeSetCommitTime=1479288280889&lastIndexedChangeSetId=15&lastIndexedTxCommitTime=1479332332535&lastIndexedTxId=56 HTTP/1.1" 200 115
127.0.0.1 - - [17/Nov/2016:10:45:00 +0100] "GET /alfresco/service/api/solr/transactions?fromCommitTime=1479375532535&toCommitTime=1479379132535&maxResults=2000&baseUrl=%2Fsolr4%2Farchive%2F&hostName=MY.DOMAIN.COM&template=&instance=0&numberOfShards=1&port=8081&stores=archive%3A%2F%2FSpacesStore&isMaster=true&hasContent=true&shardMethod=MOD_ACL_ID&lastUpdated=1479375900351&lastIndexedChangeSetCommitTime=1479288280889&lastIndexedChangeSetId=15&lastIndexedTxCommitTime=1479332332535&lastIndexedTxId=56 HTTP/1.1" 200 115
127.0.0.1 - - [17/Nov/2016:10:45:00 +0100] "POST /alfresco/service/api/solr/modelsdiff HTTP/1.1" 200 37

And maybe:

[root@shared logs]# cat localhost_access_log2016-11-17.txt | grep office
**.***.***.*** - - [17/Nov/2016:10:41:03 +0100] "GET /share/res/js/officelauncher_c5dab768d0335483c03558e7df0e3dbd.js HTTP/1.1" 200 7208
[root@shared logs]#

Re: Edit online not working

eleaese — Thu, 17 Nov 2016 09:57:00 GMT

In my experience the action Edit in MS Office needs an HTTPS connection with a full (not self-signed) certificate. You need to get a new SSL certificate for your Alfresco domain. Then you have 2 options:

Install the certificate in Alfresco Tomcat container (hard)
Install a web server as a front-end to Alfresco and put the certificate there (less hard 🙂

I suggest you to use Apache/NGinx and proxy Alfresco through AJP protocol, port 8009. For Apache, it's just a matter of activating proxy_ajp module and create the rules:

ProxyPass / ajp://localhost:8009

ProxyPassReverse / ajp://localhost:8009

in the SSL Virtual Host. You'll get plenty of help regarding searching online.

Then, you use Alfresco through SSL, more robust, secure and Edit online will work as expected. Last but not least, you may get free and strong SSL certificates from letsencrypt.org

Re: Edit online not working

afaust — Thu, 17 Nov 2016 09:58:40 GMT

The SOLR related accesses are just the "background noise". You may search for lines that refer to _vti or /aos but by only providing a grep-ed excerpt you may miss some important information. The best option would be to strip all lines that contain /service/api/solr calls.

Re: Edit online not working

criskolkman — Thu, 17 Nov 2016 10:21:29 GMT

Thank you for your reply!

Sounds like a lot of work but will try it now

I'll follow the rest of that guide to install nginx.

You're talking about

For Apache, it's just a matter of activating proxy_ajp module and create the rules:
ProxyPass / ajp://localhost:8009
ProxyPassReverse / ajp://localhost:8009

But that's only for Apache and not nginx?

Re: Edit online not working

criskolkman — Thu, 17 Nov 2016 11:58:05 GMT

Okay got the Let'sEncrypt cert running, but I'm getting an error that some images may not be secure (in browser) and when I want to login on the https side of Alfresco, I'm getting an error something went wrong and go back to dashboard.

Something's wrong with this page...

We may have hit an error or something might have been removed or deleted, so check that the URL is correct.

Alternatively you might not have permission to view the page (it could be on a private site) or there could have been an internal error. Try checking with your Alfresco administrator.

If you're trying to get to your home page and it's no longer available you should change it by clicking your name on the Alfresco toolbar.

And when I click the "Back to dashboard" button, it returns me to the normal http login, where I can login without problems.

When I then add https manually (after being logged in via http) it seems to work, but when I want to Edit online, it still shows me that the file is from my.domain.com:8081 and it starts excel but doesn't open the document.

Re: Edit online not working

eleaese — Thu, 17 Nov 2016 12:12:14 GMT

To help you please publish you nginx configuration file in the thread

Re: Edit online not working

criskolkman — Thu, 17 Nov 2016 12:18:03 GMT

Sure!

Got this from the same guide but then the part of installing nginx as proxy.

# For more information on configuration, see:
# * Official English Documentation: http://nginx.org/en/docs/
# * Official Russian Documentation: http://nginx.org/ru/docs/

user nginx;
worker_processes auto;
error_log /var/log/nginx/error.log;
pid /run/nginx.pid;

# Load dynamic modules. See /usr/share/nginx/README.dynamic.
include /usr/share/nginx/modules/*.conf;

events {
worker_connections 1024;
}

http {
    log_format main '$remote_addr - $remote_user [$time_local] "$request" '
                      '$status $body_bytes_sent "$http_referer" '
                      '"$http_user_agent" "$http_x_forwarded_for"';

access_log /var/log/nginx/access.log main;

    sendfile            on;
    tcp_nopush          on;
    tcp_nodelay         on;
    keepalive_timeout   65;
    types_hash_max_size 2048;

include /etc/nginx/mime.types;
default_type application/octet-stream;

    # Load modular configuration files from the /etc/nginx/conf.d directory.
    # See http://nginx.org/en/docs/ngx_core_module.html#include
    # for more information.
    include /etc/nginx/conf.d/*.conf;

    server {
        listen       80 default_server;
        listen       [::]:80 default_server;
        server_name _;
        root         /usr/share/nginx/html;

        location / {
        proxy_pass http://127.0.0.1:8081;
        proxy_redirect off;
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto $scheme;
        }

# Load configuration files for the default server block.
include /etc/nginx/default.d/*.conf;

#location / {
#}

        error_page 404 /404.html;
            location = /40x.html {
        }

        error_page 500 502 503 504 /50x.html;
            location = /50x.html {
        }
    }

# Settings for a TLS enabled server.
#
#    server {
#        listen       443 ssl http2 default_server;
#        listen       [::]:443 ssl http2 default_server;
#        server_name _;
#        root         /usr/share/nginx/html;
#
#        ssl_certificate "/etc/pki/nginx/server.crt";
#        ssl_certificate_key "/etc/pki/nginx/private/server.key";
#        ssl_session_cache sharedSL:1m;
#        ssl_session_timeout 10m;
#        ssl_ciphers HIGH:!aNULL:!MD5;
#        ssl_prefer_server_ciphers on;
#
#        # Load configuration files for the default server block.
#        include /etc/nginx/default.d/*.conf;
#
#        location / {
#        }
#
#        error_page 404 /404.html;
#            location = /40x.html {
#        }
#
#        error_page 500 502 503 504 /50x.html;
#            location = /50x.html {
#        }
#    }

server {
listen 443;
server_name _;
ssl_certificate           /etc/nginx/ssl/alfresco.crt;
ssl_certificate_key       /etc/nginx/ssl/alfresco.key;
ssl on;
ssl_session_cache builtin:1000 sharedSL:10m;
ssl_protocols TLSv1 TLSv1.1 TLSv1.2;
ssl_ciphers HIGH:!aNULL:!eNULL:!EXPORT:!CAMELLIA:!DES:!MD5:!PSK:!RC4;
ssl_prefer_server_ciphers on;
access_log            /var/log/nginx/ssl.access.log;
location / {
proxy_pass http://127.0.0.1:8081;
proxy_redirect off;
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_set_header X-Forwarded-Proto $scheme;
}
## This is the last curly bracket before editing the file.
}

}

### EDIT:

Somehow Alfresco seems to keep trying to function on http or something..

So login is not working on https and when I go to https://my.domain.com/share it sends me to http://my.domain.com/share/page (so on the http side..) and also the Logout button only works when I navigate to Alfresco on the http side, not on https.

### EDIT2:

Uhmmm okay but when I browse the normal http side of Alfresco, Edit Online does work now...

And.... (on http) on the site dashboard it says error loading items (see attachment) but in Document Library the documents are available.

Re: Edit online not working

ycoulon — Thu, 17 Nov 2016 22:09:11 GMT

Hi Cris,

For the issue with http / https access to Alfresco, did you update your alfresco-global.properties file ? Especially the following properties with the correct value (for example my local dev configuration) :

# Alfresco Repo Webapp (alfresco.war) context, ports etc
alfresco.context=alfresco
alfresco.host=localhost
alfresco.port=8080
alfresco.protocol=http
# Alfresco Share Webapp (share.war) context, ports etc
share.context=share
share.host=localhost
share.port=8080
share.protocol=http

Yann

Re: Edit online not working

eleaese — Thu, 17 Nov 2016 22:56:40 GMT

You need to change a couple of things:

1- In your NGinx config file:

Replace the following in the port 80 section:

proxy_pass http://127.0.0.1:8081;

with

proxy_pass http://127.0.0.1:8080;

Replace the following in the port 443 section:

proxy_pass http://127.0.0.1:8081;

with

proxy_pass http://127.0.0.1:8080;

2- As Yann pointed, change the following entries in

alfresco-global.properties

alfresco.context=alfresco

alfresco.host= and enjoy !

Re: Edit online not working

criskolkman — Fri, 18 Nov 2016 07:22:01 GMT

Hello,

Thanks for your answer!

Why do I have to change the proxy ports to 8080?

I configured Alfresco to use 8081 (instead of the default 8080).

Re: Edit online not working

criskolkman — Fri, 18 Nov 2016 07:26:12 GMT

I now have this in the Alfresco config:

alfresco.context=alfresco
alfresco.host=my.domain.com
alfresco.port=443
alfresco.protocol=https

share.context=share
share.host=my.domain.com
share.port=443
share.protocol=https
opencmis.context.override=true
opencmis.context.value=
opencmis.servletpath.override=true
opencmis.servletpath.value=
opencmis.server.override=true
opencmis.server.value=https://my.domain.com
aos.baseUrlOverwrite=https://my.domain.com/alfresco/aos