View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0001526bareos-corewebuipublic2023-03-16 11:392023-03-21 16:14
ReporterLimp Assigned Tobruno-at-bareos  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionno change required 
PlatformLinuxOSRHEL (and clones)OS Version9
Summary0001526: Unable to restore from WEBUI SQL error
DescriptionHello!

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 Reproducejust create a restore job via WebUI. Via bconsole works
TagsNo tags attached.
bareos-master: impactno
bareos-master: actionnone
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

Activities

Limp

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

bruno-at-bareos

2023-03-21 16:13

developer   ~0004913

the script grant-bareos-database is mandatory to be run on install and upgrade.
bruno-at-bareos

bruno-at-bareos

2023-03-21 16:14

developer   ~0004914

wrong grant on db

Issue History

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