You can try this version, it fixes some mysql broken stuff http://bacula.svn.sourceforge.net/viewvc/*checkout*/bacula/trunk/gui/brestore/brestore.pl?revision=4356
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 écrit : > > 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 web > > 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 the > >> > 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 = []; > 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 = Filename.FilenameId > AND Filename.Name != '' > AND File.PathId IN (3) > AND File.JobId IN (25) > GROUP BY Filename.Name > ORDER BY Filename.Name) AS listfiles, > File > WHERE File.FileId = 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 = Filename.FilenameId > AND Filename.Name != '' > AND File.PathId IN (3) > AND File.JobId IN (25) > GROUP BY Filename.Name > ORDER BY Filename.Name) AS listfiles, > File > WHERE File.FileId = listfiles.id > Bvfs::ls_files:2396 $VAR1 = []; > Bvfs::get_path:2352 Call with pathid = 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=bacula;host=192.168.69.13;port=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 -- "I like when it comes by night and sucks the vital essence from my ....computers." ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users