Database is locked for report server

Started by saksham.adyso, August 08, 2024, 02:38:43 PM

Previous topic - Next topic

saksham.adyso

If I install the report service on a separate server (a different server than the one on which the netxms server is installed), the event "Database is already locked by another NetXMS server instance (IP address: 192.168.0.254, machine info: nxserver Windows Server 2012 Build 9200)" is written to the netxmsd.log. NetXMS server and report server use the same login. I have also tried separate logins, the database always locks up.

Alex Kirhenshtein

You are running second instance of the netxmsd. Only once instance of the netxmsd should access database at the same time.

If you want to keep reporting server separate, change parameter ReportingServer.Hostname to remote IP of the reporting server.

saksham.adyso

#2
When installing a standalone report server, however, the Base component (and therefore netxmsd) is checked and cannot be unchecked and is therefore mandatory.
ReportingServer.Hostname is set to remote report server correctly.
For the report server to work, should I disable netxmsd and leave only the report service?

Filipp Sudanov

Normally reporting server is installed on the same system as netxms server itself. But theoretically yes, you can disable netxms server service and have only reporing service enabled. 

saksham.adyso

I wanted to try the scenario described in the documentation, where it says about the possibility of a separate report server. Unfortunately the installer contains another issue (another one I described here a here). It lists the base component as mandatory and in fact it is not necessary to install it for the report server.
It is worth considering correcting this error.

Alex Kirhenshtein

Just install full package, then disable "netxms core" service in service manager

saksham.adyso

And also remove any unnecessary firewall rules. Would prefer an installer modification that would not put the user in this situation.

Alex Kirhenshtein


saksham.adyso

How to configure the ListenAddress parameter for nxreportd? If I run the report on a standalone server, by default the binding is set to loopback and thus it is not possible to connect to the service from a remote server.

Filipp Sudanov

You can create nxreportd.properties file in C:\NetXMS\etc\nxreportd folder. In this file you can specify bind address:

nxreportd.bindAddress=1.2.3.4

setting it to * or 0.0.0.0 will bind to all available interfaces.