Eric, thanks for the reply. I kind of figure it was a compatibility issue with MYSQL version, I'm using centos 4 with mysql 4.1. Could you let me know what code I need to remove. I don't want to go through the trouble of recompiling mysql since this is a test system.
Paul -----Original Message----- From: ebollengier [mailto:e...@eb.homelinux.org] Sent: Saturday, October 17, 2009 10:45 AM To: bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] brestore cache tables Paul A-2 wrote: > > Hi trying to get webrestore to work, so far I can see page clients but not > jobs. I believe this is because I have no imported the bweb.sql. > > > > According to the install file its says, "3) Make sure that brestore cache > tables are in your catalog (bweb-xxx.sql files)" > > > > How do I achieve this, I ran the following but it doesn't work. > > > > mysql -u bacula -p bacula < bweb-mysql.sql > > Enter password: > > ERROR 1064 (42000) at line 7: You have an error in your SQL syntax; check > the manual that corresponds to your MySQL server version for the right > syntax to use near 'IF EXISTS base64_decode_lstat' at line 1 > Hello, Perhaps your Mysql version is a bit old to support PL procedure. You can remove PL code from the bweb-mysql.sql, it is only used in the bfileview module or you can upgrade your Mysql. Bye -- View this message in context: http://www.nabble.com/brestore-cache-tables-tp25928701p25938851.html Sent from the Bacula - Users mailing list archive at Nabble.com. ---------------------------------------------------------------------------- -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
