NetXMS Support Forum

Please login or register.

Login with username, password and session length
Pages: [1] 2 3 ... 10
 1 
 on: April 24, 2017, 05:06:13 pm 
Started by RobR - Last post by RobR
Upgrading database...
Upgrading from version 410 to 411
Converting table tdata_100:   0%SQL query failed ([Microsoft][SQL Server Native
Client 10.0]COUNT field incorrect or syntax error):
INSERT INTO tdata_100 (item_id,tdata_timestamp,tdata_value) VALUES (?,?,?)
failed
Rolling back last stage due to upgrade errors...
Database upgrade failed

C:\NetXMS\bin>nxdbmgr upgrade -t
NetXMS Database Manager Version 2.1-M3 Build 9008 (2.1-M3) (UNICODE)

Upgrading database...
Upgrading from version 410 to 411
>>> SELECT var_value FROM metadata WHERE var_name='TdataTableUpdated'
>>> SELECT var_name,var_value FROM metadata WHERE var_name LIKE 'TDataTableCreat
ionCommand_%' OR var_name LIKE 'TDataIndexCreationCommand_%'
>>> DELETE FROM metadata WHERE var_name LIKE 'TDataTableCreationCommand_%' OR va
r_name LIKE 'TDataIndexCreationCommand_%'
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand
_0','CREATE TABLE tdata_%d (item_id integer not null,tdata_timestamp integer not
 null,tdata_value text null)')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand
_0','CREATE CLUSTERED INDEX idx_tdata_%d ON tdata_%d(item_id,tdata_timestamp)')
>>> SELECT id FROM nodes
Converting table tdata_100:   0%>>> EXEC sp_rename 'tdata_100','tdata_temp_100'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_0'
>>> CREATE TABLE tdata_100 (item_id integer not null,tdata_timestamp integer not
 null,tdata_value text null)
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_1'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_2'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_3'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_4'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_5'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_6'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_7'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_8'
>>> SELECT var_value FROM metadata WHERE var_name='TDataTableCreationCommand_9'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_0'
>>> CREATE CLUSTERED INDEX idx_tdata_100 ON tdata_100(item_id,tdata_timestamp)
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_1'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_2'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_3'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_4'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_5'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_6'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_7'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_8'
>>> SELECT var_value FROM metadata WHERE var_name='TDataIndexCreationCommand_9'
>>> INSERT INTO tdata_100 (item_id,tdata_timestamp,tdata_value) VALUES (?,?,?)
SQL query failed ([Microsoft][SQL Server Native Client 10.0]COUNT field incorrec
t or syntax error):
INSERT INTO tdata_100 (item_id,tdata_timestamp,tdata_value) VALUES (?,?,?)
>>> DROP TABLE tdata_100
>>> EXEC sp_rename 'tdata_temp_100','tdata_100'
failed
>>> DELETE FROM metadata WHERE var_name LIKE 'TDataTableCreationCommand_%' OR va
r_name LIKE 'TDataIndexCreationCommand_%'
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand
_0','CREATE CLUSTERED INDEX idx_tdata_%d_id_timestamp ON tdata_%d(item_id,tdata_
timestamp)')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand
_1','CREATE INDEX idx_tdata_rec_%d_instance ON tdata_records_%d(instance)')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataIndexCreationCommand
_2','CREATE INDEX idx_tdata_rec_%d_id ON tdata_records_%d(record_id)')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand
_0','CREATE TABLE tdata_%d (item_id integer not null,tdata_timestamp integer not
 null,record_id bigint not null,UNIQUE(record_id))')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand
_1','CREATE TABLE tdata_records_%d (record_id bigint not null,row_id bigint not
null,instance varchar(255) null,PRIMARY KEY(row_id),FOREIGN KEY (record_id) REFE
RENCES tdata_%d(record_id) ON DELETE CASCADE)')
>>> INSERT INTO metadata (var_name,var_value) VALUES ('TDataTableCreationCommand
_2','CREATE TABLE tdata_rows_%d (row_id bigint not null,column_id integer not nu
ll,value varchar(255) null,PRIMARY KEY(row_id,column_id),FOREIGN KEY (row_id) RE
FERENCES tdata_records_%d(row_id) ON DELETE CASCADE)')
Rolling back last stage due to upgrade errors...
Database upgrade failed

 2 
 on: April 24, 2017, 12:42:45 pm 
Started by Hanfelt - Last post by Hanfelt
What are the requirements on the netxms side to get the grafana netxms module to work?
https://github.com/netxms/grafana

I have installed the netxms webui just in case ;)

I dont know what to enter in the API base url section?

 3 
 on: April 24, 2017, 12:35:33 am 
Started by szenrobi - Last post by szenrobi
I found an bug in MIB explorer walk result table right click functions.

There are four different type of copy:  Copy, Name, Type, Value

The copied values are:

.1.3.6.1.2.1.2.2.1.2.10901 [.iso.org.dod.internet.mgmt.mib-2.interfaces.ifTable.ifEntry.ifDescr] = Hex-STRING
.1.3.6.1.2.1.2.2.1.2.10901
.iso.org.dod.internet.mgmt.mib-2.interfaces.ifTable.ifEntry.ifDescr
Hex-STRING

So there is no way to copy the Value
The original table looks like:
OID,"OID as text","Type","Value"
.1.3.6.1.2.1.2.2.1.2.10901,".iso.org.dod.internet.mgmt.mib-2.interfaces.ifTable.ifEntry.ifDescr","Hex-STRING","EFM-NT A: NMS"

Netxms: Version 2.1-M2

Please correct it in the next release.

Roberto

 4 
 on: April 24, 2017, 12:21:15 am 
Started by szenrobi - Last post by szenrobi
Hi

I have a device with SNMP Object ID=.1.3.6.1.4.1.1887.1.2.642.
If I get the .iso.org.dod.internet.mgmt.mib-2.interfaces.ifNumber there is no returning value.
But the device has number of interface in the ifTable section.

I think the netxms try to read the ifNumber value to enumerate the interface for a node.

Is there any way, to read and use all the interface of the device?
Any suggerstion?

Thank.
Robert

 5 
 on: April 23, 2017, 09:45:34 pm 
Started by lindeamon - Last post by lindeamon
hi victor,

didn't had the patience to wait.
i have installed centos 6.9 x64 with enterprisedb's postgresql v9.5.6 and everything works like a charm.
something is not working with centos7 and i would appreciate if you find out what is the problem.

Best Regards,
Lindeamon 

 6 
 on: April 23, 2017, 03:49:23 pm 
Started by lindeamon - Last post by lindeamon
hi victor,

i have removed yum installed postgres and i have reinstalled it from enterprisedb's installer.
running "find" found libpq.
now, if run ./configure --with-pgsql=/opt/PostgreSQL/9.5/ i get passed the libpq-fe.h but i fail in libpq
i have ran find command and found both of the files in the "/opt/PostgreSQL/9.5/include" dir

what is wrong ?
need your help a.s.a.p

Best Regards,
lindeamon

 7 
 on: April 23, 2017, 03:10:19 pm 
Started by lindeamon - Last post by lindeamon
hi victor,

i have set up a VM with the exact installation and everything is the same, can not pass the libpq.
i have removed postgres v9.5.6 from enterprisedb's installation and installed postgres from yum and i get passed the ./configure step.
does this has something to do with netxms ?
should i contact enterprisedb ?

i need an answer quick.

Best Regards,
Lindeamon

 8 
 on: April 23, 2017, 12:34:48 pm 
Started by lindeamon - Last post by lindeamon
hi victor,

i have installed the postgres-devel package bundled with the centos7 install media and nothing worked, still missing libpq.
i have removed postgres9.5 and installed v9.1 and still the same error.

can you help ?
i do not want to reinstall the server with windows...

 9 
 on: April 23, 2017, 11:56:56 am 
Started by lindeamon - Last post by lindeamon
hi victor,

used --with-pgsql=/opt/PostgreSQL/9.5/ and didn't get the libpq-fe.h error.
now iam geting:
for PQconnectdb in -lpq... no
configure: error: libpq is require for PostgreSQL support.

can you tell me what is happening ?
never had those kind of troubles in the past...
Best Regards,
Lindeamon

 10 
 on: April 21, 2017, 06:20:52 pm 
Started by Tursiops - Last post by mclifford
I am having a similar issue. Anyone else?

Pages: [1] 2 3 ... 10