NetXMS Support Forum

I'm still not getting anywhere with this, the same error keeps occurring. I have checked with "netstat -ano" that the port is free and have tried configuring Jetty to use both 127.0.0.1 and the IP of the machine instead of 0.0.0.0 but it keeps insisting that the address is already in use.

I even tried copying a newer version of v7 Jetty across and that gets me nowhere, except that a deprecated class is now no longer valid.

Quote from: John M on July 09, 2013, 04:43:48 PM
Not getting an error if I log into MySQL via command line with the exact same credentials.  Is there a way to log in MySQL to see what NetXMS is trying as credentials?

I'm no MySQL expert, but a quick look around shows there's a "--verbose" and "--debug" parameter for the mysqld service - perhaps one of those will enable better logging in the "{server name}.err" log file found in \MySQL\data

Strange as that's more-or-less exactly the same settings I have:

LogFile = {syslog}
DBDriver = mysql.ddr
DBServer = localhost
DBName = netxms_db
DBLogin = netxms
DBPassword = **********
LogFailedSQLQueries = yes

Any errors in the MySQL .err file? You could also try logging into MySQL from the command-line:

mysql -h 127.0.0.1 -u netxms_usr -p

It will prompt you for the password.

What DB were you trying to connect to in the first place? That config file seems to be set up for MySQL so you need to be use the user-id has locahost access "%" or "localhost" to your MySQL server and the netxms_db database.

Quote from: Victor Kirhenshtein on July 03, 2013, 07:33:55 PM
Try to replace odbcquery.nsm with attached one. Should work!

Best regards,
Victor

Perfect, it's all working now. Many thanks.

It's working for this CSV DSN and also a SQLite one I'm also testing.

I'm now seeing the same thing, but it was working fine a few weeks ago which makes this very strange. I haven't used it much and I can only think that maybe the latest version of Java, which I did update to, has messed something up.

The port is definitely not in use and changing it to another doesn't help either.

Quote from: Victor Kirhenshtein on July 03, 2013, 12:57:21 PM
Yes, just found a bug in ODBCQUERY subagent. Are you using 32 or 64 bit version? I'll post patched subagent here.

Best regards,
Victor

64bit on both server and agent

Quote from: Victor Kirhenshtein on July 02, 2013, 11:59:07 PM
Hi!

Don't forget to put query parameter into correct section, ODBC, like this:

Code Select Expand


SubAgent = odbcquery.nsm

*ODBC
Query = TempSensorTemp:TempSensor:select 'Temperature Value' from 'Draycott Corp.csv':60


Best regards,
Victor

Ah, can't believe I missed that, thanks again. Unfortunately I still have an issue in that data I receive is not correct - no errors now in the debug logging.

I've left it running for a bit and exported the values, here's a small sample:

"03.07.2013 10:21:43","??8"
"03.07.2013 10:20:43","??1"
"03.07.2013 10:19:43","??1"
"03.07.2013 10:18:43","??5"
"03.07.2013 10:17:43","??5"
"03.07.2013 10:16:43","??5"
"03.07.2013 10:15:43","??9"
"03.07.2013 10:14:43","??9"
"03.07.2013 10:13:43","??3"

On the console, the ?? appear as Chinese characters. I have tried setting the value as both string and floating-point (which is what the value is) and it's the same.

I wanted to add, I just used Microsoft's ODBC test tool as I wanted to be sure this wasn't a 32bit/64bit ODBC issue - my other working connection is 32bit.

I used the tool to confirm both DSNs and it all seems well:

Connect to DSN

   Full Connect(Default)

   Env. Attr. SQL_ATTR_ODBC_VERSION set to SQL_OV_ODBC3

   Successfully connected to DSN 'TempSensor'.

select "Temperature Value" from "Draycott Corp.csv"

SQLExecDirect:
            In:            Statementhandle = 0x0000000000177FB0, StatementText = "select "Temperature Value" from "Draycott Corp.csv...", Statementlength = 51
            Return:   SQL_SUCCESS=0

Get Data All:
"Temperature Value"
19.94
1 row fetched from 1 column.

Quote from: Victor Kirhenshtein on July 01, 2013, 11:40:48 PM
Hi!

Looks like documentation page is misleading. You supposed to replace "Name", "DSN", etc. with actual values. Your configuration record should be

Query = TempSensorTemp:TempSensor:select 'Temperature Value' from 'database.csv':60

(60 at the end means poll every 60 seconds).

Best regards,
Victor

Thanks, but still not working. My exact lines are now:

SubAgent = odbcquery.nsm
Query = TempSensorTemp:TempSensor:select 'Temperature Value' from 'Draycott Corp.csv':60

and the debug log on the agent machine still shows:

[02-Jul-2013 18:06:39.590] [session:0] Received message CMD_GET_PARAMETER
[02-Jul-2013 18:06:39.865] [session:0] Requesting parameter "ODBC.QueryResult(TempSensorTemp)"
[02-Jul-2013 18:06:40.434] [session:0] GetParameterValue(): result is 404 (UNKNOWN_PARAMETER)
[02-Jul-2013 18:06:40.994] [session:0] Sending message CMD_REQUEST_COMPLETED (size 32)

or if I put quotes on the query:

[02-Jul-2013 18:06:39.590] [session:0] Received message CMD_GET_PARAMETER
[02-Jul-2013 18:06:39.865] [session:0] Requesting parameter "ODBC.QueryResult("TempSensorTemp")"
[02-Jul-2013 18:06:40.434] [session:0] GetParameterValue(): result is 404 (UNKNOWN_PARAMETER)
[02-Jul-2013 18:06:40.994] [session:0] Sending message CMD_REQUEST_COMPLETED (size 32)

I'm trying to get a Windows remote agent to read an ODBC sourced database (a CSV file), that contains a single row of data. I've added the ODBC nsm and configure as per the wiki the agent with:

Query = Name:TempSensorTemp DSN:TempSensor Query:"select 'Temperature Value' from 'database.csv'"

Whenever I try to create a DCI as ODBC.QueryResult(TempSensorTemp) I get an error that it's unsupported by the agent.

The agent log shows:

[01-Jul-2013 18:19:53.460] [session:0] Requesting parameter "ODBC.QueryResult(TempSensorTemp)"
[01-Jul-2013 18:19:53.805] [session:0] GetParameterValue(): result is 404 (UNKNOWN_PARAMETER)

Can anyone tell me where my config is wrong? I have a similar ODBC call from another app to the same database and my query does work.

Is there a dashboard element I can set up that can show me the status of a Windows service e.g. shows the status of System.ServiceState(*)?

I wanted to add to this thread a Windows equivalent which I needed for myself. I've added two new DCI's to my agent's config file:

ExternalParameter = DNS.Lookup(*):dig +noall +short @$1 $2 A
ExternalParameterShellExec = DNS.Check(*):dig +noall +short @$1 $2 A | find /c "$3"

The first returns the IP looked up as I wanted to be able to check it for myself, the second is the equivalent of the example from Victor that returns just a code. The reason for the "ShellExec" is because "find" is a built-in function of the command-prompt, and "/c" returns the count.

You'll also need a copy of "dig" for Windows which can be found here.

That's excellent, thanks they worked perfectly now.

I think it was the 100s in the last two fields that I was not getting right.

Hi,

Very new to NetXMS and very much amazed with the product so far - great job.

One question of probably many more to come, but with Dial Charts is there any way to reverse the colour bands? What I mean is that I want to create them to reflect percentage disk space free but I want the red band to start at 0 and go to 10, then from 10 to 20 be yellow and the rest to 100 be green. When I try to enter values for this I end up with a mess. Can I achieve this?