[Solved] Opening files in MS Office 2016

[hanscomps]

Hi,

I installed a clean Alfresco Community 201704 in VirtualBox on Ubuntu 16.04 using the installer and Basic option.

The only change made was adding "ntlm.authentication.sso.enabled=true" to the configuration file.

Site login etc working as expected.  I can also navigate using Webdav on Windows and Linux clients.

Can navigate AOS using IE, Chrome and Firefox to https://server:8443/alfresco/aos (also http and port 8080). 

Now the problem.  When going to any Office 2016 application and File - Open and the "https" address above I get nothing.  Blank screen, no response.   I can File -> Open the "http" link?

This is the opposite of what the documentation is saying: "Troubleshooting Alfresco Office Services - Error or blank screen when accessing web server"
   If you have not enabled SSL, you might encounter the following error message

   If you are running an old version of Office, you might see nothing after entering the URL in the Office file dialog.

(BTW, I have a production Community 201612 with Apache SSL proxy doing exactly the same). 

EDIT:  Maybe some background.  We had a Sharepoint setup, but the SQL price-tag outgrew our budget  .  Now the company wants the same functionality from Alfresco.   We are 95% there, but still require SSO (no password dialogs), AD sync (already working) and "Edit in Microsoft Office" (our current issue).   For future we are looking into BPM (or at least custom workflows).

[hanscomps]

[SOLVED]

Changed Apache config option;

"SSLVerifyClient     none"

[slayercol]

Hello,

I have exactly the same issue, but cannot resolv it? Could we contact each other?

Regards,

[hanscomps]

Sure, 

What is your configuration?

Some for debugging on my side found that the Apache SSL certs MUST be valid.  MS (desktop and office apps) will not authenticate otherwise.

I have reduced my Apache proxy config to bare minimum:

/etc/apache2/sites-enabled/default-ssl.conf

<IfModule mod_ssl.c>

<VirtualHost *:80>
  ServerName portal.xxxxxxxx.com
  Redirect permanent / https://portal.xxxxxxxx.com/ 
</VirtualHost>
  
<VirtualHost *:443>
 ServerName portal.xxxxxxxx.com
 SSLEngine On
 SSLVerifyClient none  
 SSLCertificateFile /etc/apache2/xxxx.pem
 SSLCertificateKeyFile /etc/apache2/xxxx.key

 SSLCACertificateFile /etc/apache2/xxxx.pem

# Send everything for the context / to worker named worker1 via ajp13                                                                                                                                                                                              JkMount /* ajp13_worker

</VirtualHost>

</IfModule>

[mkamal]

Hello Dear,

Kindly I need your support to Open Alfresco documents on MS-Word 2016

Regards