Problem with the wizard connector

jose.fernandez · March 16, 2017, 8:40pm

Hello,
I am trying to create a connector to sync cmdbuild with an external BBDD on postgresql. To do this I use the wizard.

The problem is that when I get to step 4, I can not see the "external entities". I have checked that the configuration of the BBDD is correct and in the logs of the application there are no errors.

Any ideas?

a greeting

.

tecnoteca · March 16, 2017, 8:46pm

Did you installed the BBDD driver in Tomcat ?
CMDBuild Team

.

tecnoteca · March 16, 2017, 8:52pm

Yes, the data is in another schema of the same bbdd that uses cmdbuild

Previously Tecnoteca wrote:

Did you installed the BBDD driver in Tomcat ?
CMDBuild Team

.

tecnoteca · March 16, 2017, 8:56pm

The wizard connector should be used between different databases.
CMDBuild Team

.

tecnoteca · March 16, 2017, 9:08pm

I have also tried to do it in another bbdd and the result is the same.

The cmdbuild log appears

INFO 2017-03-16 21:20:02 [cmdbuild] converting store task ‘ConnectorTask[id=25,description=xxx,running=false,lastExecution=<null>,cronExpression=0 0 * * ?,parameters={notification.template.error=null, mapping.types=null, notification.account=null, notification.active=false, mapping.attributes=null, datasource.type=sql, datasource.configuration=filter=tb|hostname=localhost|database=sda_db|password=postgres|instance=|port=5432|type=postgresql|username=postgres}]’ to logic task

And the configuration is

and the next screen

Gracias

Previously Tecnoteca wrote:

The wizard connector should be used between different databases.
CMDBuild Team

.

tecnoteca · March 17, 2017, 8:24am

Previously Tecnoteca wrote:

I have also tried to do it in another bbdd and the result is the same.

The cmdbuild log appears

INFO 2017-03-16 21:20:02 [cmdbuild] converting store task 'ConnectorTask[id=25,description=xxx,running=false,lastExecution=<null>,cronExpression=0 0 * * ?,parameters={notification.template.error=null, mapping.types=null, notification.account=null, notification.active=false, mapping.attributes=null, datasource.type=sql, datasource.configuration=filter=tb|hostname=localhost|database=sda_db|password=postgres|instance=|port=5432|type=postgresql|username=postgres}]' to logic task

And the configuration is

[IMG]http://i67.tinypic.com/2drf49t.png[/IMG]

and the next screen

[IMG]http://i65.tinypic.com/5npz5k.png[/IMG]

Gracias

Previously Tecnoteca wrote:
The wizard connector should be used between different databases.
CMDBuild Team

.

tecnoteca · March 17, 2017, 9:07am

I checked with our technicians.
The “external entities”, ie the names of the tables and columns in step “Class mapping”, at this time are not suggested, they should be typed by hand.
CMDBuild Team

tecnoteca · March 19, 2017, 7:43pm

I have succeeded, but I can not import the relationships between classes. Is it possible to do this?

If it is not, can you give me an example to synchronize two classes (1: N), server -> Disk, through the basic connector?

A greeting and thanks for your help

Previously Tecnoteca wrote:

I checked with our technicians.
The "external entities", ie the names of the tables and columns in step "Class mapping", at this time are not suggested, they should be typed by hand.
CMDBuild Team

tecnoteca · March 19, 2017, 8:53pm

I’m sorry, the Connector Wizard does not handle relationships.
The Basic Connector can do it but it is no longer supported by Tecnoteca.
Another solution is that you write your own custom connector using the REST and SOAP webservices, you can find some documentation in the Webservice Manual http://www.cmdbuild.org/en/documentazione/manuali/webservice-manual
CMDBuild Team

jose.fernandez · March 20, 2017, 8:45pm

I am trying to access via e. WS on the other and in both cases I get message:

NFO 2017-03-20 21:35:25 [cmdbuild] trying to login user admin with group null

INFO 2017-03-20 21:35:25 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'

WARN 2017-03-20 21:35:25 [cmdbuild] can not apply filter, user is not guest

The client code in python is:

from suds.wsse import *

from suds.client import Client

from suds.sax.text import Text

from suds_passworddigest.token import UsernameDigestToken

import logging

if __name__ == '__main__':

USER="admin"

PASSWD="admin"

URL="http://192.168.1.47:8080/cmdbuild/services/soap/Webservices?wsdl"

client = Client(URL)

logging.basicConfig(level=logging.INFO)

logging.getLogger('suds.client').setLevel(logging.DEBUG)

security = Security()

token = UsernameDigestToken(USER, PASSWD)

security.tokens.append(token)

client.set_options(wsse=security)

print client

card = client.service.getCardList('Disk')

print card

If I try to access through the basic connector, the message is as follows:

WARN 2017-03-20 21:31:52 [org.apache.cxf.phase.PhaseInterceptorChain] Interceptor for {http://proxy.sun.com/}$Proxy211Service has thrown exception, unwinding now

org.apache.cxf.binding.soap.SoapFault: A security error was encountered when verifying the message

at org.apache.cxf.ws.security.wss4j.WSS4JUtils.createSoapFault(WSS4JUtils.java:218)

at org.apache.cxf.ws.security.wss4j.WSS4JInInterceptor.handleMessageInternal(WSS4JInInterceptor.java:329)

at org.apache.cxf.ws.security.wss4j.WSS4JInInterceptor.handleMessage(WSS4JInInterceptor.java:184)

at org.apache.cxf.ws.security.wss4j.WSS4JInInterceptor.handleMessage(WSS4JInInterceptor.java:93)

at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308)

at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)

at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:253)

at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234)

at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208)

at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160)

at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:180)

at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:298)

at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:217)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)

at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:273)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)