On Thursday 08 March 2007 13:53, Troy Daniels wrote: > Hi again, > > Forgot to mention I'm using bweb from the 2.0.3 tarball available on > Sourceforge currently. > > Troy. > > Troy Daniels wrote: > > Hiya, > > > > I'm in the process of setup up bweb on my bacula server as the last step > > in upgrading Bacula to 2.0.x. > > > > However I've run into some problems I suspect are caused by my use of > > MySQL 3. > > > > I've followed the install instructions and can browse the main bweb > > page, but several of the other pages dont display any information. (Just > > empty tables) > > > > One example of this is the Media->Pools page. > > > > I turned on debug in bweb.conf and got the following query displayed > > when I visited the Media->Pools page: > > > > SELECT subq.volmax AS volmax, > > subq.volnum AS volnum, > > subq.voltotal AS voltotal, > > Pool.Name AS name, > > Pool.Recycle AS recycle, > > Pool.VolRetention AS volretention, > > Pool.VolUseDuration AS voluseduration, > > Pool.MaxVolJobs AS maxvoljobs, > > Pool.MaxVolFiles AS maxvolfiles, > > Pool.MaxVolBytes AS maxvolbytes, > > subq.PoolId AS PoolId > > FROM > > ( > > SELECT COALESCE(media_avg_size.volavg,0) * count(Media.MediaId) AS > > volmax, > > count(Media.MediaId) AS volnum, > > sum(Media.VolBytes) AS voltotal, > > Media.PoolId AS PoolId, > > Media.MediaType AS MediaType > > FROM Media > > LEFT JOIN (SELECT avg(Media.VolBytes) AS volavg, > > Media.MediaType AS MediaType > > FROM Media > > WHERE Media.VolStatus = 'Full' > > GROUP BY Media.MediaType > > ) AS media_avg_size ON (Media.MediaType = > > media_avg_size.MediaType) > > GROUP BY Media.MediaType, Media.PoolId, media_avg_size.volavg > > ) AS subq > > LEFT JOIN Pool ON (Pool.PoolId = subq.PoolId) > > > > > > It makes use of sub-selects and other "empty" pages I visit show queries > > also making use of them. > > > > MySQL 3 doesn't support sub queries so it looks like bweb isn't > > compatible with it. I've hunted thru all the doco on it and not found > > anything definitive however. > > > > Can someone confirm whether it works with MySQL 3, and if so what I have > > to do to make it work. > > > > Also, can anyone confirm if the bacula-mysql-2.0.2-1.el3.i386.rpm will > > work with MySQL 4 or 5, or is it built with just MySQL 3? > >
For exactly the reason you state, I believe that it is not possible for bweb to work with MySQL version 3, which is *very* old (by Open Source standards) now. It will probably work with version 4, which does implement subqueries (if I remember right). I am *sure* it works on MySQL 5, since it works here and I have: mysql-5.0.26-12 loaded. ------------------------------------------------------------------------- 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
