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