topic Re: Alfresco-5.0.d problems with SharePoint interface in Alfresco Archive

Alfresco-5.0.d problems with SharePoint interface

fvincenti — Tue, 05 May 2015 13:33:36 GMT

Hi friends of the forum,I have the following problem with SharePoint interface in Alfresco-5.0.d which I installed from:alfresco-community-5.0.d-installer-linux-x64.binchoosing easy installation.When I try to open a document using function “Edit Online” (available in site only) I get the following

Re: Alfresco-5.0.d problems with SharePoint interface

eswbitto — Tue, 05 May 2015 16:58:51 GMT

I think you should consider restarting your installation and doing the advanced and making sure the sharepoint module is installed.

From there if your using firefox as a browser to do the online editing make sure that the addon is working and installed.

Also make sure in the address bar of the browser to the very left click on the icon that looks like a lego block and make sure the plugin is allowed.

The other thing that you can do is open up word or excel and do a file….open….

In the "Look In" part you can type your url. https://fqdn:7070/alfresco and it should access your alfresco server. That's if you have the SSL configured.

Re: Alfresco-5.0.d problems with SharePoint interface

fvincenti — Wed, 06 May 2015 07:17:28 GMT

ESWBitto thank you very much for your answer.
I am sure firefox is correctly configured because it allows edit online with another alfresco-4.0.d installation, running in production environment.
BUT the URL "http://fqdn:7070/alfresco" gets the error "Connection refused" because firefox is searching on localhost instead of on the server.
I am going to search for this misconfiguration.
Thank you again.

Re: Alfresco-5.0.d problems with SharePoint interface

fvincenti — Wed, 06 May 2015 10:48:16 GMT

Nothing to do.
I have reinstalled Alfresco-5.0.d using advanced way but when I try to edit ONLINE a file the error is always the same:
"Could not start MS Office"
without asking for authentication.
Here is my alfresco-global.properties file:

dir.root=/usr/local/alfresco-5.0.d/alf_data

alfresco.context=alfresco
#alfresco.host=127.0.0.1
alfresco.host=IP_to_my_server
alfresco.port=8080
alfresco.protocol=http

share.context=share
#share.host=127.0.0.1
share.host=IP_to_my_server
share.port=8080
share.protocol=http

### database connection properties ###
db.driver=org.postgresql.Driver
db.username=alfresco
db.password=XXXXXXXX
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=UNKNOWN

### FTP Server Configuration ###
ftp.port=21

### RMI registry port for JMX ###
alfresco.rmi.services.port=50500

### External executable locations ###
ooo.exe=/usr/local/alfresco-5.0.d/libreoffice/program/soffice
ooo.enabled=true
ooo.port=8100
img.root=/usr/local/alfresco-5.0.d/common
img.dyn=${img.root}/lib
img.exe=${img.root}/bin/convert
swf.exe=/usr/local/alfresco-5.0.d/common/bin/pdf2swf
swf.languagedir=/usr/local/alfresco-5.0.d/common/japanese

jodconverter.enabled=false
jodconverter.officeHome=/usr/local/alfresco-5.0.d/libreoffice
jodconverter.portNumbers=8100

### Initial admin password ###
alfresco_user_store.adminpassword=51fb1ee7b830cf8e356ed4c554b66e4f

### E-mail site invitation setting ###
notification.email.siteinvite=false

### License location ###
dir.license.external=/usr/local/alfresco-5.0.d

### Solr indexing ###
index.subsystem.name=solr4
dir.keystore=${dir.root}/keystore
solr.port.ssl=8443

### BPM Engine ###
system.workflow.engine.jbpm.enabled=false

### Allow extended ResultSet processing
security.anyDenyDenies=false

### Inizio modifiche Major release 2.0 ###
content.transformer.PdfBox.TextToPdf.maxSourceSizeKBytes=10240
content.transformer.Pdf2swf.maxSourceSizeKBytes=8192
content.transformer.complex.Text.Pdf2swf.maxSourceSizeKBytes=8192
content.transformer.complex.OpenOffice.Pdf2swf.extensions.doc.swf.maxSourceSizeKBytes=5120
content.transformer.complex.OpenOffice.Pdf2swf.extensions.docx.swf.maxSourceSizeKBytes=5120

********************************************************************************************************************

Obviously, the directory:
…tomcat/webapps/alfresco/WEB-INF/classes/alfresco/module/org.alfresco.module.vti/context
is not present!

I have checked, in my opinion, everything was checkable without results.
Is there someone who faced the same issue?
Thank you.

Re: Alfresco-5.0.d problems with SharePoint interface

eswbitto — Wed, 06 May 2015 19:36:36 GMT

I think your issue is that you are using a IP instead of a fully qualified domain name. Try using the fqdn with a ssl certificate and see if that is the issue.

Re: Alfresco-5.0.d problems with SharePoint interface

fvincenti — Mon, 11 May 2015 12:40:41 GMT

First of all, Alfresco-5.0.d does NOT require the directory …alfresco/module/org.alfresco.module.vti/context, although the official documentation says otherwise.
Second point, I modified the alfresco-global.properties file inserting the following lines:

vti.server.port=7070
vti.alfresco.alfresoHostWithPort=http://127.0.0.1:8080
vti.share.shareHostWithPort=http://127.0.0.1:8080
vti.share.deployment.context=/share
vti.server.external.host=IP_TO_MY_SERVER <—- WITHOUT http://!!
vti.server.external.port=7070
vti.alfresco.deployment.context=/alfresco
vti.server.external.contextPath=/alfresco

I restarted Alfresco and logs did not show errors, a really clean boot, and the "Edit On Line" functionality was perfectly working.

Last but not least: be careful about Firefox plugins because i noticed, culpably late, that if they work for a release, for a new one you have to enable them again.

Greetings
Frank

Re: Alfresco-5.0.d problems with SharePoint interface

fvincenti — Wed, 20 May 2015 13:08:02 GMT

After the configuration I have done, the edit online function works, I am able to open and save MS Office document directly from Alfresco.
But there is still a problem with the MS Word (in this case) "Save AS" function: when I try to save a document with another name, another type (.docx instead of .doc) or in another place I get the following message (more or less, it is a free translation from italian):

"Modifies have been registered but it was impossible to upload them due to an error. It could be possible upload the file using the Web page of the server. Save Copy".

Clicking on the icon "Upload failed" appeared at the right bottom of the word page it opens an information MS Word page BUT, more important, it sends the following error in both alfresco.log and catalina.out:

2015-05-20 14:34:33,818 WARN [org.alfresco.module.vti.web.actions.VtiSoapAction] [1919856525@qtp-598323383-7] Failure executing Vti request
org.alfresco.module.vti.web.ws.VtiSoapException: The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
        at org.alfresco.module.vti.web.ws.GetVersionsEndpoint.executeVersionAction(GetVersionsEndpoint.java:57)
        at org.alfresco.module.vti.web.ws.AbstractVersionEndpoint.execute(AbstractVersionEndpoint.java:85)
        at org.alfresco.module.vti.web.actions.VtiSoapAction.execute(VtiSoapAction.java:84)
        at org.alfresco.module.vti.web.VtiRequestDispatcher.executeAction(VtiRequestDispatcher.java:257)
        at org.alfresco.module.vti.web.VtiRequestDispatcher.doActions(VtiRequestDispatcher.java:230)
        at org.alfresco.module.vti.web.VtiRequestDispatcher.service(VtiRequestDispatcher.java:148)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1221)
        at org.alfresco.module.vti.web.VtiFilter.doFilter(VtiFilter.java:192)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1212)
        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:399)
        at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
        at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
        at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
        at org.mortbay.jetty.Server.handle(Server.java:326)
        at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
        at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945)
        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
        at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
        at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)
        at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
Caused by: org.alfresco.service.cmr.model.FileNotFoundException: prova/documentLibrary/Prova-1/pippoxx.doc
        at org.alfresco.module.vti.handler.alfresco.AlfrescoVersionsServiceHandler.getVersions(AlfrescoVersionsServiceHandler.java:131)
        at org.alfresco.module.vti.web.ws.GetVersionsEndpoint.executeVersionAction(GetVersionsEndpoint.java:49)
        … 22 more

Because it did not find the NEW document I would want write, I tried "Save as" specifying the name of an already EXISTING document and in this case "Save as" worked perfectly.
This behaviour seems to be a bug rather than a configuration error.
Is there someone who already faced this kind of issue who can give me some explanations?

Thanks.
Frank

Re: Alfresco-5.0.d problems with SharePoint interface

didiermpl — Tue, 26 May 2015 13:52:39 GMT

Hi Franck,

I working on a 5.0.c version, and I cannot get the "edit online" option. What do you mean about the plugins for Firefox? I will tris the 5.0.d version but not sure it will be the solution.

Didier

Re: Alfresco-5.0.d problems with SharePoint interface

fvincenti — Tue, 26 May 2015 14:46:45 GMT

Hi Didier,
if you are using Mozilla Firefox browser you have to install the following plugin to make edit online working:
Microsoft Office 2010, the file name is NPSPWRAP.DLL, but is Firefox itself which shows you the full list of plugins (mozilla.com/plugincheck).
The first time you edit online a document, Firefox will ask you if you want enable, and how long, this plugin.
To check if you have this plugin installed type in Firefox, in the URL space, the following:
aboutlugins

Greetings
Frank

Re: Alfresco-5.0.d problems with SharePoint interface

sobny — Thu, 28 May 2015 07:28:59 GMT

Hi Frank!

I have same problem with alfresco community 5.0.d. When using Sharepoint Protocol, all files are read-only.
The problem resolved by re-apply alfresco sharepoint 5.0.c AMP. It's working fine now

Hope this help!
TuanNV

Re: Alfresco-5.0.d problems with SharePoint interface

fvincenti — Thu, 28 May 2015 10:39:48 GMT

Hi TuanNV
thanks for your help.
The problem I still have is not about files permissions, because if I "Save" the file it is regularly saved. Obviously, when edit online opens the document MS Word warns you that, being a file coming from web, it could be dangerous and opens it readable only, but I can chose to modify it and, furthermore, it is the same message I get opening a document using CIFS so, for me, it is a correct behavior.
It is "Save As" that can't find the new object to save.
May be I haven't understood your answer, in this case please send me another explanation, thanks.

Greetings
Frank

Re: Alfresco-5.0.d problems with SharePoint interface

drisschelouati — Fri, 29 May 2015 12:49:50 GMT

Hi mister fvincenti,

iam also having trouble setting up the online edit on a alfresco 5.0d installation on a local windows 7 machine for test purposes before production.
Iam getting the same message "couldn't start MS Office".
Iam working with chrome browser so maybe the issue originates from there. I tried using firefox but it says i need the Office 2010 plugin, wich i couldnt find to install, probably because i have a 2007 version of Office installed. should i upgrade to office 2010? Is online editing no more available with chrome (replaced by google docs integration?)

here is what i added to alfresco-global.properties:


vti.server.port=7070
vti.server.external.host=${localname}
vti.server.external.port=${vti.server.port}
vti.server.url.path.prefix=/alfresco
alfresco.context=alfresco
‍‍‍‍‍‍‍

Is there a way to use sharepoint protocol with Office 2007? thank you for your advice

Re: Alfresco-5.0.d problems with SharePoint interface

eswbitto — Fri, 29 May 2015 16:05:31 GMT

@drisschelouati,

For chrome take a look at this article.
http://support.panopto.com/documentation/admin-and-setup/troubleshooting/enabling-silverlight-plugin-npapi-plugins-chrome

For firefox yes you need the 2010 plugin and I do believe you need to upgrade to 2010 for office as well.

Re: Alfresco-5.0.d problems with SharePoint interface

rigper — Thu, 29 Oct 2015 03:06:00 GMT

Hello man… Let me help U

It is important to set the vti.server.external.host and vti.server.external.port properties in the alfresco-global.properties file to the externally resolvable host and port name that SharePoint clients will communicate with. These properties default to the host machine's local name and port 7070, respectively. These values are used by Share to generate the Edit Online link, which opens the document using the SharePoint module.

You need make change in client side…

Change in registry:

To use Online Editing on Windows 7, you must set BasicAuthLevel in the registry.
Basic authentication is disabled on Office 2010 by default. To enable it, create or edit the following registry key: HKCU\Software\Microsoft\Office\14.0\Common\Internet: BasicAuthLevel=2

Would be need install web folders by microsoft to have rw access in WebDAV into alfresco

Remember…microsoft office 2010 work in SSL

https://fqdn:8443/share

Alway in the site to you need work

I wait to help U
Enjoy