NetXMS Forum

Hi Victor,

Thanxx for your fast reply! Yep it works now! Does this mean that from V1.2.3 onwards there is unicode built-in?

Just another question that you might also be knowledgeable about. I notice that on monitored Windows hosts running on VMWare Server (so actually virtual Windows 2003 machines) the agents crash regularly with the message "The referenced memory cannot be read". I must stress that this only happens on VMWare virtual machines...  (I suspect it is due to the memory management of VMWare.)

Thanx anyway already,
Sincere greetings from Belgium ;-),
Peter.

Hello everyone,

Could someone please help with the following:

The agent on a monitored server running windows 2003 sends an invalid character as a result, instead of a string/number. (See attachment 02, 03 and a working one on another server: Attachment 04)

Running the script from a command line gives the correct response... (See attachment 01)

Some additional information:

1. Server OS: Win 2003 R2 32Bit SP2
2. Agent OS: Win 2003 R2 32Bit SP2
3. NetXMS server version is 1.2.5
4. NetXMS client version is 1.2.5
5. NetXMS server database collation: utf8_general_ci

Any help is greatly appreciated!

Sincere greetings,
Peter.

---

Hi Victor,

No sorry, I don't see that line:

[17-Jul-2012 16:16:19] [session:0] GetParameterValue(): result is 0 (SUCCESS)
[17-Jul-2012 16:16:19] [session:0] Sending message CMD_REQUEST_COMPLETED (size 4

[17-Jul-2012 16:16:20] DBConnect: server=CS9DEV db=(null) login=SYSRDR schema=(n
ull)
[17-Jul-2012 16:16:41] [session:0] Received message CMD_GET_PARAMETER
[17-Jul-2012 16:16:41] [session:0] Requesting parameter "Test(2,3)"
[17-Jul-2012 16:16:41] H_ExternalParameter called for "Test(2,3)" "S"Echo $1 $2"
"
[17-Jul-2012 16:16:41] H_ExternalParameter: command line is ""Echo 2 3""
[17-Jul-2012 16:16:41] H_ExternalParameter (shell exec): worker thread created
[17-Jul-2012 16:16:41] H_ExternalParameter/POpenWorker: worker thread pipe read
result: 00AAF788
[17-Jul-2012 16:16:41] H_ExternalParameter (shell exec): execution status 0
[17-Jul-2012 16:16:41] [session:0] GetParameterValue(): result is 0 (SUCCESS)
[17-Jul-2012 16:16:41] [session:0] Sending message CMD_REQUEST_COMPLETED (size 5
6)

Grtz,Peter.

Hi macro,

This is the (I think) relevant part of the agent:
...
[17-Jul-2012 14:19:13] [session:0] Sending message CMD_REQUEST_COMPLETED (size 4

[17-Jul-2012 14:19:17] DBConnect: server=CS9DEV db=(null) login=SYSRDR schema=(n
ull)
[17-Jul-2012 14:19:19] [session:0] Received message CMD_GET_PARAMETER
[17-Jul-2012 14:19:19] [session:0] Requesting parameter "Icmp.LastPingTime(143.1
29.11.202)"...

Thank you veruy much in advance!

Grtz,Peter.

Sorry for the late reply. (Things are stressy here...)

(Yes, I know my way around in oracle databases...;-))

1. Yes I can connect via sqlplus to the database using the same username password and the same SID...
2. Yes, I have granted the rights as mentioned.

I personally think it has to do with the NetXMS client-NetXMS server connection... EG: it is also not allowed to edit the clients' config file from the NetXMS console...
If there are other suggestions, please feel free!

Thanxxx in advance!
Grtz,Peter

Hi Victor,

Thank you very much for your answer.
I'm sorry I was not entirely clear, but of course I do use Oracle(DBInfo.IsReachable(DB1)...
Do you hav any other suggestions?

Thank you very much & sincere greetings,
Peter.

BTW: We happily use NetXMS since release 0.2x I guess

Hello all,

I need to monitor some DB parameters. I noticed by accident, that there is an oracle.nsm subagent, that can monitor different DB-parameters. However after hours of trying, I still  do not succeed getting info back. Could someone please have a look?
The agent and the console are running both on different machines on win 2003 and the database is running on Centos Linux (Oracle 11; no agent installed). NetXMS version is 1.21.

1. I installed the server binary on both machines, because simply copying the oracle.ddr made the agent crash.
2. I added following lines to the agent config file:

#
# NetXMS agent configuration file
# Created by server installer at Wed Jun 27 09:51:15 2012
#

LogFile = {syslog}
Servers = <serverip>
InstallationServers = <serverip>
FileStore = C:\NetXMS121\var
RequireAuthentication = no
SubAgent = winperf.nsm
SubAgent = portcheck.nsm
SubAgent = oracle.nsm

*oracle
Id = DB1
TnsName = SID
UserName = USER
Password = PASS

3. After starting the agent via CMD prompt, I get the following:
   (See attachment)

4. So everything looks allright, BUT requesting from the NetXMS console:
   Oracle.DBInfo.IsReachable() => gives: 'Current value is "NO"'
   Oracle.DBInfo.Name() => gives following error: 'Query agent' has encountered a problem. Cannot get current parameter value: Requested data collection item is not supported by agent.

I really have no idea anymore what has to be changed to make this work. Any help is really appreciated!!

Thanxx in advance,
Peter.

---

Thank you very much for your answer. The problem seemed to be that you only get the first line. In my case the first line was blank, so..
Anyway, I created the following bat-file:
@echo off
sqlplus -L user/password@%1 | find "ORA-01017" >NUL
if errorlevel 1 goto else
   echo 0
    goto endif
:else
   echo 1
:endif
This seems to give either 0 or 1 so, what I need.
I then added this line in the etc/nxagentd.conf:
ExternalParameterShellExec = ORALogon(*):c:\_oratest\oralogon.cmd $1
This I capture in a DCI...

However maybe 1 question. It seems that when i want to edit the etc/nxagentd.conf, to reflect the changes, I hav to restart the agent service. Is there another way to reflect the changes in the config file?

Thank you very much for your help!!! And again, this software really is a jewel!
Peter.

I tried different ways, but do not get any feedback. I succeed in executing the command (using a bat-file with a ">logfile.txt" parameter, the logfile.txt is generated, so it means that the command has been executed). However I do not get any feedback. If I try: nxget, I do not get any output. If I create a DCI, the value returned is "#00"...
Creating a "ExternalParameterShellExec: echo(*): echo $1" returns the * output as expected.

Do you perhaps know what the reason could be? ???

Thank you very much!
Peter.

Hello again,

I'm looking for a solution to test an oracle instance on Ms Win.
I would like to do a fake login (eg: sqlplus false_user/false_password@oracleinstance), and one way or another make a dci of the result...
I already do a check on port 1521 (ora listener) and check the service of the oracle instance.
Any help with this, or suggestions about other solutions would be very appreciated!

Thank you very much in advance!!
Peter.

 I 've been fiddling around with the conditions and condition.status(*) and it works like a charm.

What still might be a nice feature is that a condition could take another condition as a data-value (Now it can only take a host/dci). But I work around by using an intermediate DCI. (This takes an extra delay, but is not really a problem...)
Also thank you for the tip about the trusted nodes part, because I would never have figured that out! Apparently you get an "not supported" error then... 

Thank you very very much for your quick help. If people are interested, I'd like to share following info:
The core service failed to start on Windows 2003 after upgrading to the RC3. Solution for me was:

1. I checked the log-file (c:\netxms\log\setuplog.log) and got an error on 2 "empty" conditions (Value in SQL-yog was: #00 instead of <NULL>). (The conditions were created, but there was no data and script in it..) I'm not sure wether this was the reason for the windows service not starting up, because after removal of the empty conditions the service still didn't want to start...
2. Delete the core service:
       C:\NetXMS\bin>netxmsd -R
3. Recreate the service:
       C:\NetXMS\bin>netxmsd -c "C:\NetXMS\etc\netxmsd.conf" -I
       I'm not sure wether the "-c config-file" part is needed to create the service.
   Afterwards, the service started normally...
   I'm now trying to test the ConditionStatus(*)...

PS: this was the error in the log file:
[10-Mar-2008 11:43:35] Log file opened
[10-Mar-2008 11:43:35] Database driver "mysql.ddr" loaded and initialized successfully
[10-Mar-2008 11:43:39] GSM modem on COM1: initialized successfully. Hardware ID: "".
[10-Mar-2008 11:43:39] Failed to compile evaluation script for condition object 204 "CSTST_PRCS": Error in line 1: syntax error, unexpected $end
[10-Mar-2008 11:43:39] Failed to compile evaluation script for condition object 207 "CSPROD_PRCS": Error in line 1: syntax error, unexpected $end
[10-Mar-2008 11:43:39] Failed to compile evaluation script for condition object 211 "HRPROD_PRCS": Error in line 1: syntax error, unexpected $end
[10-Mar-2008 11:43:39] NetXMS Server started
[10-Mar-2008 11:43:39] NetXMS Server stopped
[10-Mar-2008 11:43:41] Log file closed

Thank you very much for your answer.

In the meanwhile, suppose I create a mysql table myself, is there a way to use the NXSL (scripting) to do an insert into the table? (Eg, node_id, timestamp, condition value)? It would really help me out...

Thanxx in advance!

Hello again,

Is it possible to keep a history of the results of a condition? It does not seem possible to create a DCI: Internal/child.status(condition)!
Is there a way to create such a history?

PS: I need the condition, because I need to calculate with results of the DCI's of different nodes.

Thanxx in advance!

Thank you very much for your help (especially the netstat typ). I'm sure now it has nothing to do with Netxms. Apparently the host is only listening on his own IP-adress, and not on address 127.0.0.1. This explains why only remote connections are accepted.
As this problem is on all tested hosts (Win XP and 2003 Adv Server), I think the problem is bound to Microsoft OS's...

If I have the solution, I'll post it here... Thanxx again for your help!!

Ps: the more I'm busy playing around with netxms, the more I love it!

Thank you very much for your information!

I don't seem to get the localhost part working, but am still trying. Apparently, I always get status 2 back instead of status 0. In case I don't use the (127.0.0.1,9000) but by a remote host, it works... It think it has not to do with the Peoplesoft JOLT listener because also ServiceCheck.Custom(127.0.0.1,21) on FTP-host returns dci-value 2.

Thank you very much for the info.

I still have a question though. Does netxms also keep a history of "NETWORK SERVICES" data? I can find the DCI data in the IDATA_xx tables, but not the network services data?

If this is not the case, this means I need to get the status of ports via a DCI (Eg Peoplesoft JOLT listener on port 9000). I could us the ServiceCheck.Custom(x).
What do I give as a parameter x?

EG: I need to check port 9000 of node 12. How can I define a DCI for this?
ServiceCheck.Custom(localhost, 9000) -> returns status 2
ServiceCheck.Custom(9000) -> returns status 2

Thanxx in advance!

Hello again,

I need to make a php page that shows the uptime of various services monitored by NETXMS.
I found most of the data I need, but have a problem with 'DATES' that are stored in the database. Could you please tell me how I can extract the date and time from date and time fields (eg: alarms.creation_time, alarms.change_time, idata_xx.idata_timestamp etc)?
Also, the idata_xx tables. What is the number the xx refers to?

Thank you very much in advance!
Peter.

Ok, thank you very much for your help. After adding the Logscan.nsm to the client config file and restarting the client and core, I can indeed search a textfile... Very nice!

Hello everyone,

First a happy new year and best wishes for everyone.

I would like to know how the function Log.Scan is used. I can see it on one of the screenshots, but don't find any documentation on it.
I basically want to read a text file, and check for the content of the file...

Thanxx in advance for the help...
Peter.