NetXMS 1.2.15 released

[ArtKZ]

I download latest source package, but also have error when upgrade on Solaris 10 SPARC with PostgreSQL:

bash-3.2# /opt/netxms/bin/nxdbmgr upgrade
NetXMS Database Manager Version 1.2.15 Build 7881

Upgrading database...
Upgrading from version 323 to 324
SQL query failed (42P01 ERROR:  table "tdata_rows_500" does not exist):
DROP TABLE tdata_rows_500
SQL query failed (25P02 ERROR:  current transaction is aborted, commands ignored until end of transaction block):
DELETE FROM metadata WHERE var_name='ValidTDataIndex'
Rolling back last stage due to upgrade errors...
Database upgrade failed

[victor]

Hi!

Seems that table is missing while it should exist. Try to create table with that name (any structure, it will be dropped anyway) and run upgrade again.

Best regards,
Victor

[ArtKZ]

I created all the missing tables and the db upgrate was successful. Thank you, Victor!

[user54119]

Is there somewhere a documentation of the new file management subagent (filemgr.nsm)?
I didn't found anything in the wiki.

[zev]

All new documentation is added there:
https://www.netxms.org/documentation/adminguide/index.html

Information about file management:
https://www.netxms.org/documentation/adminguide/file-management.html
https://www.netxms.org/documentation/adminguide/subagents.html#filemgr-subagent-label

[user54119]

Thank you. I was looking in the wiki.
Is the file management subagent only available on linux agents?

[zev]

Should work on all platforms. Tested also on Windows.

Windows path:
RootFolder = C:\log

[user54119]

I installed the windows agent by the 'nxagent-1.2.15-x64.exe' but there is no File Management Subagent in the subagent selection list of the installer (only ecs.nsm, ping.nsm, logwatch.nsm, portcheck.nsm, winperf.nsm, wmi.nsm, ups.nsm) and there is no 'filemgr.nsm' file in the 'bin'-directory after installation.
In log file I get:

Error loading subagent module "filemgr.nsm": The specified module could not be found.

[lindeamon]

wooooooooohooooooooooo

finally. i will wait for the fix of the missing nsm file and then...
partyyyyyyyyyyyy

[lindeamon]

Hi,

was the problem with the filemgr.nsm fixed ? can i download ?

10x,
Lindeamon

[victor]

Hi,

I forgot to include filemgr.nsm into binary package. I'll repack agent installer soon. For now filemgr.nsm for Windows x64 attached.

Best regards,
Victor
 

---

filemgr.nsm

[victor]

and for Windows x86

---

filemgr.nsm

[andrey--k]

System: Debian 7
DB: Oracle 11.2

Upgrade troubles

Upgrading database...
Upgrading from version 318 to 319
Upgrading from version 319 to 320
Upgrading from version 320 to 321
Upgrading from version 321 to 322
SQL query failed (ORA-01440: column to be modified must be empty to decrease precision or scale):
ALTER TABLE users MODIFY system_access number(20)
Rolling back last stage due to upgrade errors...
Database upgrade failed

After truncate table users
appeared:

$ nxdbmgr upgrade
NetXMS Database Manager Version 1.2.15 Build 7881

Upgrading database...
Upgrading from version 321 to 322
SQL query failed (ORA-01440: column to be modified must be empty to decrease precision or scale):
ALTER TABLE user_groups MODIFY system_access number(20)
Rolling back last stage due to upgrade errors...
Database upgrade failed

upd.
All ok.
I have made backup, truncated data and restored.
nxdbmgr upgrade finished in 40 minutes.

[lindeamon]

hi victor,

how soon will you do it ? i want to download a full working version without extra files.

Best Regards,
Lindeamon

[andrey--k]

Debian 7
Oracle 11

An error apears after upgrade

Target: INSERT INTO dc_tables (node_id,template_id,template_item_id,name,description,flags,source,snmp_port,polling_interval,retention_time,status,system_tag,resource_id,proxy_node,perftab_settings,transformation_script,comments,item_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Alert: ORA-00947: not enough values

[victor]

Yes, it's a bug. Updated version will be available later today.

Best regards,
Victor

[victor]

@lindeamon said in NetXMS 1.2.15 released:

how soon will you do it ? i want to download a full working version without extra files.

I plan to release 1.2.16 with all hotfixes today or tomorrow.

Best regards,
Victor

[lindeamon]

thank you victor.

[flynao]

Hi,

Am I supposed to update all the agents I've running with previous versions (1.2.8 and 1.2.14) in order to upload a file from the netxms server (1.2.15)? and wait until the new realese (inclundin the missing file manager subagent).

I've having a really hard time trying to install remotly software using the package manager on server 1.2.15, could it be a new bug?. NPI file are ok and sometime the server could achieve the task but mostly it fails.

Thanks,

[victor]

Hi!

@flynao said in NetXMS 1.2.15 released:

Am I supposed to update all the agents I've running with previous versions (1.2.8 and 1.2.14) in order to upload a file from the netxms server (1.2.15)? and wait until the new realese (inclundin the missing file manager subagent).

Remote upgrade and file upload are supported by older agents also. For fully functional file manager you need agent 1.2.15 or higher and filemgr subagent (which will be included in 1.2.16).

@flynao said in NetXMS 1.2.15 released:

I've having a really hard time trying to install remotly software using the package manager on server 1.2.15, could it be a new bug?. NPI file are ok and sometime the server could achieve the task but mostly it fails.

Can you please provide more details? What errors you got, on what platforms, etc.

Best regards,
Victor