Database is locked for report server
-
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.
-
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.
-
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? -
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.
-
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. -
Just install full package, then disable “netxms core” service in service manager
-
And also remove any unnecessary firewall rules. Would prefer an installer modification that would not put the user in this situation.
-
Well, you can send PR on the GitHub
-
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.
-
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.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login