NetXMS Support Forum

Dear support team is there way to stop collecting and processing rpm packages on RHEL installation of agent?

We have currently problem with corruption on rpm db which causes huge amount of packages removed and added and agent reads them. This issue is looks like Redhat bug, but i have all installation updated and same behavior occurs on another RHEL 8 servers.

I don't want unmonitor this server, just want skip packages processing. Is there any option's on agent to stop collecting rpm db data ?

Dear support team,
i have problem with my sqlite database which im using in docker image on debian 10 base, im unable to upgrade database schema from version 39.8 to 39.9

before i write this forum topic i check consistency of migrated db, and all checks are ok.

Upgrade db schema ends in step 39.8 to 39.9 and not continue further, any idea what to check ?

Docker image is avalible here > https://hub.docker.com/repository/docker/madmucho/netxms/general
i stopped all services in docker using supervisorctl stop all
update distro packages and during package update process upgrade schema hangs.

In attachment is screen of update proces on which step upgrade stops and not continue further.

Dear support team,
i observing strange behavior in times when netxms service starting, maibe service trying to cache some data from database, but this takes a lot of memory and if memory goes empty system begins to swap some process out and in this time netxms process release a lot of memory and then starts and runs ok...its strange.

My environment is debian 10, database is mariadb.

Server version 3.8.267-1

Monitored nodes 297
Collectible DCIs  22487
Active alarms 180012

Mariadb has 60Gb of data.

System has 2vCPU 10GB RAM, usually memory is at 75 percent and everything runs ok, I see problems only at startup.

You can see a few minutes delay in startup log, in this time memory usage goes to swap, and then drops to normal.


2021.04.27 16:14:32.298 *I* [logger             ] Log file opened (rotation policy 2, max size 16777216)
2021.04.27 16:14:32.298 *D* [                   ] LIB directory set to /usr/lib/x86_64-linux-gnu/netxms
2021.04.27 16:14:32.298 *I* [                   ] Code page set to UTF8
2021.04.27 16:14:32.301 *I* [                   ] Platform subagent "/usr/lib/x86_64-linux-gnu/netxms/linux.nsm" successfully loaded
2021.04.27 16:14:32.302 *I* [db.drv             ] Database driver "mariadb.ddr" loaded and initialized successfully
2021.04.27 16:14:32.303 *D* [                   ] Local administration interface listener started
2021.04.27 16:14:32.303 *D* [                   ] Successfully connected to database [email protected]
2021.04.27 16:14:32.312 *D* [db.cpool           ] Database Connection Pool initialized
2021.04.27 16:14:32.312 *D* [db.cpool           ] Database Connection Pool maintenance thread started
2021.04.27 16:14:32.312 *I* [                   ] Server ID 3007CF4CB43E2255
2021.04.27 16:14:32.316 *D* [db.lock            ] Database lock set
2021.04.27 16:14:32.322 *I* [db.writer          ] DBWriter/Housekeeper interlock is OFF
2021.04.27 16:14:32.322 *D* [core               ] Data directory set to /var/lib/netxms
2021.04.27 16:14:32.323 *D* [                   ] Global configuration loaded
2021.04.27 16:14:32.325 *D* [crypto             ] Validating ciphers
2021.04.27 16:14:32.325 *D* [crypto             ]    AES-256 enabled
2021.04.27 16:14:32.325 *D* [crypto             ]    Blowfish-256 enabled
2021.04.27 16:14:32.325 *D* [crypto             ]    IDEA disabled (config)
2021.04.27 16:14:32.325 *D* [crypto             ]    3DES enabled
2021.04.27 16:14:32.325 *D* [crypto             ]    AES-128 enabled
2021.04.27 16:14:32.325 *D* [crypto             ]    Blowfish-128 enabled
2021.04.27 16:14:32.325 *I* [crypto             ] Crypto library initialized (OpenSSL 1.1.1d  10 Sep 2019)
2021.04.27 16:14:32.325 *I* [crypto.cert        ] Server certificate not set
2021.04.27 16:14:32.334 *D* [threads.pool       ] Thread pool MAIN initialized (min=8, max=256)
2021.04.27 16:14:32.334 *D* [threads.pool       ] Thread pool AGENT initialized (min=4, max=256)
2021.04.27 16:14:32.363 *D* [watchdog           ] Watchdog thread started
2021.04.27 16:14:32.364 *D* [db.writer          ] Using 1 DCI data write queues
2021.04.27 16:14:32.364 *D* [db.writer          ] Raw DCI data flush interval is 30 seconds
2021.04.27 16:14:32.364 *D* [threads.pool       ] Thread pool NPE initialized (min=1, max=1024)
2021.04.27 16:14:32.364 *D* [                   ] SMTP mailer thread started
2021.04.27 16:14:32.365 *D* [                   ] SQLite version 3.27.2
2021.04.27 16:14:32.365 *I* [db.drv             ] Database driver "sqlite.ddr" loaded and initialized successfully
2021.04.27 16:14:34.605 *D* [                   ] SQLite version 3.27.2
2021.04.27 16:14:34.605 *I* [db.drv             ] Database driver "sqlite.ddr" loaded and initialized successfully
here something eats my memory few minutes
2021.04.27 16:17:06.738 *D* [nc                 ] Loading notification channel drivers from /usr/lib/x86_64-linux-gnu/netxms/ncdrv
2021.04.27 16:17:06.906 *D* [nc                 ] 18 notification channel drivers loaded
2021.04.27 16:17:06.906 *D* [nc                 ] 0 notification channels added
2021.04.27 16:17:06.907 *D* [ndd                ] Loading network device drivers from /usr/lib/x86_64-linux-gnu/netxms/ndd
2021.04.27 16:17:06.908 *I* [ndd                ] Network device driver CAMBIUM-CNPILOT loaded successfully
2021.04.27 16:17:06.908 *I* [ndd                ] Network device driver CAMBIUM-EPMP loaded successfully
2021.04.27 16:17:06.924 *I* [ndd                ] Network device driver SAF-INTEGRA-B loaded successfully
2021.04.27 16:17:06.925 *I* [ndd                ] Network device driver SYMBOL-WS loaded successfully
2021.04.27 16:17:06.925 *I* [ndd                ] Network device driver WESTERSTRAND loaded successfully
2021.04.27 16:17:06.926 *I* [ndd                ] Network device driver UBNT loaded successfully
2021.04.27 16:17:06.927 *I* [ndd                ] Network device driver AT loaded successfully
2021.04.27 16:17:06.928 *I* [ndd                ] Network device driver CATALYST-GENERIC loaded successfully
2021.04.27 16:17:06.928 *I* [ndd                ] Network device driver CATALYST-2900XL loaded successfully
2021.04.27 16:17:06.928 *I* [ndd                ] Network device driver CISCO-ESW loaded successfully
2021.04.27 16:17:06.928 *I* [ndd                ] Network device driver CISCO-NEXUS loaded successfully
2021.04.27 16:17:06.928 *I* [ndd                ] Network device driver CISCO-SB loaded successfully
2021.04.27 16:17:06.928 *I* [ndd                ] Network device driver CISCO-WLC loaded successfully
2021.04.27 16:17:06.928 *I* [ndd                ] Network device driver CISCO-GENERIC loaded successfully
2021.04.27 16:17:06.928 *I* [ndd                ] Network device driver OPTIX loaded successfully
....
2021.04.27 16:17:12.453 *D* [                   ] 0 startup scripts processed
2021.04.27 16:17:12.453 *D* [                   ] Server initialization completed in 160155 milliseconds
2021.04.27 16:17:12.454 *D* [statcoll           ] Server statistic collector thread started
2021.04.27 16:17:12.454 *I* [                   ] NetXMS Server started



After server started all working ok.
HTop images attached from time after Netxms server is up and responding to console.

Any idea what can cause this peak ?

Dear Technical support,
i get two SQL query failed events in my netxmsd instance, it happens again and again

Instance is debian 10 and database mariadb, and netxms 3.5.136-1 version.

I set up debug mode and catch as much as i can, looks like there is special char in value which cause query to fail.
mariadb database for netxms is Charset latin1 and collation name latin1_swedish_ci

2020.10.16 11:14:05.968 *D* [db.query           ] BEGIN TRANSACTION successful (level 1)
2020.10.16 11:14:05.997 *D* [                   ] Node(MTFlaje.poh.cz)->getMetricFromSNMP(.1.3.6.1.2.1.31.1.1.1.11.11): dwResult=0
2020.10.16 11:14:05.997 *D* [                   ] DataCollector(): processing DC object 368423 ".1.3.6.1.2.1.31.1.1.1.11.120" owner=183 sourceNode=0
2020.10.16 11:14:06.015 *E* [db.drv             ] SQL query failed (Query = "INSERT INTO hardware_inventory (node_id,category,component_index,hw_type,vendor,model,location,capacity,part_number,seri
al_number,description) VALUES (?,?,?,?,?,?,?,?,?,?,?)"): Incorrect string value: '\xC5\xA5 Eth...' for column `netxms`.`hardware_inventory`.`hw_type` at row 1
2020.10.16 11:14:06.015 *D* [                   ] NetObj::expandText(sourceObject=108 template='Database query failed (Query: %1; Error: %2)' alarm=0 event=102620065)
2020.10.16 11:14:06.015 *D* [event.corr         ] CorrelateEvent: event SYS_DB_QUERY_FAILED id 102620065 source netxms [108]


] EVENT SYS_DB_QUERY_FAILED [52] at {0} (ID:102620065 F:0x0001 S:4 TAGS:"") FROM netxms: Database query failed (Query: INSERT INTO hardware_inventory
(node_id,category,component_index,hw_type,vendor,model,location,capacity,part_number,serial_number,description) VALUES (?,?,?,?,?,?,?,?,?,?,?); Error: Incorrect string value: '\xC5\xA5 Eth...' for
column `netxms`.`hardware_inventory`.`hw_type` at row 1)



Looks like unescaped value to insert.

Dear support team,
i found small mistake while editing AlarmHistoryRetentionTime using console,
there is value and caption for it as "seconds" should be days i think.

In my case value is 60 days.

Dear support team,
i migrated to v3, and unable to get correct web ui .war file when i deploy latest .war from download section i still get app version 2.2.17 (9525) at logon screen and version conflict after login.

Screenshot attached.

Dear Support team,
I have problem with oracle subagent, cannot load it correctly at agent side.

In config i have line Subagent = oracle.nsm 
But starting agent from comand line for check if loads correctly gives me
DB Library: Unable to load database driver module "oracle.ddr": %1 is not a valid Win32 application.

I have oracle.ddr and oracle.nsm files in bin directory after install, looks like it calls something from oracle client installation, which is installed and working on same win server as agent is.

Any hints what can be wrong or what is prerequirments on windows installation for oracle subagent to load correctly?

Netxms agnet 2.2.4
Oracle client 11.2.0

Dear users,
i have problem on debian installation.

i try to migrate from sqlite to mysql, i have mysql server ready db initialized and invoking migrate command with stoped netxmsd service.
i get following.

root@netxms:/tmp# nxdbmgr -I -t migrate /tmp/netxmsd.conf
WARNING: invalid transaction size, reset to defaultNetXMS Database Manager Version 2.0.3 Build 8066 (UNKNOWN) (UNICODE)

Database driver sqlite.ddr loaded
Connected to source database


WARNING!!!
This operation will clear all configuration and collected data from destination database before migration.
Are you sure? (Y/N) y
>>> SELECT id FROM nodes
>>> DELETE FROM config
>>> DELETE FROM config_clob
>>> DELETE FROM users
>>> DELETE FROM user_groups
>>> DELETE FROM user_group_members
>>> DELETE FROM user_profiles
>>> DELETE FROM userdb_custom_attributes
>>> DELETE FROM object_properties
>>> DELETE FROM object_custom_attributes
>>> DELETE FROM zones
>>> DELETE FROM mobile_devices
>>> DELETE FROM access_points
>>> DELETE FROM racks
>>> DELETE FROM nodes
>>> DELETE FROM clusters
>>> DELETE FROM cluster_members
>>> DELETE FROM cluster_sync_subnets
>>> DELETE FROM cluster_resources
>>> DELETE FROM subnets
>>> DELETE FROM interfaces
>>> DELETE FROM interface_address_list
>>> DELETE FROM network_services
>>> DELETE FROM vpn_connectors
>>> DELETE FROM vpn_connector_networks
>>> DELETE FROM object_containers
>>> DELETE FROM conditions
>>> DELETE FROM cond_dci_map
>>> DELETE FROM templates
>>> DELETE FROM dct_node_map
>>> DELETE FROM nsmap
>>> DELETE FROM container_members
>>> DELETE FROM acl
>>> DELETE FROM trusted_nodes
>>> DELETE FROM items
>>> DELETE FROM dc_tables
>>> DELETE FROM dc_table_columns
>>> DELETE FROM dct_column_names
>>> DELETE FROM dct_thresholds
>>> DELETE FROM dct_threshold_conditions
>>> DELETE FROM dci_schedules
>>> DELETE FROM raw_dci_values
>>> DELETE FROM event_cfg
>>> DELETE FROM event_log
>>> DELETE FROM actions
>>> DELETE FROM event_groups
>>> DELETE FROM event_group_members
>>> DELETE FROM event_policy
>>> DELETE FROM policy_source_list
>>> DELETE FROM policy_event_list
>>> DELETE FROM policy_action_list
>>> DELETE FROM policy_time_range_list
>>> DELETE FROM policy_situation_attr_list
>>> DELETE FROM time_ranges
>>> DELETE FROM thresholds
>>> DELETE FROM alarms
>>> DELETE FROM alarm_notes
>>> DELETE FROM alarm_events
>>> DELETE FROM snmp_trap_cfg
>>> DELETE FROM snmp_trap_pmap
>>> DELETE FROM agent_pkg
>>> DELETE FROM object_tools
>>> DELETE FROM object_tools_acl
>>> DELETE FROM object_tools_table_columns
>>> DELETE FROM object_tools_input_fields
>>> DELETE FROM syslog
>>> DELETE FROM script_library
>>> DELETE FROM snmp_trap_log
>>> DELETE FROM agent_configs
>>> DELETE FROM address_lists
>>> DELETE FROM graphs
>>> DELETE FROM graph_acl
>>> DELETE FROM certificates
>>> DELETE FROM audit_log
>>> DELETE FROM situations
>>> DELETE FROM snmp_communities
>>> DELETE FROM ap_common
>>> DELETE FROM ap_bindings
>>> DELETE FROM ap_config_files
>>> DELETE FROM usm_credentials
>>> DELETE FROM network_maps
>>> DELETE FROM network_map_elements
>>> DELETE FROM network_map_links
>>> DELETE FROM images
>>> DELETE FROM dashboards
>>> DELETE FROM dashboard_elements
>>> DELETE FROM dashboard_associations
>>> DELETE FROM business_services
>>> DELETE FROM slm_checks
>>> DELETE FROM node_links
>>> DELETE FROM slm_agreements
>>> DELETE FROM slm_tickets
>>> DELETE FROM slm_service_history
>>> DELETE FROM organizations
>>> DELETE FROM persons
>>> DELETE FROM job_history
>>> DELETE FROM licenses
>>> DELETE FROM mapping_tables
>>> DELETE FROM mapping_data
>>> DELETE FROM dci_summary_tables
>>> DELETE FROM scheduled_tasks
>>> DELETE FROM zmq_subscription
Database successfully cleared
Migrating table config
ERROR: cannot prepare INSERT statement (Column 'possible_values' specified twice)
Database migration failed.
root@netxms:/tmp# nxdbmgr -h
NetXMS Database Manager Version 2.0.3 Build 8066 (UNKNOWN) (UNICODE)


i try export db and i get this
root@netxms:/var/lib/netxms# nxdbmgr export /tmp/migrate.db
NetXMS Database Manager Version 2.0.3 Build 8066 (UNKNOWN) (UNICODE)

Exporting table config
Segmentation fault


Instalation is from debian repository not compiled version.
Im currently on sqlite and is working, db check is ok.

Any ideas how to fix it ?

Dear users,
let me inform you about docker image which i created and maintain on dockerhub
https://hub.docker.com/r/madmucho/netxms/

this release contains netxms base sqlite version, it is very small based od debian 8 fast and running in seconds.

If you miss something inside let me know here so i will add futures and items to next versions.