Bacula-users

Re: [Bacula-users] brestore cache tables

2009-10-19 13:31:20
Subject: Re: [Bacula-users] brestore cache tables
From: ebollengier <eric AT eb.homelinux DOT org>
To: bacula-users AT lists.sourceforge DOT net
Date: Mon, 19 Oct 2009 10:25:44 -0700 (PDT)
Hello Paul,

Just remove all functions of the file (only one at the top i think)

Bye


P.A wrote:
> 
> 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:eric AT eb.homelinux DOT org] 
> Sent: Saturday, October 17, 2009 10:45 AM
> To: bacula-users AT lists.sourceforge DOT 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 AT lists.sourceforge DOT 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 AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
> 

-- 
View this message in context: 
http://www.nabble.com/brestore-cache-tables-tp25928701p25962087.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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users