NetXMS Support Forum

I finally found the problem. Man, I'm so stupid. I forgot to add the instance name after the servername in the agent config

Hello,
is there a manual on how to setup and use the reporting functions in NetXMS 3.5 under Windows?
All I found is this https://wiki.netxms.org/wiki/Reporting_server_setup, but it looks outdated to me and it's not for Windows.

Thanks

Stefan

Hello,

I'm monitoring a webservice using NetXMS and want to restart the windows service that's responsible for this webservice, in case of a returnvalue other then HTTP 200.
The monitoring already works fine and I get notified when the returnvalue is different to 200.
The service itself is running when I check it, but it delivers no results anymore.
So I restart in manually at the moment to fix this.

How can I make NetXMS do the net stop/net start commands?

Best regards

Stefan

I still have this problem. Is there a way to get more information to find out where the problem is?

Hi, I'm back from vacation now and checked the configuration again.
TCP/IP is enabled for Native Client 32bit and 64bit. (see screenshots)
Is there anything I could test?

Best regards

Stefan

Hi Victor,

I will check this, when I'm back from vacation in two weeks.

Regards

Stefan

Hi,

I think You mean "Mixed Mode Authentication" in SQL Server? This is enabled. Password only uses upper and lowercase chars with some numbers.
Checking the SQL server logs shows that there is no try to login from the login used by the agent.
Very strange.

Do You have more ideas?

Regards

Stefan

Hi,

I try to query some data from an MS SQL Server 2016, but can't get it working.

My Agent config (xxx means confidential):


MasterServers = xxx
ConfigIncludeDir = D:\Program Files\NetXMSAgent\etc\nxagentd.conf.d
LogFile = D:\Program Files\NetXMS\log\agent.log
DebugLevel = 4
FileStore = D:\Program Files\NetXMSAgent\var
SubAgent = filemgr.nsm
SubAgent = ping.nsm
SubAgent = logwatch.nsm
SubAgent = winperf.nsm
SubAgent = wmi.nsm
SubAgent = dbquery.nsm

ExecTimeout=60000
ExternalParameterShellExec=Custom.EBGroupUsers:net localgroup "Engineering Base" | find /c "\"

*DBQUERY
Database = id=db1;driver=mssql.ddr;server=xxx(IP ADDRESS);dbname=master;login=xxx;password=xxx
Query = SQL.RecoverModel:db1:600:SELECT Count(name) FROM sys.databases WHERE recovery_model<>3 and name not in ('msdb','model','master')


I'm sure username and password works.

In the agent log I get:

DBQUERY: cannot connect to database db1 ([Microsoft][SQL Server Native Client 11.0]Named Pipes Provider: Could not open a connection to SQL Server [2]. )
DBQUERY: H_DirectQueryConfigurable: no connection handle for database db1


Named Pipes and TCP/IP is enabled in configuration manager.

I use NetXMS Version 3.2.380

Best regards

Stefan

Quote from: Filipp Sudanov on May 12, 2020, 02:39:49 PM
This is error in a script of a Service Check object. 321 in the name of the script is the ID of that service check.
You'll find that service check, if you enter #321 into the filter in object tree. Check the script there.

Thank's a lot! With that info I was able to find the reason.

I get a lot of alarm messages from one server, but can't find out what is the source of them. (see attached screenshot)
The message is: Script (ServiceCheck::Status::321) execution error: Error 14 in line 4: Function or operation argument is not an object
or Script (ServiceCheck::Status::327) execution error: Error 14 in line 4: Function or operation argument is not an object
In the Alarm Details/DCI Data it says "No DCI associated with this alarm".

How can I find out what's the source of this messages?

Thanks

Stefan

OK, I will try this. Thanks

I investigated further and found out the when I use Powershell to test the service like this:

Invoke-WebRequest -uri http://myserver.net:8683/BasicDataService/help/operations/GetDatabases -UseDefaultCredentials

I have to use the -UseDefaultCredentials, otherwise I alo get error 401 Unauthorized. So ist mußt have to do with authentication.
Howx can I change authentication for NetXMS Webservice monitoring?

Thank You for Your reply. I think I'm a step further know.
The portcheck log tells me the following:

HTTP/1.1 401 Unauthorized
Content-Length: 0
Server: Microsoft-HTTPAPI/2.0
WWW-Authenticate: NTLM
Date: Mon, 23 Mar 2020 10:51:21 GMT
Connection: close

So it looks like an authentication problem. Which credentials is NetXMS using? Can I change them somwhere?
I have to use NTLM for authentication.

Thanks in advance

Hi,

I'm trying to monitor a webservice running on one of my already monitored servers. (replaced by <SERVERNAME> in the following)

The address the service can be reached in a browser is: http://<SERVERNAME>:8683/BasicDataService/help


I created a Network Service below the monitored servers node with the following parameters:

Service Type: HTTP
Port: 8683
IP Address: tried empty and servers ip address
Request: <SERVERNAME>:/BasicDataService/help
Response: ^HTTP/1\.[01] 200.*
Poller Node: default

The agents configuration file on <SERVERNAME> looks like this:


#
# NetXMS agent configuration file
# Created by agent installer at Thu Mar  5 10:38:03 2020
#

MasterServers = <NETXMSMASTERSERVER>
ConfigIncludeDir = D:\Program Files\NetXMSAgent\etc\nxagentd.conf.d
LogFile = D:\Program Files\NetXMSAgent\log\agent.log
DebugLevel = 6
FileStore = D:\Program Files\NetXMSAgent\var
SubAgent = filemgr.nsm
SubAgent = ping.nsm
SubAgent = logwatch.nsm
SubAgent = winperf.nsm
SubAgent = wmi.nsm
SubAgent = portcheck.nsm

The service is always reported as "Not Responding"

What am I doing wrong?

Regards

Stefan

Thank You.