NetXMS Support Forum

I found System.Uname in the agent parameters and can generate a DCI summary table with that.

Is there another way to get the parameters like version and name / build, all separate?

System.Uname lumps the system name, version, revision, build, etc, all together into one string.

Just wondering if there is a better / easier way to get this information.

I'm pretty sure I could run a report, but I'm currently unable to get reporting running.

https://www.netxms.org/forum/profile/?area=showposts;u=59517

Thanks!

Any ideas on this?

Thanks!

Got a little further, thanks!

What else am I missing?

I get this when running java -jar reporting-server-2.2.2.jar

09:53:33.507 [main] DEBUG c.r.reporting.dao.DaoContextConfig - DaoContextConfig initialized.
09:53:33.507 [main] DEBUG o.s.b.f.s.DefaultListableBeanFactory - Returning cached instance of singleton bean 'org.springframework.transaction.config.internalTransactionAdvisor'
09:53:33.507 [main] DEBUG o.s.b.f.s.DefaultListableBeanFactory - Finished creating instance of bean 'daoContextConfig'
09:53:33.507 [main] DEBUG o.s.b.f.s.DefaultListableBeanFactory - Creating shared instance of singleton bean 'dataSource'
09:53:33.507 [main] DEBUG o.s.b.f.s.DefaultListableBeanFactory - Creating instance of bean 'dataSource'
09:53:33.507 [main] DEBUG o.s.b.f.s.DefaultListableBeanFactory - Returning cached instance of singleton bean 'daoContextConfig'
09:53:33.898 [main] WARN  o.s.c.a.AnnotationConfigApplicationContext - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportManager': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private com.radensolutions.reporting.service.Session com.radensolutions.reporting.service.impl.FileSystemReportManager.session; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionImpl': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private com.radensolutions.reporting.service.ReportScheduler com.radensolutions.reporting.service.impl.SessionImpl.scheduler; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportScheduler': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private com.radensolutions.reporting.service.NotificationService com.radensolutions.reporting.service.impl.QuartzReportScheduler.notificationService; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'notificationServiceImpl': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private org.hibernate.SessionFactory com.radensolutions.reporting.service.impl.NotificationServiceImpl.session; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sessionFactory' defined in class path resource [com/radensolutions/reporting/dao/DaoContextConfig.class]: Unsatisfied dependency expressed through constructor argument with index 0 of type [javax.sql.DataSource]: : Error creating bean with name 'dataSource' defined in class path resource [com/radensolutions/reporting/dao/DaoContextConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'dataSource' threw exception; nested exception is java.lang.NullPointerException; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [com/radensolutions/reporting/dao/DaoContextConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'dataSource' threw exception; nested exception is java.lang.NullPointerException
09:53:33.898 [main] DEBUG o.s.b.f.s.DefaultListableBeanFactory - Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@742aa2: defining beans [org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalPersistenceAnnotationProcessor,org.springframework.context.event.internalEventListenerProcessor,org.springframework.context.event.internalEventListenerFactory,appContextConfig,org.springframework.context.annotation.ConfigurationClassPostProcessor.importAwareProcessor,org.springframework.context.annotation.ConfigurationClassPostProcessor.enhancedConfigurationProcessor,NXCLQueryExecutorFactory,serverSettings,tcpConnector,reportManager,reportResultServiceImpl,sessionImpl,reportScheduler,smtpSenderImpl,notificationServiceImpl,sessionWorker,generatorJob,daoContextConfig,reportResultDAOImpl,org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration,org.springframework.transaction.config.internalTransactionAdvisor,transactionAttributeSource,transactionInterceptor,org.springframework.transaction.config.internalTransactionalEventListenerFactory,dataSource,sessionFactory,transactionManager,org.springframework.aop.config.internalAutoProxyCreator,javaMailSender,quartzScheduler]; root of factory hierarchy



I'm trying to install reporting server on Windows following the instructions in the admin guide:

https://www.netxms.org/documentation/adminguide/reporting.html#installation-manual

Step 8 refers to a link that no longer exists:

8. Create additional tables by executing both scripts from https://git.netxms.org/public/netxms.git/tree/refs/heads/develop:/src/java/nxreporting/sql

I've extracted the files but my definitions folder is empty, I don't know where to get those files.  The zip file on the download page only contains a lib folder and a main .jar file.

https://www.netxms.org/download/releases/2.2/2.2.2/netxms-reporting-server-2.2.2.zip

When I run the following command:

java -cp /opt/nxreporting/lib/\*.jar:/opt/nxreporting/conf:/opt/nxreporting/reporting-server-2.2.2.jar com.radensolutions.reporting.Launcher

OR

java -cp C:\NetXMS\opt\nxreporting\lib\*.jar C:\NetXMS\opt\nxreporting\reporting-server-2.2.2.jar com.radensolutions.reporting.Launcher


I get this error:

Error: Could not find or load main class com.radensolutions.reporting.Launcher

Below is the entire directory structure.

I'm sure I'm missing something or doing something wrong, please let me know what to do.

Thanks!

Volume in drive C has no label.
Volume Serial Number is CAB5-6A94

Directory of C:\NetXMS\opt

02/01/2018  06:54 PM    <DIR>          .
02/01/2018  06:54 PM    <DIR>          ..
02/01/2018  06:54 PM                 0 dir.txt
02/01/2018  06:53 PM    <DIR>          nxreporting
               1 File(s)              0 bytes

Directory of C:\NetXMS\opt\nxreporting

02/01/2018  06:53 PM    <DIR>          .
02/01/2018  06:53 PM    <DIR>          ..
02/01/2018  06:08 PM    <DIR>          conf
02/01/2018  06:45 PM    <DIR>          lib
01/08/2018  02:11 PM           668,742 reporting-server-2.2.2.jar
02/01/2018  06:12 PM    <DIR>          workspace
               1 File(s)        668,742 bytes

Directory of C:\NetXMS\opt\nxreporting\conf

02/01/2018  06:08 PM    <DIR>          .
02/01/2018  06:08 PM    <DIR>          ..
02/01/2018  06:08 PM               663 nxreporting.xml
               1 File(s)            663 bytes

Directory of C:\NetXMS\opt\nxreporting\lib

02/01/2018  06:45 PM    <DIR>          .
02/01/2018  06:45 PM    <DIR>          ..
01/08/2018  02:11 PM            62,983 activation-1.1.jar
01/08/2018  02:11 PM           445,288 antlr-2.7.7.jar
01/08/2018  02:11 PM             4,467 aopalliance-1.0.jar
01/08/2018  02:11 PM           192,035 bcmail-jdk14-1.38.jar
01/08/2018  02:11 PM           192,035 bcmail-jdk14-138.jar
01/08/2018  02:11 PM         1,551,468 bcprov-jdk14-1.38.jar
01/08/2018  02:11 PM         1,551,468 bcprov-jdk14-138.jar
01/08/2018  02:11 PM            22,994 bctsp-jdk14-1.38.jar
01/08/2018  02:11 PM           608,376 c3p0-0.9.1.1.jar
01/08/2018  02:11 PM            49,513 castor-core-1.3.3.jar
01/08/2018  02:11 PM           872,827 castor-xml-1.3.3.jar
01/08/2018  02:11 PM           230,951 commons-beanutils-1.9.0.jar
01/08/2018  02:11 PM           263,965 commons-codec-1.9.jar
01/08/2018  02:11 PM           575,389 commons-collections-3.2.1.jar
01/08/2018  02:11 PM           362,679 commons-configuration-1.10.jar
01/08/2018  02:11 PM            24,283 commons-daemon-1.0.15.jar
01/08/2018  02:11 PM           160,519 commons-dbcp-1.4.jar
01/08/2018  02:11 PM           196,768 commons-digester-2.1.jar
01/08/2018  02:11 PM           284,220 commons-lang-2.6.jar
01/08/2018  02:11 PM            60,686 commons-logging-1.1.1.jar
01/08/2018  02:11 PM            96,221 commons-pool-1.5.4.jar
01/08/2018  02:11 PM           544,403 core-3.2.1.jar
01/08/2018  02:11 PM           313,898 dom4j-1.6.1.jar
01/08/2018  02:11 PM         1,830,791 ecj-4.3.1.jar
01/08/2018  02:11 PM            16,030 geronimo-jta_1.1_spec-1.1.1.jar
01/08/2018  02:11 PM         6,998,724 groovy-all-2.4.4.jar
01/08/2018  02:11 PM            45,024 hamcrest-core-1.3.jar
01/08/2018  02:11 PM            75,288 hibernate-commons-annotations-5.0.1.Final.jar
01/08/2018  02:11 PM         5,583,264 hibernate-core-5.0.7.Final.jar
01/08/2018  02:11 PM           598,084 hibernate-entitymanager-5.0.7.Final.jar
01/08/2018  02:11 PM           113,371 hibernate-jpa-2.1-api-1.0.0.Final.jar
01/08/2018  02:11 PM        11,289,823 icu4j-57.1.jar
01/08/2018  02:11 PM         1,132,307 itext-2.1.7.js5.jar
01/08/2018  02:11 PM            34,476 jackson-annotations-2.1.4.jar
01/08/2018  02:11 PM           206,866 jackson-core-2.1.4.jar
01/08/2018  02:11 PM           926,562 jackson-databind-2.1.4.jar
01/08/2018  02:11 PM            28,576 jakarta-regexp-1.4.jar
01/08/2018  02:11 PM           187,752 jandex-2.0.0.Final.jar
01/08/2018  02:11 PM         5,531,229 jasperreports-6.3.1.jar
01/08/2018  02:11 PM            32,118 jasperreports-functions-6.3.1.jar
01/08/2018  02:11 PM           714,194 javassist-3.18.1-GA.jar
01/08/2018  02:11 PM             2,497 javax.inject-1.jar
01/08/2018  02:11 PM            66,802 jboss-logging-3.3.0.Final.jar
01/08/2018  02:11 PM            16,618 jcl-over-slf4j-1.7.12.jar
01/08/2018  02:11 PM           330,246 jcommon-1.0.23.jar
01/08/2018  02:11 PM         1,565,065 jfreechart-1.0.19.jar
01/08/2018  02:11 PM           573,912 joda-time-2.2.jar
01/08/2018  02:11 PM         1,394,512 jpathwatch-0.95.jar
01/08/2018  02:11 PM           314,932 junit-4.12.jar
01/08/2018  02:11 PM           280,928 logback-classic-1.1.3.jar
01/08/2018  02:11 PM           455,041 logback-core-1.1.3.jar
01/08/2018  02:11 PM         1,586,103 lucene-analyzers-common-4.5.1.jar
01/08/2018  02:11 PM         2,297,477 lucene-core-4.5.1.jar
01/08/2018  02:11 PM           205,195 lucene-queries-4.5.1.jar
01/08/2018  02:11 PM           384,884 lucene-queryparser-4.5.1.jar
01/08/2018  02:11 PM            45,578 lucene-sandbox-4.5.1.jar
01/08/2018  02:11 PM           521,157 mail-1.4.7.jar
01/08/2018  02:11 PM           972,007 mysql-connector-java-5.1.36.jar
01/08/2018  02:11 PM           149,288 netxms-base-2.2.2.jar
01/08/2018  02:11 PM           432,518 netxms-client-2.2.2.jar
01/08/2018  02:11 PM         3,698,857 ojdbc6-12.1.0.2.jar
01/08/2018  02:11 PM           445,343 olap4j-0.9.7.309-JS-3.jar
01/08/2018  02:11 PM         2,136,557 poi-3.12.jar
01/08/2018  02:11 PM           654,490 postgresql-9.4-1202-jdbc4.jar
01/08/2018  02:11 PM           660,316 quartz-2.2.1.jar
01/08/2018  02:11 PM           386,724 simple-xml-2.6.4.jar
01/08/2018  02:11 PM            32,127 slf4j-api-1.7.12.jar
01/08/2018  02:11 PM           370,051 spring-aop-4.2.4.RELEASE.jar
01/08/2018  02:11 PM           731,512 spring-beans-4.2.4.RELEASE.jar
01/08/2018  02:11 PM         1,097,552 spring-context-4.2.4.RELEASE.jar
01/08/2018  02:11 PM           176,775 spring-context-support-4.2.4.RELEASE.jar
01/08/2018  02:11 PM         1,078,737 spring-core-4.2.4.RELEASE.jar
01/08/2018  02:11 PM           262,990 spring-expression-4.2.4.RELEASE.jar
01/08/2018  02:11 PM           423,369 spring-jdbc-4.2.4.RELEASE.jar
01/08/2018  02:11 PM           466,177 spring-orm-4.2.4.RELEASE.jar
01/08/2018  02:11 PM           562,475 spring-test-4.2.4.RELEASE.jar
01/08/2018  02:11 PM           265,523 spring-tx-4.2.4.RELEASE.jar
01/08/2018  02:11 PM           584,207 sqljdbc4-4.0.jar
01/08/2018  02:11 PM           179,346 stax-1.2.0.jar
01/08/2018  02:11 PM            23,346 stax-api-1.0-2.jar
01/08/2018  02:11 PM            26,514 stax-api-1.0.1.jar
01/08/2018  02:11 PM           109,318 xml-apis-1.0.b2.jar
01/08/2018  02:11 PM            93,395 xpp3-1.1.3.3.jar
              83 File(s)     70,072,376 bytes

Directory of C:\NetXMS\opt\nxreporting\workspace

02/01/2018  06:12 PM    <DIR>          .
02/01/2018  06:12 PM    <DIR>          ..
02/01/2018  06:45 PM    <DIR>          definitions
02/01/2018  06:12 PM    <DIR>          output
               0 File(s)              0 bytes

Directory of C:\NetXMS\opt\nxreporting\workspace\definitions

02/01/2018  06:45 PM    <DIR>          .
02/01/2018  06:45 PM    <DIR>          ..
               0 File(s)              0 bytes

Directory of C:\NetXMS\opt\nxreporting\workspace\output

02/01/2018  06:12 PM    <DIR>          .
02/01/2018  06:12 PM    <DIR>          ..
               0 File(s)              0 bytes

     Total Files Listed:
              86 File(s)     70,741,781 bytes
              20 Dir(s)  379,893,391,360 bytes free