NetXMS Support Forum

Hi Victor,

Sorry I missed the bit in the post you referred to about situation attributes. Thanks for your help.

Steve...

Hi Victor,

Thanks for the reply.

I still am having problems with my implementation, should I be able to see the attributes in situation manager?, as I can see the instance, but cannot see the attribute.

Many thanks,
Steve..

Hi

I have been trying to trigger a SYS_NODE_DOWN event by checking if another Node is not down. I have implemented as per manual and various other posts, but still cannot get it to work.

I have attempted to do this by creating a situation, as per thread https://www.netxms.org/forum/configuration/node-down-config-question/, however I  want to report only if nodeB is not down (nodeB being the remote router, and NodeA is a device on the remote network).

In a previous thread, Victor stated that you should be able to see situation, instance and attribute from console https://www.netxms.org/forum/configuration/action-to-return-value/, however I can only see the situation and instance, but not the attribute - maybe this is the problem?(see attachment).

My situation created is:
Event: SYS-NODE-DOWN, Situation Name = NodeDown, situation instance = %n, Attribute: status = 1. This will create a NodeDown situation instance for each node with a status = 1 for a sys_node_down
Event: SYS-NODE-UP, Situation Name = NodeUp, situation instance = %n, Attribute: status = 0. This will create a NodeDown situation instance for each node with a status = 0 for a sys_node_up

I have setup an event process policy for a separate host that I want to report on if the router (dev2rtr) is NOT down:
My script in this event processing policy is:

// We only want to send alert if router is not down
sub main()
{
  s = FindSituation("NodeDown", "dev2rtr");
  if (s != NULL)
  {
  if (s->status == 1)
     return 0; // Don't match rule
  }
  return 1; // Match rule
}

I am using version 1.08 on a windows platform.

Appreciate any help with this,
Steve...

Hi Victor,

That worked!!

Your help was greatly appreciated.

Thank you.
Steve...

Hi Jdamien,

Thanks for your reply,

QuoteConfiguring root access to mysql:

Is mysql required for microsoft sql server? I didn't install mysql, as I am using ODBC to connect to database. My configure script contained "--with-odbc", and I installed unix odbc package and not mysql as per installation guide

Kind Regards,
Steve..

Hi All,

I have been trying to install netxms on debian linux connecting to MSSQL 2005. I can init the database, however when I start netxms deamon, I get the following error:
"Your database has format version 0, but server is compiled for version 99"

Quote[15-Mar-2010 15:59:44] Log file opened
[15-Mar-2010 15:59:44] Platform subagent "/usr/local/lib/libnsm_linux.so" successfully loaded
[15-Mar-2010 15:59:44] Database driver "libnxddr_odbc.so" loaded and initialized successfully
[15-Mar-2010 15:59:44] Your database has format version 0, but server is compiled for version 99

These are the things that I tried:

• Create new db and user using server sql server management studio. I Could connect to db using isql odbc in linux, and was able to init db using "nxdbmgr init /usr/local/share/netxms/sql/dbinit_mssql.sql", and can query db OK, but netxmsd does not start.


• Since the above failed, I'd thought I'd install windows version on a windows PC so the windows GUI can install and init the db. When this install finished, I stopped the services on the windows install and connect the linux install to this newly created db, and I get the same error as above.
  

When I run "nxdbmgr check" I get the following error:

Quote"Unable to determine database syntax"

This is my config file.

QuoteConfiguration file for NetXMS server
#
DBDriver = libnxddr_odbc.so
DBServer = netxms
DBLogin = netxms
DBPassword = PaSsWd
LogFile = /var/log/netxmsd
LogFailedSQLQueries = yes

I have been trying for a while now to get this to work, and would appreciate any insights on this.

Regards   

Thanks Victor,

That worked. Your help is much appreciated.

Kind Regards,
Steve...

Hi Victor,

Thank you for your swift response. I am using SQL 2005, and the field "script_code" is data type "text".

The script had 5547 characters, and when saved, it chopped off after 3591 characters.

In your example, you mention the calling script in event processing policy. Can this be another script in library?

Kind Regards,
Steve...

Hi All,

I am trying to display a message in response to a SNMP trap that has 200+ Emums (using a case statement in a script), and there seems to be a limitation to the numbers of lines that a script allows. It allows me to add all the lines in the script editor, but when I save the script, it seems to get cut short.

In an attempt to get around this I thought that I may be able to split it up into 2 separate scripts, and call them from another script. I have done some basic testing, I cannot seem to be able to call a script from another script.

Can someone please advise if it is possible to call a script from another script, and if so, the syntax.

Also is there some way the database can be modified to allow longer scripts?

Many thanks.