-
Problem report
-
Resolution: Unresolved
-
Major
-
None
-
7.0.20
-
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
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 |