NetXMS Support Forum

MySQL8 now use "row_number" as a keyword.
We'll look into it.
Thank you for report.

Quote from: Spheron on August 28, 2018, 10:30:01 AM

Hello @all,

i would like to update from 2.2.7 to 2.2.8. The database upgrade doesn't work. It throws the following error:

Code Select Expand


Upgrading database...
Upgrading from version 22.35 to 22.36
SQL query failed (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'row_number=0 WHERE row_number IS NULL' at line 1):
UPDATE dct_threshold_instances SET row_number=0 WHERE row_number IS NULL
Rolling back last stage due to upgrade errors...
Database upgrade failed



NetXMS is running on Windows 7 (64bit) and MySQL 8.0.12 (64-bit).

Any help will be welcome... Thanx.

Greetings
Marco

There is a known issue with upgrading utf8/16 database on older mysql (pre-5.7):

Upgrading from version 22.32 to 22.33
SQL query failed (Specified key was too long; max key length is 767 bytes):
CREATE TABLE policy_timer_cancellation_list (   rule_id integer not null,   timer_key varchar(255) not null,   PRIMARY KEY(rule_id,timer_key))
Rolling back last stage due to upgrade errors...
Database upgrade failed

We are working on that, but in a meantime you can perform this upgrade step manually:

CREATE TABLE policy_timer_cancellation_list(rule_id integer not null, timer_key varchar(191) not null, PRIMARY KEY(rule_id,timer_key));

UPDATE metadata SET var_value='33' WHERE var_name='SchemaVersionMinor';

After these changes, re-run "nxdbmgr upgrade" to finish upgrade.

Hello

NetXMS version 2.2.8 is out. Changes since previous release:

- Delayed actions in event processing policy
- Raw event data stored in event log
- New hook scripts: PostObjectCreate and DiscoveryPoll
- Implemented watchdog functionality for external subagents
- SNMP port and context can be specified in NXSL function CreateSNMPTransport
- Fixed Summary DCI table fail when row limit set
- Fixed menu path creation for Summary DCI Table and folder creation for graph view
- New command line options for Windows agent installer: /FORCECREATECONFIG, /LOGFILE=, /FILESTORE=, /CONFIGINCLUDEDIR=
- Server optimization for high load
- Fixed SQL errors during database import or migration
- New dashboard element "Port view"
- Fixed issues:
   NX-1377 (Can't upgrade sqlite database from version 21.4 to 21.5 with error "Unable to set not null constraint")
   NX-1435 (AgentTunnelListenPort configuration parameter is missing from config table)
   NX-1458 (DB upgrade from 0.454 to 0.455 failing for sqlite)
   NX-1459 (Online upgrade for 22.21 failed on sqlite)
   NX-1471 (Add option to create node in maintenance mode)
   NX-1472 (Physical Hyper-V Hosts are reporting as Node Type "Virtual" in 2.2.7)
   NX-1480 (Varbinds in SNMP Traps restricted to 255 characters)
   NX-1481 (Configuration option to disable topology based event correlation)
   NX-1482 (NetXMS server ignoring Syslog and Traps from devices in a Zone which are sending directly to NetXMS server)
   NX-1484 (Corrupted event messages if MySQL is used as backend database)
   NX-1488 ("Use active thresholds" checkbox gets checked after clicking on OK in map link properties)
   NX-1492 (Changes in object status not reflected on geo map)

Выложил новую сборку на веб

Hello.

Unlock and set password for user "system", then use this user to grant access rights to admin.
Once done, re-lock user "system", as it should not be used in normal day to day operations.

I just pushed correct 2.2.4 libraries to maven central. Try rebuilding tool.

Key in netxms-keyring.gpg is installed using netxms-release package which is available in the repos (and I suggest to upgrade it this way).
You can upgrade it manually:

wget https://packages.netxms.org/netxms-release_1.2_all.deb
dpkg -i netxms-release_1.2_all.deb

Try to unpack archive to separate directory (not on top of the existing version).
You might also need to run "nxmc -clean".

All libraries are in manifest, so you can just run "cd java -jar reporting-server-2.2.2.jar" (working directory should be C:\NetXMS\opt\nxreporting)

Quote from: KarlMCS on January 26, 2018, 06:39:19 PM
Okay, I got it working, but it seems a bit strange.  What I did was I switched to openjdk-8-jre (from jessie-backports) and tomcat8. 

Hello.

Yes, Java8 is a requirement for some time now. We'll mention it on the site.

You have leftover libraries in /usr/local/lib which clash with package libs in /usr/lib/x86_64-linux-gnu/

Cleanup /usr/local/lib and issue should be resolved .

Can you show output of "ldd /usr/bin/nxagend", please?

Looks like your reporting perspective is messed up. Reset it using menu Window -> Reset Perspective

This topic has been moved to General Support.

https://www.netxms.org/forum/index.php?topic=5237.0

В 2.1 старый admin (для которого раньше не проверяли права доступа) переименован в system. Новый admin теперь - обычный юзер.