0001526: Unable to restore from WEBUI SQL error

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.

Limp 2023-03-20 09:11 reporter ~0004911	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;

bruno-at-bareos 2023-03-21 16:13 manager ~0004913	the script grant-bareos-database is mandatory to be run on install and upgrade.

bruno-at-bareos 2023-03-21 16:14 manager ~0004914	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	Note Added: 0004914