CMDBuild Forum

Problems with Alfresco

Hi everybody,


I'm beginner in CMDBuild and I have problems to enable Alfresco in CMDBuild.

I installed CMDBuild 2.2.1 with Alfresco 3.4. I setting options in Configuration/Alfresco in Administration Module of CMDBuild and I check Enabled option, then I change to Management Module in CMDBuild to attach a document, but show me an error with the following code:

 

Call: services/json/attachments/getattachmentscontext
------------------------------------------------------
Error: org.alfresco.webservice.util.WebServiceException: Error starting session.
	at org.alfresco.webservice.util.AuthenticationUtils.startSession(AuthenticationUtils.java:88)
	at org.cmdbuild.dms.alfresco.webservice.AlfrescoSession.start(AlfrescoSession.java:29)
	at org.cmdbuild.dms.alfresco.webservice.AlfrescoWebserviceClient.executeWhithinSession(AlfrescoWebserviceClient.java:52)
	at org.cmdbuild.dms.alfresco.webservice.AlfrescoWebserviceClient.getDocumentTypeDefinitions(AlfrescoWebserviceClient.java:138)
	at org.cmdbuild.dms.alfresco.webservice.AlfrescoWsService.getDocumentTypeDefinitions(AlfrescoWsService.java:422)
	at org.cmdbuild.dms.alfresco.AlfrescoDmsService.getTypeDefinitions(AlfrescoDmsService.java:64)
	at org.cmdbuild.dms.ForwardingDmsService.getTypeDefinitions(ForwardingDmsService.java:30)
	at org.cmdbuild.dms.LoggedDmsService.getTypeDefinitions(LoggedDmsService.java:32)
	at org.cmdbuild.dms.ForwardingDmsService.getTypeDefinitions(ForwardingDmsService.java:30)
	at org.cmdbuild.dms.CachedDmsService.getTypeDefinitions(CachedDmsService.java:24)
	at org.cmdbuild.logic.dms.DefaultDmsLogic.getCategoryDefinitions(DefaultDmsLogic.java:105)
	at org.cmdbuild.logic.dms.DefaultDmsLogic.getCategoryDefinition(DefaultDmsLogic.java:84)
	at org.cmdbuild.logic.dms.ForwardingDmsLogic.getCategoryDefinition(ForwardingDmsLogic.java:32)
	at org.cmdbuild.servlets.json.Attachments.categoryDefinition(Attachments.java:226)
	at org.cmdbuild.servlets.json.Attachments.getAttachmentsContext(Attachments.java:69)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:97)
	at org.cmdbuild.servlets.JSONDispatcher.doGet(JSONDispatcher.java:63)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:158)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:48)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:52)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
	at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:879)
	at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:617)
	at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1774)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.net.ConnectException: Connection refused: connect
	at org.apache.axis.AxisFault.makeFault(AxisFault.java:101)
	at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:154)
	at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
	at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
	at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
	at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)
	at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
	at org.apache.axis.client.Call.invoke(Call.java:2767)
	at org.apache.axis.client.Call.invoke(Call.java:2443)
	at org.apache.axis.client.Call.invoke(Call.java:2366)
	at org.apache.axis.client.Call.invoke(Call.java:1812)
	at org.alfresco.webservice.authentication.AuthenticationServiceSoapBindingStub.startSession(AuthenticationServiceSoapBindingStub.java:187)
	at org.alfresco.webservice.util.AuthenticationUtils.startSession(AuthenticationUtils.java:73)
	... 52 more
Caused by: java.net.ConnectException: Connection refused: connect
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.PlainSocketImpl.doConnect(Unknown Source)
	at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
	at java.net.PlainSocketImpl.connect(Unknown Source)
	at java.net.SocksSocketImpl.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.axis.components.net.DefaultSocketFactory.create(DefaultSocketFactory.java:153)
	at org.apache.axis.components.net.DefaultSocketFactory.create(DefaultSocketFactory.java:120)
	at org.apache.axis.transport.http.HTTPSender.getSocket(HTTPSender.java:191)
	at org.apache.axis.transport.http.HTTPSender.writeToSocket(HTTPSender.java:404)
	at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:138)
	... 63 more

 

I did manual configuration according to the installation guide. 


Attach the configuration of alfresco-global.properties and dms files:


FILE: alfresco-global.properties

LOCATION: C:\Alfresco\tomcat\shared\classes

###############################

## Common Alfresco Properties #

###############################

 

dir.root=C:/Alfresco/DOCUMENTOSMYSRL

 

web.application.context.url=http://127.0.0.1:8080/alfresco

 

### database connection properties ###

db.driver=org.postgresql.Driver

db.username=postgres

db.password=Hope.2014

db.name=CMDB

db.url=jdbc:postgresql://localhost:5432/CMDB

 

### FTP Server Configuration ###

ftp.enabled=true

ftp.port=1121

ftp.ipv6.enabled=false

 

### RMI service ports ###

alfresco.rmi.services.port=50500

avm.rmi.service.port=0

avmsync.rmi.service.port=0

attribute.rmi.service.port=0

authentication.rmi.service.port=0

repo.rmi.service.port=0

action.rmi.service.port=0

deployment.rmi.service.port=0

 

### External executable locations ###

ooo.exe=C:/Alfresco/openoffice/App/openoffice/program/soffice.exe

ooo.enabled=true

ooo.port=8100

img.root=C:/Alfresco/imagemagick

img.dyn=${img.root}/lib

img.exe=${img.root}/convert

swf.exe=C:/Alfresco/swftools/pdf2swf.exe

jodconverter.enabled=false 

jodconverter.officeHome=C:/Alfresco/openoffice/App/openoffice 

jodconverter.portNumbers=8100 

 

### Initial admin password ###

alfresco_user_store.adminpassword=93305d226fa5cfbc19fc222f32a65c1f

 

FILE: dms

LOCATION: C:\ProgramFiles\ApacheSoftwareFoundation\Tomcat6.0\webapps\cmdbuild\WEB-INF\conf

#

#Tue Nov 25 18:31:49 COT 2014

credential.user=admin

fileserver.type=AlfrescoFTP

delay=1000

metadata.autocompletion.filename=metadataAutocompletion.xml

category.lookup=AlfrescoCategory

alfresco.custom.prefix=cmdbuild

category.lookup.attachments=Document

alfresco.custom.model.filename=cmdbuildCustomModel.xml

enabled=true

repository.fspath=/Alfresco/User Homes/cmdbuild

repository.app=cm\:cmdbuild

server.url=http\://localhost\:10080/alfresco/api

fileserver.url=localhost

fileserver.port=1121

credential.password=admin

repository.wspath=/app\:company_home/app\:user_homes/

 

alfresco.custom.uri=org.cmdbuild.dms.alfresco

 
I have a database in PostgreSQL named: CMDB with username: postgres and password: Hope.2014

Please your help with this issue.

Thank you very much.

Regards.