NetXMS Support Forum

Log:
2025.08.01 12:09:09.879 *D* [nc                 ] SendNotification: sending message to "[email protected]" via channel "Mailgun"
2025.08.01 12:09:09.879 *D* [nc                 ] Message to "[email protected]" via channel "Mailgun" dequeued
2025.08.01 12:09:09.879 *D* [ncd.smtp           ] Sending mail with url="smtp://smtp.mailgun.org:25", to="[email protected]", subject="subject4", login="[email protected]"
2025.08.01 12:09:53.415 *D* [ncd.smtp           ] Call to curl_easy_perform("smtp://smtp.mailgun.org:25") failed (56: response reading failed (errno: 0))
2025.08.01 12:09:53.415 *D* [nc                 ] Driver error for channel "Mailgun", retrying in 30 seconds, 2 retries left
2025.08.01 12:10:23.415 *D* [ncd.smtp           ] Sending mail with url="smtp://smtp.mailgun.org:25", to="[email protected]", subject="subject4", login="[email protected]"
2025.08.01 12:11:04.017 *D* [ncd.smtp           ] Call to curl_easy_perform("smtp://smtp.mailgun.org:25") failed (56: response reading failed (errno: 0))
2025.08.01 12:11:04.018 *D* [nc                 ] Driver error for channel "Mailgun", retrying in 30 seconds, 1 retries left
2025.08.01 12:11:34.019 *D* [ncd.smtp           ] Sending mail with url="smtp://smtp.mailgun.org:25", to="[email protected]", subject="subject4", login="[email protected]"
2025.08.01 12:11:35.754 *D* [ncd.smtp           ] Call to curl_easy_perform("smtp://smtp.mailgun.org:25") failed (67: Login denied)
2025.08.01 12:11:35.754 *D* [nc                 ] Driver error for channel "Mailgun", message dropped

Driver configuration:
Server=smtp.mailgun.org
Port=25
LocalHostName=localhost
TLSMode=NONE
[email protected]
[email protected]
Password=<password>
MailEncoding=utf8
IsHTML=no

I'm using version 4.5.0

I've created an SMTP notification channel with below parameters:
Server=smtp.mailgun.org
RetryCount=1
Port=25
TLSMode=NONE
LocalHostName=localhost
FromName= xxx.mailgun.org
FromAddr=xxx.mailgun.org
Password=<password given by Mailgun>
MailEncoding=utf8
IsHTML=no

I get Status=Failure, Error message=Driver error in Send Notification test. Mailgun parameters are OK. I have tested email delivery using Windows PowerShell.

Please help.

Solution was to increase the Agent.CommandTimeout value 

The Query does not run from the DCI Parameter Selection form too. But it runs and gives output from nxget.

Origin : NetXMS Agent
Metric : query4(1)
There's no transformation.

I think it has got something to do with query running time. If I simplify the select query then I do get output in the GUI.

It is giving correct output

C:\NetXMS\bin>nxget 10.14.50.30 query4(1)
90.7

I'm using v4.5.0
I have a query in agent configuration file which I'm polling in a DCI. It always gives <<ERROR>> output value. However, from the agent log below, I found that the query is indeed returning the intended output.

2025.03.25 12:35:53.413 *D* [comm.cs.1          ] Message dump:
  ** 000000 | 00 41 50 00 00 00 00 28 00 00 00 E0 00 00 00 01 | .AP....(........
  ** 000010 | 00 00 00 55 07 00 00 00 00 00 00 09 71 75 65 72 | ...U........quer
  ** 000020 | 79 34 28 31 29 00 00 00                        | y4(1)...
  ** code=0x0041 (CMD_GET_PARAMETER) version=5 flags=0x0000 id=224 size=40 numFields=1
  ** 000000: [    85] UTF8-STRING "query4(1)"

2025.03.25 12:35:53.413 *D* [comm.cs.1          ] Received message CMD_GET_PARAMETER (224)
2025.03.25 12:35:53.413 *D* [comm.cs.1          ] Requesting metric "query4(1)"
2025.03.25 12:35:55.015 *D* [db.query          ] Long running query: "MY SELECT QUERY" [5602 ms]
2025.03.25 12:35:55.015 *D* [comm.cs.1          ] GetMetricValue("query4(1)"): 0 (SUCCESS) value = "88.78"
2025.03.25 12:35:55.015 *D* [dbquery            ] H_DirectQueryConfigurable: Executing query "MY SELECT QUERY" in database "kmrcldb"
2025.03.25 12:35:55.015 *D* [comm.cs.1          ] Sending message CMD_REQUEST_COMPLETED (ID 222; size 56; uncompressed)
2025.03.25 12:35:55.015 *D* [comm.cs.1          ] Outgoing message dump:
  ** 000000 | 00 1D 50 00 00 00 00 38 00 00 00 DE 00 00 00 02 | ..P....8........
  ** 000010 | 00 00 00 1C 00 00 00 00 00 00 00 00 00 00 00 00 | ................
  ** 000020 | 00 00 00 15 07 00 00 00 00 00 00 05 38 38 2E 37 | ............88.7
  ** 000030 | 38 00 00 00 00 00 00 00                        | 8.......
  ** code=0x001D (CMD_REQUEST_COMPLETED) version=5 flags=0x0000 id=222 size=56 numFields=2
  ** 000000: [    28] INT32      0
  ** 000010: [    21] UTF8-STRING "88.78"

It is working now with below config:

ID = DB1
Name = <IPADDRESS>:<PORT NUMBER>/<SERVICE NAME>
Username = dbuser
Password = mypass123

Thanks for the '--with-oracle' suggestion. It worked.
Now, Oracle.DBInfo.IsReachable(DB1) is coming NO

SubAgent = oracle.nsm
[ORACLE]
ID = DB1
Name = TEST
Username = dbuser
Password = "mypass123"
I also tried below config but that didn't work either.
Select
SubAgent = oracle.nsm
[ORACLE]
ID = DB1
TnsName = TEST
Username = dbuser
Password = "mypass123"
I gave full connection string as below. Also didn't work.
Select
SubAgent = oracle.nsm
[ORACLE]
ID = DB1
Name = dbuser@//localhost:1521/TEST
Username = dbuser
Password = "mypass123"
2024.05.28 15:16:46.285 *D* [comm.cs.1          ] Requesting metric "Oracle.DBInfo.IsReachable(DB1)"
2024.05.28 15:16:46.285 *D* [comm.cs.1          ] GetMetricValue("Oracle.DBInfo.IsReachable(DB1)"): 0 (SUCCESS) value = "NO"
2024.05.28 15:16:46.285 *D* [comm.cs.1          ] Outgoing message dump:
  ** 000000 | 00 1D 50 00 00 00 00 30 00 00 05 3E 00 00 00 02 | ..P....0...>....
  ** 000010 | 00 00 00 1C 00 00 00 00 00 00 00 00 00 00 00 00 | ................
  ** 000020 | 00 00 00 15 07 00 00 00 00 00 00 02 4E 4F 00 00 | ............NO..
  ** code=0x001D (CMD_REQUEST_COMPLETED) version=5 flags=0x0000 id=1342 size=48 numFields=2
  ** 000000: [    28] INT32       0
  ** 000010: [    21] UTF8-STRING "NO"
Is there any difference between the INI formats of 4.5.0 and 5.x ? Id or ID? TnsName or Name?
Can't find Administration Guide for old versions.

In version 4.5.0 Oracle subagent is not getting loaded. Agent config file is as below:

SubAgent = oracle.nsm
[ORACLE]
ID = DB1
Name = TEST
Username = dbuser
Password = "mypass123"
2024.05.23 11:25:27.629 *I* [db.drv            ] Database driver "sqlite.ddr" loaded and initialized successfully
2024.05.23 11:25:27.637 *I* [db.agent          ] Local database opened successfully
2024.05.23 11:25:27.637 *I* [startup            ] Agent ID is fe5c6553-04d2-4303-b702-f51d3befdbf2
2024.05.23 11:25:27.638 *I* [startup            ] Local host name is "RAC1.kmrcl.in"
2024.05.23 11:25:27.638 *I* [startup            ] Using system name "rac1"
2024.05.23 11:25:27.639 *I* [startup            ] Arbitrary command execution disabled
2024.05.23 11:25:28.642 *I* [linux              ] Unable to parse /proc/drbd, DRBD data collector will not start
2024.05.23 11:25:28.647 *I* [subagents          ] Subagent "Linux" (/usr/local/lib/netxms/linux.nsm) loaded successfully (version 4.5.0)
2024.05.23 11:25:28.647 *E* [subagents          ] Error loading subagent module "oracle.nsm" (/usr/local/lib/netxms/oracle.nsm: cannot open shared object file: No such file or directory)
2024.05.23 11:25:28.647 *E* [subagents          ] Error loading subagent module "netsvc.nsm" (/usr/local/lib/netxms/netsvc.nsm: cannot open shared object file: No such file or directory)

There's no oracle.ddr in /usr/local/lib/netxms/dbdrv/ ; only sqlite.ddr is there.
In /usr/local/lib/netxms netsvc.nsm is also missing.

Please help.

No error in MariaDB...

2024-05-13 16:46:02 0 [Note] C:\Program Files\MariaDB 10.4\bin\mysqld.exe (initiated by: unknown): Normal shutdown
2024-05-13 16:46:02 0 [Note] Event Scheduler: Purging the queue. 0 events
2024-05-13 16:46:02 0 [Note] InnoDB: FTS optimize thread exiting.
2024-05-13 16:46:02 0 [Note] InnoDB: Starting shutdown...
2024-05-13 16:46:02 0 [Note] InnoDB: Dumping buffer pool(s) to C:\Program Files\MariaDB 10.4\data\ib_buffer_pool
2024-05-13 16:46:02 0 [Note] InnoDB: Instance 0, restricted to 16054 pages due to innodb_buf_pool_dump_pct=25
2024-05-13 16:46:02 0 [Note] InnoDB: Buffer pool(s) dump completed at 240513 16:46:02
2024-05-13 16:46:04 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-05-13 16:46:04 0 [Note] InnoDB: Shutdown completed; log sequence number 12673536826768; transaction id 626221754
2024-05-13 16:46:04 0 [Note] C:\Program Files\MariaDB 10.4\bin\mysqld.exe: Shutdown complete

2024-05-13 16:46:04 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-05-13 16:46:04 0 [Note] InnoDB: Uses event mutexes
2024-05-13 16:46:04 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-05-13 16:46:04 0 [Note] InnoDB: Number of pools: 1
2024-05-13 16:46:04 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-05-13 16:46:04 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2024-05-13 16:46:04 0 [Note] InnoDB: Completed initialization of buffer pool
2024-05-13 16:46:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-05-13 16:46:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-05-13 16:46:07 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-05-13 16:46:07 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2024-05-13 16:46:07 0 [Note] InnoDB: Waiting for purge to start
2024-05-13 16:46:07 0 [Note] InnoDB: 10.4.25 started; log sequence number 12673536826768; transaction id 626221755
2024-05-13 16:46:07 0 [Note] InnoDB: Loading buffer pool(s) from C:\Program Files\MariaDB 10.4\data\ib_buffer_pool
2024-05-13 16:46:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-05-13 16:46:07 0 [Note] Server socket created on IP: '::'.
2024-05-13 16:46:07 0 [Note] Reading of all Master_info entries succeeded
2024-05-13 16:46:07 0 [Note] Added new Master_info '' to hash table
2024-05-13 16:46:07 0 [Note] C:\Program Files\MariaDB 10.4\bin\mysqld.exe: ready for connections.
Version: '10.4.25-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
2024-05-13 16:46:22 8 [Warning] Aborted connection 8 to db: 'netxms' user: 'netxms' host: 'localhost' (Got an error reading communication packets)
2024-05-13 16:47:00 0 [Note] InnoDB: Buffer pool(s) load completed at 240513 16:47:00
2024-05-13 16:48:20 9 [Warning] Aborted connection 9 to db: 'netxms' user: 'netxms' host: 'localhost' (Got an error reading communication packets)
2024-05-13 16:49:23 10 [Warning] Aborted connection 10 to db: 'netxms' user: 'netxms' host: 'localhost' (Got an error reading communication packets)

I didn't keep a database backup. I don't know what to do now!!

This upgrade has proved to be too costly for me.

Windows event logs have the below MariaDB error:

Aborted connection 40 to db: 'netxms' user: 'netxms' host: 'localhost' (Got an error reading communication packets) 

Do I have to upgrade MariaDB?

Please help in resolving this issue.

I'm facing exactly the same issue. I didn't take database backup so cannot go back to the old schema version either.

Hi,

I upgraded from 4.5.6 to 5.0.2 and NetXMS server refuses to start. I'm using MariaDB 10.4. 

Your database has format version 50.32, but server is compiled for version 50.39

Running  nxdbmgr.exe upgrade has no effect/output either.

C:\NetXMS\bin>nxdbmgr.exe upgrade
NetXMS Database Manager Version 5.0.2 Build 5.0-878-gccaeca5869 (UNICODE)

Upgrading database...
Upgrading from version 50.32 to 50.33

C:\NetXMS\bin>

Please help.

Upgraded to v4.5.6 but the problem with maps persists.