[ZBX-25324] MSSQL ODBC driver special password syntax required Created: 2024 Sep 30  Updated: 2024 Nov 21  Resolved: 2024 Nov 07

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Proxy (P), Server (S)
Affects Version/s: None
Fix Version/s: 6.0.36rc1, 6.4.20rc1, 7.0.6rc1, 7.2.0beta1

Type: Problem report Priority: Trivial
Reporter: Sergejs Boidenko Assignee: Sergejs Boidenko
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: Text File 0001-.S.-ZBX-25324-fixed-FreeTDS-ODBC-login-with-special-.patch    
Issue Links:
Duplicate
Team: Team A
Sprint: S24-W40/41, S24-W42/43, S24-W44/45
Story Points: 0.5

 Description   

Response from customer:
Before upgrade to 6.4.19 - yes it worked when you entered the password directly with braces and a semi colon. Also worked if the macro for the password was updated with the braces around it and a semi colon. With just the password in the ui (without braces and a semi colon) it would fail with integrated authentication.

After upgrade to 6.4.19 - correct the workaround (entering password field with braces and a semi colon at the end) or leaving the password field without modification both fail with Integrated authentication failure

Think i mentioned below but if not - isql behaves similar that if I add a semicolon at the end it works (with special character wrapped in braces).

as_vzfxfb@pwcppvwzbx001:~$ isql -v -k 'Driver=FreeTDS;Server=XXX;Port=1433;Database=FlexNet;TrustServerCertificate=yes;TrustServerCertificate=yes;UID=pwc\svc_mfg_app_mon;PWD={Zj;Fp&f`2BjWIX|YhWC9*PS!$c0obJR5}'
[S1000][FreeTDS][SQL Server]Unable to connect to data source
[37000][FreeTDS][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.
[ISQL]ERROR: Could not SQLDriverConnect


as_vzfxfb@pwcppvwzbx001:~$ isql -v -k 'Driver=FreeTDS;Server=XXX;Port=1433;Database=FlexNet;TrustServerCertificate=yes;TrustServerCertificate=yes;UID=pwc\svc_mfg_app_mon;PWD={Zj;Fp&f`2BjWIX|YhWC9*PS!$c0obJR5};'
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> quit

 

 

 Comments   
Comment by Sergejs Boidenko [ 2024 Oct 28 ]

Available in versions:

Generated at Mon Mar 31 18:45:16 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.