[ZBX-23705] Monitor Mysql with ODBC gives the SSL Error Created: 2023 Nov 14  Updated: 2024 May 27  Resolved: 2023 Nov 15

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Problem report Priority: Trivial
Reporter: Furqan Ahmed Assignee: Zabbix Support Team
Resolution: Commercial support required Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File image-2023-12-12-23-38-13-034.png    
Issue Links:
Sub-task

 Description   

Steps to reproduce:

  1. Cannot connect to ODBC DSN: [SQL_ERROR]:[HY000][2026][[unixODBC][MySQL][ODBC 8.2(w) Driver]SSL connection error: No such file or directory]

This error occur when i check on zabbix but on direct ODBC works fine



 Comments   
Comment by Edgar Akhmetshin [ 2023 Nov 15 ]

This error occur when i check on zabbix but on direct ODBC works fine

Check with isql connection with user used to run Zabbix Server/Proxy process:

sudo -H -u zabbix bash -c 'isql -vvv DNS USERNAME PASSWORD'

Cannot connect to ODBC DSN: [SQL_ERROR]:[HY000][2026][[unixODBC][MySQL][ODBC 8.2(w) Driver]SSL connection error: No such file or directory]

This is a misconfiguration on a UnixODBC/MySQL driver level which should be fixed by MySQL DBA or Linux/Systems engineer.

Please be advised that this section of the tracker is for bug reports only. The case you have submitted can not be qualified as one, so please reach out to [email protected] for commercial support (https://zabbix.com/support) or consultancy services. Alternatively, you can also use our IRC channel or community forum (https://www.zabbix.com/forum) for assistance. With that said, we are closing this ticket. Thank you for understanding.

Comment by Eric Tang [ 2023 Dec 12 ]

I had same problem. I had checked with isql connection in Zabbix Server, and it worked. But in Zabbix webpage, it failed. Like below

My version is 6.0.22

Generated at Sun May 11 07:57:34 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.