NetXMS Support Forum

Hello,
we are using latest NetXMS on Debian, and using only Web console.
Is it possible to have Single Sign On enabled, and configured to work with Azure Active Directory (Microsoft Entra ID / Office 365) users? If so, can somebody share configuration steps?
This is not LDAP authentication nor RADIUS.
As I understand it should be under
> Central Authentication Service (CAS) single sign-on is supported in web interface only.
User management — NetXMS Administrator Guide (4.2.433)
 but i do not see way to enter URLs, application id, secret etc., for newly created Azure AD Application Registration

Thank you for your support and great product.

After upgrading to 3.0.0 we started regularly receiving the following errors in the nxagentd log:


[db.driver          ] SQL query failed (Query = "INSERT INTO software_inventory (node_id,name,version,vendor,install_date,url,description) VALUES (?,?,?,?,?,?,?)"): Duplicate entry '4454-SQL Server 2012 Client Tools-11.2.5058.0' for key 'PRIMARY'
[db.driver          ] SQL query failed (Query = "INSERT INTO software_inventory (node_id,name,version,vendor,install_date,url,description) VALUES (?,?,?,?,?,?,?)"): Duplicate entry '5956-SQL Server 2008 R2 SP1 Common Files-10.51.2500.0' for key 'PRIMARY'
[db.driver          ] SQL query failed (Query = "INSERT INTO software_inventory (node_id,name,version,vendor,install_date,url,description) VALUES (?,?,?,?,?,?,?)"): Duplicate entry '6002-SQL Server 2008 R2 SP2 Common Files-10.52.4000.0' for key 'PRIMARY'
[db.driver          ] SQL query failed (Query = "INSERT INTO software_inventory (node_id,name,version,vendor,install_date,url,description) VALUES (?,?,?,?,?,?,?)"): Duplicate entry '6014-Microsoft SQL Server 2008 Analysis Services-10.4.6000.29' for key 'PRIMARY'
[db.driver          ] SQL query failed (Query = "INSERT INTO software_inventory (node_id,name,version,vendor,install_date,url,description) VALUES (?,?,?,?,?,?,?)"): Duplicate entry '6016-Microsoft SQL Server 2008 R2 Setup (English)-10.53.6000.34' for key 'PRIMARY'
[db.driver          ] SQL query failed (Query = "INSERT INTO software_inventory (node_id,name,version,vendor,install_date,url,description) VALUES (?,?,?,?,?,?,?)"): Duplicate entry '6024-SQL Server 2008 R2 SP1 Common Files-10.51.2500.0' for key 'PRIMARY'
[db.driver          ] SQL query failed (Query = "INSERT INTO software_inventory (node_id,name,version,vendor,install_date,url,description) VALUES (?,?,?,?,?,?,?)"): Duplicate entry '6340-SQL Server 2012 Common Files-11.0.2100.60' for key 'PRIMARY'
[db.driver          ] SQL query failed (Query = "INSERT INTO software_inventory (node_id,name,version,vendor,install_date,url,description) VALUES (?,?,?,?,?,?,?)"): Duplicate entry '6783-SQL Server 2012 Common Files-11.3.6020.0' for key 'PRIMARY'
[db.driver          ] SQL query failed (Query = "INSERT INTO software_inventory (node_id,name,version,vendor,install_date,url,description) VALUES (?,?,?,?,?,?,?)"): Duplicate entry '7049-Azure AD Authentication Connected Service-14.0.23107' for key 'PRIMARY'


The exact same nine errors repeat themselves every minute, in the same order.
How can we rectify this? We're ignoring the errors for now since there doesn't seem to be any negative effect from them, other than filling up the logs.

Any info on when we might expect NetXMS Debian buster packages?

Thank you

Quote from: tomaskir on September 07, 2016, 05:41:34 PM
IP address uniqueness is one of the basic concepts in NetXMS... I am pretty sure internally the code also relies on single IP = single device a lot.
Victor will however have to comment more on this.

Simply put a Raspberry Pi, or similar $30 Linux machine into the network, and use it as a proxy.

I believe so and I agree with you.
But since it is a small network with one router and one local switch, i should not buy another device ($5 or whatever) for this simple local network and basic SNMP monitoring.
This is simple NetXMS software limitation then, and my request/proposal is to change the behavior and single IP = single device. I also understand that this is core of the system possibly.

I currently use zoning and it works, which I am trying to avoid.
I do not have devices where I can install NetXMS agent so I can't use proxy.

Enabling simple that IP address must not be unique would resolve the issue.

Quote from: Tatjana Dubrovica on July 07, 2016, 01:07:55 PM
One of solutions can be creation of zones and add devices with same IP in different zones.

thank you for the option, I am aware of it.

So if I have about 10 local network switches, behind one router with nat/public ip, i need to have 10 different zones, one for each switch, which is annoying and destroying the organization of netxms nodes.
but thank you for the info.

Quote from: troffasky on June 16, 2016, 11:11:07 PM

Quote from: hkusulja on June 06, 2016, 08:44:31 PM
I hoped for native NetXMS solution

Site-to-site VPN? TBH the cheapest VPN-capable router will be about the same price as an SBC to run nxagent on, so not much difference either way.

Can you fool NetXMS with multiple DNS/hosts entries pointed at the same IP address?

I can not change routers.
The problem is not network connectivity, I have NAT with port forwarding and connection is possible.

The problem is in NetXMS configuration, which always translates the DNS hostname to IP , and then I have multiple same IPs for more nudes/devices.

Ability to have multiple nodes with same public IP, but pooling using different ports (SNMP...).
Currently this causes node save IP conflict error.

Quote from: tomaskir on June 06, 2016, 08:21:47 PM
Solution without new feature request would be to put a Raspberry Pi (or a similiar SBC) into the network and use it as a proxying agent.

Wish I could help in another way, but without a proxy in the network, not much can be done in this case.

Ok, thank you for the info, I will search for the raspbian (.deb) package of netxms agent.

I hoped for native NetXMS solution

Hi,
I am running latest stable NetXMS 2.x.
I have few locations/clients, with one public IP, and in local area network there are only local routers and switches, without local server where I can place NetXMS agent.
I want to SNMP pool all local switches and routers using one public IP, but using different SNMP port (I have configured NAT and port forwarding).

The problem is that NetXMS says that I have IP conflict.

What is solution, without new feature requests?

Thank you

Quote from: Alex Kirhenshtein on June 29, 2015, 06:17:40 PM
Yes, my bad – packages will be available tomorrow.

Hi, no problem, but is there any progress ?

Regarding to: https://www.netxms.org/forum/announcements/new-debian-repository/

The latest Debian packages are missing. any news about this ?

Quote from: Victor Kirhenshtein on May 08, 2014, 05:02:12 PM
If topology information is correct, you can try to use this script: http://wiki.netxms.org/wiki/Script_Example:_Additional_Information_About_Connected_Node as an example of how to get connected nodes and for SYS_NODE_DOWN event check if node is connected to the switch which is already down.

Hi, maybe my question was not clear enough.
For another example, I do have node (windows server with agent) which has 10x DCI's , 10x network interfaces, 10x network services.
If node goes down, I do not want to receive email / alert for each stuff (every network interface, every network service) that this is down now.

Also is it possible to send email as digest (every 5 mins, grouped in one email) etc.

Thank you

Quote from: Victor Kirhenshtein on May 08, 2014, 05:00:06 PM
NetXMS agent uses PDH API to access performance counters. You can add feature request to our bug tracker for instance discovery support for perf counter DCIs.

Great, thank you, feature request is created here: https://www.radensolutions.com/chiliproject/issues/567

Quote from: Victor Kirhenshtein on May 08, 2014, 06:28:11 PM
Currently you cannot see what output agent was gathered nor measure response time. Feel free to fill feature request

Best regards,
Victor

Ok, thank you. I am marking this as answered/solved.
New feature request is here: https://www.radensolutions.com/chiliproject/issues/565

Thank you once again.