NetXMS Support Forum

Hi all!

NetXMS version 1.2.13 is out. Changes since previous release:

- Improved layer 2 topology discovery performance
- Special handling of incorrect LLDP data provided by some D-Link switches
- Optimizations in NXCP processing
- Added driver for Cisco Small Business switches
- Improved file retrieve from agent
- Windows agent: added service list and service table (System.Services)
- Fixed bug with SQL initialization script generation on HP-UX
- Fixed Oracle DB initialization error
- New macro %K (alarm key) in event actions
- Management console:
   - Implemented alarm sounds
   - Fixed "broken pipe" errors
   - Macros with alarm data in object tools
   - Added option "Manage image library" in user access rights property page
   - Fixed image upload in web console
- Added support for sticky acknowledge in nxalarm tool
- Fixed bug causing excessive memory usage by AIX agent
- Fixed bug with interface status detection if agent runs in Solaris zone
- Fixed agent crash if HTTPS service status requested
- Android Console:
   - Fix bug missing hide notification alarm in status bar
   - Implemented "Font size in graph/dashboard sessions" (Feature #240)
- Fixed issues: #109, #240, #425, #428, #438, #462, #466, #471, #493, #507, #508, #527

Best regards,
Victor

Hi,

I juist tested the new release.... 

NetXms server don't want to start. When I check the database all looks OK.
But when I start netxms with: sudo netxmsd -e -D9

We stops with the error

[21-Mar-2014 10:50:37.506] [DEBUG] Finished status poll for node xx.xx.xx.xx (ID: 1193)
[21-Mar-2014 10:50:37.506] [DEBUG] Starting status poll for node LSNA001 (ID: 1195)
[21-Mar-2014 10:50:37.506] [DEBUG] ConfigReadStr: (cached) name=CapabilityExpirationTime value="604800"
[21-Mar-2014 10:50:37.506] [DEBUG] StatusPoll(LSNA001): check SNMP
[21-Mar-2014 10:50:37.506] [DEBUG] StatusPoll(LSNA001): cannot create SNMP transport
admin@SYS008:/usr/local$

Hi,

Everything works fine on Windows server 2012! Thanks a lot, for efforts!

Nikk

Quote from: d-ray on March 21, 2014, 11:52:19 AM
Hi,

I juist tested the new release.... 

NetXms server don't want to start. When I check the database all looks OK.
But when I start netxms with: sudo netxmsd -e -D9

We stops with the error

[21-Mar-2014 10:50:37.506] [DEBUG] Finished status poll for node xx.xx.xx.xx (ID: 1193)
[21-Mar-2014 10:50:37.506] [DEBUG] Starting status poll for node LSNA001 (ID: 1195)
[21-Mar-2014 10:50:37.506] [DEBUG] ConfigReadStr: (cached) name=CapabilityExpirationTime value="604800"
[21-Mar-2014 10:50:37.506] [DEBUG] StatusPoll(LSNA001): check SNMP
[21-Mar-2014 10:50:37.506] [DEBUG] StatusPoll(LSNA001): cannot create SNMP transport
admin@SYS008:/usr/local$

I removed the node in the nodes tables and also some strange nodes with the same name.
I never seen them in the previous release.

but we are up and running now

Update worked fine on Linux 64bit (compiled from sources). Thanks a lot!

Chart legend bug described here:
https://www.netxms.org/forum/general-support/line-chart-legend-potential-bug/msg12934/#msg12934
still exists.

Regards, Grzegorz.

I upgraded from 1.2.12 to 1.2.13 and now I cannot start the server because the server cannot log into the database.  Here is the output from the server log file (DebugLevel = 9):

[23-Mar-2014 18:58:33.677] Log file opened
[23-Mar-2014 18:58:33.677] [DEBUG] Code page set to ASCII
[23-Mar-2014 18:58:33.678] [INFO ] Platform subagent "/usr/local/lib/netxms/linux.nsm" successfully loaded
[23-Mar-2014 18:58:33.679] [DEBUG] Debug callback set for DB library
[23-Mar-2014 18:58:33.681] [INFO ] Database driver "pgsql.ddr" loaded and initialized successfully
[23-Mar-2014 18:58:33.683] [DEBUG] DBConnect: server=localhost db=netxms_db login=netxms schema=netxms
[23-Mar-2014 18:58:38.697] [DEBUG] DBConnect: server=localhost db=netxms_db login=netxms schema=netxms
[23-Mar-2014 18:58:43.710] [DEBUG] DBConnect: server=localhost db=netxms_db login=netxms schema=netxms
[23-Mar-2014 18:58:48.723] [DEBUG] DBConnect: server=localhost db=netxms_db login=netxms schema=netxms
[23-Mar-2014 18:58:53.736] [DEBUG] DBConnect: server=localhost db=netxms_db login=netxms schema=netxms
[23-Mar-2014 18:58:58.744] [DEBUG] DBConnect: server=localhost db=netxms_db login=netxms schema=netxms
[23-Mar-2014 18:58:58.751] [ERROR] Unable to establish connection with database (fe_sendauth: no password supplied)


The database is PostgreSQL 9.3.4 - it worked fine with NetXMS v1.2.12.  The log file mentions "no password supplied", but this password is *still* in /etc/netxms.conf. Here is that file (without the password). As I said,it worked fine with v1.2.12:

[netxms-debian-vm:/etc jeffreyz]$ cat netxmsd.conf
DebugLevel = 9
DBDriver = pgsql.ddr
DBServer = localhost
DBName = netxms_db
DBLogin = netxms
DBPassword = <removed>
DBSchema = netxms
LogFailedSQLQueries = yes
LogFile = /var/log/netxmsd
LogRotationMode = 1
[netxms-debian-vm:/etc jeffreyz]$

I ran both:

nxdbmgr check
nxdbmgr upgrade


and there were no problems reported.  I can log into the database fine using the PostgreSQL utility psql with the "netxms" login name and the database password from /etc/netxms.conf.

Here are a few more details:

OS:    Debian Linux 7.4

NetXMS installed from sources. Initially installed v1.2.12. I have just now upgraded from 1.2.12 to 1.2.13, also using sources (netxms-1.2.13.tar.gz).  Here is my configure command:


$ sh ./configure --with-server --with-pgsql --with-agent --enable-unicode

Any ideas?

Netxms snapshot (2014-03-21)
Debian 7
Oracle 11g
Сделал переинициализацию БД. Выскакивают следующие ошибки:

[24-Mar-2014 04:22:09.876] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 74, maximum: 63)
[24-Mar-2014 04:22:09.876] [DEBUG] EVENT 52 (ID:40123 F:0x0001 S:4 TAG:"") FROM i0mon2.bank.gov.ua: Database query failed (Query: INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); Error: ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 74, maximum: 63))
[24-Mar-2014 04:22:09.879] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 87, maximum: 63)
[24-Mar-2014 04:22:09.879] [DEBUG] EVENT 52 (ID:40124 F:0x0001 S:4 TAG:"") FROM i0mon2.bank.gov.ua: Database query failed (Query: INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); Error: ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 87, maximum: 63))
[24-Mar-2014 04:22:09.881] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 74, maximum: 63)
[24-Mar-2014 04:22:09.881] [DEBUG] EVENT 52 (ID:40125 F:0x0001 S:4 TAG:"") FROM i0mon2.bank.gov.ua: Database query failed (Query: INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); Error: ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 74, maximum: 63))
[24-Mar-2014 04:22:09.883] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 74, maximum: 63)
[24-Mar-2014 04:22:09.883] [DEBUG] EVENT 52 (ID:40126 F:0x0001 S:4 TAG:"") FROM i0mon2.bank.gov.ua: Database query failed (Query: INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); Error: ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 74, maximum: 63))



Hi!

So nxdbmgr can login to database? That's very strange, because both nxdbmgr and netxmsd uses same library and same config. Just in case please show me your pg_hba.conf.

Best regards,
Victor

Quote from: andrey--k on March 24, 2014, 09:55:46 AM
Netxms snapshot (2014-03-21)
Debian 7
Oracle 11g
Сделал переинициализацию БД. Выскакивают следующие ошибки:

Code Select Expand


[24-Mar-2014 04:22:09.876] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 74, maximum: 63)
[24-Mar-2014 04:22:09.876] [DEBUG] EVENT 52 (ID:40123 F:0x0001 S:4 TAG:"") FROM i0mon2.bank.gov.ua: Database query failed (Query: INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); Error: ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 74, maximum: 63))
[24-Mar-2014 04:22:09.879] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 87, maximum: 63)
[24-Mar-2014 04:22:09.879] [DEBUG] EVENT 52 (ID:40124 F:0x0001 S:4 TAG:"") FROM i0mon2.bank.gov.ua: Database query failed (Query: INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); Error: ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 87, maximum: 63))
[24-Mar-2014 04:22:09.881] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 74, maximum: 63)
[24-Mar-2014 04:22:09.881] [DEBUG] EVENT 52 (ID:40125 F:0x0001 S:4 TAG:"") FROM i0mon2.bank.gov.ua: Database query failed (Query: INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); Error: ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 74, maximum: 63))
[24-Mar-2014 04:22:09.883] [ERROR] SQL query failed (Query = "INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 74, maximum: 63)
[24-Mar-2014 04:22:09.883] [DEBUG] EVENT 52 (ID:40126 F:0x0001 S:4 TAG:"") FROM i0mon2.bank.gov.ua: Database query failed (Query: INSERT INTO object_properties (name,status,is_deleted,inherit_access_rights,last_modified,status_calc_alg,status_prop_alg,status_fixed_val,status_shift,status_translation,status_single_threshold,status_thresholds,comments,is_system,location_type,latitude,longitude,location_accuracy,location_timestamp,guid,image,submap_id,object_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?); Error: ORA-12899: value too large for column "NETXMS"."OBJECT_PROPERTIES"."NAME" (actual: 74, maximum: 63))



Some objects have too long names. Max acceptable name is 63 characters. I suspect this could be due to encoding of Russian characters. I will check this. As a workaround, you can expand column name in table object_properties to varchar(127).

Best regards,
Victor

Поменял на varchar2(127)
Сделал запрос в бд:

select name, LENGTH(name) from OBJECT_PROPERTIES
order by LENGTH(name) DESC

HP ETHERNET MULTI-ENVIRONMENT,ROM L.20.07,JETDIRECT,JD84,EEPROM 63
HP ETHERNET MULTI-ENVIRONMENT,ROM L.20.07,JETDIRECT,JD84,EEPROM 63
Broadcom NetLink (TM) Gigabit Ethernet - Kaspersky Anti-Virus N 63
Intel(R) PRO/100 VE Network Connection - Минипорт планировщика 63
Realtek PCIe GBE Family Controller - Минипорт планировщика паке 63
Atheros AR8151 PCI-E Gigabit Ethernet Controller - Минипорт пла 63
Atheros AR8151 PCI-E Gigabit Ethernet Controller - Минипорт пла 63
Atheros AR8151 PCI-E Gigabit Ethernet Controller - Минипорт пла 63


В коде, длина случайно не обрезается?

Ну да, обрезается. Я просто думал что реальная длинна меньше, просто из-за того, что Oracle может определять длинну поля в байтах а не символах (это определяет NLS_LENGTH_SEMANTICS) реально поле создалось меньшей длинны. Я могу увеличить размер имени обьекта, но это уже будет только в следующем релизе.

Quote from: Victor Kirhenshtein on March 24, 2014, 10:50:48 AM
Ну да, обрезается. Я просто думал что реальная длинна меньше, просто из-за того, что Oracle может определять длинну поля в байтах а не символах (это определяет NLS_LENGTH_SEMANTICS) реально поле создалось меньшей длинны. Я могу увеличить размер имени обьекта, но это уже будет только в следующем релизе.

Я собираю netxms, на этом сервере, из snapshot.
Пожалуйста, когда исправите, сообщите, для того что бы можно было протестировать.

Quote from: Victor Kirhenshtein on March 24, 2014, 09:56:48 AM
Hi!

So nxdbmgr can login to database? That's very strange, because both nxdbmgr and netxmsd uses same library and same config. Just in case please show me your pg_hba.conf.

Yes, nxdbmgr can log in fine.  Here is some output I copied from a shell that also shows

• pg_hba.conf
• logging in to the database using psql (I specified the password from /etc/netxmsd.conf).

All commands are executed from the NetXMS server machine, of course:


root@netxms-debian-vm:~# nxdbmgr check
NetXMS Database Manager Version 1.2.13 Build 7864

Checking database (excluding collected data):
* Checking zone objects...                                            [PASSED]
* Checking node objects...                                            [PASSED]
* Checking interface objects...                                       [PASSED]
* Checking network service objects...                                 [PASSED]
* Checking cluster objects...                                         [PASSED]
* Checking template to node mapping...                                [PASSED]
* Checking object properties...                                       [PASSED]
* Checking event processing policy...                                 [PASSED]
* Checking network map links...                                       [PASSED]
Database doesn't contain any errors
Database check completed

root@netxms-debian-vm:~# nxdbmgr upgrade
NetXMS Database Manager Version 1.2.13 Build 7864

Upgrading database...
Your database format is up to date

root@netxms-debian-vm:~# tail -23 /etc/postgresql/9.3/main/pg_hba.conf
# Database administrative login by Unix domain socket
local   all             postgres                                peer

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
#local   all             all                                     peer
local   all             all                                     md5

# IPv4 local connections:
host    all             all             127.0.0.1/32            md5

# IPv4 connections from my local subnet
# (so psql or pgAdmin can be used remotely, for example):
host    all             all             10.0.0.0/16             md5

# IPv6 local connections:
host    all             all             ::1/128                 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local   replication     postgres                                peer
#host    replication     postgres        127.0.0.1/32            md5
#host    replication     postgres        ::1/128                 md5

root@netxms-debian-vm:~# psql netxms_db netxms
Password for user netxms:
psql (9.3.4)
Type "help" for help.

netxms_db=> \q
root@netxms-debian-vm:~#


I am at a loss for how to debug this. Are there any other tests that you can suggest?

Quote from: andrey--k on March 24, 2014, 09:55:46 AM
Netxms snapshot (2014-03-21)
Debian 7
Oracle 11g

Еще одна ошибочка в sql:
[25-Mar-2014 10:09:26.716] [ERROR] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): ORA-12899: value too large for column "NETXMS"."EVENT_LOG"."USER_TAG" (actual: 70, maximum: 63)
[25-Mar-2014 10:09:26.716] [DEBUG] EVENT 52 (ID:72059 F:0x0001 S:4 TAG:"") FROM localhost: Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?); Error: ORA-12899: value too large for column "NETXMS"."EVENT_LOG"."USER_TAG" (actual: 70, maximum: 63))

Я так понимаю - тут тоже надо увеличить длину поля?