View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001526 | bareos-core | webui | public | 2023-03-16 11:39 | 2023-03-21 16:14 |
Reporter | Limp | Assigned To | bruno-at-bareos | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | no change required | ||
Platform | Linux | OS | RHEL (and clones) | OS Version | 9 |
Summary | 0001526: Unable to restore from WEBUI SQL error | ||||
Description | Hello! Have a problem with a bareos-webui version: 22.0.2~pre10.81f8d3b2b i've tried to restore via bconsole and it works.... it always reports the error: Query failed: SELECT JobId, FileIndex FROM b2000277986 ORDER BY JobId, FileIndex ASC . ERR=Query failed: SELECT JobId, FileIndex FROM b2000277986 ORDER BY JobId, FileIndex ASC : ERR=OSHIBKA: otnoshenie "b2000277986" ne sushhestvuet СТРОКА 1: SELECT JobId, FileIndex FROM b2000277986 ORDER BY JobId, Fil... ^ No table found: b2000277986 No files selected to be restored. How to deal with it? Any log for web? because i cannot see any error from bconsole or other logs... thanks in advance! | ||||
Steps To Reproduce | just create a restore job via WebUI. Via bconsole works | ||||
Tags | No tags attached. | ||||
bareos-master: impact | no | ||||
bareos-master: action | none | ||||
bareos-19.2: impact | |||||
bareos-19.2: action | |||||
bareos-18.2: impact | |||||
bareos-18.2: action | |||||
bareos-17.2: impact | |||||
bareos-17.2: action | |||||
bareos-16.2: impact | |||||
bareos-16.2: action | |||||
bareos-15.2: impact | |||||
bareos-15.2: action | |||||
bareos-14.2: impact | |||||
bareos-14.2: action | |||||
bareos-13.2: impact | |||||
bareos-13.2: action | |||||
bareos-12.4: impact | |||||
bareos-12.4: action | |||||
please close ticket. Seems to be that user has no permissions to create TEMP tables. su - postgres psql ALTER DATABASE bareos OWNER TO bareos; ALTER ROLE bareos SUPERUSER; \l GRANT TEMPORARY on DATABASE bareos to bareos; |
|
the script grant-bareos-database is mandatory to be run on install and upgrade. | |
wrong grant on db | |
Date Modified | Username | Field | Change |
---|---|---|---|
2023-03-16 11:39 | Limp | New Issue | |
2023-03-20 09:11 | Limp | Note Added: 0004911 | |
2023-03-21 16:13 | bruno-at-bareos | Note Added: 0004913 | |
2023-03-21 16:14 | bruno-at-bareos | Assigned To | => bruno-at-bareos |
2023-03-21 16:14 | bruno-at-bareos | Status | new => closed |
2023-03-21 16:14 | bruno-at-bareos | Resolution | open => no change required |
2023-03-21 16:14 | bruno-at-bareos | bareos-master: impact | => no |
2023-03-21 16:14 | bruno-at-bareos | bareos-master: action | => none |
2023-03-21 16:14 | bruno-at-bareos | Note Added: 0004914 |