NetXMS Support Forum

Ok, Seems that I found a workaround ...
I just forced the upgrade .. I don't know how can it impact  ..
For now, it's working back .



C:\NetXMS\bin>nxdbmgr upgrade -X
NetXMS Database Manager Version 1.2.6

Upgrading database...
Upgrading from version 265 to 266
SQL query failed ([Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword 'WHERE'.):
CREATE INDEX idx_event_log_root_id ON event_log(root_event_id) WHERE root_event_id > 0
Upgrading from version 266 to 267
Upgrading from version 267 to 268
Upgrading from version 268 to 269
Upgrading from version 269 to 270
Upgrading from version 270 to 271
Database upgrade succeeded

C:\NetXMS\bin>

Hi there,

Yesterday I tried to upgrade to the newest version 1.2.6 from version 1.2.4 ..
Unfortunatelly the upgrade did not suceed and even trying to install 1.2.4 again, I cannot get the database running again.
I followed the instructions from these posts, but no success.

https://www.netxms.org/forum/oe-oo/1-2-4-gt-1-2-5-upgrade-fail/msg9310/#msg9310
https://www.netxms.org/forum/general-support/netxms-upgrade-to-v1-2-5-mssql-database-upgrade-issue/msg9297/#msg9297

I deleted my [event_log] table, re-created it and the error is still the same ..
I really don't have an idea of what's the problem, I don't have much knowledge in SQL ..

C:\NetXMS\bin>nxdbmgr upgrade -t
NetXMS Database Manager Version 1.2.6

Upgrading database...
Upgrading from version 265 to 266
>>> CREATE INDEX idx_event_log_root_id ON event_log(root_event_id) WHERE root_event_id > 0
SQL query failed ([Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword 'WHERE'.):
CREATE INDEX idx_event_log_root_id ON event_log(root_event_id) WHERE root_event_id > 0
Rolling back last stage due to upgrade errors...
Database upgrade failed

C:\NetXMS\bin>

Hi there,

I´m using this WMI Query to monitor if a particular event happened on windows eventviewer.

WMI.Query(root\CIMV2\, Select * from Win32_NTLogEvent Where Logfile = 'Application' and EventType = '1' and EventCode = '9006')

The query works great fine, but in WMI it returns several Rows, and I believe that netxms doesn´t know how to deal with those results. So I tried to "Count", but in WMI Count is a property, and not a function. So I cannot make changes in WMI side.

I´m looking for clarification if this is supported in Netxms, or if can I use a transformation script or something like this to get a number of rows, or a value that Netxms can understand and display.

Ideas are great apreciated.

Thanks in advance

I know that the post is old, But I just want to report what I found in case it helps someone else when searching on this fórum.
Please let me know if is there a better way to do this.

I found that Dell Servers have a particular way to interact with ACPI on this fórum : http://forums13.itrc.hp.com/service/forums/questionanswer.do?admit=109447627+1307729003111+28353475&threadId=940582

So I made the following query using NetXMS agent :

WMI.Query(root\CIMV2\dell, SELECT * FROM CIM_TemperatureSensor where DeviceID=2, CurrentReading)

It works perfectly to me as the DeviceID 2 is the "BMC Ambient Temp Sensor" wich gives me better values (only 2 degrees of difference) like if the room temperature is around 25 Celcius, this sensor gives me the value of 270.

Also for those who want to explore WMI, I recommend 2 tools. One is Windows native called Wbemtest.exe (C:\windows\system32\wbem) and the other you have to download and is called "WMI Administrative Tools" http://www.microsoft.com/downloads/en/details.aspx?familyid=6430f853-1120-48db-8cc5-f2abdc3ed314

Thanks.

Thank you

It´s time for me to start using scripts on Netxms ...

Thanks again.

Hi,

I have some maintenance and backup plans during the night.
Some services become down, and some servers reboots.
So i´m notified about those events by Netxms, and that´s great.

Is there a way to create an exception during that time ?
For example, I make backups of some virtual machines, and they become down during that time. I can´t increase the status pool time to 40min, understand ? only during that time that I know what´s going on.
The same thing happen to some services that I monitor.

Ideas are welcome,

Thanks in advance

Hi,

I couldn´t find anything about Agent Traps, so I have to ask.
Does Windows Agent support sending SNMP Traps ? If yes, how do I use ?

My idea is to receive a trap when something critical happens like a shutdown is initiated on a server.

Thanks in advance.

Hi,

Just to finish this Post, It´s working perfectly.
As Victor Said, the messages that contains a "/" are not sent, but I´m finding ways to workaround this.

Thank you very much for your help.

Hi,

My Huawei E220 is directly conected to the Netxms machine, and I´ve done a Hyper Terminal Test, And I was able to conect to the COM3 and send a SMS message to my cellphone, So I guess it´s all Ok .
Now, I´m configuring the parameters under Netxms Server configurarion like this :

SMSDriver : generic.sms Restart=No
SMSDrvConfig : COM1 Restart=Yes

I´ve by mistake deleted a the row "SMSDriver", and I had to re-create it, and after that, the Restart become =No and I cant change that.
I hope it doesn´t affect my tests.

Well, Thank you very much for your help, and I´ll post my results.

Hi,

I want to configure Netxms to send SMS messages.
I´ve searched a lot, and I found some things here in this forum, but I want to confirm if is there a specific device that Netxms supports, in case I need to buy one.
I found some stuff about use a terminal program, to connect to a COM Modem, and send some AT commands.
I believe that netxms "sms.nsm" uses this kind of commands, only specifying the COM port name. Right ?

have someone configured this already ?

I have here a Huawei E226 3G modem, but so far no progress... I apreciate comments and ideas.

Thanks in advance

You Rock Victor,

Always answering posts quickly ... Thank you very much !!!

Tested, and imported successfully !! under "Mib Browser" now I can see the "Fujitsu" node.
Also thanks about the output command. The netxms.mib was being saved on the nxmibc.exe directory .... now it´s correct.

Luiz Alberto Camilo.
Network Administrator

Hi,

I´m having problems to import a MIB file from a Storage Fujitsu DX80.
I´m using Windows, and running the following Command : c:\NetXMS\bin\nxmibc.exe -d c:\netxms\var\mibs

The mib file is attached.
The error is the following :
FJDARY-E60
FJDARY-E60: WARNING 006: Cannot resolve data type "PhysAddress" for object "fjdaryLanportHwAddress0"
FJDARY-E60: WARNING 006: Cannot resolve data type "PhysAddress" for object "fjdaryLanportHwAddress1"

The export log is attached also.
The FJDARY-E60.MIB was renamed to FJDARY-E60.MIB.txt and placed on the MIBS folder.
I´ve tryed deleting parts of the MIB header´s file, but the error is always on the same line ...
I´m running out of ideas ... does someone have any in mind to share ?

Hi there,

I just want to relate a strange behaviour that have been the same in at least 4 versions releases ..
I have some Graphs that I usually let opened during my working time.
They show-me in a refresh of 30sec the Inbound and outbound of internet traffic, MPLS links, and SMTP queues.
What happens is that after some hours with those graphs opened, the NetXMS Console window just freezes, and mess up with my screen.
As workaround, I just close it, and open again and it works fine for some hours.

I believe that this console window have some cache, that maybe become full.
If I son´t open graphs, and just open for example Object Browser, It works all day long just fine.
Just to document, and help inprove this excelent software.

Thanks
Luiz

Hi Folks,

Netxms is working perfectly for almost a year over here, but sometimes it full my mailbox of alerts of nodes down.
I need to increase the time that it determines if a node is down or not ... like if the last 5 or 10 pool requests are less than 1 .. then the node is down ....
I guess that you will say "that´s easy" but how to do that for all objects without needing to edit one by one ?

I tryed again and used the executable that you provided me, and got an error again ... on another step ...

C:\NetXMS\bin>nxdbmgr upgrade -t
NetXMS Database Manager Version 0.2.23-rc1

Configuration file OK
Upgrading database...
Upgrading from version 80 to 81
>>> SELECT item_id,schedule FROM dci_schedules
>>> DROP TABLE dci_schedules
>>> CREATE TABLE dci_schedules (schedule_id integer not null,item_id integer not
null,schedule varchar(255) not null,PRIMARY KEY(item_id,schedule_id))
>>> ALTER TABLE address_lists ADD PRIMARY KEY (list_type,community_id,addr_type,
addr1,addr2)
SQL query failed (General SQL Server error: Check messages from the SQL Server.)
:
ALTER TABLE address_lists ADD PRIMARY KEY (list_type,community_id,addr_type,addr
1,addr2)
Rolling back last stage due to upgrade errors...
Database upgrade failed

When executing the command from query analyzer, the error is bellow .

Server: Msg 8111, Level 16, State 1, Line 1
Cannot define PRIMARY KEY constraint on nullable column in table 'address_lists'.
Server: Msg 1750, Level 16, State 1, Line 1
Could not create constraint. See previous errors.

Can you give me the full upgrade script that you´re using on this executable ?
I can try to work on it .. , as seems that I´m the only one having problems to upgrade ...