NetXMS 1.2.13 released

[d-ray]

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$

[Nikk]

Hi,

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

Nikk

[d-ray]

@d-ray said in NetXMS 1.2.13 released:

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

[user54119]

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

[ditonet]

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

Regards, Grzegorz.

[jeffreyz]

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?

[andrey--k]

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))

[victor]

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

[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

[andrey--k]

Поменял на 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

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

[victor]

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

[andrey--k]

@victor said in NetXMS 1.2.13 released:

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

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

[jeffreyz]

@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]

@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))

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

[alk]

@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):

1. Try to change "localhost" to "127.0.0.1"
2. Please show your pg_hba.conf

[andrey--k]

Win 7 + NetXMS 1.2.13 Management Console
Edit Script window: ctrl+c does not copy selected text.

[jeffreyz]

@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):

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.

[raypetter]

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

[raypetter]

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

[victor]

@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