Hello Dan,
Please, commit your changes to the CVS when you want. However, perhaps you
would want to wait one commit in the next days with my last development
version. I included a very (very) rudimentary support for PostgreSQL and I am
convinced that you can adapt your patch to this version and surely update
(better than I) the sql querys.
Next CVS Changelog:
- Updated French translation
- Initial support for PostgreSQL
- Upgrade Phplot to 5.0rc2 version.
Best regards,
Juan Luis Francés
El Viernes 17 Junio 2005 09:53, Kern Sibbald escribió:
> 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
-------------------------------------------------------
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
