NetXMS 1.2.13 released
-
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 -
@andrey-k said in NetXMS 1.2.13 released:
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) реально поле создалось меньшей длинны. Я могу увеличить размер имени обьекта, но это уже будет только в следующем релизе.
-
@victor said in NetXMS 1.2.13 released:
Ну да, обрезается. Я просто думал что реальная длинна меньше, просто из-за того, что Oracle может определять длинну поля в байтах а не символах (это определяет NLS_LENGTH_SEMANTICS) реально поле создалось меньшей длинны. Я могу увеличить размер имени обьекта, но это уже будет только в следующем релизе.
Я собираю netxms, на этом сервере, из snapshot.
Пожалуйста, когда исправите, сообщите, для того что бы можно было протестировать. -
@victor said in NetXMS 1.2.13 released:
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?
-
@andrey-k said in NetXMS 1.2.13 released:
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))Я так понимаю - тут тоже надо увеличить длину поля?
-
@jeffreyz said in NetXMS 1.2.13 released:
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):
- Try to change "localhost" to "127.0.0.1"
- Please show your pg_hba.conf
-
-
@alk said in NetXMS 1.2.13 released:
@jeffreyz said in NetXMS 1.2.13 released:
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):
- Try to change "localhost" to "127.0.0.1"
- 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 md5Do 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.
-
-
-
@raypetter said in NetXMS 1.2.13 released:
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)
@jeffreyz said in NetXMS 1.2.13 released:
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) -
@andrey-k said in NetXMS 1.2.13 released:
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 -
-
@jeffreyz said in NetXMS 1.2.13 released:
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,
nxdbmgrandpsqlconnect flawlessly to the PostgreSQL database withauth-method = md5, but in order for NetXMS server to connect, I need to setauth-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.
-
@victor said in NetXMS 1.2.13 released:
@raypetter said in NetXMS 1.2.13 released:
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,
VictorIs 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! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login