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 (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
Сделал переинициализацию БД. Выскакивают следующие ошибки:
[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))
Я так понимаю - тут тоже надо увеличить длину поля?
Quote from: jeffreyz on March 23, 2014, 08:15:13 PM
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):
1. Try to change "localhost" to "127.0.0.1"
2. Please show your pg_hba.conf
Win 7 + NetXMS 1.2.13 Management Console
Edit Script window: ctrl+c does not copy selected text.
Quote from: Alex Kirhenshtein on March 25, 2014, 07:59:04 PM
Quote from: jeffreyz on March 23, 2014, 08:15:13 PM
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):
1. Try to change "localhost" to "127.0.0.1"
2. Please show your pg_hba.conf
Unfortunately, changing "localhost" to "127.0.0.1" did not work. Same result. Here is the log file from that attempt:
[28-Mar-2014 16:29:45.942] Log file opened
[28-Mar-2014 16:29:45.942] [DEBUG] Code page set to ASCII
[28-Mar-2014 16:29:45.948] [INFO ] Platform subagent "/usr/local/lib/netxms/linux.nsm" successfully loaded
[28-Mar-2014 16:29:45.948] [DEBUG] Debug callback set for DB library
[28-Mar-2014 16:29:45.952] [INFO ] Database driver "pgsql.ddr" loaded and initialized successfully
[28-Mar-2014 16:29:45.952] [DEBUG] DBConnect: server=127.0.0.1 db=netxms_db login=netxms schema=netxms
[28-Mar-2014 16:29:50.966] [DEBUG] DBConnect: server=127.0.0.1 db=netxms_db login=netxms schema=netxms
[28-Mar-2014 16:29:55.979] [DEBUG] DBConnect: server=127.0.0.1 db=netxms_db login=netxms schema=netxms
[28-Mar-2014 16:30:00.992] [DEBUG] DBConnect: server=127.0.0.1 db=netxms_db login=netxms schema=netxms
[28-Mar-2014 16:30:06.003] [DEBUG] DBConnect: server=127.0.0.1 db=netxms_db login=netxms schema=netxms
[28-Mar-2014 16:30:11.015] [DEBUG] DBConnect: server=127.0.0.1 db=netxms_db login=netxms schema=netxms
[28-Mar-2014 16:30:11.023] [ERROR] Unable to establish connection with database (fe_sendauth: no password supplied)
Here is my 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
host all all 10.0.0.0/16 md5
host all all ::1/128 md5
Do you have any other suggestions? The data is not very important since this is for a server that I am only using for testing. Plus it is on a virtual machine so I am willing to try anything - I can always revert to a snapshot if things go south. But I do need to get it going somehow.
Victor, please update the postgresql package so that it does NOT depend on postgresql 8.4
Most of us are running 9.1 and newer. For every update I need to extract the package and remove/update the package dependency (DEBIAN/control).
Thanks
Jeff,
I'm also running postgres, although on debian stable 9.1
Only difference from my config versus yours are the following;
netxms.conf
host: 127.0.0.1
driver: libnxddr_pgsql.so
pg_hba
- #local all all peer
+ local all all peer
Quote from: raypetter on March 29, 2014, 11:50:16 PM
Victor, please update the postgresql package so that it does NOT depend on postgresql 8.4
Most of us are running 9.1 and newer. For every update I need to extract the package and remove/update the package dependency (DEBIAN/control).
Thanks
I've changed dependency for Debian 7 package. Next release should be ok.
Best regards,
Victor
No idea, to be honest. I'd try to capture traffic with tcpdump when nxdbmgr connects (successfully) and compare it to traffic when server connects (with error)
Quote from: jeffreyz on March 28, 2014, 05:40:52 PM
Do you have any other suggestions? The data is not very important since this is for a server that I am only using for testing. Plus it is on a virtual machine so I am willing to try anything - I can always revert to a snapshot if things go south. But I do need to get it going somehow.
Debian 7 + Oracle
next error apears:
[31-Mar-2014 12:13:06.971] [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: 73, maximum: 63)
[31-Mar-2014 12:13:31.038] [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: 71, maximum: 63)
Quote from: andrey--k on March 31, 2014, 03:55:32 PM
Debian 7 + Oracle
next error apears:
[31-Mar-2014 12:13:06.971] [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: 73, maximum: 63)
[31-Mar-2014 12:13:31.038] [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: 71, maximum: 63)
Fixed.
Best regards,
Victor
Quote from: Victor Kirhenshtein on March 21, 2014, 12:32:37 AM
- Management console:
- Implemented alarm sounds
How can i setup and use this ?
Quote from: jeffreyz on March 23, 2014, 08:15:13 PM
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.
I found that if I change "md5" to "trust" for 127.0.0.1 in pg_hba.conf, then NetXMS server starts up OK and can connect with the PostgreSQL database, i.e., if I change:
host all all 127.0.0.1/32 md5to
host all all 127.0.0.1/32 trustthen the problem goes away, although so does the security :-)
To sum things up,
nxdbmgr and
psql connect flawlessly to the PostgreSQL database with
auth-method = md5, but in order for NetXMS server to connect, I need to set
auth-method = trust. Strange. It worked fine with v1.2.12. Could it be that something did not get built properly (I installed and upgraded from sources)?
I will try upgrading to v1.2.14 when it appears. Fingers crossed.
Quote from: Victor Kirhenshtein on March 31, 2014, 11:29:29 AM
Quote from: raypetter on March 29, 2014, 11:50:16 PM
Victor, please update the postgresql package so that it does NOT depend on postgresql 8.4
Most of us are running 9.1 and newer. For every update I need to extract the package and remove/update the package dependency (DEBIAN/control).
Thanks
I've changed dependency for Debian 7 package. Next release should be ok.
Best regards,
Victor
Is this change present in the hourly snapshot: http://git.netxms.org/netxms-snapshot-develop.tar.gz ?
I don't see it mentioned in the ChangeLog file.
It should be there.
Best regards,
Victor
Hello, Victor!
I am upgraded to new version 1.2.13. And after that NetXMS became shutdown. I haven't found error for a long time. And now I find only 1 error.
[ERROR] SQL query failed (Query = "INSERT INTO alarm_events (alarm_id,event_id,event_code,event_name,severity,source_object_id,event_timestamp,message) VALUES (?,?,?,?,?,?,?,?)"): 23505 ERROR: duplicate key value violates unique constraint "alarm_events_pkey"
DETAIL: Key (alarm_id, event_id)=(3, 354) already exists.
How can I use stable version without shutdown? Maybe it depends on postrgesql version?
Hi!
You mean it crashed?
Best regards,
Victor
Yeap, crashed
Victor, thanks for fixing the debian package.
Jeff, my guess is that the issue is _not_ netxms related, but in fact postgresql related. I'd downgrade postgresql instead of running bleeding edge. I'm running the latest netxms release on postgresql 9.1 and having no issues.
Quote from: raypetter on April 03, 2014, 12:09:35 AM
Victor, thanks for fixing the debian package.
Jeff, my guess is that the issue is _not_ netxms related, but in fact postgresql related. I'd downgrade postgresql instead of running bleeding edge. I'm running the latest netxms release on postgresql 9.1 and having no issues.
I am coming to the same conclusion, but have not yet tested this hypothesis. But I
am successfully running NetXMS 1.2.13 with PostgreSQL 9.3.4 on another machine (Ubuntu, not Debian), although in that case NetXMS was installed from Debian packages and here I am installing from sources.
Thanks for the input.
Posted this in general, but it might be more suitable in this thread as it did not occur on the previous version of netxms.
I've had netxms die on me two times. Not much in logs except this;
Apr 4 09:52:07 netxms kernel: [6647577.566437] netxmsd[29596]: segfault at 0 ip 00007f2a203a8f96 sp 00007f2a152bc9e0 error 4 in libnetxms.so.1.0.0[7f2a20382000+39000]
Quote from: raypetter on April 04, 2014, 09:13:57 PM
Posted this in general, but it might be more suitable in this thread as it did not occur on the previous version of netxms.
Please use general support instead of announces - it is more suitable for support questions.
Best regards,
Victor
Здраствуйте!
Когда планируется (приблизительно) выход следующей версии?
Пока рассчитываем в конце этой недели, но может немного задержится.