NetXMS 2.1-RC1 released

[victor]

Hi all!

NetXMS version 2.1-RC1 is released. It is release candidate, and if there will be no big issues, next release will be officially declared stable.

Changes since previous release:

• External tables in agent
• Script source for table DCIs
• Driver for IgniteNet devices
• Network device database (allows some device specific information to be provided without drivers)
• Server certificate's key can be stored in separate file
• Multiple CA certificates can be specified in server configuration file
• Number of samples can be configured for table thresholds
• Null value can be used as "no change" option in auto bind scripts
• Grafana integration
• Management console:
          - Node's zone name shown in alarm browser and object overview when zoning is enabled
          - Sorting option in table based charts on dashboards (to implement "Top N" style charts)
          - Full text object search
          - Agent tunnel manager view
• Fixed issues: NX-386, NX-1127, NX-1128, NX-1210, NX-1211, NX-1222, NX-1231, NX-1239, NX-1240, NX-1242

Best regards,
Victor

[flytech-ben]

Hi Victor,

thanks for the new release!

I'm currently on 2.0.8 and using MSSQL 2016 (database is in 2008-compatibility mode) and upgrading the database schema fails:

C:\NetXMS\bin>nxdbmgr.exe upgrade -t
NetXMS Database Manager Version 2.1-RC1 Build 9010 (2.1-RC1) (UNICODE)

Upgrading database...
Upgrading from version 410 to 411
>>> SELECT var_value FROM metadata WHERE var_name='TdataTableUpdated'
>>> SELECT var_name,var_value FROM metadata WHERE var_name LIKE 'TDataTableCreationCommand_%' OR var_name LIKE 'TDataIndexCreationCommand_%'
>>> DELETE FROM metadata WHERE var_name LIKE 'TDataTableCreationCommand_%' OR var_name LIKE 'TDataIndexCreationCommand_%'
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand_0','CREATE TABLE tdata_%d (item_id integer not null,tdata_timestamp integer not null,tdata_value text null)')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand_0','CREATE CLUSTERED INDEX idx_tdata_%d ON tdata_%d(item_id,tdata_timestamp)')
>>> SELECT id FROM nodes
Converting table tdata_111:   0%>>> EXEC sp_rename 'tdata_111','tdata_temp_111'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_0'
>>> CREATE TABLE tdata_111 (item_id integer not null,tdata_timestamp integer not null,tdata_value text null)
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_1'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_2'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_3'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_4'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_5'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_6'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_7'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_8'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_9'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_0'
>>> CREATE CLUSTERED INDEX idx_tdata_111 ON tdata_111(item_id,tdata_timestamp)
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_1'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_2'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_3'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_4'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_5'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_6'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_7'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_8'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_9'
>>> DROP TABLE tdata_111
>>> EXEC sp_rename 'tdata_temp_111','tdata_111'
failed
>>> DELETE FROM metadata WHERE var_name LIKE 'TDataTableCreationCommand_%' OR var_name LIKE 'TDataIndexCreationCommand_%'
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand_0','CREATE CLUSTERED INDEX idx_tdata_%d_id_timestamp ON tdata_%d(item_id,tdata_timestamp)')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand_1','CREATE INDEX idx_tdata_rec_%d_instance ON tdata_records_%d(instance)')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand_2','CREATE INDEX idx_tdata_rec_%d_id ON tdata_records_%d(record_id)')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand_0','CREATE TABLE tdata_%d (item_id integer not null,tdata_timestamp integer not null,record_id bigint not null,UNIQUE(record_id))')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand_1','CREATE TABLE tdata_records_%d (record_id bigint not null,row_id bigint not null,instance varchar(255) null,PRIMARY KEY(row_id),FOREIGN KEY (record_id) REFERENCES tdata_%d(record_id) ON DELETE CASCADE)')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand_2','CREATE TABLE tdata_rows_%d (row_id bigint not null,column_id integer not null,value varchar(255) null,PRIMARY KEY(row_id,column_id),FOREIGN KEY (row_id) REFERENCES tdata_records_%d(row_id) ON DELETE CASCADE)')
Rolling back last stage due to upgrade errors...
Database upgrade failed

[Hanfelt]

• Grafana integration?

Do we still need to checkout source from git and compile webapi?
https://wiki.netxms.org/wiki/NetXMS_WebAPI

[Sviests]

Currently yes.

Regards,
Eriks

[lweidig]

Any ETA on 2.1RC2?  I have at least three major issues posted to the forums that have no response / resolution.

[victor]

Hi,

we expect to made stable release 2.1 within next two weeks.

Best regards,
Victor

[lweidig]

Thanks for the update, hope the issues get resolved in the released version as they are pretty critical to our being able to use it.

[Tursiops]

Hi,

Just wanted to check in to see if there is a new ETA for the next release? Maybe a 2.1-RC2 as an in between step?
I'm mostly asking as our server is crashing pretty much every hour by now and the fix (agent tunnel related) is in the next version.

Cheers