-
Type:
Problem report
-
Resolution: Unresolved
-
Priority:
Major
-
Affects Version/s: 7.0.20
-
Component/s: Proxy (P), Server (S)
-
Environment:AlmaLinux release 8.9
unixODBC-2.3.7-1.el8.x86_64
postgresql-odbc-10.03.0000-3.el8_6.x86_64
postgresql-server-13.14-1.module_el8.9.0+3815+0bfda440.alma.1.x86_64
postgresql-13.14-1.module_el8.9.0+3815+0bfda440.alma.1.x86_64
-
Prev.Sprint, S25-W50/51/52/01, S26-W04/05, S26-W06/07, S26-W08/09, S26-W10/11, S26-W12/13, S26-W18/19
-
1
Two issues are observed with password handling in ODBC connections.
According to the documentation, starting from Zabbix 7.0.3, passwords should be accepted both with and without curly braces {} in DSN and connection string configurations.
In practice, authentication behavior varies depending on the presence of "{}".
Details:
- When using a DSN, authentication fails only if the password field includes "{}".
(Authentication succeeds when "{}" are omitted.) - When using a connection string, authentication fails if the password field does not include {}, despite documentation stating that "{}" are optional.
db.odbc.select[<unique short description>,<dsn>,<connection string>]
| Parameter | Web interface password field | Password in connection string | Credentials in odbc.ini (different user due to escape issue) | Result |
|---|---|---|---|---|
| dsn | empty | – | configured | OK |
| dsn | without {} | – | configured | OK |
| dsn | with {} | – | configured | × Comments: authentication fails when {} is present; works fine without. |
| connection string | empty | with {} | configured | OK |
| connection string | without {} | with {} | configured | × Comments: documentation says {} optional, but authentication fails. |
| connection string | with {} | with {} | configured | OK |
| connection string | empty | without {} | configured | × |
| connection string | without {} | without {} | configured | × Comments: documentation says {} optional, but authentication fails. |
| connection string | with {} | without {} | configured | OK |
| both | empty | with {} | configured | OK |
| both | without {} | with {} | configured | × Comments: documentation says {} optional, but authentication fails. |
| both | with {} | with {} | configured | OK |
| both | empty | without {} | configured | × |
| both | without {} | without {} | configured | × Comments: documentation says {} optional, but authentication fails. |
| both | with {} | without {} | configured | OK |
- caused by
-
-
- Closed
-
