CMDBuild Forum

Simple connector does not work

Old Versions
#1

I used the connector wizzard to create a connection to my OCS Database. To keep it very simple I created some views in the OCS-MySQL-DB fitting my CMD-classes.

So it should be more than easy: define the database connection, map the classes and attributes and test in a single run - but nothing happens!

I'm fairly sure to have the right connection data, so what can be wrong? Can I somewhere find something like a logfile which is commenting whats going wrong?

 

Thanks for any help!

#2
Dear Kearns,
 
edit the log4j.conf file and change the value of log4j.logger.org.cmdbuild.services.sync.logging, the messages will be printed within CMDBuild's log file.
 
Best regards.
 
-- CMDBuild Team
 
Previously Kearns wrote:

I used the connector wizzard to create a connection to my OCS Database. To keep it very simple I created some views in the OCS-MySQL-DB fitting my CMD-classes.

So it should be more than easy: define the database connection, map the classes and attributes and test in a single run - but nothing happens!

I'm fairly sure to have the right connection data, so what can be wrong? Can I somewhere find something like a logfile which is commenting whats going wrong?

 

Thanks for any help!

 

#3

Thank you so far, that helps to pin it down to this error:

 

INFO  2017-05-22 11:32:06 [cmdbuild] converting store task 'ConnectorTask[id=22350,description=OCS-Sync-Monitor,running=false,lastExecution=2017-05-18T13:57:17.874+02:00,cronExpression=0 0 * * ?,parameters={notification.template.error=null, mapping.types=V_CMD_monitor,cv_monitor,true,true,true, notification.account=null, notification.active=false, mapping.attributes=V_CMD_monitor,NAME,cv_monitor,Code,true|V_CMD_monitor,DESCRIPTION,cv_monitor,Description,false|V_CMD_monitor,SERIAL,cv_monitor,SN,false|V_CMD_monitor,TYPE,cv_monitor,OCS_type,false|V_CMD_monitor,MANUFACTURER,cv_monitor,OCS_manufacturer,false|V_CMD_monitor,CAPTION,cv_monitor,OCS_caption,false, datasource.type=sql, datasource.configuration=filter=|hostname=xxx.xxx.xxx.xxx|database=ocsweb|password=*********|instance=|port=3306|type=mysql|username=ocs}]' to logic task
ERROR 2017-05-22 11:32:06 [org.cmdbuild.common.logging] error invoking method 'public abstract void org.cmdbuild.common.java.sql.DataSourceTypes$DataSourceTypeVisitor.visit(org.cmdbuild.common.java.sql.DataSourceTypes$SqlServer)'

I use MySQL Version 5.5.54-0+deb8u1 with an mysql-connector-java-5.1.42-bin.jar for connection. 
What do I do wrong?