Messages

31

General Support / Re: SQL errors in 1.2.2 ?

« on: September 06, 2012, 05:02:40 pm »

Hi,

 I have now installed MySQL Community Server 5.5.27 (x64), re-installed NetXMS to include MySQL client support. I setup MySQL database thus:

 mysql> CREATE DATABASE netxms;
 mysql> GRANT ALL ON netxms.* TO netxms@localhost IDENTIFIED BY 'password'

 netxmsd.conf:
---------------------------------------------------------------------------------
#
# NetXMS Server configuration file
# Created by NetXMS Server configuration wizard at Wed May 09 15:31:46 2012
#

LogFile = {syslog}
DBDriver = C:\NetXMS\bin\mysql.ddr
DBServer = localhost
DBName = netxms
DBLogin = netxms
DBPassword = password
LogFailedSQLQueries = yes
---------------------------------------------------------------------------------

I initialised the database using:

 nxdbmgr.exe init C:\NetXMS\lib\sql\dbinit_mysql.sql

then I tried importing the existing configuration and history using:

 mxdbmgr.exe import C:\NetXMS\database\bn-netxms

 this results in the following output:

-------------------------------------------------------------------------
NetXMS Database Manager Version 1.2.2



WARNING!!!
This operation will clear all configuration and collected data from database.
Are you sure? (Y/N) Y
Database successfully cleared
Importing table config
Importing table config_clob
Importing table users
-------------------------------------------------------------------------

 The import generates an exception, logged as follows:

-------------------------------------------------------------------------
Faulting application name: nxdbmgr.exe, version: 0.0.0.0, time stamp: 0x500d3368
Faulting module name: libnetxmsw.dll, version: 0.0.0.0, time stamp: 0x500d32f4
Exception code: 0xc0000005
Fault offset: 0x000000000001c5ab
Faulting process id: 0x11b8
Faulting application start time: 0x01cd8c3483769b7d
Faulting application path: C:\NetXMS\bin\nxdbmgr.exe
Faulting module path: C:\NetXMS\bin\libnetxmsw.dll
Report Id: c265019d-f827-11e1-ad02-00155d002212
-------------------------------------------------------------------------

Regards,
David

32

General Support / Re: SQL errors in 1.2.2 ?

« on: September 03, 2012, 12:09:48 pm »

Hi,

 Is there an easy way to migrate existing configuration and history to a better dB product ?

Regards,
David

33

General Support / Re: SQL errors in 1.2.2 ?

« on: August 28, 2012, 11:23:00 am »

Hi,

 Anyone any thoughts on this ?

Regards,
David

34

General Support / Re: SQL errors in 1.2.2 ?

« on: August 16, 2012, 07:17:52 pm »

Hi Victor,

 Yes it is SQLite, conf file:

LogFile = {syslog}
DBDriver = sqlite.ddr
DBName = C:\NetXMS\database\bn-netxms
LogFailedSQLQueries = yes

Regards,
David

35

General Support / Re: SQL errors in 1.2.2 ?

« on: August 16, 2012, 06:29:08 pm »

Hi Victor,

 It is the one built into the installer, is that SQLite ? The original install was quite some time ago ( 0.x version) and upgraded over time. Is there a way of asking netxms which dB it is using ?

Regards,
David

36

General Support / SQL errors in 1.2.2 ?

« on: August 16, 2012, 02:56:24 pm »

Hi,

 Server Platform: Windows Server 2008 R2 standard (64bit)
 NetXMS Server: netxms-1.2.2-x64

 Since upgrading to 1.2.2 I'm having intermittent problems viewing graphs of DCI values and getting DCI collection failures in the client. In the server system log I get a number of entries when the DCI collection fails:

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 (?,?,?,?,?,?,?,?)"): constraint failed

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 (?,?,?,?,?,?,?,?)"): constraint failed

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 (?,?,?,?,?,?,?,?)"): column event_id is not unique

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 (?,?,?,?,?,?,?,?)"): constraint failed

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 (?,?,?,?,?,?,?,?)"): column event_id is not unique

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 (?,?,?,?,?,?,?,?)"): constraint failed

 I then restart NetXMS Core and its ok again for a while before failing again with the same problem.

 Any pointers on where I should be looking would a great help.

David

37

General Support / Re: Cannot figure web site monitor

« on: May 17, 2012, 02:24:18 pm »

Hi Victor,

 Thanks for your help.

 I am using version 1.2 of the management server and consoles. I was using the 'Legacy console' when I got the 'invalid argument' error, in light of your comment above I tried the new console (java?) and it accepted the same arguments that the legacy console rejected. So now I have a little bit more knowledge I will go and play with it and see if I can get it to work.
 Thanks for your patience an assistance.

Regards,
David Hewison

38

General Support / Re: Cannot figure web site monitor

« on: May 16, 2012, 08:14:35 pm »

Hi,

 I have now discovered ServiceCheck.HTTP() , however if copy the example (below) into the DCI I get 'unable to create new data collection item: invalid argument' , I've quotes around what are likely to be strings, reduced the test expression to "*" but cannot create the item. Anyone point me in the right direction ?

 ServiceCheck.HTTP(159.148.208.90,80,/index.html,www.netxms.org,"^HTTP/1\.[01] 200.*")

Reagrds,
David

39

General Support / Re: Cannot figure web site monitor

« on: May 15, 2012, 11:31:46 am »

Hi Victor,

 I'm not sure I understand the elements involved here, the monitored node, www.infoshop.co.uk , is an Internet facing web site on a shared server at an ISP, I have no access other than http. In NetXMS the node has the NetXMS agent and SNMP polling disabled, the 'child' service of this node, 'Web Site', has a service type of 'HTTP' and port 80.
 Is my mistake thinking that the monitoring of HTTP port 80 is done from the NetXMS server, must it be done from a local agent on the node itself ? If that is the case, is it possible to monitor a TCP application service such as an HTTP server from the NetXMS server without the use of agents on the monitored service ?

Best regards,
David

40

General Support / Cannot figure web site monitor

« on: May 10, 2012, 11:32:40 am »

Hi,

 I'm struggling with trying to monitor web sites and hope someone can point out how thick I am in a constructive manner !

 An example configuration:

  Node "www.infoshop.co.uk"
   Polling: access to NextXMS agent disabled, usage of SNMP for all polls disabled
   Service "Web Site"
     Service type: http, tcp/udp port: 80
     Request: www.infoshop.co.uk
     Expected response: ^HTTP/1\.[01] 200.*

 The results of a status poll are:
[10-May-2012 09:27:10] Sending poll request to server...
[10-May-2012 09:27:10] Poll request accepted
[10-May-2012 09:27:10] Starting status poll for node www.infoshop.co.uk
[10-May-2012 09:27:10]    Starting status poll on interface lan0
[10-May-2012 09:27:10]       Current interface status is NORMAL
[10-May-2012 09:27:10]       Starting ICMP ping
[10-May-2012 09:27:10]       Interface is NORMAL for 13 polls (1 poll required for status change)
[10-May-2012 09:27:10]       Interface status after poll is NORMAL
[10-May-2012 09:27:10]    Finished status poll on interface lan0
[10-May-2012 09:27:10]    Starting status poll on network service Web site
[10-May-2012 09:27:10]       Current service status is Unknown
[10-May-2012 09:27:10]       Polling service from node FS01.bustednetworks.com [192.168.0.31]
[10-May-2012 09:27:10]       Unable to check service status due to agent or communication error
[10-May-2012 09:27:10]    Finished status poll on network service Web site
[10-May-2012 09:27:10] iNode is connected
[10-May-2012 09:27:10] Finished status poll for node www.infoshop.co.uk
[10-May-2012 09:27:10] Node status after poll is NORMAL
[10-May-2012 09:27:10] Poll completed successfully

 All I ever get is "Unable to check service status due to agent or communication error". I have checked browsing to the monitored web site from the NetXMS server, that works fine. I have no idea how to test what actual response I should get from the web server, any help / suggested tools would be appreciated.

Regards,
David Hewison

41

General Support / Re: UPS monitoring and shutdown

« on: March 22, 2012, 03:46:51 pm »

Hi Victor,

 Thanks for coming back on this, your answer confirms what I thought.

 I think it is safer for software on the server to initiate the shutdown rather than such software report to an external system in order to initiate a remote shutdown, there are too many potential points of failure in the critical path of the latter method (at least in our network model).

Regards,
David

42

General Support / UPS monitoring and shutdown

« on: March 10, 2012, 11:47:39 am »

Hi,

 I've been looking at monitoring UPS' with NetXMS but currently can only get it to work by disabling the monitoring / shutdown software on the server. The example I'm looking at is a Dell PowerEdge server with an APC Smart-UPS 1500 connected to the server via COM1 and using Microsoft's inbuilt UPS monitoring software.

 I'm guessing I cannot use NetXMS AND some other software because the COM port gets locked by the monitoring software, but if that is the case how do other people get around this ? It is of prime importance to us to have the server shutdown automatically by the monitoring software and it seems to me to be prudent to have such monitoring very local to the server rather than remote as who knows what intervening kit might fail in a power outage ?

 Any guidance on this would be most welcome.


Regards,
David

43

General Support / Re: Upgrade procedure

« on: February 15, 2012, 03:49:50 pm »

OK, thanks Victor will do.

Regards,
David

44

General Support / Upgrade procedure

« on: February 15, 2012, 02:36:27 pm »

Hi,

 What is the correct procedure to upgrade 1.0.13 (embedded SQL Lite) to 1.1.10 on Windows 2008 R2 ?

 I have tried and end up with all sorts of SQL errors.

Regards,
David

45

General Support / Re: Inter-dependent status

« on: October 26, 2011, 05:10:40 pm »

Hi Victor,

 If I read the status of node "ISP_gateway" from an event processing rule triggered by a "NODE_DOWN" event does all the other nodes have to be in the trusted node list of node "ISP_gateway" ?

Regards,
David