Using Sharepoint from Mac OS X/Linux

[benw]

Has anyone managed to successfully connect yet?

I'm currently trying to set up Sharepoint access on my local machine but having little success.. Office seems to recognise that a Sharepoint server exists but refuses to connect and connecting directly to http://localhost:7070/alfresco presents a login window (which accepts my username and password) but then simply shows 'not found'.

The instructions at http://wiki.alfresco.com/wiki/SharePoint_Protocol are useless - I've tried setting up Firefox to replicate a 'trusted site' as much as possible but with no luck.

I've also been through all the points in this thread; http://forums.alfresco.com/en/viewtopic.php?f=47&t=20384&p=66482&hilit=sharepoint+connect#p66482 with no luck.

I'll post my logs up soon but just wondering if I'm banging my head against a brick wall for no reason as it won't work anyway right now!

Using OS X 10.5.8 and Alfresco CE 3.2 by the way

Cheers,

Ben

[mikeh]

Office 2008 has only very recently gained the ability to connect to SharePoint, so it's not something we've had time to debug yet - obviously there are some subtleties in the implementation we'll need to have a look at.

Thanks,
Mike

[benw]

OK Mike thanks, I look forward to seeing this working properly

[benw]

OK here are my logs.. as I said this is a local installation which I'm using as a test platform

Catalina.out

22:48:56,173  INFO  [management.subsystems.ChildApplicationContextFactory] Stopping 'imap' subsystem, ID: [default]
22:48:56,174  INFO  [management.subsystems.ChildApplicationContextFactory] Stopped 'imap' subsystem, ID: [default]
22:48:56,174  INFO  [management.subsystems.ChildApplicationContextFactory] Stopping 'Synchronization' subsystem, ID: [default]
22:48:56,174  INFO  [management.subsystems.ChildApplicationContextFactory] Stopped 'Synchronization' subsystem, ID: [default]
22:48:56,201  INFO  [management.subsystems.ChildApplicationContextFactory] Stopping 'thirdparty' subsystem, ID: [default]
22:48:56,201  INFO  [management.subsystems.ChildApplicationContextFactory] Stopped 'thirdparty' subsystem, ID: [default]
22:48:56,207  INFO  [management.subsystems.ChildApplicationContextFactory] Stopping 'Authentication' subsystem, ID: [managed, alfrescoNtlm1]
22:48:56,208  INFO  [management.subsystems.ChildApplicationContextFactory] Stopped 'Authentication' subsystem, ID: [managed, alfrescoNtlm1]
Aug 26, 2009 10:48:58 PM org.apache.coyote.http11.Http11Protocol destroy
INFO: Stopping Coyote HTTP/1.1 on http-8080
Aug 28, 2009 11:09:37 AM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Aug 28, 2009 11:09:37 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1109 ms
Aug 28, 2009 11:09:37 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Aug 28, 2009 11:09:37 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18
Aug 28, 2009 11:09:45 AM org.apache.catalina.core.StandardContext addApplicationListener
INFO: The listener "org.apache.myfaces.webapp.StartupServletContextListener" is already configured for this context. The duplicate definition has been ignored.
11:09:52,651  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
11:09:52,653  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
11:09:52,654  INFO  [alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/Users/ben/Alfresco/tomcat/shared/classes/alfresco-global.properties]
11:09:52,836  INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
11:10:24,622  INFO  [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
11:10:28,200  INFO  [domain.schema.SchemaBootstrap] No changes were made to the schema.
11:10:32,151 User:System INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'thirdparty' subsystem, ID: [default]
11:10:32,181 User:System INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
11:10:34,267 User:System ERROR [util.exec.RuntimeExecBootstrapBean] Bootstrap command failed: 
Execution result: 
   os:         Mac OS X
   command:    [/Users/ben/Alfresco/program/soffice, -accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager, -env:UserInstallation=file:///Users/ben/Alfresco/alf_data/oouser, -nologo, -headless, -nofirststartwizard, -nocrashrep, -norestore]
   succeeded:  false
   exit code:  2
   out:        
   err:        /Users/ben/Alfresco/program/soffice: not found
11:10:34,390 User:System WARN  [alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.
11:10:34,391 User:System INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'thirdparty' subsystem, ID: [default] complete
11:10:34,622 User:System INFO  [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /Users/ben/Alfresco/alf_data
11:10:34,705 User:System INFO  [admin.patch.PatchExecuter] Checking for patches to apply …
11:10:35,054 User:System INFO  [admin.patch.PatchExecuter] No patches were required.
11:10:35,063 User:System INFO  [repo.module.ModuleServiceImpl] Found 1 module(s).
11:10:35,158 User:System INFO  [repo.module.ModuleServiceImpl] Starting module 'org.alfresco.module.vti' version 1.2.
11:10:35,238 User:System INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'fileServers' subsystem, ID: [default]
11:10:35,284 User:System INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
11:10:35,746 User:System INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'Authentication' subsystem, ID: [managed, alfrescoNtlm1]
11:10:35,795 User:System INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
11:10:36,429 User:System INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'Authentication' subsystem, ID: [managed, alfrescoNtlm1] complete
11:10:37,061 User:System INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'fileServers' subsystem, ID: [default] complete
11:10:37,062 User:System INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'imap' subsystem, ID: [default]
11:10:37,076 User:System INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
11:10:37,127 User:System INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'imap' subsystem, ID: [default] complete
11:10:37,128 User:System INFO  [management.subsystems.ChildApplicationContextFactory] Starting 'Synchronization' subsystem, ID: [default]
11:10:37,168 User:System INFO  [alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
11:10:37,179 User:System INFO  [management.subsystems.ChildApplicationContextFactory] Startup of 'Synchronization' subsystem, ID: [default] complete
11:10:37,244 User:System INFO  [service.descriptor.DescriptorService] Alfresco JVM - v1.5.0_19-b02-304; maximum heap size 506.313MB
11:10:37,244 User:System INFO  [service.descriptor.DescriptorService] Alfresco started (Community): Current version 3.2.0 (2039) schema 2019 - Installed version 3.2.0 (2039) schema 2019
11:10:37,558 User:System INFO  [module.vti.VtiServer] Vti server started successfully on port: 7070
Aug 28, 2009 11:10:55 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive mobile.war
11:10:58,144  INFO  [alfresco.config.JBossEnabledWebApplicationContext] Refreshing org.alfresco.config.JBossEnabledWebApplicationContext@62c358: display name [Root WebApplicationContext]; startup date [Fri Aug 28 11:10:58 BST 2009]; root of context hierarchy
11:10:58,615  INFO  [alfresco.config.JBossEnabledWebApplicationContext] Bean factory for application context [org.alfresco.config.JBossEnabledWebApplicationContext@62c358]: org.springframework.beans.factory.support.DefaultListableBeanFactory@c8aaeb
11:11:00,172  INFO  [web.scripts.DeclarativeRegistry] Registered 24 Web Scripts (+0 failed), 26 URLs
11:11:00,206  INFO  [web.scripts.AbstractRuntimeContainer] Initialised Presentation Web Script Container (in 320.629ms)
11:11:00,373  INFO  [web.scripts.DeclarativeRegistry] Registered 42 Web Scripts (+0 failed), 44 URLs
11:11:00,397  INFO  [web.scripts.AbstractRuntimeContainer] Initialised WebFramework Web Script Container (in 175.898ms)
11:11:00,446  INFO  [web.site.FrameworkHelper] Successfully Initialized Web Framework
Aug 28, 2009 11:11:00 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive share.war
11:11:04,762  INFO  [web.site.FrameworkHelper] Successfully Initialized Web Framework
Aug 28, 2009 11:11:05 AM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Aug 28, 2009 11:11:05 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 87614 ms‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Alfresco.log

11:09:52,651 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/repository.properties]
11:09:52,653 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from class path resource [alfresco/domain/transaction.properties]
11:09:52,654 INFO  [org.alfresco.config.JndiPropertiesFactoryBean] Loading properties file from URL [file:/Users/ben/Alfresco/tomcat/shared/classes/alfresco-global.properties]
11:09:52,836 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
11:10:24,622 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
11:10:28,200 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] No changes were made to the schema.
11:10:32,151 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'thirdparty' subsystem, ID: [default]
11:10:32,181 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
11:10:34,267 ERROR [org.alfresco.util.exec.RuntimeExecBootstrapBean] Bootstrap command failed: 
Execution result: 
   os:         Mac OS X
   command:    [/Users/ben/Alfresco/program/soffice, -accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager, -env:UserInstallation=file:///Users/ben/Alfresco/alf_data/oouser, -nologo, -headless, -nofirststartwizard, -nocrashrep, -norestore]
   succeeded:  false
   exit code:  2
   out:        
   err:        /Users/ben/Alfresco/program/soffice: not found
11:10:34,390 WARN  [org.alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.
11:10:34,391 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'thirdparty' subsystem, ID: [default] complete
11:10:34,622 INFO  [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /Users/ben/Alfresco/alf_data
11:10:34,705 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] Checking for patches to apply …
11:10:35,054 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] No patches were required.
11:10:35,063 INFO  [org.alfresco.repo.module.ModuleServiceImpl] Found 1 module(s).
11:10:35,158 INFO  [org.alfresco.repo.module.ModuleServiceImpl] Starting module 'org.alfresco.module.vti' version 1.2.
11:10:35,238 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'fileServers' subsystem, ID: [default]
11:10:35,284 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
11:10:35,746 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'Authentication' subsystem, ID: [managed, alfrescoNtlm1]
11:10:35,795 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
11:10:36,429 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'Authentication' subsystem, ID: [managed, alfrescoNtlm1] complete
11:10:37,061 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'fileServers' subsystem, ID: [default] complete
11:10:37,062 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'imap' subsystem, ID: [default]
11:10:37,076 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
11:10:37,127 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'imap' subsystem, ID: [default] complete
11:10:37,128 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'Synchronization' subsystem, ID: [default]
11:10:37,168 INFO  [org.alfresco.config.JndiPropertyPlaceholderConfigurer] Loading properties file from class path resource [alfresco/alfresco-shared.properties]
11:10:37,179 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'Synchronization' subsystem, ID: [default] complete
11:10:37,244 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco JVM - v1.5.0_19-b02-304; maximum heap size 506.313MB
11:10:37,244 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco started (Community): Current version 3.2.0 (2039) schema 2019 - Installed version 3.2.0 (2039) schema 2019
11:10:37,558 INFO  [org.alfresco.module.vti.VtiServer] Vti server started successfully on port: 7070
11:10:58,144 INFO  [org.alfresco.config.JBossEnabledWebApplicationContext] Refreshing org.alfresco.config.JBossEnabledWebApplicationContext@62c358: display name [Root WebApplicationContext]; startup date [Fri Aug 28 11:10:58 BST 2009]; root of context hierarchy
11:10:58,615 INFO  [org.alfresco.config.JBossEnabledWebApplicationContext] Bean factory for application context [org.alfresco.config.JBossEnabledWebApplicationContext@62c358]: org.springframework.beans.factory.support.DefaultListableBeanFactory@c8aaeb
11:11:00,172 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 24 Web Scripts (+0 failed), 26 URLs
11:11:00,206 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised Presentation Web Script Container (in 320.629ms)
11:11:00,373 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 42 Web Scripts (+0 failed), 44 URLs
11:11:00,397 INFO  [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised WebFramework Web Script Container (in 175.898ms)
11:11:00,446 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
11:11:04,762 INFO  [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework
 ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Hope that helps with diagnosis,

Cheers,

Ben

[glendaviesnz]

Is there any more word on connecting to alfreco sharepoint protocol via Office 2008 document connection? I just get "You do not have permission to connect" when trying - have tried both the default admin user and another user I have created. I am just connecting to copy of alfresco on my local machine and have tried with localhost and ip address.

There do not seem to be any logs generated by the connection process. I am happy to help out with degugging if there is some way to enable logging of the connection process.

Glen

[meecect]

I'd very much like to see a solution to this.  Can we get an update?

I am using 3.2r2 and word 2008 12.2.3 on Snow Leopard 10.6.2

I get the same error 'you do not have permission to connect'.

[paulleman]

me too - exactly the same problem same components - is it the "trusted site" problem - if so how do you get round that on a mac?

[paulleman]

there's a useful document at https://docs.rice.edu/confluence/display/ITTUT/Sharepoint+on+a+Mac+OS - doesn't give a lot of hope for interworking between OSX and Sharepoint though

[frodelau]

Hi,
I´m veery interested in this topica as well.

Have anyone succeeded in connecting Office 2008 and MS Document Connection with Alfresco?

Regards,
Frode

[rays]

I'm simply adding my voice to the growing number of users who are frustrated to discover that Alfresco's implementation of Sharepoint protocol works with MS Office on Windows but not from MS Office's Document Manager on Mac OS X.

If we can help in any way towards resolving this issue - through testing of proposed solutions etc. - we will. Where is the best place where can we join-in in the process of helping to resolve this issue?

Thanks, in advance, for all useful guidance offered in pursuit of this objective.