> 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
-------------------------------------------------------------------------
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
