Reporting Module not working 4.1.420

[negron]

I've installed NetXMS-Server 4.1.420, WebGUI: nxmc-legacy-4.1.420 , WebServer: Jetty 9.4.45 all on the same Ubuntu 22.04 machine

After I installed the netxms-reporting (4.1.420) Module I get the attached error in the WebGUI when I open the Reports-Tab.

I'm using the default Port and Hostname 127.0.0.1:4710

Also I didn't see any option to change the listening Port for the netxms-reporting Modul.
Is this Modul only locally on the same machine usable?

---

[Filipp Sudanov]

Try running
systemctl daemon-reload
as it's suggesting. 

Then try
systemctl start netxms-reporting.service

systemctl status netxms-reporting.service
and
journalctl -u netxms-reporting.service
should provide information about status of the reporting service

[negron]

Thank you for your quick reply.

At first the "daemon-reload" did nothing,
because for unknown reasons there was no "netxms-reporting.service" but a "nxreport.service".

I just renamed the services under "/etc/systemd/system/" as well as "/lib/systemd/system/". Then the service could start successfully.

Attached is a snapshot of "journalctl -u netxms-reporting.service", does this work correctly?

where can I define the IP and port on which the reporting service listens? Currently it is bound to 127.0.0.1:4710

---

[Filipp Sudanov]

Listening IP can be change by setting java option nxreportd.bindAddress, simplest way to do it is adding -Dnxreportd.bindAddress=1.2.3.4 to JAVA_OPTIONS in /usr/bin/nxreportd

Port is currently hard-coded. If it's causing problems, it could be made configurable is some future patch release.

[negron]

Thanks, the connection seems to work with that.

Now I have another problem unfortunately

I used the instructions from How To: NetXMS Reports in 2021 and used the sample file as a test. The report is correctly displayed to me on the main NetXMS, but the report cannot be generated. When clicking on "execute now" a pop-up appears with the message "Sample Report - Users execution started successfully" and then the status in the results shows Error.

journalctl -axeu netxms-reporting.service throws the error
"java.sql.SQLException: Access denied for user '<user>'@'localhost' (using password: YES)".

As I understand it, the reporting server gets the SQL credentials from the main netxms. How should this work, since the main netxms accesses SQL via <user>@localhost, but the reporting server has to access via <user>@<reporting-server-ip>?

[Filipp Sudanov]

Yes, reporting process gets database credentials from netxmsd process. What is the value of DBServer= in your netxmsd.conf ?

[negron]

In the netxmsd.conf the parameter DBServer=127.0.0.1 was entered.

I have now entered the IP of the main server.
Afterwards I created a new user for the reporting server with read-only permission on the SQL-DB and now the reporting module is running.

So now there are the following DB users:
<user>@<main-netxms>
<user>@<netxms-reporting>

Thanks for your help