NetXMS Support Forum

Hello

Can you please point me to document, that will provide me help me/ guide me to implement reporting feature (using Jasper report's .jxml files).  Not sure from where I need to start. It will great if there is any tutorial kind of document.

Currently I am using Netxms window client version 2.0-M2(8008)


I have done following
from  "https://www.netxms.org/download/archive/reporting/" I have download "netxms-reporting-server-2.0-M2.zip"
I have unziped it in Window and copied it to unix box where my netxms server (ntxmsd) is running

copied it to location /apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2
and did following steps

1) executed "nxdbmgr set EnableReportingServer 1"
2) created conf folder under "/apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2"
3) created workplace folder under ""/apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2"
4) created logback.xml under conf folder
5) created nxreporting.xml under conf folder
6) Now the folder looks like

   uspsqa1@mkeux805n-z1-76-SWITCH>> ls -ltra
   total 5920
   drwxr-xr-x  11 uspsqa1  uspsqa1       34 Sep  9 02:33 ..
   -rw-r--r--   1 uspsqa1  uspsqa1  2929061 Sep  9 02:33 nxreporting-2.0-M2.jar
   drwxr-xr-x   5 uspsqa1  uspsqa1        6 Sep  9 02:33 .
   drwxr-xr-x   2 uspsqa1  uspsqa1       79 Sep  9 02:33 lib
   drwxr-xr-x   2 uspsqa1  uspsqa1        4 Sep  9 02:48 conf
   drwxr-xr-x   4 uspsqa1  uspsqa1        4 Sep  9 02:49 workplace

   /apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2/workplace
   uspsqa1@mkeux805n-z1-76-SWITCH>> ls -ltra
   total 13
   drwxr-xr-x   5 uspsqa1  uspsqa1        6 Sep  9 02:33 ..
   drwxr-xr-x   2 uspsqa1  uspsqa1        2 Sep  9 02:49 definitions
   drwxr-xr-x   2 uspsqa1  uspsqa1        2 Sep  9 02:49 output
   drwxr-xr-x   5 uspsqa1  uspsqa1        5 Sep  9 02:49 .



7) When I executed "java -jar nxreporting-2.0-M2.jar", it produced several errors, kindly review the errors and
let me know the corrections that I need to do, I have attached output of execution for your review


Also here are the content of my nxreporting.xml and logback.xml,
The path "/apps/uspsqa1/ntxms/netxms/etc/netxmsd.conf" valid path were I have server configuration
I have not given <datasource> info beacause I read that database details be collected from server configuration


content of "nxreporting.xml"

<config>
  <workspace>/apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2/workplace</workspace>
    <netxmsdConfig>/apps/uspsqa1/ntxms/netxms/etc/netxmsd.conf</netxmsdConfig>
    <datasources>
        <datasource>           
        </datasource>
    </datasources>
    <smtp>
        <server>127.0.0.1</server>
        <from>[email protected]</from>
    </smtp>
    <netxms>
        <server>127.0.0.1</server>
        <login>admin</login>
        <password>Awesome@1</password>
    </netxms>
</config>


content of "logback.xml"

<configuration>
  <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
     <!-- encoders are assigned the type
         ch.qos.logback.classic.encoder.PatternLayoutEncoder by default -->
     <encoder>
         <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
     </encoder>
  </appender>
  <root level="debug">
    <appender-ref ref="STDOUT" />
  </root>
</configuration>


Regards
Naga

Hello Team

I have to execute by explicity spcifying the path in the command after modifying the "nxreporting.xml" to have datasource information

java -cp /apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2/lib/\*.jar:/apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2/conf:/apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2/nxreporting-2.0-M2.jar com.radensolutions.reporting.Launcher

Now I am getting database connection error:
java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

I have attached full output of above command execution

The content of update "nxreporting.xml", please let me know whether this xml content is correct or not
<config>
  <workspace>/apps/uspsqa1/ntxms/netxms-reporting-server-2.0-M2/workplace</workspace>
    <netxmsdConfig>/apps/uspsqa1/ntxms/netxms/etc/netxmsd.conf</netxmsdConfig>
    <datasources>
        <datasource>
            <id>ntxdb</id>
            <type>oracle</type>
            <url>jdbc:oracle:thin:@//10.80.226.18:1521/uspsq_app</url>
            <username>e1010985</username>
            <password>one2345</password>
        </datasource>
    </datasources>
    <smtp>
        <server>127.0.0.1</server>
        <from>[email protected]</from>
    </smtp>
    <netxms>
        <server>127.0.0.1</server>
        <login>admin</login>
        <password>Awesome@1</password>
    </netxms>
</config>



Thanks
Naga