-
Type:
Incident report
-
Resolution: Duplicate
-
Priority:
Major
-
None
-
Affects Version/s: 3.2.0, 3.2.1
-
Component/s: Proxy (P), Server (S)
-
None
-
Environment:Server: Centos 7
Proxy: 6
Database beeing accessed via ODBC: postgresql-9.2.15-1.el7_2.x86_64
ODBC version on Proxy: unixODBC-2.2.14-14.el6.i686, postgresql-odbc-08.04.0200-1.el6.x86_64
I had an ODBC discovery configured this way:
db.odbc.discovery[{$BAREOS_DBDSN}.discovery,{$BAREOS_DBDSN}]
Query: select name as client,clientid from client;
Discovered items:
db.odbc.select[{$BAREOS_DBDSN}.{#CLIENT}.jobstatus,{$BAREOS_DBDSN}]
Query: select jobstatus from job where clientid={#CLIENTID} and type='B' order by endtime desc limit 1;
After upgrading to 3.2.0 all the discovered items went unsupported with the following error:
Cannot execute ODBC query:[SQL_ERROR]:[07002][32][The # of binded parameters < the # of parameter markers]|
odbc.ini is configured this way:
[bareos-srvbkp] Description = PostgreSQL connection to XXXXXXX Driver = PostgreSQL Database = bareos Servername = 10.254.99.100 UserName = bareos Password = XXXXXXX Port = 5432 #Protocol = 9.3 ReadOnly = No RowVersioning = No ShowSystemTables = No ConnSettings =
- duplicates
-
-
- Closed
-