NetXMS Support Forum

English Support => General Support => Topic started by: aron on August 06, 2012, 05:13:03 PM

Title: ODBC.Nxagentd: 1.2.2
Post by: aron on August 06, 2012, 05:13:03 PM
Hello

Unfortunately we are experiencing a problem with Nxagentd on a windows server. The agent will run successfully however at the moment the ODBC subagent seems to stop after around 12 hours or so. The log is reporting;

[06-Aug-2012 14:57:43] ODBC connect error: Failed to set ODBC version ([MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '10.30.0.151' (10060))
[06-Aug-2012 14:57:49] ODBC connect error: Failed to set ODBC version ([MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '10.30.0.151' (10060))
[06-Aug-2012 14:57:54] ODBC connect error: Failed to set ODBC version ([MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '10.30.0.151' (10060))
[06-Aug-2012 14:57:55] ODBC connect error: Failed to set ODBC version ([MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '10.30.0.151' (10060))
[06-Aug-2012 14:57:57] ODBC connect error: Failed to set ODBC version ([MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '10.30.0.151' (10060))
[06-Aug-2012 14:57:57] ODBC connect error: Failed to set ODBC version ([MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '10.30.0.151' (10060))
[06-Aug-2012 14:57:59] ODBC connect error: Failed to set ODBC version ([MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on '10.30.0.151' (10060))

If you go into the ODBC and test connection the test reports as succesfull. The NXAgent is working successfully for all other probes that is configure to be done (LogWatch, Ping, etc). Restart of the Nxagent service sucessfully resolves the issue until the same error will return.

Regards

Aron
Title: Re: ODBC.Nxagentd: 1.2.2
Post by: Victor Kirhenshtein on August 16, 2012, 12:02:31 PM
Hi!

I suppose that connection to server was dropped by timeout or due to some other reason, and ODBC subagent does not reconnect. I'll check it.

Best regards,
Victor