Hi all,
I installed cmdbuild 2.2.1 + Postgres9.3 + JDK6 + Tomcat6 on CentOS6.5, and also basic-connector 1.5.0 and OCS inventory 2.1.2 installed on the same server as below;
Connector.sh and workflow seems to work, and cmdbuild web console shows the process was completed,
Activity Name;Description;actionDetail ;Modifiche in PC - PC: cmdb0;"La tabella PC (PC Code: cmdb0) ha subito i seguenti cambiamenti: CPUSpeed: 2000 (valore precedente: ) Description: cmdb0 (valore precedente: ) RAM: 4096 (valore precedente: ) IPAddress: 192.168.100.249 (valore precedente: ) CPUNumber: 2 (valore precedente: )
But the card of asset (PC:cmdb0) is not updated.
Please let me know what's wrong.
Any suggestions or ideas are appreciated.
Satoru Funai
===
# wget http://sourceforge.net/projects/cmdbuild/files/2.2.0/basic-connector-1.5.0.zip
# unzip basic-connector-1.5.0.zip
# cd basic-connector-1.5.0/
# mysql -uroot -p
mysql> use ocsweb;
mysql> source ocs-views.sql;
mysql> exit
# chmod +x basic-connector/bin/connector.sh
# cp -R basic-connector /opt/
# cd /opt/basic-connector/
# vim conf/configuration.xml
Edit user, password, port, etc.
Create CMDBuild user/group "inventory/inventory" as a normal group and added write permissions of all classes.
Create a new process "ImportAsset" inside CMDBuild, with two attributes:
- actionList - type TEXT (editing: hidden)- actionDetail - type TEXT (editing: editable)
And upload the xpdl for this process (ImportAsset_Shark4.4.xpdl).
====
After executed connector.sh, it seems to work as below;
# ./bin/connector.sh &
[1] 32367
# log4j:WARN No appenders could be found for logger (connector).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
log4j: Parsing for [root] with value=[WARN, R].
log4j: Level token is [WARN].
log4j: Category root set to WARN
log4j: Parsing appender named "R".
log4j: Parsing layout options for "R".
log4j: End of parsing for "R".
log4j: Setting property [file] to [./logs/basic-connector.log].
log4j: Setting property [maxFileSize] to [100MB].
log4j: Setting property [maxBackupIndex] to [10].
log4j: setFile called: ./logs/basic-connector.log, true
log4j: setFile ended
log4j: Parsed "R" options.
log4j: Parsing for [connector] with value=[DEBUG].
log4j: Level token is [DEBUG].
log4j: Category connector set to DEBUG
log4j: Handling log4j.additivity.connector=[null]
log4j: Parsing for [servermail] with value=[INFO].
log4j: Level token is [INFO].
log4j: Category servermail set to INFO
log4j: Handling log4j.additivity.servermail=[null]
log4j: Parsing for [inventory] with value=[INFO].
log4j: Level token is [INFO].
log4j: Category inventory set to INFO
log4j: Handling log4j.additivity.inventory=[null]
log4j: Parsing for [ldap] with value=[INFO].
log4j: Level token is [INFO].
log4j: Category ldap set to INFO
log4j: Handling log4j.additivity.ldap=[null]
log4j: Finished configuring.
====
# cat logs/basic-connector.log
>>> Program Started - version (Basic Connector 1.5.0 - 30/10/2013)<<<
Searching for: /opt/basic-connector/conf/configuration.xml
Parsing XML file [/opt/basic-connector/conf/configuration.xml]
Ended to read configuration file
Reading the transform file.
Parsing XML file [/opt/basic-connector/conf/cmdbuild-schema.xml]
Configuring endpoint for: http://127.0.0.1:8080/cmdbuild/services/soap/Private (username: inventorypassword: inventory)
Total objects to check: 1
Reading card nr. 1 - Code: cmdb0
keyNode name is: devicewith id:1
[PC.Code: cmdb0] Update PC with Id: 1493
>>> Program Terminated <<<
===
# tail -f /var/log/tomcat6/cmdbuild.log
INFO 2014-08-21 18:12:31 [workflow] getting process class with name 'ImportAsset'
INFO 2014-08-21 18:12:31 [workflow] getting process class with name 'ImportAsset'
INFO 2014-08-21 18:12:31 [workflow] starting process for class 'ImportAsset'
INFO 2014-08-21 18:12:32 [cmdbuild] trying to login user workflow with group null
INFO 2014-08-21 18:12:32 [workflow] pushing event 'WorkflowEvent[type=START,processDefinitionId=Process_importasset,processInstanceId=203_Package_importasset_Process_importasset]' for session '28'
INFO 2014-08-21 18:12:32 [cmdbuild] trying to login user workflow with group null
INFO 2014-08-21 18:12:32 [workflow] pushing event 'WorkflowEvent[type=UPDATE,processDefinitionId=Process_importasset,processInstanceId=203_Package_importasset_Process_importasset]' for session '28'
WARN 2014-08-21 18:12:32 [sql ] cannot get content of column 'ImportAsset#FlowStatus#Description'
WARN 2014-08-21 18:12:32 [sql ] cannot get content of column 'ImportAsset#FlowStatus#Description'
INFO 2014-08-21 18:12:32 [workflow] updating activity instance '210_203_Package_importasset_Process_importasset_InserimentoModifiche' for process 'ImportAsset'
WARN 2014-08-21 18:12:32 [sql ] cannot get content of column 'ImportAsset#FlowStatus#Description'
INFO 2014-08-21 18:12:32 [workflow] advancing activity instance '210_203_Package_importasset_Process_importasset_InserimentoModifiche' for process 'ImportAsset'
INFO 2014-08-21 18:12:32 [cmdbuild] trying to login user workflow with group null
INFO 2014-08-21 18:12:32 [workflow] pushing event 'WorkflowEvent[type=UPDATE,processDefinitionId=Process_importasset,processInstanceId=203_Package_importasset_Process_importasset]' for session '32'
INFO 2014-08-21 18:12:33 [cmdbuild] trying to login user admin with group null
INFO 2014-08-21 18:12:33 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2014-08-21 18:12:33 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2014-08-21 18:12:33 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2014-08-21 18:12:33 [cmdbuild] trying to login user workflow with group null
INFO 2014-08-21 18:12:33 [workflow] pushing event 'WorkflowEvent[type=UPDATE,processDefinitionId=Process_importasset,processInstanceId=203_Package_importasset_Process_importasset]' for session '32'
INFO 2014-08-21 18:12:33 [workflow] processing events for session '32'
WARN 2014-08-21 18:12:33 [sql ] cannot get content of column 'ImportAsset#FlowStatus#Description'
INFO 2014-08-21 18:12:33 [workflow] synchronizing process state, activities and (maybe) variables
INFO 2014-08-21 18:12:33 [workflow] synchronizing variables
INFO 2014-08-21 18:12:33 [workflow] process is completed, delete if from workflow service
====