Backup Central

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?

Thanks in advance,

Troy Daniels.
Systems Administrator
iTouch Australia (pty) ltd.

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?

Thanks in advance,


Troy Daniels.
Systems Administrator
iTouch Australia (pty) ltd.

-------------------------------------------------------------------------
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 < at > li...
https://lists.sourceforge.net/lists/listinfo/bacula-users

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.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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.

I use MySQL 4 -- it works fine.

=R

- --
---- _ _ _ _ ___ _ _ _
|Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer III
|$&| |__| | | |__/ | \| _| |novosirj < at > um... - 973/972.0922 (2-0922)
\__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFF8IwYmb+gadEcsb4RAlo9AJ9eG+by13q+YXf7hY6e002UlkbKlQCgyWxF
NrY1f6ixtWRVXmy2g1YUydk=
=aKI6
-----END PGP SIGNATURE-----

Hi,


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.


Thanks for your response. Unfortunately it was the one I was expecting, however
was hoping I'd overlooked something in my tiredness last night and sent the
email anyways.

I know my MySQL is an old version, but it's the version that seems to be the
default for EL3 installations. (ie, it's the most recent version in the EL3
Repo I use). I can see however that there are rpms for 5.0 available for EL3 on
the MySQL site so this may not be the case.

AFAIK, it's also the version the standard EL3 Bacula MySQL rpm is built
against. Therefore, If I upgrade my database, I'll have to build Bacula MySQL 5
rpms for EL3 myself wont I? This is the main reason I hadn't upgraded my MySQL
DB yet. (Plus the fact that my catalog DB gets replicated to an offsite DB
server which replicates it's catalog to this DB server - both are running 3.23
and both would need simultaneous upgrades of both the DB and bacula == extra
comlpexity)

Also, does anyone have any advise on the best way to upgrade from version 3.23
to 5.0 of MySQL. The MySQL documentation recommends upgrading thru each
intermediate version (4.0, 4.1) but I was wondering if this was more of a
guideline than a strict rule.

Also, I was thinking it might be simpler in the long run to just install a
separate MySQl 5 instance and load the MySQL 3.23 dumps into it - anyone know
if this is possible? I haven't seen any clear indication either way in the
MySQL documentation.

Time to break out the test box again...

Cheers,

Troy.


-------------------------------------------------------------------------
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 < at > li...
https://lists.sourceforge.net/lists/listinfo/bacula-users

On Friday 09 March 2007 03:34, Troy Daniels wrote:
Hi,

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.

Thanks for your response. Unfortunately it was the one I was expecting,
however was hoping I'd overlooked something in my tiredness last night and
sent the email anyways.

I know my MySQL is an old version, but it's the version that seems to be
the default for EL3 installations. (ie, it's the most recent version in the
EL3 Repo I use). I can see however that there are rpms for 5.0 available
for EL3 on the MySQL site so this may not be the case.

AFAIK, it's also the version the standard EL3 Bacula MySQL rpm is built
against. Therefore, If I upgrade my database, I'll have to build Bacula
MySQL 5 rpms for EL3 myself wont I? This is the main reason I hadn't
upgraded my MySQL DB yet. (Plus the fact that my catalog DB gets replicated
to an offsite DB server which replicates it's catalog to this DB server -
both are running 3.23 and both would need simultaneous upgrades of both the
DB and bacula == extra comlpexity)

Yes, Bacula *must* be built against the version of MySQL that you are running
or it will likely segfault.


Also, does anyone have any advise on the best way to upgrade from version
3.23 to 5.0 of MySQL. The MySQL documentation recommends upgrading thru
each intermediate version (4.0, 4.1) but I was wondering if this was more
of a guideline than a strict rule.

1. Copy your database.
2. Make an ASCI dump of it.
3. Here, I upgraded from 3 to 4 by simply installing MySQL 4 and it ran.
4. I did the same for MySQL 5.
5. Don't try the above for PostgreSQL. From what I understand you *must*
create a dump and reload the db on each PostgreSQL update.
6. I don't know if you can go directly from MySQL 3 to MySQL 5 without running
MySQL in between. I never tried it.


Also, I was thinking it might be simpler in the long run to just install a
separate MySQl 5 instance and load the MySQL 3.23 dumps into it - anyone
know if this is possible? I haven't seen any clear indication either way in
the MySQL documentation.

Time to break out the test box again...

If Bacula is not the only program using MySQL, then you probably need to
upgrade your system. This would be the best solution, but it is probably the
most difficult and the most work.

If Bacula is the only program using MySQL, it depends on your rpm policy. My
easy way out would be to load a MySQL version 4 rpm (if possible). Run it,
manually check that the tables are correct. Then either stick with version 4
rebuilding Bacula from source, and you should be in business or upgrade to
MySQL 5, check manually that the tables are OK, and rebuild Bacula from
source.