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
|
