You can try this version, it fixes some mysql broken stuff
http://bacula.svn.sourceforge.net/viewvc/*checkout*/bacula/trunk/gui/bresto=
re/brestore.pl?revision=3D4356
You have to cleanup your database
drop table brestore_missing_path;
drop table brestore_pathhierarchy;
drop table brestore_pathvisibility;
drop table brestore_knownjobid;
Thanks for your feedback
Bye
Le Dimanche 18 Mars 2007 00:26, Lonny Selinger a =E9crit=A0:
Hi,
Hi Eric :)
Which version of brestore/bacula are you using ?
bacula-2.0.3 and got brestore from bacual-gui of the same version
On Saturday 17 March 2007 02:22, Lonny Selinger wrote:
Still playing around. I managed to get brestore loading etc but I'm
not sure I'm doing it right. I have put brestore.pl and the
brestore.glade file on my Master (director) with the brestore.pl in =
my
cgi-bin
brestore is not a part of bweb. This is a Gtk/Perl application, not a w=
eb
application.
Indeed
I know this but I wasn't sure how the execution happened or how
the install actually took place.
First, you have to read brestore/INSTALL notes, and i think/hope it will
be more clear for you.
ALso what I was hoping for
... I read the README but in the release I
have there is no INSTALL file :/
Here;s the directory listing:
# pwd && ls
/usr/local/src/bacula/bacula-gui-2.0.3/brestore
brestore.console_apps brestore.desktop.consolehelper brestore-fr.glade
brestore.pamd brestore.png README
brestore.desktop brestore.desktop.xsu brestore.glade
brestore.pl COPYING ReleaseNotes
. When
accessing it through bweb it asks what I would like to open the file
with so I used a local copy (on a client) of brestore.pl abd set up
the options there.
It's better like this :)
When I select jobs/restore brestore launches and can make connections
to the database etc but I can't find anything to restore? When I
select a client and pic a backup image and put soemthing like / in t=
he
location nothing shows up.
Could you run brestore in a terminal (like xterm or konsole) and see
output ? (You could also have messages in status bar)
When I run it from a terminal I get the same thing. I can select a client,
I get a full list of backup images and if I put something like / in the
location field and hit enter, nothing happens. On the backend I see this:
ORDER BY 2,3 DESC ) As a
DBD::mysql::st execute failed: Every derived table must have its own alias
at ./brestore.pl line 2463.
DBD::mysql::st fetchall_arrayref failed: fetch() without execute() at
./brestore.pl line 2464.
Bvfs::ls_dirs:2489 $VAR1 =3D [];
Bvfs::ls_files:2394 SELECT File.FilenameId, listfiles.id,
listfiles.Name, File.LStat, File.JobId
FROM
(SELECT Filename.Name, max(File.FileId) as id
FROM File, Filename
WHERE File.FilenameId =3D Filename.FilenameId
AND Filename.Name !=3D ''
AND File.PathId IN (3)
AND File.JobId IN (25)
GROUP BY Filename.Name
ORDER BY Filename.Name) AS listfiles,
File
WHERE File.FileId =3D listfiles.id
Bvfs::ls_files:2395 SELECT File.FilenameId, listfiles.id,
listfiles.Name, File.LStat, File.JobId
FROM
(SELECT Filename.Name, max(File.FileId) as id
FROM File, Filename
WHERE File.FilenameId =3D Filename.FilenameId
AND Filename.Name !=3D ''
AND File.PathId IN (3)
AND File.JobId IN (25)
GROUP BY Filename.Name
ORDER BY Filename.Name) AS listfiles,
File
WHERE File.FileId =3D listfiles.id
Bvfs::ls_files:2396 $VAR1 =3D [];
Bvfs::get_path:2352 Call with pathid =3D 3
Bvfs::get_path:2357 SELECT Path FROM Path WHERE PathId IN (?)
UNION
SELECT Path FROM brestore_missing_path WHERE PathId IN (?)
The first time that you run brestore, it could be long to display files
and directories. Try an other job.
If you turn debug to on in preferences, you can try to execute SQL
queries in a terminal (mysql bacula) and see if you have results.
Here's my config:
DBD Chain: DBI:mysql:database=3Dbacula;host=3D192.168.69.13;port=3D=
3306
Username: bacula
Pass: ******
GladeFile /etc/bacula/brestore.glade
Now these I know are working ... here's the "I'm not too sure part"
Under Bacula Connection:
BSR Destination String:
http://my.director.addy/bweb/cgi-bin/bconsole.pl (the cgi-bin where=
I
have bweb.pl and bconsole.pl on my master)
bconsole command: /usr/sbin/bconsole -n -c /etc/bacula/bconsole.conf
Default Restore Job: Restore (as defined in bacula-dir.conf)
Bweb URL:
http://my.director.addy/bweb/cgi-bin/bweb.pl
Mozilla path: /usr/bin/firefox
It sound good to me.
Something else not being interpretted properly? It's like it's not
packing/assembling the query properly?
Thanks for the response!! :)
Lonny
=2D-=20
"I like when it comes by night and sucks the vital essence from=20
my ....computers."
