topic Re: Problem with the Sharepoint functionality in Alfresco Archive

Problem with the Sharepoint functionality

moe — Thu, 02 Apr 2009 14:57:00 GMT

Hello,first of all, I`m pretty new to Alfresco as I`ve installed the software just yesterday.So please don`t mind if I`m asking a beginner`s question.I`d like to know how to get the Sharepoint support for Alfresco to work.I`ve downloaded 'Alfresco-Labs-'3c-Mini-Setup.exe' which contains the Sharepoi

Re: Problem with the Sharepoint functionality

mrogers — Thu, 02 Apr 2009 23:09:36 GMT

I think you need to install a separate sharepoint vti module on 3c. You will find details on this forum.

However I think you will be much better off installing 3d / stable instead since there was major rework to the sharepoint implementation.

Re: Problem with the Sharepoint functionality

moe — Fri, 03 Apr 2009 07:12:24 GMT

I think you need to install a separate sharepoint vti module on 3c. You will find details on this forum.

However I think you will be much better off installing 3d / stable instead since there was major rework to the sharepoint implementation.

Where do I get 3d / stable?
Is this the right thing?
http://wiki.alfresco.com/wiki/Labs_3_Final_download_files

I`m a little bit confused as there is no '3d' mentioned.

Best regards,
moe

Re: Problem with the Sharepoint functionality

moe — Fri, 03 Apr 2009 12:15:39 GMT

I think you need to install a separate sharepoint vti module on 3c. You will find details on this forum.

I`ve downloaded 'Alfresco-Labs-3-Stable' and after exceuting the file 'apply-amps.bat', Port 7070 is available.
Unfortunately, the error message which I mentioned above, is still being displayed.

I just want to be sure about the following two things:

1) Do I have to use 'vti-module.amp' from here: http://wiki.alfresco.com/wiki/Labs_3_Final_download_files?
2) Do I have to use the file 'alfresco-labs-word2003-addin-3Stable.zip' from http://wiki.alfresco.com/wiki/Labs_3_Final_download_files?
In the documentation, it is not mentioned whether to an addin or not (at least, it is not mentioned in 'Getting Started with SharePoint Protocol Support.pdf')?

Best regards,
moe

Re: Problem with the Sharepoint functionality

mikeh — Fri, 03 Apr 2009 12:52:11 GMT

Yes, you need the vti-module AMP, but not the Office add-in. The add-ins were developed to provide a direct interface from Word, Excel & PowerPoint to Alfresco before Microsoft were made to open up the Sharepoint protocol.

Thanks,
Mike

Re: Problem with the Sharepoint functionality

moe — Fri, 03 Apr 2009 13:45:57 GMT

Yes, you need the vti-module AMP, but not the Office add-in. The add-ins were developed to provide a direct interface from Word, Excel & PowerPoint to Alfresco before Microsoft were made to open up the Sharepoint protocol.

Thanks,
Mike

Hello Mike,

thank you for your quick response.
According to you, I need the file 'vti-module.amp'.
This is already contained in 'Alfresco-Labs-3-FINAL', which I`m currently using.
As I mentioned in my first post, I ran the file 'apply_amps.bat'.
That *should* enable the Sharepoint functionality, right?

I found another document http://wiki.alfresco.com/w/images/a/a1/Install_Configure_Alfresco_Labs3Final.pdf.
It is mentioned that you have to copy the files 'custom-vt-properties.sample' and 'custom-vti-context.xml.sample' from 'webapps\alfresco\WEB-INF\classes\alfresco\module\org.alfresco.module.vti\context' to 'webapps\alfresco\WEB-INF\classes\alfresco\extension'.
In this directory, I deleted '.sample' of the file names.

Then, I configured 'custom-vi-properties' (in 'extension') with the following values:


vti.server.port=7070
vti.alfresco.deployment.context=http://10.2.181.79:7070/alfresco
vti.share.shareHostWithPort=http://10.2.181.79:8080‍‍‍‍

Anything wrong with this configuration?

Do I also have to change value(s) in the file 'vi.properties' in 'webapps\alfresco\WEB-INF\classes\alfresco\module\org.alfresco.module.vi\context'?
Actually, I don`t think so.

Best regards,
moe

Re: Problem with the Sharepoint functionality

mikeh — Fri, 03 Apr 2009 13:58:07 GMT

They should be more like:

vti.server.port=7070
vti.alfresco.deployment.context=/alfresco
vti.share.shareHostWithPort=http://10.2.181.79:8080‍‍‍

Thanks,
Mike

Re: Problem with the Sharepoint functionality

moe — Fri, 03 Apr 2009 14:24:59 GMT

They should be more like:

vti.server.port=7070
vti.alfresco.deployment.context=/alfresco
vti.share.shareHostWithPort=http://10.2.181.79:8080‍‍‍

Thanks,
Mike

Hello Mike,

I`ve applied your suggested change, deleted the 'work'- and 'temp'-directory of Tomcat, restarted the Alfresco server…it just doesn`t want to work 😞
I`m still getting the error message when trying to connect from Word to Alfresco.
In Word, I`m using the URL http://10.2.181.79:7070/alfresco, which doesn`t seem wrong to me.

I had another look on http://wiki.alfresco.com/w/images/a/a1/Install_Configure_Alfresco_Lab3Final.pdf and
especially on the part 'Installing the SharePoint Protcol Support AMP':

4. Install the vti-module.amp file into the alfresco.war file using the Module Management Tool
   (MMT).
    The vti-module.amp file holds the functionality for the SharePoint connector.
    Note: For Tomcat, alternatively, run the apply_amps.bat command, which is in the root Alfresco
    directory, to install the vti-module.amp. This batch file applies all the amps that are located in the
    amps directory.

Well, I did not use 'Module Management Tool', but according to the 'Note' above, it doesn`t seem to be necessary when using Tomcat.

Any suggestions?

Best regards,
moe

Re: Problem with the Sharepoint functionality

moe — Mon, 06 Apr 2009 07:12:57 GMT

Hello,

I`ve had a closer look on the Alfresco server`s startup.
There is one entry that caught my attention:

'2009-04-06 08:56:32.921::INFO: Started SocketConnector@0.0.0.0:7070'

'0.0.0.0:7070' seems wrong to me. I think that it should be more like '127.0.0.1:7070' or '10.2.181.79:7070'.
Am I right with my assumption?
If yes, where do I have to configure the IP?

Best regards,
moe

Re: Problem with the Sharepoint functionality

moe — Thu, 09 Apr 2009 12:36:15 GMT

Hello,

I`m still having trouble enabling the Sharepoint functionality.
I followed the steps in 'http://wiki.alfresco.com/w/images/b/b3/Getting_Started_with_SPP_Support_for_Labs_3_Stable.pdf', but didn`t succeed.

If I am getting it right, it should be like this:
After creating a document workspace from within MS-Word with 'http://<servername>:7070/alfresco' and logging with specific user, i.e. 'User A',
a new site should have been created in Alfresco Share for 'User A'.
The name of the site should be equal to the name that was used for the document workspace of Word (in the tutorial above, it would be 'SPP').
That site should finally contain the Word document itself.

What does work:
I can save a Word document (with 'Save as') with URL 'http://<servername>:8080/alfresco'.
After that, I`m able to choose where to store the document in Alfresco.
But I don`t think that this covers the SharePoint-functionality (rather WebDAV) of Alfresco.

Hope that someone may help me with the problem.

Best regards,
moe

Re: Problem with the Sharepoint functionality

moe — Tue, 14 Apr 2009 10:44:27 GMT

Isn`t there anyone who encounters the same problem?
Please, I`d really like to get this done.

Best regards,
moe

Re: Problem with the Sharepoint functionality

bimmo2007 — Mon, 20 Apr 2009 22:45:05 GMT

I have the exact same problem, also working on 8080 from word as you described but same message on 7070: The action could not be completed…

Re: Problem with the Sharepoint functionality

gronfelt — Tue, 21 Apr 2009 09:36:30 GMT

Same issue here, I get the same uninformative error message from Word.

My settings are


vti.server.port=7070
vti.share.shareHostWithPort=http://a1:8080
vti.alfresco.deployment.context=/alfresco
‍‍‍‍‍

I can also save through WebDAV as described above (by supplying "http://a1:8080/alfresco" as the filename in the Save as… box).

I'm running a multi-tenancy environment, but I don't think that should be an issue, since I'm able to log in to Alfresco Share through the web interface (http://a1:8080/share) with my tenant users.

I have tried to go to "http://a1:7070" with my web browser, that brings up a login question (a simple http authorization box), it won't accept any of my login credentials, neither for my tenant users nor for my underlying admin account. I don't know what's supposed to happen when you try that.

In Word, when I try to save to workspace, I get a login window, and it seems to accept my credentials, or at least it only shows up once.

Any ideas?

UPDATE:
I had obviously put the custom-vti files in the wrong extensions-directory. I had placed them in

tomcat/shared/classes/alfresco/extension/

although they should be in

tomcat/webapps/alfresco/WEB-INF/classes/alfresco/extension/

Now it's working as intended with the normal admin user, but I get the same generic error message as before when i try with a tenant user (for an example admin@mydomain.com).

Is it not possible at all to use the SharePoint Protocol Support with multi-tenants?

Re: Problem with the Sharepoint functionality

gronfelt — Wed, 22 Apr 2009 12:00:51 GMT

I've been trying a bit further to get SharePoint functionality with a tenant user and I can't seem to figure out exactly what's not working.

This is what I believe to be the essential part of the alfresco.log:


13:28:54,889 DEBUG [org.alfresco.module.vti.web.VtiFilter] Ticket was validated
13:28:54,889 DEBUG [org.alfresco.module.vti.web.VtiRequestDispatcher] Process request
13:28:54,889 DEBUG [org.alfresco.module.vti.web.VtiRequestDispatcher] Find appropriate action by specific rules
13:28:54,889 DEBUG [org.alfresco.module.vti.web.VtiRequestDispatcher] Specific rule not found
13:28:54,889 DEBUG [org.alfresco.module.vti.web.VtiRequestDispatcher] Find appropriate action by pattern for uri='/_vti_bin/dws.asmx'
13:28:54,889 DEBUG [org.alfresco.module.vti.web.VtiRequestDispatcher] Action found for request
13:28:54,889 DEBUG [org.alfresco.module.vti.web.VtiRequestDispatcher] Execute target action
13:28:54,890 DEBUG [org.alfresco.module.vti.web.ws.CreateDwsEndpoint] SOAP method with name CreateDws is started.
13:28:54,891 DEBUG [net.sf.acegisecurity.intercept.AbstractSecurityInterceptor] Secure object: ReflectiveMethodInvocation: public abstract org.alfresco.service.cmr.model
.FileInfo org.alfresco.service.cmr.model.FileFolderService.resolveNamePath(org.alfresco.service.cmr.repository.NodeRef,java.util.List) throws org.alfresco.service.cmr.mo
del.FileNotFoundException; target is of class [org.alfresco.repo.model.filefolder.FileFolderServiceImpl]; ConfigAttributes: [AFTER_ACL_NODE.sys:base.ReadProperties]
13:28:54,891 DEBUG [net.sf.acegisecurity.providers.ProviderManager] Authentication attempt using org.alfresco.repo.security.authentication.AuthenticatedAuthenticationPas
sthroughProvider
13:28:54,891 DEBUG [net.sf.acegisecurity.intercept.AbstractSecurityInterceptor] Authenticated: net.sf.acegisecurity.providers.UsernamePasswordAuthenticationToken@485220c
0: Username: net.sf.acegisecurity.providers.dao.User@7e44258: Username: admin@domain.com; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNo
nExpired: true; AccountNonLocked: true; Granted Authorities: ROLE_AUTHENTICATED; Password: [PROTECTED]; Authenticated: true; Details: net.sf.acegisecurity.providers.dao.
User@7e44258: Username: admin@domain.com; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted
Authorities: ROLE_AUTHENTICATED; Granted Authorities: ROLE_AUTHENTICATED
13:28:54,891 DEBUG [net.sf.acegisecurity.intercept.AbstractSecurityInterceptor] Authorization successful
13:28:54,891 DEBUG [net.sf.acegisecurity.intercept.AbstractSecurityInterceptor] RunAsManager did not change Authentication object
13:28:54,892 DEBUG [net.sf.ehcache.store.MemoryStore] Initialized net.sf.ehcache.store.LruMemoryStore for org.alfresco.tenantsTransactionalCache_44552833-33ea-4420-beb2-
3ccd4e3b0d39_updates
13:28:54,892 DEBUG [net.sf.ehcache.store.LruMemoryStore] org.alfresco.tenantsTransactionalCache_44552833-33ea-4420-beb2-3ccd4e3b0d39_updates Cache: Using SpoolingLinkedH
ashMap implementation
13:28:54,892 DEBUG [net.sf.ehcache.Cache] Initialised cache: org.alfresco.tenantsTransactionalCache_44552833-33ea-4420-beb2-3ccd4e3b0d39_updates
13:28:54,892 DEBUG [net.sf.ehcache.store.MemoryStore] Initialized net.sf.ehcache.store.LruMemoryStore for org.alfresco.tenantsTransactionalCache_44552833-33ea-4420-beb2-
3ccd4e3b0d39_removes
13:28:54,892 DEBUG [net.sf.ehcache.store.LruMemoryStore] org.alfresco.tenantsTransactionalCache_44552833-33ea-4420-beb2-3ccd4e3b0d39_removes Cache: Using SpoolingLinkedH
ashMap implementation
13:28:54,892 DEBUG [net.sf.ehcache.Cache] Initialised cache: org.alfresco.tenantsTransactionalCache_44552833-33ea-4420-beb2-3ccd4e3b0d39_removes
13:28:54,892 DEBUG [net.sf.ehcache.store.MemoryStore] Initialized net.sf.ehcache.store.LruMemoryStore for org.alfresco.storeAndNodeIdTransactionalCache_44552833-33ea-442
0-beb2-3ccd4e3b0d39_updates
13:28:54,892 DEBUG [net.sf.ehcache.store.LruMemoryStore] org.alfresco.storeAndNodeIdTransactionalCache_44552833-33ea-4420-beb2-3ccd4e3b0d39_updates Cache: Using Spooling
LinkedHashMap implementation
13:28:54,892 DEBUG [net.sf.ehcache.Cache] Initialised cache: org.alfresco.storeAndNodeIdTransactionalCache_44552833-33ea-4420-beb2-3ccd4e3b0d39_updates
13:28:54,892 DEBUG [net.sf.ehcache.store.MemoryStore] Initialized net.sf.ehcache.store.LruMemoryStore for org.alfresco.storeAndNodeIdTransactionalCache_44552833-33ea-442
0-beb2-3ccd4e3b0d39_removes
13:28:54,892 DEBUG [net.sf.ehcache.store.LruMemoryStore] org.alfresco.storeAndNodeIdTransactionalCache_44552833-33ea-4420-beb2-3ccd4e3b0d39_removes Cache: Using Spooling
LinkedHashMap implementation
13:28:54,892 DEBUG [net.sf.ehcache.Cache] Initialised cache: org.alfresco.storeAndNodeIdTransactionalCache_44552833-33ea-4420-beb2-3ccd4e3b0d39_removes
13:28:54,893 DEBUG [net.sf.ehcache.store.MemoryStore] org.alfresco.storeAndNodeIdTransactionalCache_44552833-33ea-4420-beb2-3ccd4e3b0d39_removesCache: Cannot remove entr
y as key workspace://@domain.com@SpacesStore/9965f4b9-a63c-491e-8f35-9086d5bb1cbb was not found
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

There's no error, nothing obvious failing ("Cannot remove entry…"-messages are seen when it's working too, in a single-tenent environment). Any ideas of what could be the problem?

Obviously the above is a very verbose logging (root level set to debug), if I set only the sharepoint logging level to debug, the last output connected to the SharePoint module is this:

13:28:54,890 DEBUG [org.alfresco.module.vti.web.ws.CreateDwsEndpoint] SOAP method with name CreateDws is started.‍

So the method starts, but it never finishes. How do I go about to find out why?

Re: Problem with the Sharepoint functionality

moe — Mon, 27 Apr 2009 14:41:14 GMT

UPDATE:
I had obviously put the custom-vti files in the wrong extensions-directory. I had placed them in

tomcat/shared/classes/alfresco/extension/

although they should be in

tomcat/webapps/alfresco/WEB-INF/classes/alfresco/extension/

Hello gronfelt,

which files do you mean?
"custom-vti.properties.sample" and "custom-vti-context.xml.sample" from "/WEB-INF/classes/alfresco/module/org.alfresco.module.vti/context", which should be copied and renamed to "vti.properties" and "vti-context.xml"? I copied those those 2 files to the directory you have described above.
But even with using the admin user in Word, I still receive the same error messagen.

Best regards,
moe

Re: Problem with the Sharepoint functionality

gronfelt — Tue, 28 Apr 2009 07:24:47 GMT

UPDATE:
I had obviously put the custom-vti files in the wrong extensions-directory. I had placed them in

tomcat/shared/classes/alfresco/extension/

although they should be in

tomcat/webapps/alfresco/WEB-INF/classes/alfresco/extension/

Hello gronfelt,

which files do you mean?
"custom-vti.properties.sample" and "custom-vti-context.xml.sample" from "/WEB-INF/classes/alfresco/module/org.alfresco.module.vti/context", which should be copied and renamed to "vti.properties" and "vti-context.xml"? I copied those those 2 files to the directory you have described above.
But even with using the admin user in Word, I still receive the same error messagen.

Best regards,
moe

Hello moe,

those are the files I meant, however I did not rename them that way, I just copied them and removed the ".sample" extension, keeping the "custom-" in the beginning of the file names.

To clarify:

../tomcat/webapps/alfresco/WEB-INF/classes/alfresco/module/org.alfresco.module.vti/context/custom-vti.properties.sample
../tomcat/webapps/alfresco/WEB-INF/classes/alfresco/module/org.alfresco.module.vti/context/custom-vti-context.xml.sample

where copied to

../tomcat/webapps/alfresco/WEB-INF/classes/alfresco/extension/custom-vti.properties
../tomcat/webapps/alfresco/WEB-INF/classes/alfresco/extension/custom-vti-context.xml

I then edited custom-vti.properties as described in previous posts and restarted Alfresco, this worked for me, I hope it works out for you to.

Re: Problem with the Sharepoint functionality

ndemarco — Fri, 22 May 2009 12:57:40 GMT

Hi,

I've been following this thread and other resoucres to get SharePoint integration working properly. It's not working for me either. My experiences are identical to many on this thread.

I'm saving a document AND creating a new document workspace (SPP) per the user doc for sharepoint functionality. I get the same 'unimaginitive error' from Word.

At times, I've seen a login box, but my credentials are not accepted. Thanks to all for their help so far. I suspect we're all a few well placed keystrokes away from solving this.

Best regards,

Nick