Hello,
On Fri, 2009-05-15 at 11:26 +0200, Eric Bollengier wrote:
> Hello,
>
> Le Friday 15 May 2009 10:23:16 Ulrich Leodolter, vous avez écrit :
> > Hello,
> >
> > I have installed and configured bweb + bresto.
> > Since last update to latest svn version bresto is broken
> > (at least for me).
> >
> > I can browse through clients, jobs and files.
> >
> > But i cannot drop files or directories
> > into Restore Selection area.
> >
> > When dragging into this area it turns into
> > green, but nothing happens.
> >
> > In my firefox javascript Error Console i see one error:
> >
> > console is not defined
> > http://director/bweb/bresto.js Line: 850
> >
> > bresto.js:850: console.info("DropTarget");
> This problem has been reported few days ago and is now fixed.
>
Ok, drop works now BUT found another problem:
After dropping a directory i clicked "Run Restore"
and then "Compute with directories" to see Media needed.
This action resulted in web interface timeout.
So i looked into mysql processlist, and it looks like there is
something wrong with temporary sql tables create by bresto.pl
As u can see table b213536 doesn't have FileId field,
but there is a SELECT FileId FROM b213536.
mysql> show full processlist;
...
| 28371 | bacula | localhost | bacula | Query | 13 | Sending data |
SELECT DISTINCT VolumeName, Enabled, InChanger
FROM File,
( -- Get all media from this job
SELECT MIN(FirstIndex) AS FirstIndex, MAX(LastIndex) AS LastIndex,
VolumeName, Enabled, Inchanger
FROM JobMedia JOIN Media USING (MediaId)
WHERE JobId IN (SELECT DISTINCT JobId FROM b213536)
GROUP BY VolumeName,Enabled,InChanger
) AS allmedia
WHERE File.FileId IN (SELECT FileId FROM b213536)
AND File.FileIndex >= allmedia.FirstIndex
AND File.FileIndex <= allmedia.LastIndex |
mysql> SELECT FileId FROM b213536;
ERROR 1054 (42S22): Unknown column 'FileId' in 'field list'
mysql> describe b213536;
+------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+-------+
| JobId | int(10) unsigned | NO | | | |
| FileIndex | int(10) unsigned | YES | | 0 | |
| FilenameId | int(10) unsigned | NO | | | |
| PathId | int(10) unsigned | NO | | | |
+------------+------------------+------+-----+---------+-------+
4 rows in set (0.01 sec)
Regards
Ulrich
> > BTW: what is the status of bresto, Experimental/Alpha/Beta/Produktion?
>
> Some fields (at least Replace option) are buggy or not yet implemented, the
> drag&drop can also insert the selection two times, nothing critical, but hard
> to fix in javascript.
>
> I would say that Beta is the right status (i'm using it all the time)
>
> Bye
>
> >
> > Regards
> > Ulrich
> >
--
Ulrich Leodolter <[email protected]>
OBVSG
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables
unlimited royalty-free distribution of the report engine
for externally facing server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Bacula-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-devel
