NetXMS Forum

MHdby

I'm getting unknown type in the logs for an externaltable request. The request runs a powershell script which contains a command that returns text data separated by a |. The data that is returned is a text value and a number.

Script to get data

$s = "QueueName|MessagesReady";
$i = 1;
$rabbitInfo = rabbitmqctl list_queues -q name messages_ready | ConvertFrom-Csv -delimiter "`t" -Header 'Name','MessagesReady'
ForEach($item in $rabbitInfo)
{
  $s = $s + "`r`n" + $item.Name + "|" + $item.MessagesReady;
  $i = $i +1;
}
echo $s

I've also tried this as a script because the data returned is tab delimited and in the policy which contains the ExternalTable line i set separator to `t

$s = "QueueName	MessagesReady";
$rabbitInfo = rabbitmqctl list_queues -q name messages_ready
echo $s $rabbitInfo

2019.03.07 15:12:29.118 *D* [CS-0(19)] Received message CMD_GET_TABLE (413)
2019.03.07 15:12:29.118 *D* [CS-0(19)] Requesting table "RabbitQueueNames"
2019.03.07 15:12:29.118 *D* [CS-0(19)] H_ExternalTable called for "RabbitQueueNames" (separator=0x0060 mode=E cmd="powershell c:\netxms\var\getRabbitQueueNames.ps1"
2019.03.07 15:12:29.118 *D* RunExternal called for "RabbitQueueNames" "Epowershell c:\netxms\var\getRabbitQueueNames.ps1"
2019.03.07 15:12:29.118 *D* RunExternal: command line is "powershell c:\netxms\var\getRabbitQueueNames.ps1"

2019.03.07 15:12:33.772 *D* [CS-0(19)] GetTableValue(): result is 0 (SUCCESS)
2019.03.07 15:12:33.772 *D* [CS-0(19)] Sending message CMD_REQUEST_COMPLETED (ID 413; size 584; compressed)
2019.03.07 15:12:33.772 *D* [CS-0(19)] Outgoing message dump:
** 000000: 001D0048000002480000019D00000034 ...H...H.......4
** 000010: 0000078078DAA5555B53D35010DE58E5 ....x..U[S.P..X.
** 000020: 52116B05442C508B820FC0607F830FFA R.k.D,P....`....
** 000030: 203338BE67521A4A86A685B4B5C32F82 38.gR.J....../.
** 000040: DFC32FE2CB66B3392797BED84C722EFB ../..f.9'...Lr..
** 000050: EDEDDB3DA744D422FBF7E8D8EBD31A0F ...=.D."........
** 000060: CE938C3F65FF5B3238BF64CD6A8D7402 ...?e.[28.d.j.t.
** 000070: 3DBAA019F9FC9E934721C655FA8DEF04 =.......G!.U....
** 000080: 8F47039EFDC1D7A33EDD274A0D55D7F5 .G......>.'J.U..
** 000090: 8BFFB45793B8FF9A76DB599C4D1AC166 ...W....v.Y.M..f
** 0000A0: 04DD00B3016C9EB1DC11790B92103623 .....l....y...6#
** 0000B0: 9A928BF98C7A58075801D9CEE26B02E1 .....zX.X....k..
** 0000C0: B37C08D944EDD444BE6ED86199C4F152 .|..D..D.n.a...R
** 0000D0: E45BF03EA45B3AA13BCDD3C4BD12DC8E .[.>.[:.;.......
** 0000E0: 61E7049808CF186FEA6F49707BB9BC6C a......o.oIp{..l
** 0000F0: 6C57ED2E0BBECEBC4DD5CE8AEC1F6A5C lW......M.....j
** 000100: 767EB6BDEF6A6F55ED857405DDD45E5D v~...joU..t...^]
** 000110: 79BAA46B8E3FA9582A7FAD71DBF2428E y..k.?.X*..q..B.
** 000120: E2674DF121647186636063BD583FA07F .gM.!dq.c`c.X?..
** 000130: 39FEDE685C71969EFA5D97FD0EF46790 9..h\q...]....g.
** 000140: F4781C011557DBE7996FF0FB56F0C705 .x...W...o..V...
** 000150: 3E7ACCA02BF58BD0832EE2E84B9F34B4 >z..+.......K.4.
** 000160: CE89FFAABCDE3969EB065C6783259637 ......9i..\g.%.7
** 000170: B52F4D3FC5BE7CAFFD72051F43C9C2A5 ./M?..|..r..C...
** 000180: 1F4086A8679ACF86D6D9E47188EF6021 [email protected]..`!
** 000190: 9F9BA2B74173CEE1067E62ADB9F8DF2A ....As...~b....*
** 0001A0: F47579BE1F1497F44B156E5B70DBB0E6 .uy.....K.n[p...
** 0001B0: 21D7D2CE00EE63053F562581DB115CB7 !.....c.?V%...\.
** 0001C0: 50C798C5899E1B17DE2EF14CF93C85CA P..........L.<..
** 0001D0: DB27E5B7FC7CA4B896E2CC788AE77657 .'...|.....x..vW
** 0001E0: EF893E3C06B0726FE5BFA7FD6EF7D7C8 ..><..ro....n...
** 0001F0: E85813BF2FF835E52BC9BBEDA4907CDD .X../.5.+.....|.
** 000200: CAF9FCACF549EE87AAFA742AEECB3CEF .....I....t*..<.
** 000210: 079AC7A2FB24B3FB45EFFFB2F399757D .....$..E.....u}
** 000220: 95FE57E53FE3B5ECDE3CD4F8CD739743 ..W.?....<...s.C
** 000230: 0277B4F0BEB04E21E31ECCFFCB67A70E .w....N!.....g..
** 000240: DE36000000000000 .6......
** code=0x001D (CMD_REQUEST_COMPLETED) flags=0x0048 id=413 size=584 numFields=52
** 000010: [ 1920] unknown type 120
** 000018: [1532220240] unknown type 16
** 000020: [1376873221] unknown type 68
** 000028: [-2112896928] unknown type 127
** 000030: [540227774] unknown type 103
** 000038: [-2035907148] unknown type 181
** 000040: [-540856350] unknown type 203
** 000048: [664256216] unknown type 76
** 000050: [-303178947] unknown type 167
** 000058: [-67639080] unknown type 235
** 000060: [-829191105] unknown type 101
** 000068: [952067277] unknown type 106
** 000070: [1035640857] unknown type 249
** 000078: [1193395797] unknown type 250
** 000080: [-1891171426] unknown type 253
** 000088: [1054680906] unknown type 13
** 000090: [-1946176425] unknown type 147
** 000098: [1994086812] unknown type 77
** message format error (invalid field size -602834665 at offset 0x0000A0)

In the columns on the dci i have QueueNames and MessagesReady, I have tried all sorts of combinations for type, both string, queuename as string and messagesready as int. When i let the columns auto populate by running the query from the columns box it auto selected them both as int.
I also have the setting to 60000 to allow the script command to complete in the policy

MHdby

debug level of 6 in the server config was on. If i grep the log on agent.tunnel I am seeing some of these but not sure how to interpret it

2019.03.06 09:41:56.638 *D* [agent.tunnel.99697 ] Communication error (MSGRECV_COMM_FAILURE)
2019.03.06 09:41:56.638 *D* [agent.tunnel.99697 ] Tunnel unregistered
2019.03.06 09:41:56.638 *D* [agent.tunnel.99697 ] Receiver thread stopped
2019.03.06 09:41:56.638 *D* [agent.tunnel.99697 ] Tunnel shutdown
2019.03.06 09:41:56.638 *D* [agent.tunnel.99697 ] Tunnel destroyed
2019.03.06 09:41:56.664 *D* [agent.tunnel.24253 ] Received message CMD_CHANNEL_DATA
2019.03.06 09:41:56.672 *D* [agent.tunnel.4921 ] Received message CMD_CHANNEL_DATA
2019.03.06 09:41:56.673 *D* [agent.tunnel.4063 ] Received message CMD_CHANNEL_DATA
2019.03.06 09:41:56.674 *D* [agent.tunnel.4841 ] Received message CMD_CHANNEL_DATA
2019.03.06 09:41:56.675 *D* [agent.tunnel.14940 ] Received message CMD_CHANNEL_DATA
2019.03.06 09:41:56.675 *D* [agent.tunnel.4096 ] Received message CMD_CHANNEL_DATA
2019.03.06 09:41:56.675 *D* [agent.tunnel.4883 ] Received message CMD_CHANNEL_DATA
2019.03.06 09:41:56.676 *D* [agent.tunnel.4885 ] Received message CMD_CHANNEL_DATA
2019.03.06 09:41:56.677 *D* [agent.tunnel.4884 ] Received message CMD_CHANNEL_DATA
2019.03.06 09:41:56.680 *D* [agent.tunnel.934 ] Received message CMD_CHANNEL_DATA
2019.03.06 09:41:56.682 *D* [agent.tunnel ] SetupTunnel(<public IP here>): Agent certificate not provided
2019.03.06 09:41:56.682 *D* [agent.tunnel.99698 ] Tunnel started
2019.03.06 09:41:56.682 *D* [agent.tunnel.99698 ] Tunnel closed by peer
2019.03.06 09:41:56.682 *D* [agent.tunnel.99698 ] Tunnel unregistered
2019.03.06 09:41:56.682 *D* [agent.tunnel.99698 ] Receiver thread stopped
2019.03.06 09:41:56.682 *D* [agent.tunnel.99698 ] Tunnel shutdown
2019.03.06 09:41:56.682 *D* [agent.tunnel.99698 ] Tunnel destroyed

I'm also seeing
2019.03.06 09:42:05.713 *D* [agent.tunnel.6 ] Received message CMD_CHANNEL_DATA
2019.03.06 09:42:05.714 *D* [agent.tunnel.4920 ] Received message CMD_CHANNEL_DATA
2019.03.06 09:42:05.757 *D* [agent.tunnel ] SetupTunnel(<public ip here>): Agent certificate not provided
2019.03.06 09:42:05.757 *D* [agent.tunnel.99699 ] Tunnel started
2019.03.06 09:42:05.757 *D* [agent.tunnel.99699 ] Tunnel closed by peer
2019.03.06 09:42:05.757 *D* [agent.tunnel.99699 ] Tunnel unregistered
2019.03.06 09:42:05.757 *D* [agent.tunnel.99699 ] Receiver thread stopped
2019.03.06 09:42:05.758 *D* [agent.tunnel.99699 ] Tunnel shutdown
2019.03.06 09:42:05.758 *D* [agent.tunnel.99699 ] Tunnel destroyed
2019.03.06 09:42:05.767 *D* [agent.tunnel.18996 ] Received message CMD_KEEPALIVE
2019.03.06 09:42:05.768 *D* [agent.tunnel.18996 ] Sending message CMD_KEEPALIVE
2019.03.06 09:42:05.779 *D* [agent.tunnel.6 ] Received message CMD_CHANNEL_DATA
2019.03.06 09:42:05.844 *D* [agent.tunnel.6 ] Received message CMD_CHANNEL_DATA
2019.03.06 09:42:05.912 *D* [agent.tunnel.6 ] Received message CMD_CHANNEL_DATA

MHdby

I have an agent tunnel on a remote site that, from what I can see in the agent log seems to be connecting. I see the node in the agent tunnel manager, but when i create and bind, it remains unbound and has a ? on the icon in infrastructure services. I do have other nodes from other sites that are working. I suspect this is related to something with the network the remote site has but I dont know what to request from them to allow through.
I redacted some info with x's
2019.03.01 17:48:26.326 *D* Trying to bind on 0.0.0.0:4700
2019.03.01 17:48:26.326 *D* Trying to bind on [::]:4700
2019.03.01 17:48:26.326 *D* Session agent connector disabled
2019.03.01 17:48:26.326 *I* Listening on socket 0.0.0.0:4700
2019.03.01 17:48:26.326 *D* Database writer thread started
2019.03.01 17:48:26.327 *I* Listening on socket [::]:4700
2019.03.01 17:48:26.327 *D* NamedPipeListener(nxagentd.push): waiting for connection
2019.03.01 17:48:26.327 *D* [tunnel ] Tunnel manager started
2019.03.01 17:48:26.330 *D* [tunnel ] xxxxxx: Certificate and private key loaded
2019.03.01 17:48:26.554 *D* [tunnel ] xxxxxx: Server certificate subject is /C=xx/ST=xx/O=xxxxx/OU=xxxx/CN=xxxx/[email protected]
2019.03.01 17:48:26.554 *D* [tunnel ] xxxxxx: Server certificate issuer is /C=xx/ST=xx/O=xxxxx/OU=xxxx/CN=xxxx/[email protected]
2019.03.01 17:48:26.554 *D* [VCS-1] Requesting parameter "System.PlatformName"
2019.03.01 17:48:26.554 *D* [VCS-1] Requesting parameter "System.UName"
2019.03.01 17:48:26.554 *D* [tunnel ] xxxxxx: Sending message CMD_SETUP_AGENT_TUNNEL
2019.03.01 17:48:26.616 *D* [tunnel ] xxxxxx: Received message CMD_REQUEST_COMPLETED
2019.03.01 17:48:26.616 *I* Tunnel with xxxxxxx established
2019.03.01 17:48:26.616 *D* [tunnel ] xxxxxx: Tunnel is active
2019.03.01 17:48:27.328 *I* NetXMS Agent started
2019.03.01 17:48:56.616 *D* [tunnel ] 24.172.241.174: Sending message CMD_KEEPALIVE
2019.03.01 17:48:56.677 *D* [tunnel ] 24.172.241.174: Received message CMD_KEEPALIVE
2019.03.01 17:49:26.677 *D* [tunnel ] 24.172.241.174: Sending message CMD_KEEPALIVE
2019.03.01 17:49:26.738 *D* [tunnel ] 24.172.241.174: Received message CMD_KEEPALIVE
2019.03.01 17:49:56.738 *D* [tunnel ] 24.172.241.174: Sending message CMD_KEEPALIVE
2019.03.01 17:49:56.799 *D* [tunnel ] 24.172.241.174: Received message CMD_KEEPALIVE

From the server log im getting
2019.03.01 13:12:15.847 *D* [poll.manager ] Node 451 "xxxx" queued for status poll
2019.03.01 13:12:15.847 *D* [poll.status ] Starting status poll for node xxxx (ID: 451)
2019.03.01 13:12:15.847 *D* StatusPoll(xxxx [451]): unable to get system uptime
2019.03.01 13:12:15.847 *D* Finished status poll for node xxxx (ID: 451)

force full config check
2019.03.01 13:16:05.682 *D* [client.session.1 ] Sending message CMD_POLLING_INFO (96 bytes)
2019.03.01 13:16:05.682 *D* [client.session.1 ] Sending compressed message CMD_POLLING_INFO (112 bytes)
2019.03.01 13:16:05.682 *D* [poll.conf ] Starting configuration poll for node xxxx (ID: 451)
2019.03.01 13:16:05.682 *D* [client.session.1 ] Sending message CMD_POLLING_INFO (88 bytes)
2019.03.01 13:16:05.686 *D* [client.session.1 ] Sending message CMD_POLLING_INFO (112 bytes)
2019.03.01 13:16:05.687 *D* [poll.conf ] ConfPoll(xxxx): checking for NetXMS agent Flags={01000000} DynamicFlags={00040400}
2019.03.01 13:16:05.687 *D* [client.session.1 ] Sending message CMD_POLLING_INFO (104 bytes)
2019.03.01 13:16:05.687 *D* [client.session.1 ] Sending compressed message CMD_POLLING_INFO (128 bytes)
2019.03.01 13:16:05.687 *D* [poll.conf ] ConfPoll(xxxx): node primary IP is invalid and there are no active tunnels
2019.03.01 13:16:05.687 *D* [client.session.1 ] Sending message CMD_POLLING_INFO (104 bytes)
2019.03.01 13:16:05.687 *D* [client.session.1 ] Sending message CMD_POLLING_INFO (120 bytes)
2019.03.01 13:16:05.687 *D* [client.session.1 ] Sending message CMD_POLLING_INFO (128 bytes)
2019.03.01 13:16:05.687 *D* [poll.conf ] Node::updateInterfaceConfiguration(xxxx [451]): Unable to get interface list from node
2019.03.01 13:16:05.687 *D* [poll.conf ] Node::updateInterfaceConfiguration(xxxx [451]): pIfList == NULL, dwCount = 0
2019.03.01 13:16:05.687 *D* Checking subnet bindings for node xxxx [451]
2019.03.01 13:16:05.687 *D* [client.session.1 ] Sending message CMD_POLLING_INFO (128 bytes)
2019.03.01 13:16:05.687 *D* [client.session.1 ] Sending message CMD_POLLING_INFO (88 bytes)
2019.03.01 13:16:05.687 *D* [client.session.1 ] Sending message CMD_POLLING_INFO (80 bytes)
2019.03.01 13:16:05.688 *D* [poll.conf ] ConfPoll(xxxx): detected node type: 0 (Unknown)
2019.03.01 13:16:05.688 *D* [client.session.1 ] Sending compressed message CMD_POLLING_INFO (112 bytes)
2019.03.01 13:16:05.688 *D* [client.session.1 ] Sending compressed message CMD_POLLING_INFO (112 bytes)
2019.03.01 13:16:05.688 *D* Finished configuration poll for node xxxx (ID: 451)
2019.03.01 13:16:05.688 *D* [client.session.1 ] Sending message CMD_POLLING_INFO (32 bytes)

NetXMS Forum

MHdby

Posts