On Tue, 2005-06-21 at 12:52 -0500, Jeffrey L. Taylor wrote:
Quoting nils <lists < at > ol...>:
hi,
Installed bacula-web but its not working as it says that
*Fatal error*: Call to undefined function: fetchrow() in
*/var/www/bacula/index.php* on line *47
*This is line 47 in index.php*
$tmp = $client->fetchRow();
*As I am not familiar with bacula-web classes and its structures I've no
idea.
It looks to me like you are missing the PHP database library, e.g.,
php4-mysql, php4-psql, etc.
HTH,
Jeffrey
Nope, I have all the php modules loaded mysql, sqlite
The bacula database is sqlite, and i have edited the bacula.conf to
specify this.
fetchRow is a pear DB.php It seem for doing a little googling
http://www.free2code.net/plugins/articles/read.php?id=260
down at the bottom is states that
<quote>
call to undefined function fetchRow() on line xxx
This happens because when you call $var->fetchRow(), $var contains an
error message, you must always use DB::IsError to check if the returned
object is an error.
</quote>
So adding error checking
if(DB::IsError($client)) {
die($client->getMessage();
}
returns
DB Error: no such table
Then looking at the SQL statments in index.php
<quote>
$client = $dbSql->link->query("select count(*) from Client")
or die ("Error query at row 37");
$totalfiles = $dbSql->link->query("select count(FilenameId) from
Filename")
or die ("Error query at row 39");
$last24bytes = $dbSql->link->query("select sum(JobBytes),count(*) from
Job where Endt$ or die ("Error query at row 41");
$bytes_stored =& $dbSql->link->getOne("select SUM(VolBytes) from Media")
or die ("Error query at row 43");
</quote>
Does pear DB.php only work with mysql/postgresql ? or are the tables
different in sqlite ?
nils
Re: AW: [Bacula-users] how to speed up directory tree building? From: Arno Lehmann <al < at > it...> - 2005-06-21 20:30
Hello,
J=FCrgen Kuri wrote:
Hello,
=20
I observed the very same phenomenon but I run a PostgreSql instead of a=
MySql database.
To my knowledge - without ever having used PostgreSQL - with this=20
database there seems to be some sort of problems with the indexes. This=20
was probably discussed with Dan Langille, either on this list or on=20
bacula-devel.
I would restore a number of ~740.000 files backed up of one host
via a full backup and several incrementals. But the database, to
me, seems not to be the problem. The file entries from the
database were collected fast but the 'backup-dir' daemon consumed
the bigger part of time to build the virtual filesystem in the
backup server's memory. Even worse if you then - after the built
- type 'mark all' for a full restore, it takes again a lot of
time to mark all the files in the virtal file system. The result
of this action then is - this is what I observed - a very small
ASCII bootstrap file for restore purposes with the names of the
involved backup volumes the corresponding tapefiles numbers into
the backups were written.
This sounds like a design limitation. Or, in other words, might be=20
better to discuss on the developer list.
To me in a case of full restore it is not necessary to build a
virtal filesystem in the backup server's memory. What you need
is the information of all the involved backup volumes and the
position of the corresponding tape files. For cases like this
the pieces of information should be in the datebase (saveset
'something' -> volume name, tapefile number). This makes
especially full restores with a huge number of files
considerably faster.
this sounds quite reasonable. Time to try a full restore again, I guess,=20
because I *think* that a full restore didn't take very long to prepare=20
here. Of course, with my backup server, *everything* is slow, so I=20
probably didn't notice the difference.
Anyway, considering that the suggested changes might take a while to=20
implement there could be a workaround in case of a full restore you need=20
quickly: Use bextract if you've got the bootstrap file and or know which=20
volmes you need.
J=FCrgen
Is c't planning an article about bacula? In fact I was thinking about=20
such a project...
Arno
-----Urspr=FCngliche Nachricht-----
Von: bacula-users-admin < at > li...
[mailto:bacula-users-admin < at > li...]Im Auftrag von Arno
Lehmann
Gesendet: Dienstag, 21. Juni 2005 10:43
An: Sebastian Stark
Cc: bacula-users < at > li...
Betreff: Re: [Bacula-users] how to speed up directory tree building?
=20
=20
Hello,
=20
Sebastian Stark wrote:
=20
=20
Is there a way to speed up the creation of the directory tree when rest=
oring=20
files? For some clients this takes more than an hour for us.
Our MySQL catalog has grown quite large (~5G) and I think this is the r=
eason.=20
But maybe there's another way to speed this up other than splitting up =
the=20
catalog? Maybe play around with indexes?
=20
=20
That would seem the first step.
=20
There are quite some messages concerning this, you could use the list=20
archive. If you have a good understanding of SQL and MySQL, observing=20
the queries and analyzing them might give some hints, too.
=20
Arno
=20
=20
Thanks,
Sebastian
=20
=20
--=20
IT-Service Lehmann al < at > it...
Arno Lehmann
http://www.its-lehmann.de
