On Thursday 06 September 2007 20:37, Dan Langille wrote:
> On 6 Sep 2007 at 20:16, Kern Sibbald wrote:
> > On Thursday 06 September 2007 19:38, Dan Langille wrote:
> > > The latest versions of Bacula (>= 2.2.0, I think) require a newer
> > > version of MySQL. We are now using nested selects, which older
> > > versions of MySQL do not have. I think the minimum requirement is
> > > MySQL 4.1
> > >
> > > This is the second instances of this problem that I have noticed.
> > >
> > > Things we should do:
> > >
> > > 1 - Put out an announcement notifying people of this requirement.
> > > 2 - Update ReleaseNotes
> > >
> > > Things we could also do:
> > >
> > > 3 - Put checks in bacula-dir to check for database version >= that
> > > required.
> > >
> > >
> > > I can do #2 right away.
> >
> > I assume you mean check for MySQL version. The term database version
> > usually refers to Bacula's internal table format.
> >
> > > Kern: can you do #1?
> >
> > Yes
> >
> > > #3 would be a nice to have, and would help reduce the number of
> > > support calls. I don't think it's a big priority.
> >
> > Can you tell me where the nested selects are, and are you sure that MySQL
> > 4.1 is the first version that supports them?
> >
> > I have no problem with requiring 4.1 as the any 3.x is *very* old.
>
> I am updating docs/manual/mysql.tex and I see some things which we
> might be able to remove. In particular, I wonder if we can safely
> remove this:
>
> ###
> Bacula has been tested on MySQL version 4.1.12 and works providing
> you are running it in the default installation that is compatible
> with MySQL 3.23.x. If you are using one of the new modes such
> as ANSI/ISO compatibility, you may experience problems.
> ###
>
> Is the ANSI/ISO issue still applicable?
I forget exactly what the problem was/is, but I suspect that it still applies.
If you point me at the documentation for the ANSI/ISO compatibility mode, I
could check.
>
>
> Which will leave just this:
>
> If you use the ./configure \verb:--:with-mysql=mysql-directory
> statement for
> configuring {\bf Bacula}, you will need MySQL version 4.1 or later
> installed in the {\bf mysql-directory
>
> Comments? Ideas? Suggestions?
You might be more explicit and say that if you are using the Batch Insert
feature you need nested SELECT capability hence version 4.1 or greater.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Bacula-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-devel
