NetXMS Support Forum

This is a Ubuntu 16.04 system, fully patched using the packages for installation.  Running the command:
nxdbmgr init /usr/share/netxms/sql/dbinit_mysql.sql

Results in the following:
NetXMS Database Manager Version 2.1-RC1 Build 9010 (2.1-RC1) (UNICODE)

Initializing database...
SQL query failed (Specified key was too long; max key length is 767 bytes):
CREATE TABLE user_profiles (   user_id integer not null,   var_name varchar(255) not null,   var_value longtext not null,   PRIMARY KEY(user_id,var_name) )
Database initialization failed

Suggestions on getting past this point?

Quote from: Victor Kirhenshtein on July 23, 2013, 12:23:04 AM
Yes, libappagent was missing in deb package. I repack packages and upload updated versions.

Best regards,
Victor

Thanks Victor, that cleared it up!

Having problems with the agent deb package:

# dpkg -i netxms-agent_1.2.8_amd64.deb
(Reading database ... 31283 files and directories currently installed.)
Preparing to replace netxms-agent 1.2.5 (using netxms-agent_1.2.8_amd64.deb) ...
Unpacking replacement netxms-agent ...
Setting up netxms-agent (1.2. ...
/usr/bin/nxagentd: error while loading shared libraries: libappagent.so.1: cannot open shared object file: No such file or directory

Rest of the upgrade process appears to have went ok.

We are running a Ubuntu 12.04 server at version 1.2.5.  If you create the MIB file using the command:

nxmibc -d /usr/share/netxms/mibs/ -z

Then when you run the console from a Windows machine (1.2.5 as well) you get the following error:

QuoteCannot load MIB file from server: Bad MIB file data

Omitting the -z option causes the error to go away, but of course increase the size of the file by about tenfold in our case.

Not an AIX user myself, but it simply appears you are missing the needed development tools on your system.  A quick search yields the toolbox for Linux support:

http://www-03.ibm.com/systems/power/software/aix/linux/toolbox/download.html

Hope this helps.

Thanks, appreciate it!

I always hope that when I double click a device in the tree it will open the properties.  Yes, I do know that ALT+Enter will do this, but for some reason I always double click it first.  Thanks!

There does not seem to be a way to clear the proxy node if you copy a DCI from one template to another. We have a group of templates for devices that cannot run the agent that simply use the agent on the server to process them.  When we copy to a template where we would have an agent on the device it would be applied to we cannot seem to clear the value.

I have always wondered why data collection and graphing is not using RRD for its storage and display.  So I decided to make this a feature request to hopefully open some discussion.  While I 100% love NetXMS I do miss the capabilities most of the other NMS software gave through use of RRD (just browsing through http://oss.oetiker.ch/rrdtool/gallery/index.en.html brings tears to my eyes ).  Specifically, looking for things like:

- Easily being able to select date / time ranges and adjust them on the fly.  Opsview, ZenOSS give good examples
- Does not seem to be any facility for getting Min, Max, Average, Total,... and displaying these on the graphs.
- Custom set presets.  As an example for some links we would like to look at "last month" (9/1 - 9/30 for current example)

It is a code base that has existed been enhanced for quite some time and really seems to be the defacto standard.  Curious what everybody thinks.  Thanks as always!

Ok, followup and solution on my own post.  Two changes were necessary:

1.  In the nxagentd.conf needed to add a line:
ExecTimeout = 5000

2. The external parameter line ended up removing the "ShellExec" portion AND had an additional $ added to the echo resulting in:

ExternalParameter = Dhcp.Check(*):/usr/lib/nagios/plugins/check_dhcp -u -s $1 -m $2 > /dev/null ; echo $$?

Still confused as to when you would use the ShellExec version versus not, but will keep moving along.  Value is properly collecting at this point and can be added to the system controls.

I am trying to simply use the Nagios check_dhcp plugin to test some DHCP services in our network.  On the agent running on the same machine as the server I created the following entry:

ExternalParameterShellExec = Dhcp.Check(*):/usr/lib/nagios/plugins/check_dhcp -u -s $1 -m $2 > /dev/null ; echo $?


I then created a DCI for one of my machines using the NetXMS server as the proxy:

Dhcp.Check(1.2.3.4,"11:22:33:44:55:66")

The server shows the value in ERROR.  When I debug with agent I get:

[03-Oct-2012 13:57:13] [session:0] Requesting parameter "Dhcp.Check(1.2.3.4,"11:22:33:44:55:66")"
[03-Oct-2012 13:57:13] H_ExternalParameter called for "Dhcp.Check(1.2.3.4,"11:22:33:44:55:66")" "S/usr/lib/nagios/plugins/check_dhcp -u -s $1 -m $2 > /dev/null ; echo $?"
[03-Oct-2012 13:57:13] H_ExternalParameter: command line is "/usr/lib/nagios/plugins/check_dhcp -u -s 1.2.3.4 -m 11:22:33:44:55:66 > /dev/null ; echo ?"
[03-Oct-2012 13:57:13] H_ExternalParameter (shell exec): worker thread created
[03-Oct-2012 13:57:15] H_ExternalParameter (shell exec): execution timeout
[03-Oct-2012 13:57:15] H_ExternalParameter (shell exec): execution status 2
[03-Oct-2012 13:57:15] [session:0] GetParameterValue(): result is 500 (INTERNAL_ERROR)
[03-Oct-2012 13:57:15] [session:0] Sending message CMD_REQUEST_COMPLETED (size 32)
[03-Oct-2012 13:57:15] [session:0] Received message CMD_GET_PARAMETER
[03-Oct-2012 13:57:15] [session:0] Requesting parameter "Dhcp.Check(1.2.3.4,"11:22:33:44:55:66")"
[03-Oct-2012 13:57:15] H_ExternalParameter called for "Dhcp.Check(1.2.3.4,"11:22:33:44:55:66")" "S/usr/lib/nagios/plugins/check_dhcp -u -s $1 -m $2 > /dev/null ; echo $?"
[03-Oct-2012 13:57:15] H_ExternalParameter: command line is "/usr/lib/nagios/plugins/check_dhcp -u -s 1.2.3.4 -m 11:22:33:44:55:66 > /dev/null ; echo ?"
[03-Oct-2012 13:57:15] H_ExternalParameter (shell exec): worker thread created
[03-Oct-2012 13:57:15] H_ExternalParameter/POpenWorker: worker thread pipe read result: 0x7f84e0001070
[03-Oct-2012 13:57:17] H_ExternalParameter (shell exec): execution timeout
[03-Oct-2012 13:57:17] H_ExternalParameter (shell exec): execution status 2
[03-Oct-2012 13:57:17] [session:0] GetParameterValue(): result is 500 (INTERNAL_ERROR)
[03-Oct-2012 13:57:17] [session:0] Sending message CMD_REQUEST_COMPLETED (size 32)
[03-Oct-2012 13:57:17] [session:0] Received message CMD_GET_PARAMETER
[03-Oct-2012 13:57:17] [session:0] Requesting parameter "Dhcp.Check(1.2.3.4,"11:22:33:44:55:66")"
[03-Oct-2012 13:57:17] H_ExternalParameter called for "Dhcp.Check(1.2.3.4,"11:22:33:44:55:66")" "S/usr/lib/nagios/plugins/check_dhcp -u -s $1 -m $2 > /dev/null ; echo $?"
[03-Oct-2012 13:57:17] H_ExternalParameter: command line is "/usr/lib/nagios/plugins/check_dhcp -u -s 1.2.3.4 -m 11:22:33:44:55:66 > /dev/null ; echo ?"
[03-Oct-2012 13:57:17] H_ExternalParameter (shell exec): worker thread created
[03-Oct-2012 13:57:17] H_ExternalParameter/POpenWorker: worker thread pipe read result: 0x7f84e0001340
[03-Oct-2012 13:57:17] H_ExternalParameter/POpenWorker: worker thread pipe read result: 0x7f84e0001070


Have also tried this with the agent configuration as just ExternalParameter.  Still not 100% sure on the difference of the two. 

Running the parsed command from the server produces the desired results, 0 if everything works and 2 if there is no offer.

I am assuming you will ship these with pre-configured agent software on them.  If so, you should be able to use the server variable EnableAgentRegistration set to enabled to allow them to call in as they are turned up.  Is that what you are going after?

If you just want to display a specific web page from the web interface setup a "kiosk".  Here is one example using Ubuntu - http://www.instructables.com/id/Setting-Up-Ubuntu-as-a-Kiosk-Web-Appliance/.  Then just have the browser setup to auto fill password pages, their are lots of addons for this. 

Hope this helps.

I was documenting the PortCheck subagent this morning on the WIKI (complete BTW) and noticed while reading the code that you are not using the Header value that is passed in as an option.  It is using instead the Host (target) passed in as the first parameter in making the request.  Not a huge deal, but should be resolved.  Thanks!

Learning more about this each day and it only keeps getting BETTER!  Thanks for the reply, this will solve the issue very well and offers exactly what I need.

Just a couple of comments:

• Try changing your data type on the General tab to Unsigned integer 64 bit.  With your transformation anything over 4GB may fail.
• Update your transformation to '$1 * 1024' as that is the correct conversion from KB to bytes, not 1000
• I cannot comment on the test transformation window, I have NEVER had it actually pop up for me.  My only guess is that it is using the base type provided by the SNMP value as its type for processing which means anything over 2,147,483,647 (MAX for 32 bit signed) bytes becomes negative