OneCMDB / Discussion / Help Version 2.x: OneCMDB Version 2.1.0 released.

Niklas Granryd - 2009-12-15

Hi,

Version 2.1.0 of OneCMDB has been released at SourceForge.

One new feature with this release is the MDR configurator. This will make it much easier to import data into OneCMDB.
We have seen a number of threads concerning this and we hope that this new feature will solve a lot of these question.

The MDR support transform and import of data from data sources such as Excel, CSV (Delimted text files) and sql databases. It also support reconciliation (object identification) by specifying the attributes that are regarded as keys.

A complete tutorial describing in detail how to use this new feature is also available .

Regards

Lokomo Development Team.

: http://www.onecmdb.org/wiki/index.php?title=Import_Excel_with_MDR_Configurator

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2009-12-17

Hello,

I upgraded to this version and the new wizard for excel works
well, lets configure new loads quickly and easily,
thanks.

The way to do the update has been to create a new directory for
the new version and copy the directories in this configuration
existing burdens on the previous version.

But these charges had in the previous version no longer
run all of them give me the same error:

Start path set to '/usr/local/onecmdb_v210/repository/MDR/jdbc_Discovery'
Program path set to '/usr/local/onecmdb_v210/repository/MDR/jdbc_Discovery/bin/transform-import-cmdb'
jdbc_Discovery/bin/transform-import-cmdb - start.
jdbc_Discovery/bin/transform-import-cmdb - Will wait…
jdbc_Discovery/bin/transform-import-cmdb - start.
jdbc_Discovery/bin/transform-import-cmdb - Will wait…
Direct stdout to /usr/local/onecmdb_v210/repository/MDR/jdbc_Discovery/logs/stdout-transform-import-cmdb-20091217-113020
Direct stderr to /usr/local/onecmdb_v210/repository/MDR/jdbc_Discovery/logs/stderr-transform-import-cmdb-20091217-113020
Start Exec…
Shell for .sh resolved to '/bin/bash'
CMD-LIST :
jdbc_Discovery/bin/transform-import-cmdb - start.
jdbc_Discovery/bin/transform-import-cmdb - Will wait…
jdbc_Discovery/bin/transform-import-cmdb - started.
jdbc_Discovery/bin/transform-import-cmdb - started.
jdbc_Discovery/bin/transform-import-cmdb - started.
jdbc_Discovery/bin/transform-import-cmdb - no reader set.
jdbc_Discovery/bin/transform-import-cmdb - auto-close streams
jdbc_Discovery/bin/transform-import-cmdb - terminated
jdbc_Discovery/bin/transform-import-cmdb - - ============ENVIRONMENT=====================
jdbc_Discovery/bin/transform-import-cmdb - - ONECMDB_HOME=/usr/local/onecmdb_v210
jdbc_Discovery/bin/transform-import-cmdb - - JAVA_HOME=/usr/local/onecmdb_v210/jre
jdbc_Discovery/bin/transform-import-cmdb - - ONECMDB_URL=http://localhost:8080
jdbc_Discovery/bin/transform-import-cmdb - - ONECMDB_URL=http://localhost:8080/onecmdb-desktop
jdbc_Discovery/bin/transform-import-cmdb - - ============================================
jdbc_Discovery/bin/transform-import-cmdb - - HISTORY=MDR_HistoryEntry-7-1261045819280 TOKEN=1faa5a9
jdbc_Discovery/bin/transform-import-cmdb - - java.lang.NullPointerException
jdbc_Discovery/bin/transform-import-cmdb - -   at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
jdbc_Discovery/bin/transform-import-cmdb - -   at java.lang.ClassLoader.loadClass(Unknown Source)
jdbc_Discovery/bin/transform-import-cmdb - -   at java.lang.ClassLoader.loadClass(Unknown Source)
jdbc_Discovery/bin/transform-import-cmdb - -   at java.lang.ClassLoader.loadClass(Unknown Source)
jdbc_Discovery/bin/transform-import-cmdb - -   at org.onecmdb.core.utils.transform.jdbc.JDBCDataSourceWrapper.setupDataSource(Unknown Source)
jdbc_Discovery/bin/transform-import-cmdb - -   at org.onecmdb.utils.wsdl.OneCMDBTransform.getDataSource(Unknown Source)
jdbc_Discovery/bin/transform-import-cmdb - -   at org.onecmdb.utils.wsdl.OneCMDBTransform.getDataSource(Unknown Source)
jdbc_Discovery/bin/transform-import-cmdb - -   at org.onecmdb.utils.wsdl.OneCMDBTransform.process(Unknown Source)
jdbc_Discovery/bin/transform-import-cmdb - -   at org.onecmdb.utils.wsdl.OneCMDBTransform.process(Unknown Source)
jdbc_Discovery/bin/transform-import-cmdb - -   at org.onecmdb.utils.wsdl.AbstractCMDBCommand.start(Unknown Source)
jdbc_Discovery/bin/transform-import-cmdb - -   at org.onecmdb.utils.wsdl.OneCMDBTransform.main(Unknown Source)
jdbc_Discovery/bin/transform-import-cmdb - -   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
jdbc_Discovery/bin/transform-import-cmdb - -   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
jdbc_Discovery/bin/transform-import-cmdb - -   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
jdbc_Discovery/bin/transform-import-cmdb - -   at java.lang.reflect.Method.invoke(Unknown Source)
jdbc_Discovery/bin/transform-import-cmdb - -   at org.onecmdb.utils.classloader.RemoteClassLoader.main(Unknown Source)
jdbc_Discovery/bin/transform-import-cmdb - - Runtime 463ms
jdbc_Discovery/bin/transform-import-cmdb - - transform result to cmdb failed!
jdbc_Discovery/bin/transform-import-cmdb - auto-close streams
jdbc_Discovery/bin/transform-import-cmdb - terminated
jdbc_Discovery/bin/transform-import-cmdb - auto-close streams
jdbc_Discovery/bin/transform-import-cmdb - terminated
Exec Ended , result=1 - null
Update History….
History update complete
Execution Completed

¿any idea? TIA

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Niklas Granryd - 2009-12-17

Hi,

Sorry for this.
What you need to do is to edit the datasource definition, conf/source_jdbc*.xml. You need to modify the db. to jdbc.

2.0.1 style:

      <entry key="type">jdbc</entry>
      <entry key="db.user">root</entry>
      <entry key="db.password">1qaz1qaz</entry>
      <entry key="db.url">jdbc:mysql://192.168.1.15:3306/cmdb_systems</entry>
    <entry key="db.driverClass">com.mysql.jdbc.Driver</entry>
    <entry key="db.query">
    …

to 2.1.0 style

    <entry key="type">jdbc</entry>
    <entry key="jdbc.user">root</entry>
    <entry key="jdbc.password">1qaz1qaz</entry>
    <entry key="jdbc.url">jdbc:mysql://192.168.1.15:3306/cmdb_systems</entry>
    <entry key="jdbc.driverClass">com.mysql.jdbc.Driver</entry>
    <entry key="jdbc.query">

Regards
/Niklas

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2009-12-17

Perfect, thanks!

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Rodrigo Juan - 2009-12-22

Hi, i've installed onecmdb 2.1 and then changed de password of admin user following the steps described in the FAQ Area.
Now a can log on with the new password, but when a try to execute de Customer Reportes i get an Tomcat error .
**HTTP Status 400 - Error:org.codehaus.xfire.fault.XFireFault: Bad credentials
type Status report
message Error:org.codehaus.xfire.fault.XFireFault: Bad credentials
description The request sent by the client was syntactically incorrect (Error:org.codehaus.xfire.fault.XFireFault: Bad credentials).**

********************
In the Catalina.out :

Dec 22, 2009 1:15:11 PM org.onecmdb.ui.gwt.desktop.server.service.content.ContentParserFactory getAdaptor
INFO: Adapt file 'CustomReports/CMDB/templates/CMDBTemplateReportView.xml' to 'com.extjs.gxt.ui.client.data.BaseModel' with 'org.onecmdb.ui.gwt.desktop.server.service.content.adapter.GXTModelContentAdapter'
Dec 22, 2009 1:15:12 PM org.onecmdb.ui.gwt.desktop.server.command.ExportQueryCommand setRoot
INFO: Set ExportHandler Root to </opt/onecmdb/repository>
Dec 22, 2009 1:15:12 PM org.onecmdb.ui.gwt.desktop.server.command.ExportQueryCommand setName
INFO: setName(CMDB/templates/templates.cfg)
Dec 22, 2009 1:15:12 PM org.onecmdb.ui.gwt.desktop.server.command.ExportQueryCommand transfer
INFO: Transfer(CustomReports/CMDB/templates/TemplateQuery.xml, CustomReports/CMDB/templates/Templates.xslt)
2009-12-22 13:15:12,091 INFO - OneCMDBWebServiceImpl.auth(?) | WSDL: auth(admin, ******)
2009-12-22 13:15:12,095 INFO - Session.login(?) | Login FAILED for user<admin
2009-12-22 13:15:12,096 ERROR - DefaultFaultHandler.invoke(35) | Fault occurred!
org.acegisecurity.BadCredentialsException: Bad credentials
at org.acegisecurity.providers.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:118)

Can you help me with this?
Thanks in advance

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

M Maxwell - 2009-12-22

Fresh install of the new version, clean system. Setup per the docs. I configured the network range in nmap discovery, ran it, and here we go again…:

NMAP_Discovery/bin/nmap-discovery - - Nmap run completed - 256 IP addresses (42 hosts up) scanned in 191 seconds
NMAP_Discovery/bin/nmap-discovery - - Transform output.
NMAP_Discovery/bin/nmap-discovery - - org.apache.commons.logging.LogConfigurationException: java.lang.ClassFormatError: Incompatible magic value 1313685840 in class file org/apache/log4j/LayoutBeanInfo (Caused by java.lang.ClassFormatError: Incompatible magic value 1313685840 in class file org/apache/log4j/LayoutBeanInfo)
NMAP_Discovery/bin/nmap-discovery - - at org.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:538)
NMAP_Discovery/bin/nmap-discovery - - at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:235)
NMAP_Discovery/bin/nmap-discovery - - at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:209)
NMAP_Discovery/bin/nmap-discovery - - at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:351)
NMAP_Discovery/bin/nmap-discovery - - at org.onecmdb.core.utils.transform.TransformEngine.<init>(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at org.onecmdb.core.utils.transform.TransformBeanProvider.<init>(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at org.onecmdb.utils.wsdl.OneCMDBTransform.process(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at org.onecmdb.utils.wsdl.OneCMDBTransform.process(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at org.onecmdb.utils.wsdl.AbstractCMDBCommand.start(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at org.onecmdb.utils.wsdl.OneCMDBTransform.main(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
NMAP_Discovery/bin/nmap-discovery - - at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at java.lang.reflect.Method.invoke(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at org.onecmdb.utils.classloader.RemoteClassLoader.main(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - Caused by: java.lang.ClassFormatError: Incompatible magic value 1313685840 in class file org/apache/log4j/LayoutBeanInfo
NMAP_Discovery/bin/nmap-discovery - - at java.lang.ClassLoader.defineClass1(Native Method)
NMAP_Discovery/bin/nmap-discovery - - at java.lang.ClassLoader.defineClass(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at java.security.SecureClassLoader.defineClass(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at java.net.URLClassLoader.defineClass(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at java.net.URLClassLoader.access$100(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at java.net.URLClassLoader$1.run(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at java.security.AccessController.doPrivileged(Native Method)
NMAP_Discovery/bin/nmap-discovery - - at java.net.URLClassLoader.findClass(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at org.onecmdb.utils.classloader.RemoteClassLoader.findClass(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at java.lang.ClassLoader.loadClass(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at java.lang.ClassLoader.loadClass(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at java.beans.Introspector.instantiate(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at java.beans.Introspector.findExplicitBeanInfo(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at java.beans.Introspector.<init>(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at java.beans.Introspector.getBeanInfo(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at java.beans.Introspector.getBeanInfo(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at java.beans.Introspector.<init>(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at java.beans.Introspector.getBeanInfo(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at org.apache.log4j.config.PropertySetter.introspect(PropertySetter.java:66)
NMAP_Discovery/bin/nmap-discovery - - at org.apache.log4j.config.PropertySetter.getPropertyDescriptor(PropertySetter.java:234)
NMAP_Discovery/bin/nmap-discovery - - at org.apache.log4j.config.PropertySetter.setProperty(PropertySetter.java:146)
NMAP_Discovery/bin/nmap-discovery - - at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:120)
NMAP_Discovery/bin/nmap-discovery - - at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:87)
NMAP_Discovery/bin/nmap-discovery - - at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:640)
NMAP_Discovery/bin/nmap-discovery - - at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:603)
NMAP_Discovery/bin/nmap-discovery - - at org.apache.log4j.PropertyConfigurator.configureRootCategory(PropertyConfigurator.java:500)
NMAP_Discovery/bin/nmap-discovery - - at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:406)
NMAP_Discovery/bin/nmap-discovery - - at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:432)
NMAP_Discovery/bin/nmap-discovery - - at org.apache.log4j.helpers.OptionConverter.selectAndConfigure(OptionConverter.java:460)
NMAP_Discovery/bin/nmap-discovery - - at org.apache.log4j.LogManager.<clinit>(LogManager.java:113)
NMAP_Discovery/bin/nmap-discovery - - at org.apache.log4j.Logger.getLogger(Logger.java:94)
NMAP_Discovery/bin/nmap-discovery - - at org.apache.commons.logging.impl.Log4JLogger.getLogger(Log4JLogger.java:229)
NMAP_Discovery/bin/nmap-discovery - - at org.apache.commons.logging.impl.Log4JLogger.<init>(Log4JLogger.java:65)
NMAP_Discovery/bin/nmap-discovery - - at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
NMAP_Discovery/bin/nmap-discovery - - at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at java.lang.reflect.Constructor.newInstance(Unknown Source)
NMAP_Discovery/bin/nmap-discovery - - at org.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:529)
NMAP_Discovery/bin/nmap-discovery - - … 14 more
NMAP_Discovery/bin/nmap-discovery - - Runtime 246ms
NMAP_Discovery/bin/nmap-discovery - - Transform nmap result FAILED!
NMAP_Discovery/bin/nmap-discovery - auto-close streams
NMAP_Discovery/bin/nmap-discovery - terminated
NMAP_Discovery/bin/nmap-discovery - auto-close streams
NMAP_Discovery/bin/nmap-discovery - terminated
Exec Ended , result=1 - null
Update History….
NMAP_Discovery/bin/nmap-discovery - started.
NMAP_Discovery/bin/nmap-discovery - no reader set.
NMAP_Discovery/bin/nmap-discovery - auto-close streams
NMAP_Discovery/bin/nmap-discovery - terminated
History update complete
Execution Completed

Time to find another product.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

OneCMDB Version 2.1.0 released.

Forums

Help

OneCMDB Version 2.1.0 released. document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

OneCMDB Version 2.1.0 released.