Reporting Server 2.2.10 (Failed to load reports from the server:...)

Started by 91jme, October 29, 2018, 05:09:36 PM

Previous topic - Next topic

91jme

Hi all,

Attempting to get the Reporting Server set up at the minute and can't seem to get past this final hurdle.

Running 2.2.10 on CentOS 7 x64, kernel 3.10.0-862.14.4.el7.x86_64

I've followed instructions here for setup: https://www.netxms.org/documentation/adminguide/reporting.html.

I used the .sql files from https://git.netxms.org/public/reporting-server.git/tree/HEAD:/sql/mysql?js=1 to create the required tables (links in wiki are dead).

Reporting Server seems to start and listen correctly:



Reporting Server is enabled in NetXMS Server however when trying to load the Reports view the following error is received:



I've checked netxmsd.log with debug at 9 and the only reference I can find to Reporting Server is a message that the connector has started:



/usr/local/etc/netxmsd.conf contains the following:



/opt/nxreporting/conf/nxreporting.xml contains:

<config>
  <workspace>/opt/nxreporting/workspace</workspace>
    <netxmsdConfig>/usr/local/etc/netxmsd.conf</netxmsdConfig>
    <smtp>
        <server>127.0.0.1</server>
        <from>[email protected]</from>
    </smtp>
</config>


Any help or tips on troubleshooting this would be greatly appreciated.

Tatjana Dubrovica

Do you have EnableReportingServer=1 in netxms server configuration(netxmsd.conf)?
This section describes possible additional configuration options: https://www.netxms.org/documentation/adminguide/reporting.html#netxms-server

91jme

Quote from: Tatjana Dubrovica on October 30, 2018, 11:59:44 AM
Do you have EnableReportingServer=1 in netxms server configuration(netxmsd.conf)?
This section describes possible additional configuration options: https://www.netxms.org/documentation/adminguide/reporting.html#netxms-server

Hi Tatjana, yes I have the Reporting Server enabled. You can see the configuration option on my third screenshot of the netxmsd.log output:

Quotename=EnableReportingServer value="1"

91jme

Hi all,

For anybody reading, I think I've fixed the issue. Seems to have been the firewall; I'll list all the troubleshooting steps anyway just in case they help anybody else:

Noticed Java listening on tcp6 (IPv6), switched Java to bind to IPv4 using this command:
export _JAVA_OPTIONS="-Djava.net.preferIPv4Stack=true"
I could't telnet to the server on 4710, which lead me to look at the firewall.
Allowed all traffic on the local interface with the following:
firewall-cmd --permanent --zone=trusted --add-interface=lo
Restarted the reporting engine and netxmsd, waited around 30 seconds and the Report Server perspective loaded correctly: