NetXMS Support Forum

Hi,

Thank you for your support.
Can this webapi test be performed in a browser, e.g. with the URL "http://ipaddress:port/webapi"?
I tried this, but unfortunately I didn't get any results.


If I enter the Hostname or IP parameter in the format http://ipaddress:port in the Android app, I get an error code 500.

Thanks, that's was exactly what I needed.

The thing is that on some Linux Distros only Maria DB is available.
That's why Alex recommended to put

DBDriver=mariadb

into agent's configuration file instead of

DBDriver=mysql


You've achieved the same result by copying database driver file, but this is not correct approach, because on next upgrade you'll get new version of mariadb.ddr file and if you forget to copy it, you'll get strange errors.

Sorry
I didn't catch the last line of your answer

Thanks,
did the trick but I had to do:

cp /usr/lib/x86_64-linux-gnu/netxms/dbdrv/mariadb.ddr /usr/lib/x86_64-linux-gnu/netxms/dbdrv/mysql.ddr

apt install netxms-dbdrv-mariadb

then use DBDriver=mariadb

I just installed netxms but

nxdbmgr init
NetXMS Database Manager Version 5.2.6 Build 5.2-443-ge9a696f0c2

Unable to load and initialize database driver "mysql.ddr"

looking for it I get:

root@x22:/home/he/0/net# ls /usr/lib/x86_64-linux-gnu/netxms/dbdrv/
pgsql.ddr  sqlite.ddr

What can I do?
Thanks in advance

Im using this metric (deployed by a template attached to all Windows systems):
ExternalMetric = MSSQL.InstalledInstancesCount:powershell -NonInteractive -NoProfile -Command "& { (Get-ItemProperty \"HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\").InstalledInstances.Count }"

Then you can use something like this in automatic bind/auto apply:
value = $node.readAgentParameter("MSSQL.InstalledInstancesCount");
return (value != NULL && typeof(value) == "int32" && value > 0);


Oh nice, thank you. Maybe you can add this to the manual for future reference!

Hi

I've got a number of Windows Servers running a variety of different versions of MSSQL server.  I was wondering if anyone has come up with an Automatic Bind rule that can be used to bind them to a container.