NetXMS Support Forum

Hi.

It is planned to incorporate this feature in future versions?
In a large structure would be very useful.

Best regards.

QuoteThe fact that problem occurs on exact hours may point to some scheduled task, which broke communication with MySQL server in some way

All the users's crontab are empty. No system log error message at this time. No mysql log error message at this time.

QuoteDo you have MySQL server on same machine or on remote host?

The MySQL server is on same machine as the NetXMS server.

Best regards.

It seems that has not helped. Does anyone get this error?
It is curious that usually occur in exact hours (03:00, 04:00, etc.)

Quote[13-Mar-2012 10:47:19] NetXMS Server started
[13-Mar-2012 10:47:19] Listening for client connections on TCP socket 0.0.0.0:4701
[13-Mar-2012 14:24:32] Client session closed due to communication error (Connection reset by peer)
[13-Mar-2012 20:04:08] Client session closed due to communication error (Network is unreachable)
[14-Mar-2012 04:00:06] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[14-Mar-2012 04:00:06] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[14-Mar-2012 06:00:10] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[14-Mar-2012 06:00:10] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[14-Mar-2012 06:00:10] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away

In my linux box, I set max_allowed_packet parameter in my.conf from 100M (not bad) to 300M and restarted mysqld. I would say if this solves it.

Best regards.

Hi.

I had to restart the server because it did not allow new client connections. This is already a serious problem that should be resolved.

Best regards.

Quote[13-Mar-2012 01:00:48] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[13-Mar-2012 01:00:48] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[13-Mar-2012 01:00:48] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[13-Mar-2012 01:00:48] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[13-Mar-2012 05:00:12] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[13-Mar-2012 06:00:39] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[13-Mar-2012 06:00:39] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away

[13-Mar-2012 09:53:18] Log file opened
[13-Mar-2012 09:53:18] Platform subagent "/usr/local/lib/libnsm_linux.so" successfully loaded
[13-Mar-2012 09:53:18] Database driver "/usr/local/lib/libnxddr_mysql.so" loaded and initialized successfully
[13-Mar-2012 09:53:18] Network device driver "CATALYST-2900XL" loaded successfully
[13-Mar-2012 09:53:18] Network device driver "ERS8000" loaded successfully
[13-Mar-2012 09:53:18] Network device driver "BAYSTACK" loaded successfully
[13-Mar-2012 09:53:18] Network device driver "NETSCREEN" loaded successfully
[13-Mar-2012 09:53:18] Network device driver "CATALYST-GENERIC" loaded successfully
[13-Mar-2012 09:53:38] Failed to compile script for service check object 22045 "PlantillaServicio": Error in line 1: syntax error, unexpected $end
[13-Mar-2012 09:53:38] NetXMS Server started
[13-Mar-2012 09:53:38] Listening for client connections on TCP socket 0.0.0.0:4701

Hi.
I have been working with CentOS systems over the past 5 years.
CentOS is a linux distribution built on the RedHat Enterprise Source RPMs. It's a clone of an enterprise linux distribution, RHEL which means it's very stable, well tested and for the most part on the ball with security patches.
With CentOS you will get an OS with updates available for more than one year. With this Linux distribution you will have five years of guaranteed available updates, and guaranteed upgradeability to CentOS 6 once it becomes available and CentOS 5 is EOLed (End Of Life).
CentOS systems may be working for many months without the slightest degradation.
CentOS is the only free enterprise operating system.

Best regards.

Hi.

I send you required information for Cisco Nexus 1000 switches.

Best regards.

Hi Victor.

Okay, thanks for the info.
So, the next version release will be 1.2.0?

Best regards.

Hi.

Is this the ToDo list currently in effect?
https://svn.netxms.org/public/netxms/trunk/TODO

Best regards.

Hi Victor.

So all these limitations disappear?

QuoteMost notable one is very limited access to data outside script boundaries. For
example, from NXSL script you can neither access files on the server, nor call external programs,
nor even access data of any node object, other than the one the script is running for.

Best regards

I tried this script, but without results.

Quoteprintln FindNodeObject(null, $1);
return 1;

As a workaround, I am currently using a AutoIt script in the new java console. That script reads a external text file and create new containers, node, conditions, assigned to them several properties, transformation scripts, etc..
But I have real difficulties with interfaces list, for example to select all interfaces of a node or an interface with a certain IP, to define DCI's for one or more interfaces, etc..
Perhaps this would be easier showing all interfaces in a SysListView32 tab control in addition to deploy it in a SysTreeView32 control.

Hi.

In the NetXMS log file I can see this error:

Quote[23-Feb-2012 12:27:24] Failed to compile script for service check object 22045 "PlantillaServicio": Error in line 1: syntax error, unexpected $end

How can I identify this object number in the Services tree?

Best regards.

Hi.


At my company we have Cisco Nexus 5500 and Cisco Nexus 1000 Switches wich incorporates unified fabric and fabric-extender technology. This implies that  Cisco Nexus 1000 Switches can have up to 2048 physical + logical ports, or until 1248 physical ports for Cisco Nexus 5500 switches.

Manage, unmanage, monitor this number of ports may be impractical ... unless the NetXMS server loads corresponding driver.

By the way, new approach for port tab using drivers sound great!!!


Best regards.

This problem persist in 1.1.10 version.

Quote[15-Feb-2012 23:01:04] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[15-Feb-2012 23:01:04] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[15-Feb-2012 23:01:04] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[15-Feb-2012 23:01:04] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 00:00:43] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 00:00:58] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 00:00:58] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 00:00:58] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 00:17:04] Client session closed due to communication error (No route to host)
[16-Feb-2012 18:52:08] Client session closed due to communication error (Connection reset by peer)
[16-Feb-2012 19:00:35] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:37] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:37] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:39] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:41] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:44] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:45] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:45] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:46] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:47] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:48] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:49] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:54] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:56] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:56] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:57] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:59] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:01:01] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:01:01] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:01:01] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:01:02] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:01:04] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:01:04] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:01:05] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away