NetXMS Support Forum

Database log show some processing and is ending with "Prepare UPDATE network_maps SET link_styling_script=?,filter=? WHERE id=?"

In MariaDB log appear message:
2024-05-09 13:59:01 9 [Warning] Aborted connection 9 to db: 'netxms_db' user: 'netxms' host: 'localhost' (Got an error reading communication packets)

#####
    9 Query SELECT item_id,transformation,instd_filter FROM items
    9 Prepare UPDATE items SET transformation=?,instd_filter=? WHERE item_id=?
...
    9 Query SELECT threshold_id,script FROM thresholds
    9 Prepare UPDATE thresholds SET script=? WHERE threshold_id=?
...
    9 Query SELECT item_id,transformation_script,instd_filter FROM dc_tables
    9 Prepare UPDATE dc_tables SET transformation_script=?,instd_filter=? WHERE item_id=?
...   
9 Query SELECT rule_id,filter_script,action_script FROM event_policy
    9 Prepare UPDATE event_policy SET filter_script=?,action_script=? WHERE rule_id=?
...
    9 Query SELECT trap_id,transformation_script FROM snmp_trap_cfg
    9 Prepare UPDATE snmp_trap_cfg SET transformation_script=? WHERE trap_id=?
...
    9 Query SELECT script_id,script_code FROM script_library
    9 Prepare UPDATE script_library SET script_code=? WHERE script_id=?
...
    9 Query SELECT id,link_styling_script,filter FROM network_maps
    9 Prepare UPDATE network_maps SET link_styling_script=?,filter=? WHERE id=?
HERE is the end, nothing executed

Martin

Hello,
has somebody similar issue?

I did direct upgrade from version 4.5.6 to 5.0.2 on windows server.
Database MariaDB 10.4

The service does not start
2024.05.09 12:45:00.438 *I* [startup            ] Starting NetXMS server version 5.0.2 build tag 5.0-878-gccaeca5869
..
2024.05.09 12:45:00.472 *E* [db                ] Your database has format version 50.32, but server is compiled for version 50.39

When run nxdbmgr upgrade, the database is not upgraded.


D:\NetXMS\bin>nxdbmgr check
NetXMS Database Manager Version 5.0.2 Build 5.0-878-gccaeca5869 (UNICODE)

Checking database (excluding collected data):
Your database has format version 50.32, this tool is compiled for version 50.39.
Use "upgrade" command to upgrade your database first.
Database check aborted

D:\NetXMS\bin>nxdbmgr upgrade
NetXMS Database Manager Version 5.0.2 Build 5.0-878-gccaeca5869 (UNICODE)

Upgrading database...
Upgrading from version 50.32 to 50.33

D:\NetXMS\bin>
D:\NetXMS\bin>nxdbmgr check
NetXMS Database Manager Version 5.0.2 Build 5.0-878-gccaeca5869 (UNICODE)

Checking database (excluding collected data):
Your database has format version 50.32, this tool is compiled for version 50.39.
Use "upgrade" command to upgrade your database first.
Database check aborted



Thank you for any advice.

Martin

Is it possible to detect gpu model on windows system and also monitor usage?

Does 5.0.2 address any possible issues with Neighbors links not being drawn on the map ?  It could possible be a filter issue I'm not sure.  

In order to keep the map visuals under control I set the snmp location to the fiber zone that the switch resides in for instance Zone_1 i then create a corresponding container and map.  Container Zone_1 will have a binding rule to bind all switches that match and an inheritable attribute (Name FiberZone  Value 1) The corresponding map will have the following object filter script.

if ($node->name == "CoreSW") return true;
attributes = $node->customAttributes;
foreach(a : attributes->keys)
{
      if(attributes[a] == 1){
      return true;
      }
}

Prior all switches would populate and draw neighbor links and now any new switch added does not show and if manually added to the map links will still not be drawn.  I am assuming this maybe due to the filtering but I am not sure due to the fact i manually add the device to the map and still nothing is linked.

Thanks  

Previously I was using the following script in the configpoll to use the SNMP sysname

/* Available global variables:
 *  $object - current object, one of 'NetObj' subclasses
 *  $node - current object if it is 'Node' class
 *
 * Expected return value:
 *  none - returned value is ignored
 */
 
if (($node->snmpSysName != "") and ($node->snmpSysName !=null))
{
 RenameObject($node->snmpSysName);
}

I know that RenameObject is deprecated but the new rename() does not seem to work either here is what I tried rename( $node->snmpSysName) is there a better way to do this or can this possibly be implemented in the core functionality or as a server config variable 

What do the yellow DCI mean? they collect data but are yellow.

also script says function "CreateSNMPTransport" and "SNMPGetValue" are deprecated, what are replacements?

Quote from: Filipp Sudanov on May 03, 2024, 12:10:56 PMCurrently you can have "Unbound stuff" container somewhere with this auto-bind script, it will pick objects that are not present in any other containers:

for(p : $object.parents) {
  println(classof(p));
  if ((classof(p) == "Container") and p.id != $container.id) return false;
}
return true;

Thanks Filipp.  

I tried this script however it seems to pickup and autobind all nodes over time, not just those nodes outside the infrastructure services tree with no parent container.  

eg: attached an example of it filtered down to some APs that are already in parent containers and still trigger the autobind event.

5.0.2 is now available. Most likely this will be the last release of the legacy console, we'll push app for the new console in next few days.

These scripts were not converted during migration (for multiple reasons, we'll handle that).

You can convert scripts using "nxscript -5" command.

Copy script from the chart into a file, then run "nxscript -5 file.nxsl", it will output updated script.

5.0.2 in published