NetXMS Forum

Spheron

Sorry, i missed that: https://docs.netxms.org/admin/7.0/installation/upgrading/

Ignore my last message, please...

Spheron

Hi Alex,

another question: NetXMS V7 is not shown for update/upgrade on my Debian 13 servers. As APT source i use:

deb http://packages.netxms.org/debian trixie main

Is this the wrong source?

Greetings
Marco

Spheron

Hi Victor,

is see that V7.0 (and V6.2.6) are withdrawn from Homepage, so i think we should not install either V6.2.6 or V7.0.. (i downloaded both, but not install them...)?

Greetings
Marco

Spheron

Hi Alex,

thanks for the infos. The checked EXE is unfortunately not a service. So i give the WMI thing a try...

Do you patch this in the V6.2.6 ?

Greetings
Marco

PS: As allways: Great Support... Many thanks... ;D

Spheron

Hello @all,

we are running NetXMS at V6.2.5. We notice since the last versions, that process.count returns 0 even the checked EXE is running.

Have anyone else this behaviour to?

Greetings
Marco

Spheron

Hello NetXMS Team,

the download files for V6.2.1 are missing at your homepage... The download links leads to an 404 error...

Greetings
Marco

Spheron

Hi Alex,

thanks for the hint. I give it a try...

Greetings
Marco

Spheron

Hello Alex,

thanks for the description. I tried that today, but running out of storage...

Is there an function in nxdbmgr or any other tool for deleting all DCI Data in tables, so the tables has less amount of data so i can do the migration?

Greetings
Marco

Spheron

Hello @all,

today i updated our NetXMS server vom Debian 12 to 13. At the first try i upgraded, as part of the Debian Update, the Postgres Cluster from 15 to 17 too. But there are many warnings:

Example:

Fixing hardcoded library paths for stored procedures...
WARNUNG:  Version von Sortierfolge für Datenbank »postgres« stimmt nicht überein
DETAIL:  Die Datenbank wurde mit Sortierfolgenversion 2.36 erzeugt, aber das Betriebssystem hat Version 2.41.
TIP:  Bauen Sie alle Objekte in dieser Datenbank, die die Standardsortierfolge verwenden, neu und führen Sie ALTER DATABASE postgres REFRESH COLLATION VERSION aus, oder bauen Sie PostgreSQL mit der richtigen Bibliotheksversion.
Upgrading database postgres...
WARNUNG:  Version von Sortierfolge für Datenbank »postgres« stimmt nicht überein
DETAIL:  Die Datenbank wurde mit Sortierfolgenversion 2.36 erzeugt, aber das Betriebssystem hat Version 2.41.
TIP:  Bauen Sie alle Objekte in dieser Datenbank, die die Standardsortierfolge verwenden, neu und führen Sie ALTER DATABASE postgres REFRESH COLLATION VERSION aus, oder bauen Sie PostgreSQL mit der richtigen Bibliotheksversion.
Fixing hardcoded library paths for stored procedures...
WARNUNG:  Version von Sortierfolge für Datenbank »netxms« stimmt nicht überein
DETAIL:  Die Datenbank wurde mit Sortierfolgenversion 2.36 erzeugt, aber das Betriebssystem hat Version 2.41.
TIP:  Bauen Sie alle Objekte in dieser Datenbank, die die Standardsortierfolge verwenden, neu und führen Sie ALTER DATABASE netxms REFRESH COLLATION VERSION aus, oder bauen Sie PostgreSQL mit der richtigen Bibliotheksversion.
Upgrading database netxms...
WARNUNG:  Version von Sortierfolge für Datenbank »netxms« stimmt nicht überein
DETAIL:  Die Datenbank wurde mit Sortierfolgenversion 2.36 erzeugt, aber das Betriebssystem hat Version 2.41.
TIP:  Bauen Sie alle Objekte in dieser Datenbank, die die Standardsortierfolge verwenden, neu und führen Sie ALTER DATABASE netxms REFRESH COLLATION VERSION aus, oder bauen Sie PostgreSQL mit der richtigen Bibliotheksversion.

So i decided to rollback the snapshot of the VM and upgrade Debian without the cluster update of Potsgres.

Are there any howto's or links to websites where i can figure out how i make the Postgres Cluster Update from 15 to 17 on the "right" way for NetXMS?

Greetings
Marco

Spheron

Hello @all,

i have following code in a template:

<config>
	<core>
		<ExternalMetric>WindowsADUserGroup.Count(*):powershell -NoProfile -NonInteractive -Command "Write-Host ((Get-ADGroupMember -Identity '$1' -Recursive | Where-Object { $_.objectClass -eq 'user' }).count)"</ExternalMetric>
	</core>
</config>

If i run the code directly on a server, there are no errors..

If i run the script via NetXMS DC, i getting the error that "_.objectClass" is not found...

Where is my fault? I didn't get a solution for that... Many thanks for any help...

Greetings
Marco

Spheron

@victor said in NetXMS 6.04: Perfomance View drawing error:

I just fixed that, we will publish patch release 6.0.5 soon.

Great, thanks Victor... ;D

Spheron

Hi Filipp,

i'm using the V6.0.4 NetXMS Client.

Greetings
Marco

Spheron

Hello @all,

perfomance view (see the attachment, please) seems a little bit buggy if i choose a view >= 2 days. I noticed that since V6.

Anyone else with the issue?

Greetings
Marco

Spheron

Hi Filipp,

it worked!!

Background Update has completed the task ...

:~$ nxdbmgr background-upgrade
NetXMS Database Manager Version 5.2.8 Build 5.2-506-g7d4137c08a

Background upgrade is locked by another process
Are you sure you want to start background upgrade? (Yes/No) yes
Running background upgrade procedure for version 52.24
Background upgrade procedure for version 52.24 completed

...and the update to V6.0.1 worked without any error messages...

Many thanks for the support...

Greetings
Marco

Spheron

Hi Filipp,

nxdbmgr ist not running

:~$ ps fax | grep nx
    507 ?        Ssl    1:02 /usr/bin/nxagentd -S
  42549 pts/0    S+     0:00              \_ grep nx

...but nxdbmgr shows, that Background Update ist locked...

:~$ nxdbmgr background-upgrade
NetXMS Database Manager Version 5.2.8 Build 5.2-506-g7d4137c08a

Background upgrade is locked by another process
Are you sure you want to start background upgrade? (Yes/No)

Should I run "nxdbmgr background-upgrade" anyway?

Greetings
Marco

Spheron

Hi Filipp,

thanks for the fast reply. How can i recognize then background prozess?

ps fax shows me only this in combination with netxms:


    507 ?        Ssl    0:36 /usr/bin/nxagentd -S

    986 ?        Ssl    4:16 /usr/bin/netxmsd -S

603 ?        Ss     0:00 /usr/lib/postgresql/15/bin/postgres -D /var/lib/postgresql/15/main -c config_file=/etc/postgresql/15/main/postgresql.conf
    659 ?        Ss     0:06  \_ postgres: 15/main: checkpointer
    660 ?        Ss     0:00  \_ postgres: 15/main: background writer
    667 ?        Ss     0:01  \_ postgres: 15/main: walwriter
    668 ?        Ss     0:00  \_ postgres: 15/main: autovacuum launcher
    669 ?        Ss     0:00  \_ postgres: 15/main: logical replication launcher
    990 ?        Ss     0:20  \_ postgres: 15/main: netxms netxms 127.0.0.1(46052) idle
    991 ?        Ss     0:20  \_ postgres: 15/main: netxms netxms 127.0.0.1(46062) idle
    992 ?        Ss     0:19  \_ postgres: 15/main: netxms netxms 127.0.0.1(46064) idle
    993 ?        Ss     0:19  \_ postgres: 15/main: netxms netxms 127.0.0.1(46066) idle
    994 ?        Ss     0:17  \_ postgres: 15/main: netxms netxms 127.0.0.1(46078) idle in transaction
  12165 ?        Ss     0:16  \_ postgres: 15/main: netxms netxms 127.0.0.1(33932) idle

Other question: Can i run "nxdbmgr background-upgrade" while running the NetXMS server or must i stop the server?

Greetings
Marco

Spheron

Hello @all,

want to update NetXMS from V5.2.8 to V6.0.1. After the Update NetXMS cannot upgrade DB:

Upgrading database...
Upgrading from version 52.24 to 53.0
Upgrading from version 53.0 to 53.1
Upgrading from version 53.1 to 53.2
Upgrading from version 53.2 to 53.3
Upgrading from version 53.3 to 53.4
Upgrading from version 53.4 to 53.5
Upgrading from version 53.5 to 53.6
Upgrading from version 53.6 to 53.7
Upgrading from version 53.7 to 53.8
Upgrading from version 53.8 to 53.9
Upgrading from version 53.9 to 53.10
Upgrading from version 53.10 to 53.11
Upgrading from version 53.11 to 60.0
Upgrading from version 60.0 to 60.1
Upgrading from version 60.1 to 60.2
Upgrading from version 60.2 to 60.3
Upgrading from version 60.3 to 60.4
Upgrading from version 60.4 to 60.5
Upgrading from version 60.5 to 60.6
Upgrading from version 60.6 to 60.7
Upgrading from version 60.7 to 60.8
Pending online upgrades must be completed before this step
Rolling back last stage due to upgrade errors...
Database upgrade failed

Background upgrades pending. Please run mnxdbmgr background-upgrade when possible.

So i rolled back the server to the latest snapshot...

After that i tried to upgrade the db with the following commands. Everytime i startet the upgrade, the "nxdbmgr background-upgrade" says the background update is locked by another process...

Also i don't understand, that "nxdbmgr check" says, its the latest db version, but if i run the "nxdbmgr background-upgrade" it want to upgrade the db version 52.24...

Please help, i'm a little bit lost... What have i to do to fix the db problem...

Many thanks
Marco

-------------------------------------

:~$ nxdbmgr check
NetXMS Database Manager Version 5.2.8 Build 5.2-506-g7d4137c08a

Checking database (excluding collected data):
* Zone object properties                                               [PASSED]
* Node object properties                                               [PASSED]
* Node to subnet bindings                                              [PASSED]
* Interface object properties                                          [PASSED]
* Interface bindings                                                   [PASSED]
* Network service object properties                                    [PASSED]
* Network service bindings                                             [PASSED]
* Cluster object properties                                            [PASSED]
* Cluster member nodes                                                 [PASSED]
* Access point object properties                                       [PASSED]
* Template mapping                                                     [PASSED]
* Business services                                                    [PASSED]
* Business service prototypes                                          [PASSED]
* Object properties                                                    [PASSED]
* Container membership                                                 [PASSED]
* Event processing policy                                              [PASSED]
* Network map links                                                    [PASSED]
* Data tables                                                          [PASSED]
* Orphaned data tables                                                 [PASSED]
* DCI configuration                                                    [PASSED]
* Raw DCI values table                                                 [PASSED]
* DCI thresholds                                                       [PASSED]
* Table DCI thresholds                                                 [PASSED]
* Business service checks - service bindings                           [PASSED]
* Business service tickets - service bindings                          [PASSED]
* Business service tickets - check bindings                            [PASSED]
* Business service tickets - hierarchy                                 [PASSED]
* Business service checks - state                                      [PASSED]
* Business service downtime                                            [PASSED]
* Assets                                                               [PASSED]
* Asset to node links                                                  [PASSED]
* Node to asset links                                                  [PASSED]
Database doesn't contain any errors
Database check completed

WARNING: Background upgrades pending. Please run nxdbmgr background-upgrade when possible.

-------------------------------------

:~$ sudo nxdbmgr background-upgrade
NetXMS Database Manager Version 5.2.8 Build 5.2-506-g7d4137c08a

Background upgrade is locked by another process
Are you sure you want to start background upgrade? (Yes/No)

-------------------------------------

:~$ nxdbmgr upgrade
NetXMS Database Manager Version 5.2.8 Build 5.2-506-g7d4137c08a

Upgrading database...
Core database schema is up to date
Database upgrade succeeded

WARNING: Background upgrades pending. Please run nxdbmgr background-upgrade when possible.

-------------------------------------

:~$ nxdbmgr background-upgrade
NetXMS Database Manager Version 5.2.8 Build 5.2-506-g7d4137c08a

Background upgrade is locked by another process
Are you sure you want to start background upgrade? (Yes/No) yes
Running background upgrade procedure for version 52.24

-------------------------------------

Spheron

Hello @all,

is it possible to log the user sessions (User, Client name, Client Adress, ...) to the NetXMS event log?

Greetings
Marco

Spheron

Hi Filipp,

@filipp-sudanov said in NetXMS 5.2 patch release 5:

Could be that during the execution of the first script it deleted all the duplicates.

I think, the duplicates was created while the update of NetXMS to V5.2.5. But, in cause of my revert to a VM snapshot with NetXMS V5.2.4, there are no duplicates in tables. I run the scripts above against the V5.2.4 Version of the tables (after i restored the snapshot of the VM)...

Greetings
Marco

Spheron

Hi Alex,

thanks for the new script... Started it an the result is:

psql:showduplicate1.sql:39: HINWEIS: Total duplicate rows found: 0

So, at earlier post you said i had duplicates, but the script says there are none... Whats the truth?

Greetings
Marco

NetXMS Forum

Spheron

Posts