NetXMS Forum

testos

Todayyyyy!!! Good news!!!
Thank you very much Victor.

Best regards.

testos

Hi

When have you planed to release 1.2.10 version?
I can not compile 1.2.9 version for Debian 7 X64 box:

make[3]: se ingresa al directorio `/root/netxms-agent/netxms-1.2.9/src/libnetxms'
CXX libnetxms_la-agent.lo
stdin:1: error: character not allowed to start a syntax specifier
make[3]: *** [libnetxms_la-agent.lo] Error 1

Best regards

testos

millerpaint,
I apply this template to nodes that I need to know if my Internet Service Provider meets the Service Level Agreements availability contracted, ie all remote nodes.

Best regads.

testos

Hi.

I add a template for node availability calculation parameters. You can get additional information on this wiki entry:
http://wiki.netxms.org/wiki/MTBF_(Mean_Time_Between_Failures)_and_MTTR_(Mean_Time_To_Repair)_Calculation

Best regards.

Availability.xml

testos

Hi Victor.

Thank you very much for your help.
Based on your proposal, I think that this requirement can be simplified to just two steps:

- Create a template called say "Availability" with the four DCIs shown in the image
  "Availability template DCIs.png". Transformation scripts for each DCI are these
  
  For "Failures" DCI

return GetCustomAttribute($node, "NumFailures");

For "MTBF (hours)" DCI

return GetCustomAttribute($node, "mtbf");

For "MTTR (hours)" DCI

return GetCustomAttribute($node, "mttr");

For "Node availability (percentage)" DCI

// This script calculates MTTR, MTBF and perAvailability parameters and stores them in custom attributes
// Initialize some custom attributes the first time.
// Undefined attributes are created by SetCustomAttribute function automatically
CurrentStatus = GetDCIValue($node, FindDCIByName($node, "Status"));
PreviousState = GetCustomAttribute($node, "PreviousState");
if (PreviousState == null)
{ // In the first time, previous state is null
    SetCustomAttribute($node, "PreviousState", CurrentStatus);
    SetCustomAttribute($node, "TimeStamp", time());
    SetCustomAttribute($node, "NumFailures", 0);
    SetCustomAttribute($node, "TotalUptime", 0);
    SetCustomAttribute($node, "TotalDowntime", 0);
    return 100;
}

// From here the 2nd and subsequent times
NumFailures = GetCustomAttribute($node, "NumFailures");
LastTime = time() - GetCustomAttribute($node, "TimeStamp");

// Status is up
if (CurrentStatus == 0)
{
    if (PreviousState != CurrentStatus)
    { // just changed to up
        // update mttr
        TotalDowntime = GetCustomAttribute($node, "TotalDowntime") + LastTime;
        mttr = TotalDowntime / ((NumFailures == 0) ? 1 : NumFailures) / 3600; // to prevent division by ze
        SetCustomAttribute($node, "TotalDowntime", TotalDowntime);
        SetCustomAttribute($node, "mttr", mttr);
    }
    else
    { // still up
        // update mtbf
        TotalUptime = GetCustomAttribute($node, "TotalUptime") + LastTime;
        mtbf = TotalUptime / ((NumFailures == 0) ? 1 : NumFailures) / 3600; // to prevent division by zero
        SetCustomAttribute($node, "TotalUptime", TotalUptime);
        SetCustomAttribute($node, "mtbf", mtbf);
    }
}

// Status is down
if (CurrentStatus == 4)
{
    if (PreviousState != CurrentStatus)
    { // just changed to down
        // update mtbf
        NumFailures++;
        TotalUptime = GetCustomAttribute($node, "TotalUptime") + LastTime;
        mtbf = TotalUptime / NumFailures / 3600;
        SetCustomAttribute($node, "NumFailures", NumFailures);
        SetCustomAttribute($node, "TotalUptime", TotalUptime);
        SetCustomAttribute($node, "mtbf", mtbf);
    }
    else
    { // still down
        // update mttr
        TotalDowntime = GetCustomAttribute($node, "TotalDowntime") + LastTime;
        mttr = TotalDowntime / NumFailures / 3600;
        SetCustomAttribute($node, "TotalDowntime", TotalDowntime);
        SetCustomAttribute($node, "mttr", mttr);

    }
}

If (CurrentStatus == 0 || CurrentStatus == 4)
{
    // Save previous state and timestamp
    SetCustomAttribute($node, "PreviousState", CurrentStatus);
    SetCustomAttribute($node, "TimeStamp", time());

    // perAvailability section
    TotalUptime = GetCustomAttribute($node, "TotalUptime");
    TotalDowntime = GetCustomAttribute($node, "TotalDowntime");
    perAvailability = TotalUptime / (TotalUptime + TotalDowntime) * 100;
    SetCustomAttribute($node, "perAvailability", perAvailability);

    return perAvailability;
}

- Apply manually previous template to nodes required or apply this template automatically to nodes filtered by custom script (Properties -> Automatic Apply Rules).

In this way, we avoid having to define custom attributes (now created by the fourth transformation script), events, actions, event processing policy rules, etc.
In addition, the four DCIs are updated at each polling interval.
Only supports up (Normal = 0) and down (Critical = 4) node status.

Best regards.

Availability template DCIs.png

testos

Hi Alex.

Thanks for the upgrade to 2.7 version and for the Jython versions clarification. Now I can add current versions of modules I need. It is also possible to list all availables modules (in the previous version modules command gave me an error):

NetXMS 1.2.6 Interactive Shell
>>> import xlrd
>>> help()

Welcome to Python 2.7! This is the online help utility.

If this is your first time using Python, you should definitely check out
the tutorial on the Internet at http://docs.python.org/tutorial/.

Enter the name of any module, keyword, or topic to get help on writing
Python programs and using Python modules. To quit this help utility and
return to the interpreter, just type "quit".

To get a list of available modules, keywords, or topics, type "modules",
"keywords", or "topics". Each module also comes with a one-line summary
of what it does; to list the modules whose summaries contain a given word
such as "spam", type "modules spam".

help> modules

Please wait a moment while I gather a list of all available modules...

BaseHTTPServer codecs jffi sched
CGIHTTPServer codeop json select
ConfigParser collections keyword sets
Cookie colorsys linecache setuptools
DocXMLRPCServer command locale sgmllib
HTMLParser commands logging sha
MimeWriter compileall macpath shelve
Queue compiler macurl2path shlex
SimpleHTTPServer contextlib mailbox shutil
SimpleXMLRPCServer cookielib mailcap signal
SocketServer copy markupbase site
StringIO copy_reg marshal smtpd
UserDict csv math smtplib
UserList ctypes md5 sndhdr
UserString datetime mhlib socket
_LWPCookieJar dbexts mime sre
_MozillaCookieJar decimal mimetools sre_compile
_builtin_ difflib mimetypes sre_constants
_future_ dircache mimify sre_parse
_abcoll dis modjy ssl
_ast distutils multifile stat
_codecs doctest mutex string
_collections dom netrc struct
_csv dumbdbm new subprocess
_fsum dummy_thread nntplib symbol
_functools dummy_threading nt synchronize
_google_ipaddr_r234 easy_install ntpath sys
_hashlib email nturl2path sysconfig
_io encodings numbers tabnanny
_jyio errno opcode tarfile
_marshal etree operator telnetlib
_py_compile exceptions optparse tempfile
_pyio filecmp os test
_random fileinput parsers tests
_rawffi fnmatch pawt textwrap
_sre formatter pdb this
_strptime fpformat pickle thread
_systemrestart fractions pickletools threading
_threading ftplib pipes time
_threading_local functools pkg_resources timeit
_warnings future_builtins pkgutil token
_weakref gc platform tokenize
_weakrefset genericpath plistlib trace
abc getopt popen2 traceback
aifc getpass poplib tty
anydbm gettext posixfile types
argparse glob posixpath ucnhash
array grp pprint unicodedata
ast gzip profile unittest
asynchat hashlib pstats urllib
asyncore heapq pty urllib2
atexit hmac pwd urlparse
base64 htmlentitydefs py_compile user
bdb htmllib pycimport uu
binascii httplib pyclbr uuid
binhex ihooks pydoc warnings
bisect imaplib pyexpat weakref
bz2 imghdr quopri whichdb
cPickle imp random wsgiref
cStringIO importlib re xdrlib
calendar inspect readline xlrd
cgi io repr xml
cgitb isql rfc822 xmllib
chunk itertools rlcompleter xmlrpclib
cmath jarray robotparser zipfile
cmd javapath runpy zipimport
code javashell sax zlib

Enter any module name to get more help. Or, type "modules spam" to search
for modules whose descriptions contain the word "spam".

help>

I will continue testing this good tool...

testos

Hi Alex.

I'm trying NetXMS 1.2.5 Interactive Shell and and I can see it's a nice tool. It is much easier any automatic bulk operation.

NetXMS 1.2.5 Interactive Shell
>>> help()

Welcome to Python 2.5! This is the online help utility.

But Interactive Shell use python 2.5 vesion and the latest current production versions is Python 3.3.0
I'm trying to modify nxshell-1.2.5.jar contents to replace the lib directory from 3.3.0 version, but then I get an error in org.python.core
How can I upgrade python shell to 3.3.0 version?
I need to import some Python modules which only work with 2.7 version and later.

Best regards.

testos

It seems like a hardware failure.
Centos kernel is not supposed to panic under any circumstance.
There's no "normal" circumstances beyond a hardware failure or kernel bug that should cause one.
Try to run memtest86 or memtest86+ and performs a BIOS address test in physical machine.

testos

What version of MySQL are you using?
Check if there is something strange in similar files:
/var/log/messages
/var/log/nxagentd
/var/log/netxmsd.log
/var/log/mysqld.log
etc.

testos

Hi.

Is a good practice to check, repair and backup database every night. In linux you can make a bash script like this:

# Check_db.sh
#
# Check, repair and backup netxms database in remote host
#
### Variables ###
date=`date +%d-%m-%Y`
DateTimeStamp="date +%d/%m/%Y-%H:%M:%S"
# Paths
logfile="/var/log/mysql_backup.log"
tempbackdir="/tmp"
remotebackdir="/datos/backup/mysql_netxms_pro"
sourcedir="/var/lib/mysql"

### Check and repair data base ###
### First stop netxms agent and server, and then repair netxms data base using nxdbmgr
/usr/bin/killall nxagentd >> $logfile
/usr/bin/killall netxmsd >> $logfile
/usr/local/bin/nxdbmgr -f check >> $logfile
sleep 60
### Repair all mysql database (-Avrs parametres can be different depending on mysql version)
echo "#################################################" >> $logfile
echo `$DateTimeStamp` - All processes have been stopped. Analysis and repair MySQL DB started: >> $logfile
/usr/bin/mysqlcheck -Avrs -uroot -pxxxxxxxxx >> $logfile

### Backup databases locally whit compression ###
### Stop mysqld deamon
/sbin/service mysqld stop
sleep 60
### Compress with tar command
echo `$DateTimeStamp` - MySQL databases backup started: >> $logfile
tar -pcjvf $tempbackdir/mysql_backup-$date.tar.bz2 $sourcedir/ ### >> $logfile
tar -tjvf $backdir/mysql_backup-$date.tar.bz2 $sourcedir/ ### >> $logfile
sleep 60
/sbin/service mysqld start >> $logfile
/usr/local/bin/netxmsd -d >> $logfile
/usr/local/bin/nxagentd -d >> $logfile
echo `$DateTimeStamp` - MySQL databases backup completed. All netxms processes have been started >> $logfile

### Move local backup to remote server # # #
### Note that the remote server must contain the server's public key (generated with the
###“ssh-keygen-t rsa” command) from which you send the backup in
###“$HOME/.ssh/authorized_keys” file
scp $tempbackdir/mysql_backup-$date.tar.bz2 [email protected]:$remotebackdir >> $logfile
echo `$DateTimeStamp` - Local backup has been moved to remote server >> $logfile

### Remove daily backups over 32 days old on the remote server ###
ssh [email protected] find $remotebackdir/ -name '*.tar.bz2' -type f -mtime +32 -exec "rm -f {} \;" >> $logfile
echo `$DateTimeStamp` - Remote backups over 32 days old have been removed >> $logfile
echo "###" >> $logfile
echo "###" >> $logfile

exit 0

Finally you must assign the appropriate permissions to the script and then schedule it in crontab:

00 3 * * * /usr/local/scripts/Check_db.sh

Best regards.

testos

Thank you very much for your support, it is just what I needed.
nxshell opens a world of great possibilities for large environments!

Best regards.

testos

I had planned to read nodes from a file and check if exist in certain containers. If they did not exist would be created and then:

Modify some node properties: polling options, comments, custom attributes, calculation status, etc.
Manage network interfaces only having a certain name, others unmanaged.
Create DCI for managed interfaces.
Edit some properties for the previous DCIs (description, transformation, thresholds, etc..)
Create other DCI for node (MTBF & MTTR -https://www.netxms.org/forum/general-support/mtbf-(mean-time-between-failures)-and-mttr-(mean-time-to-repair)/msg8953/#msg8953-, etc.)

All this for about 400 nodes :-[.

Best regards.

testos

Hello Alex.

Thanks for this tool, I'm very interested in trying it.
Is it possible to automate any task we can be done by console?
Is there available other sample scripts in addition to the one in the wiki?

Best regards.

testos

Hi Victor.

Is it for all addresses or only for some?

This happens with every address (IP/MAC) I've tried to find.

What switches you are using in your network?

Cisco Nexus n5000, Cisco Nexus 1010, Cisco Nexus 1000, Cisco Catalyst 4500, Cisco Catalyst s72033, Cisco Catalyst C3750E, Cisco Catalyst C3500XL, Cisco 2801, Cisco Catalyst c6sup2_rp, Cisco Catalyst C2950, Cisco Catalyst C2970, Cisco Catalyst CBS31X0, HP Procurve 2810-24G, HP Procurve 1810G, HP Procurve 2910al-48G, HP Procurve 2650, HP Procurve 2824, etc.

Is it possible to read forwarding database from switches (Tools -> Info -> Switch forwarding database)?

Yes for:

Cisco Catalyst s72033 (only 1 interface to several)
Cisco Catalyst C3750E (only 2 interfaces to several)
Cisco Nexus 1000 (only 1 interface to several)
Cisco Catalyst C2970 (only 1 interface to several)
Cisco Catalyst C3500XL
HP Procurve 2810-24G
HP Procurve 1810G
HP Procurve 2910al-48G
HP Procurve 2650
HP Procurve 2824

Best regards.

testos

Hi.

When I use in NetXMS 1.2.4 either "Find IP Address" or "Find MAC Address" tools, I get the following warning message:

Connection point information cannot be found

Best regards.

testos

Hi.

These are nodes that have only SNMP capabilities. The node failed state is determined by the node Internal State oid.

After that you can do some combination of internal DCIs and custom attributes to do calculations.

Can you expand this?

Best regards.

testos

Hello.

Recently I was told that we need to implement the measures MTBF (Mean Time
Between Failures) and MTTR (Mean Time To Repair) for each node, but I do not know how.

Could you help me if there is any somehow to get this measures? Does anybody have implemented
this in NetXMS?

Best regards.

testos

Hi.

I attach text file with translations.

Best regards.

NetXMS_API.txt

testos

Hi Victor.

When you plan to release version 1.2.4?

Best regards

testos

Hi.

I send you message files translated into Spanish language. Sorry for delay :-[

Best regards.

nxmc-messages.zip

NetXMS Forum

testos

Posts