MS Office 2016 and Alfresco Office Services (AOS)

[fedorow]

Edited: problem steel present. Look at post bellow.

It's one tip of using MS Office 2016 with AOS.

Do not install "Microsoft SharePoint Foundation Support" component form "Office Tools" section. It marks in registry as HKEY_LOCAL_MACHINE\SOFTWARE\SyncIntegrationClients.

The problems is:

1. Unstable saving file after online editing. File usely stuck in the Microsoft Office Upload Center and give an error.
2. You can't compare and see versions of file in the Word (Review>Compare>Specific Version...).

The known solution EnableADAL=0 does not help me at all.

[fedorow]

Second tip.

Don't mount more then one disk for repository. Better don't mount disks at all. Than file moves from one disk to anothe, windows delete source node and makes new. Naturely, document looses all its versions, comments and ather metadate.

Insted of disks, Add a network location to Computer folder in next format:

\\your.domain.com@SSL\DevWWWRoot\alfresco\aos\...

User could have what ever his want qantity of network location folders and move content betwin it by Windows Explorer.

[fedorow]

The problem steel present. After installing latest security updates of Office 2016, unstabel connections to aos backed and Word again can't compare versions.

So we discuss to downgrade to 2013 version.

Does anyone have any sugestion how to reanimate Office 2016?

Alfresco 6.1.2-ga / Share 6.1.0 / AOS 1.2.2 / Kerberos SSO

Clients Windows 7 / Office 2016

alfresco-global.properties

# Alfresco Office Services override
aos.baseUrlOverwrite=https://dms.uos.ua/alfresco/aos
aos.sitePathOverwrite=/alfresco/aos

nginx ssl revers proxy

        # SharePoint URLs for Office clients
        location  ~ (^/spp|^/_vti_bin/|^/_vti_history/|^/_vti_inf.html$) {
            proxy_pass http://alfresco;
            proxy_next_upstream error timeout invalid_header http_500 http_502 http_503 http_504;
            proxy_redirect off;
            proxy_buffering 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_pass_header Set-Cookie;
        }

Next manipulations with server.xml doesn't help:

Share dockerfile

# Proxy pass configuration for SSL
RUN sed -i '/<Connector port="8080" protocol="HTTP\/1.1"/a \
    proxyName="domain.com"\n\
    proxyPort="443" \n\
    scheme="https" \n\
    secure="true" \
' $TOMCAT_DIR/conf/server.xml

Alfresco dockerfile

# In nginx you should also set the X-Forwarded-* header to remap them in tomcat's server.xml 
# to avoid trouble with DAV and AOS. e.g. by setting RemoteIpValve:
RUN sed -i '/pattern="\%h \%l \%u \%t "\%r" \%s \%b" \/>/a \
        <Valve className="org.apache.catalina.valves.RemoteIpValve"\n \
          remoteIpHeader="x-forwarded-for"\n \
          remoteIpProxiesHeader="x-forwarded-by"\n \
          protocolHeader="x-forwarded-proto"\n \/>' $TOMCAT_DIR/conf/server.xml

[mattjourdan]

Hi,

i've got the same problem with  MS Office 2016  and 2019 and Windows 10.

Currently, i don't have any solutions

Matthieu

[fedorow]

In my case the problem is coming after any of one of this office 2016 updates:

KB4475583, KB4462242,  KB4462146, KB4461535, KB4461437, KB4032233, KB448414, KB4475542.

Yes, Windows 10 + office 2016 has the problem too.