Dear Larry,
In message <b03b1499f80214ce34e13911f0e3a...@lerctr.org> you wrote:
>
> > Are you using the most recent version of bconsole?
The most recent one that is available for Fedora 34, i. e.
bacula-director-11.0.5-1.fc34.x86_64
> > *restore
...
I can do restores similar to this fine.
The problem comes with the "query" command,
For example:
*query
Available queries:
1: List up to 20 places where a File is saved regardless of the directory
2: List where the most recent copies of a file are saved
3: List last 20 Full Backups for a Client
4: List all backups for a Client after a specified time
5: List all backups for a Client
6: List Volume Attributes for a selected Volume
7: List Volumes used by selected JobId
8: List Volumes to Restore All Files
9: List Pool Attributes for a selected Pool
10: List total files/bytes by Job
11: List total files/bytes by Volume
12: List Files for a selected JobId
13: List Jobs stored on a selected MediaId
14: List Jobs stored for a given Volume name
15: List Volumes Bacula thinks are in changer
16: List Volumes likely to need replacement from age or errors
17: List Volumes Bacula thinks are eligible for the changer
18: List Volumes by Volume:
19: List Volumes by Jobs:
20: List Volumes for a jobname:
Choose a query (1-20): 2
Enter path with trailing slash: /ssd/mail/
Enter filename: inbox
Enter Client name: gemini-fd
Query failed: ERROR: relation "filename" does not exist
LINE 1: ...ame,Client.Name AS ClientName FROM Job,File,Path,Filename,M...
^
SELECT DISTINCT Job.JobId,StartTime AS JobStartTime,VolumeName,Client.Name AS
ClientName FROM Job,File,Path,Filename,Media,JobMedia,Client WHERE
File.JobId=Job.JobId AND File.FileIndex > 0 AND Path.Path='/ssd/mail/' AND
Filename.Name='inbox' AND Client.Name='gemini-fd' AND Path.PathId=File.PathId
AND Filename.FilenameId=File.FilenameId AND JobMedia.JobId=Job.JobId AND
JobMedia.MediaId=Media.MediaId AND Client.ClientId=Job.ClientId ORDER BY
Job.StartTime DESC LIMIT 5;
I start to wonder if this is a problem with my database, or rather a
problem with /etc/bacula/query.sql ? I copied the one from
/usr/share/doc/bacula-director/sample-query.sql unchanged ...
Or this:
...
Choose a query (1-20): 12
Enter JobId: 92777
Query failed: ERROR: relation "filename" does not exist
LINE 1: SELECT Path.Path,Filename.Name FROM File,Filename,Path WHERE...
^
SELECT Path.Path,Filename.Name FROM File,Filename,Path WHERE File.JobId=92777
AND File.FileIndex > 0 AND Filename.FilenameId=File.FilenameId AND
Path.PathId=File.PathId ORDER BY Path.Path,Filename.Name;
Is this working for you?
Best regards,
Wolfgang Denk
--
DENX Software Engineering GmbH, Managing Director: Wolfgang Denk
HRB 165235 Munich, Office: Kirchenstr.5, D-82194 Groebenzell, Germany
Phone: (+49)-8142-66989-10 Fax: (+49)-8142-66989-80 Email: w...@denx.de
You see things; and you say ``Why?'' But I dream things that never
were; and I say ``Why not?''
- George Bernard Shaw _Back to Methuselah_ (1921) pt. 1, act 1
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
