NetXMS Support Forum

Another finding fron debug userdb

There is a message
UpdateLDAPUser(): User with name "XYZ" already exists. Unique user name have been generated: "XYZ_LDAP6756"

Then server crashes and in the user database the new generated user " XYZ_LDAP6756" does not exists.

In our company are the users partionally managed based on user HR database. So when is an employe fired, the account in LDAP/AD remains, but the attribute CN (Full Name) is prepended with "S_". NetXMS ldapsync generate new user. So was it working up to version 5


When delete the LDAP user "XYZ" in Netxms, the sync ends without crashing.

Hello,
my NetXMS service on Windows server 2019, MariaDB crashes when start ldap sync. LDAP server is connected, can read data, then starts update the dababase and crashes

output from debug ldap 4

LDAPConnection::initLDAP(): Connecting to LDAP server
LDAPConnection::initLDAP(): servers="X.Y.X.Y:389" port=389 secure=false
LDAPConnection::syncUsers(): search base DN = OU=##############
LDAPConnection::fillLists(): hook script is empty
LDAPConnection::fillLists(): Found entry count: 714

...

LDAPConnection::closeLDAPConnection(): disconnect form LDAP server
LDAPConnection::syncUsers(): read completed, updating user database

now is server terminated


When delete all LDAP users and groups, the sync is ending successfully, but after some time have the same behaviour. Have tried change to the different LDAP search bases and maybe, there are problems with one specific OU with 211 objects. Can you give me a some advice how to activate the right debug?

Thank you. Martin

Only confirmation. The upgrade was successfull now.
Thank you. Martin

Perfect. Thank You very much.

Martin

There is not a link_styling_script field (currently running 4.5.6 version(restored from backup)

There is result of query as .csv attachment
SELECT id,filter FROM network_maps WHERE filter <> '';

.. have backups, have restored the database. Look's nobody else is observing the same issue. Try activate MariaDB logging if you are ending on updating network maps

.. "Prepare UPDATE network_maps SET link_styling_script=?,filter=? WHERE id=?"

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

Yes, it works now.

Thank you very much.

Martin

Hello Filipp,
I forgot to mention, it is MS windows server based installation. For testing have installed a new NetXMS server with sqlite DB and with webui. There is nothing configured, empty. Created the new map, then entered in the map .. and the error message arise. Jetty logs are attached.
The same bahaviour have in production installation NetXMS 4.4.4 + MariaDB + webui. When try open the map, error message appear and map is not displayed.


Martin

Hello, have the same question, the same error.

The error ist there in new web gui when display the map. 
Failed to register resource: generated/6b33fe9d.png
Cannot tell since is occuring, but it is there in 4.4.4, 4.4.3 and earlier versions. I tried make clean fresh test server installation and there is the same error.

Martin

Hello,
I am using Object Filter in Netxms L2 topology maps. The Object Filter code is lost after every Netxms service restart. Only the "Filter objects" checkbox remain checked. Have you the same experience? I am observing this behaviour from some 3.x version, maybe 3.1 upwards.

Netxms server 3.5.90 running on W2019 server, MariaDB.

Martin

Hello Viktor, the port names on links are the same, identical.
Need to mention, the discovery radius is the default (3) and the seed nodes have overlapping radius, it mean, the seed nodes are less than 3 hops. When remove the seed nodes and delete the links, the new links are created correctly. So the @JuraSSik is probably directing to right direction ...
Martin

Hello can somebody explain why are multiple links generated on my maps? And how prevent them.
I think it come with some of 3.0 or 3.1 version. The version had new feature "consolidate multiple nodes in one". I am using Cisco 3650 with hsrp/vrrp as core switches (and up to this version had for these switches multiple objects automaticaly generated). The rest are Cisco SMB 300, 350. Maps are created L2 with multiple seeds.

Thank you. Martin

The problematic modules have different timestamp (20.3.2018).

05/14/2018  07:11 PM            29,776 airespace.ndd
05/14/2018  07:11 PM            29,264 at.ndd
03/20/2018  04:49 PM            28,240 avaya-ers.dll
03/20/2018  04:49 PM            26,192 baystack.ndd
03/20/2018  04:49 PM            23,632 cat2900xl.ndd
03/20/2018  04:49 PM            24,144 catalyst.ndd
03/20/2018  04:49 PM            23,120 cisco-esw.ndd
03/20/2018  04:49 PM            23,632 cisco-sb.ndd
03/20/2018  04:49 PM            28,240 cisco.dll
05/14/2018  07:11 PM            24,144 dell-pwc.ndd
05/14/2018  07:11 PM            24,144 dlink.ndd
03/20/2018  04:49 PM            24,144 ers8000.ndd
05/14/2018  07:11 PM            24,144 extreme.ndd
03/20/2018  04:49 PM            24,144 h3c.ndd
03/20/2018  04:49 PM            23,120 hpsw.ndd
05/14/2018  07:11 PM            24,656 ignitenet.ndd
05/14/2018  07:11 PM            30,288 juniper.ndd
05/14/2018  07:11 PM            28,240 mikrotik.ndd
05/14/2018  07:11 PM            23,120 netonix.ndd
03/20/2018  04:49 PM            25,680 netscreen.ndd
03/20/2018  04:49 PM            30,288 ntws.ndd
05/14/2018  07:11 PM            26,192 ping3.ndd
03/20/2018  04:49 PM            24,144 procurve.ndd
05/14/2018  07:11 PM            26,192 qtech-olt.ndd
05/14/2018  07:11 PM            30,288 symbol-ws.ndd
05/14/2018  07:11 PM            28,752 tb.ndd
05/14/2018  07:11 PM            28,752 ubnt.ndd