Difference between revisions of "Reporting server setup"

From NetXMS Wiki
Jump to navigation Jump to search
(Created page with "Prerequisites: Java 1.7+ # Create directories (modify locations to your liking): mkdir -p /opt/netxms-reporting-server mkdir /opt/netxms-reporting-server/conf mkdir /opt/...")
 
m ("Run server" section's path fixed)
Line 57: Line 57:
# Run reporting server:
# Run reporting server:


  cd /opt/netxms-reporting-server/workspace/definitions
  cd /opt/netxms-reporting-server
  java -jar reporting-server-2.0.6.jar
  java -jar reporting-server-2.0.6.jar


In under 30 seconds NetXMS should establish connection with reporting server.
In under 30 seconds NetXMS should establish connection with reporting server.
Open Management Console and select perspective "Reporting", sample report "Alarm Resolution Time" should be listed on the left.
Open Management Console and select perspective "Reporting", sample report "Alarm Resolution Time" should be listed on the left.

Revision as of 14:55, 3 October 2016

Prerequisites: Java 1.7+

  1. Create directories (modify locations to your liking):
mkdir -p /opt/netxms-reporting-server
mkdir /opt/netxms-reporting-server/conf
mkdir /opt/netxms-reporting-server/workspace
mkdir /opt/netxms-reporting-server/workspace/definitions
  1. Download and unpack Reporting server binaries:
cd /opt/netxms-reporting-server
wget http://www.netxms.org/download/reporting/netxms-reporting-server-2.0.6.zip
unzip netxms-reporting-server-2.0.6.zip
rm  netxms-reporting-server-2.0.6.zip
  1. Create configuration file:
cd /opt/netxms-reporting-server/conf
vim nxreporting.xml

Sample configuration file:

<config>
  <workspace>/opt/netxms-reporting-server/workspace</workspace>
    <netxmsdConfig>/etc/netxmsd.conf</netxmsdConfig>
    <smtp>
        <server>127.0.0.1</server>
        <from>[email protected]</from>
    </smtp>
    <netxms>
        <server>127.0.0.1</server>
        <login>admin</login>
        <password>netxms</password>
    </netxms>
</config>
  1. Create additional tables:

Schema for each database type available in GIT: http://git.netxms.org/public/netxms.git/tree/refs/heads/develop:/src/java/nxreporting/sql

wget http://git.netxms.org/public/netxms.git/blob_plain/refs/heads/develop:/src/java/nxreporting/sql/postgres/nxreporting.sql
wget http://git.netxms.org/public/netxms.git/blob_plain/refs/heads/develop:/src/java/nxreporting/sql/postgres/quartz.sql
nxdbmgr batch nxreporting.sql
nxdbmgr batch quartz.sql
  1. Add sample report definition:
cd /opt/netxms-reporting-server/workspace/definitions
wget https://alk.lv/alarm-resolution-time-1.0.0.jar
  1. Configure and restart NetXMS server:
nxdbmgr set EnableReportingServer 1
service netxmsd restart
  1. Run reporting server:
cd /opt/netxms-reporting-server
java -jar reporting-server-2.0.6.jar

In under 30 seconds NetXMS should establish connection with reporting server. Open Management Console and select perspective "Reporting", sample report "Alarm Resolution Time" should be listed on the left.