Re: [Bacula-users] FreeBSD Bacula port - SQL table generation problem
2011-04-05 08:42:56
I had problems with Bacula installation on FreeBSD from ports too.
I don't know about your's but in my case I should modify make_mysql_tables
script - in that script some table and field names are same as MySQL reserved
words. Therefore you need to modify that script and put all field and table
names in backticks.
Hope that helps.
Edgars
-----Original Message-----
From: Kernel Panic [mailto:kpnemesis AT gmail DOT com]
Sent: Tuesday, April 05, 2011 3:22 PM
To: bacula-users AT lists.sourceforge DOT net
Subject: [Bacula-users] FreeBSD Bacula port - SQL table generation problem
Hello everyone,
I orginally posted my problem on the FreeBSD forums here:
http://forums.freebsd.org/showthread.php?p=130088#post130088
I was asked by the port maintainer to try the Bacula mail lists. My
problem is that when I try to run the database setup scripts supplied
with Bacula as specified in:
http://www.bacula.org/5.0.x-manuals/en/main/main/Installing_Configuring_MySQ.html#SECTION004220000000000000000
it generates the following error when running the ./make_mysql_tables script:
ERROR 1064 (42000) at line 316: 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 'MaxValue INTEGER DEFAULT 0,
CurrentValue INTEGER DEFAULT 0,
WrapCounter TI' at line 4
Can anyone help me?
Thanks.
------------------------------------------------------------------------------
Xperia(TM) PLAY
It's a major breakthrough. An authentic gaming
smartphone on the nation's most reliable network.
And it wants your games.
http://p.sf.net/sfu/verizon-sfdev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------
Xperia(TM) PLAY
It's a major breakthrough. An authentic gaming
smartphone on the nation's most reliable network.
And it wants your games.
http://p.sf.net/sfu/verizon-sfdev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
|
|