Hello Dan, Thanks for jumping into this :-) For others on this list, bacula-web is written so it can be used by multiple DB engines. However, if I am not mistaken, Juan Luis, doesn't have PostgreSQL loaded, and there are lots of tricky, totally non-evident things one must do to write DB neutral SQL (mostly due to the fact that MySQL prior to version 4.1 is not ANSI compatible).
One question Dan: Will your changes work equally well on MySQL? I'd like to hear from Juan Luis, but I think he would be pleased to see you commit your changes to the CVS (I know I would be happy -- with the exception perhaps of configs/bacula.conf) Best regards, Kern On Friday 17 June 2005 02:35, Dan Langille wrote: > On 16 Jun 2005 at 20:03, Dan Langille wrote: > > On 17 Jun 2005 at 0:02, Kern Sibbald wrote: > > > Hello, > > > > > > This is just to let you know that as was previously discussed on this > > > list, I have created a "gui" project in the Bacula Source Forge CVS > > > repository. At the moment, this project (or module) contains bacula-web > > > 1.1 written by Juan Luis Francés and bimagemgr written by Scott > > > Barninger. Thanks to both of them for taking the time and effort to > > > write web based programs that add functionality to Bacula. > > > > > > In case you have not heard about bacula-web, it is a web based program > > > that provides information on the status of your Bacula jobs by reading > > > the Catalog database. It includes a nice summary of what happened in > > > the last 24 hours and some nice graphics. bacula-web is written in php, > > > so needs a web server to run it. > > > > > > bimagemgr is also a web based program, but it is written in Perl. > > > bimagemgr monitors Bacula disk Volumes that you intend to write to > > > CDROM. For more information, please see the Bacula manual where it is > > > documented. > > > > I just downloaded this and got it going. I like it. Pretty easy to > > get running. I especially like the test.php. More PHP-based apps > > should do this type of checking. > > > > The only hitch on installing is that test.php did not detect my > > DB.php after I installed it. On FreeBSD, this file goes to > > /usr/local/share/pear/DB.php. A symlink solved that: > > > > ln -s /usr/local/share/pear/DB.php . > > > > When running the app, I got this error: > > > > [Thu Jun 16 19:10:33 2005] [error] PHP Notice: Use of undefined > > constant hostspec - assumed 'hostspec' in > > /usr/websites/bacula.unixathome.org/classes.inc on line 44 > > > > Putting the constants into quotes helped: > > > > $this->dsn['hostspec'] = $conf->get(CONFIG_FILE,"DATABASE","host"); > > > > Now I'll describe a problem which I've solved. I'm documenting it so > > others know: > > > > The main page (index.php) is blank. I'm finding that it's dying > > during this line: > > > > $dbSql = new Bweb(); > > > > I looked closer, and it's dying during part of the constuctor: > > > > $this->link =& $this->connect($this->dsn); > > > > I know this because I added a die() call right after the above. It > > never gets executed. > > > > Dumping the variables, I get: > > > > dsn[hostspec]=localhost > > dsn[username]=bacula > > dsn[password]= > > dsn[database]=bacula > > dsn[phptype]=pgsql > > > > >From bacula-dir.conf, in the Catalog resource, I have: > > > > dbname = bacula; user = bacula; password = "" > > > > So I'm not sure why this is dying. > > > > Solution: Don't symlink. Add something like this to php.ini: > > > > include_path = "/usr/local/share/pear" > > > > And remember to restart Apache. > > > > When looking at /external_packages/phplot/examples/test_setup.php, I > > noticed this: > > > > "Use this form to test many different options of PHPlot. You can test > > every graph type supported for any of four different data types. You > > can tweak as you like or you can leave everything as is and press > > "Submit" for" > > > > But I don't have a form... or a submit button. I wonder if something > > is missed in the configuration. > > > > NOTE: from the /test.php page, everything looks good. No problems. > > > > I had to create templates_c and chown it to www (which is what Apache > > runs as on my box). > > > > This I started getting these errors: > > > > Jun 16 19:50:52 polo postgres[38380]: [11-1] ERROR: function > > unix_timestamp(timestamp without time zone) does not exist > > > > I'll work on converting the SQL to something that can work with > > PostgreSQL. > > I've converted the SQL. The diffs are available here: > > http://www.langille.org/tmp/bacula-web.diff > > NOTE: this is incomplete and not fully tested. There are other > things yet to be fixed. > > cheers. ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=click _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
