NetXMS Support Forum

Here is content of netxsmd.conf file. Sensitive data were replaced by XXX (all of the characters were ASCII, no special ones)

DBDriver = /opt/netxms/lib/netxms/dbdrv/oracle.ddr
DBServer = XXX:1525/TDWNDB.world
DBLogin = XXX
DBPassword = XXX
#DBEncryptedPassword = XXX
DBSchema= XXX
LogFailedSQLQueries = yes
LogFile = /var/log/netxmsd
DebugLevel=0

Exactly the same configuration file is OK for nxdbmgr version 1.2.13.

Best regards,
Marcin

Hello,

I did an upgrade of NetXMS from version 1.2.13 to 1.2.15 on Solaris 10. As a consequence I have to upgrade Oracle 11.2.0 database format:
[30-Jul-2014 10:33:53.636] [DEBUG] Successful sync query: "SELECT var_value FROM metadata WHERE var_name='SchemaVersion'" [6 ms]
[30-Jul-2014 10:33:53.636] [ERROR] Your database has format version 307, but server is compiled for version 330

Unfortunately nxdbmgr is not working anymore, it's always dumping core files:
root$ /opt/netxms/bin/nxdbmgr check
NetXMS Database Manager Version 1.2.15 Build 7879

Bus Error (core dumped)

I tried also with version 1.2.14 - error is the same.
Now I reverted back to 1.2.13 and there are no problems:
root$ /opt/netxms/bin/nxdbmgr check
NetXMS Database Manager Version 1.2.13 Build 7863

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

Details of core file:
root$ pstack core
core 'core' of 5109:    /opt/netxms/bin/nxdbmgr check
ffffffff7f015808 __1cGConfigNparseTemplate6MpkwpnPNX_CFG_TEMPLATE__b_ (1001c5010, 0, 1001e3bf0, 1001e5db0, ffffffff7f036034, ffffffff7fffb590) + 158
0000000100008e3c main (100000, ffffffff7ffffb08, 100024, 1, 63, 100024000) + a2c
000000010000736c _start (0, 0, 0, 0, 0, 0) + 12c

root$ pmap core
core 'core' of 5109:    /opt/netxms/bin/nxdbmgr check
0000000100000000        448K r-x--  /opt/netxms/bin/nxdbmgr
000000010016E000        328K rwx--  /opt/netxms/bin/nxdbmgr
00000001001C0000        168K rwx--    [ heap ]
FFFFFFFF7C400000        688K r-x--  /lib/sparcv9/libnsl.so.1
FFFFFFFF7C5AC000         64K rwx--  /lib/sparcv9/libnsl.so.1
FFFFFFFF7C5BC000         32K rwx--  /lib/sparcv9/libnsl.so.1
FFFFFFFF7C600000        152K r-x--  /lib/sparcv9/libelf.so.1
FFFFFFFF7C726000         16K rwx--  /lib/sparcv9/libelf.so.1
FFFFFFFF7C800000       1272K r-x--  /lib/sparcv9/libc.so.1
FFFFFFFF7CA3E000         72K rwx--  /lib/sparcv9/libc.so.1
FFFFFFFF7CA50000          8K rwx--  /lib/sparcv9/libc.so.1
FFFFFFFF7CB00000        584K r-x--  /lib/sparcv9/libm.so.2
FFFFFFFF7CC00000         64K rwx--
FFFFFFFF7CC90000         32K rwx--  /lib/sparcv9/libm.so.2
FFFFFFFF7CD00000         64K r-x--  /usr/lib/sparcv9/libCrun.so.1
FFFFFFFF7CE0E000         16K rwx--  /usr/lib/sparcv9/libCrun.so.1
FFFFFFFF7CE12000         16K rwx--  /usr/lib/sparcv9/libCrun.so.1
FFFFFFFF7CF00000       1680K r-x--  /usr/lib/sparcv9/libCstd.so.1
FFFFFFFF7D100000          8K r-x--  /platform/sun4u-opl/lib/sparcv9/libc_psr.so.1
FFFFFFFF7D1A2000         64K rwx--  /usr/lib/sparcv9/libCstd.so.1
FFFFFFFF7D200000       1952K r-x--  /opt/netxms/lib/libcrypto.so.1.0.0
FFFFFFFF7D400000         64K rwx--
FFFFFFFF7D4E6000        144K rwx--  /opt/netxms/lib/libcrypto.so.1.0.0
FFFFFFFF7D50A000         16K rwx--  /opt/netxms/lib/libcrypto.so.1.0.0
FFFFFFFF7D600000         56K r-x--  /lib/sparcv9/libsocket.so.1
FFFFFFFF7D700000         24K rwx--
FFFFFFFF7D70E000         16K rwx--  /lib/sparcv9/libsocket.so.1
FFFFFFFF7D800000          8K r-x--  /lib/sparcv9/libdl.so.1
FFFFFFFF7D902000          8K rwx--  /lib/sparcv9/libdl.so.1
FFFFFFFF7DA00000          8K r-x--  /lib/sparcv9/libkstat.so.1
FFFFFFFF7DB02000          8K rwx--  /lib/sparcv9/libkstat.so.1
FFFFFFFF7DC00000         88K r-x--  /usr/lib/sparcv9/libz.so.1
FFFFFFFF7DD00000          8K rwx--
FFFFFFFF7DD14000          8K rwx--  /usr/lib/sparcv9/libz.so.1
FFFFFFFF7DE00000        288K r-x--  /lib/sparcv9/libresolv.so.2
FFFFFFFF7DF00000          8K rwx--
FFFFFFFF7DF48000         24K rwx--  /lib/sparcv9/libresolv.so.2
FFFFFFFF7DF4E000          8K rwx--  /lib/sparcv9/libresolv.so.2
FFFFFFFF7E000000         16K r-x--  /usr/lib/sparcv9/libkvm.so.1
FFFFFFFF7E100000          8K rwx--
FFFFFFFF7E104000          8K rwx--  /usr/lib/sparcv9/libkvm.so.1
FFFFFFFF7E200000        584K r-x--  /opt/netxms/lib/libnxsqlite.so.1.0.0
FFFFFFFF7E300000          8K rwx--
FFFFFFFF7E390000         24K rwx--  /opt/netxms/lib/libnxsqlite.so.1.0.0
FFFFFFFF7E400000         64K r-x--  /opt/netxms/lib/libnxtre.so.5.0.0
FFFFFFFF7E500000          8K rwx--
FFFFFFFF7E50E000          8K rwx--  /opt/netxms/lib/libnxtre.so.5.0.0
FFFFFFFF7E600000        152K r-x--  /opt/netxms/lib/libnxexpat.so.1.0.0
FFFFFFFF7E700000          8K rwx--  /lib/sparcv9/libxnet.so.1
FFFFFFFF7E724000          8K rwx--  /opt/netxms/lib/libnxexpat.so.1.0.0
FFFFFFFF7E800000         64K r-x--  /opt/netxms/lib/libnxsnmp.so.1.0.0
FFFFFFFF7E900000         16K r-x--  /lib/sparcv9/libpthread.so.1
FFFFFFFF7E90E000         16K rwx--  /opt/netxms/lib/libnxsnmp.so.1.0.0
FFFFFFFF7EA00000        136K r-x--  /opt/netxms/lib/libnxsrv.so.1.0.0
FFFFFFFF7EB00000          8K rwx--
FFFFFFFF7EB20000         16K rwx--  /opt/netxms/lib/libnxsrv.so.1.0.0
FFFFFFFF7EC00000         40K r-x--  /opt/netxms/lib/libnxmap.so.1.0.0
FFFFFFFF7ED00000          8K rwx--
FFFFFFFF7ED08000          8K rwx--  /opt/netxms/lib/libnxmap.so.1.0.0
FFFFFFFF7EE00000         56K r-x--  /opt/netxms/lib/libnxdb.so.1.0.0
FFFFFFFF7EF00000          8K rwx--
FFFFFFFF7EF0C000          8K rwx--  /opt/netxms/lib/libnxdb.so.1.0.0
FFFFFFFF7EF0E000          8K rwx--  /opt/netxms/lib/libnxdb.so.1.0.0
FFFFFFFF7F000000        256K r-x--  /opt/netxms/lib/libnetxms.so.1.0.0
FFFFFFFF7F100000          8K rwx--
FFFFFFFF7F13E000         32K rwx--  /opt/netxms/lib/libnetxms.so.1.0.0
FFFFFFFF7F146000         80K rwx--  /opt/netxms/lib/libnetxms.so.1.0.0
FFFFFFFF7F200000          8K rwx--
FFFFFFFF7F300000          8K rw---
FFFFFFFF7F400000          8K rw---
FFFFFFFF7F500000          8K rwx--
FFFFFFFF7F600000        240K r-x--  /lib/sparcv9/ld.so.1
FFFFFFFF7F700000          8K rwx--
FFFFFFFF7F73C000         24K rwx--  /lib/sparcv9/ld.so.1
FFFFFFFF7F792000          8K rwx--
FFFFFFFF7FFF6000         40K rw---    [ stack ]
         total        10528K

Could you help me with this problem?

Best regards,
Marcin

Hello,

I was using NetXMS server version 1.2.13 installed on Solaris 10 with Oracle as a backend DB. Password for Oracle connection in netxsmsd.conf was encrypted using parameter DBEncryptedPassword. Now after upgrade to 1.2.15 DBEncryptedPassword is not working anymore. I have error:
[ERROR] Unable to establish connection with database (ORA-01005: null password given; logon denied)
When I replace DBEncryptedPassword with DBPassword (unencrypted password) it works.
Seems to be a bug in the new version.

/Marcin