NetXMS Support Forum

Check netxmsd log for failed sql queries. Also check db writer queue size (there should be automatically created DCIs on the server node).

https://wiki.netxms.org/wiki/How_to_migrate_to_another_database

Yes, it's a bug, looks like automatic cast not working correctly in set custom attribute. Wrap -1 in quite marks and it will work.

// Set initial device attributes
// If an attribute does not exist, will create it with -1 as value
// If attribute already exists, will not change it


sub AirFiber()
{
if (GetCustomAttribute($node,"TestVar1") == null) SetCustomAttribute($node,"TestVar1","-1");
}

sub AirMax()
{
if (GetCustomAttribute($node,"TestVar2") == null) SetCustomAttribute($node,"TestVar2","-1");
}

Add brackets in "if":

if ( ifType->value == 1 && ifType->value == 1 ) return %(true,$1,ifName->value);

А на какой платформе запускаете клиента?

Yes

There was a mistake in the script - there are few more object types which can have idata_* tables.
Please use this script instead:

SELECT s.name FROM (
    SELECT
        substr(t.table_name,7) AS id,
        t.table_name AS name
    FROM information_schema.tables t
    WHERE
        t.table_schema='mtest'
        AND t.table_name LIKE 'idata_%') AS s
WHERE s.id NOT IN (
        SELECT id FROM nodes
        UNION SELECT id FROM clusters
        UNION SELECT id FROM access_points
        UNION SELECT id FROM sensors
        UNION SELECT id FROM mobile_devices
    );

Hello.

Number of idata tables should be roughly the same as number of nodes in the system.

This query should return list of tables without corresponding record in nodes or clusters:
SELECT s.id,s.name FROM (SELECT substr(t.table_name,7) AS id, t.table_name AS name FROM information_schema.tables t WHERE t.table_schema='mtest' AND t.table_name LIKE 'idata_%') AS s WHERE s.id NOT IN (SELECT id FROM nodes UNION SELECT id FROM clusters);

I assume you are talking about SYS_IF_DOWN, because SYS_NODE_DOWN is unrelated to expected interface status.

I see two ways:
1) Create DCIs
2) Change interfaces back to expected UP/DOWN and filter out SYS_IF_DOWN in EPP (with "stop processing" action). Most likely you'll want to change status propagation on interfaces to Normal, this way they will not affect status of the node itself (expect up/downlinks, probably). All these changes can be scripted (in Hook::ConfigurationPoll).

You can also double click on the node - this will show interfaces for this particular node even if they are hidden globally

Quote from: MarcusH on October 07, 2019, 08:54:23 AM
Thanks for clearing that one up, if it is by design i'll try to stick with it and i kind of got a liking for changing interfaces via object details now

Plugin in grafana repo will be updated shortly.
In a meantime you can update it directly from git.

Quote from: vir_db on September 12, 2019, 12:34:03 PM
Thanks Viktor,

just another issue: seems that the upgrade brok the grafana plugin. I can get alerts, but I cannot collect any graphs (for ex. CPU Usage)

Hello.

Today we incidentally pushed pre-release build from 3.0 branch to a stable repository for Ubuntu Xenial and Bionic (amd64 only) and this version was available for couple of hours. We are really sorry for this mistake.

Repository is rolled back.

If you upgraded your system, you now have two options - continue to use v3 (which is not yet released as stable, but quite a lot of our customers use it in production environment already) or revert to pre-upgrade backup.

If you'll decide to use v3, management console is available here:
Desktop - https://cloud.netxms.org/index.php/s/C3YvqKOwCgp3Dvz
Web - https://cloud.netxms.org/index.php/s/AJIGoc8w028EBBU

Looks like internal lock. I recommend you to upgrade to 2.2.16. If issue remain, please take snapshot of the process threads (we bundle script capture_netxmsd_threads.sh for that).

Just pushed into repo, please check

Thank you for kind words and for using our product