Hi,

Not what you asked, But you could also use postgres as database i you don't want to install a newer mysql version in your box.  It also ships with solaris.

Kind regards
Mit freundlichem Gruß

Julian Fahrer


----- Originalnachricht -----
Von: Bob <bear AT rwhartzell DOT net>
An: bacula-users <Bacula-users AT lists.sourceforge DOT net>
Gesendet: Mon Jun 15 22:04:18 2009
Betreff: Re: [Bacula-users] Problem with accurate backups

Andrea Conti wrote:
>> Are these subqueries something that's newly added when accurate backups
>> were implemented?
>
> Well, all I wanted to point out was that the error message you are
> getting is caused by MySQL choking on the subquery in the statement...
>
> I am not really familiar with the SQL Bacula uses, but yes, if you were
> using MySQL 4.0 without problems, then I'd say that none of the stuff in
> 2.4.4 contains subqueries as you would get similar error messages
> otherwise. I cannot vouch for 3.0, as other things might have been
> rewritten.
>
> I strongly suggest upgrading MySQL anyway, as 4.0 is *really* ancient...
>
> andrea

I do have a newer version of MySQL (5.1.30) available on another host
and I can confirm that everything works as expected using the newer version.

unfortunately this adds a layer of complexity to using bacula on solaris
that i'm not looking forward to. Does anyone know if using bacula
compiled against mysql 4.0 is going to cause any issues when connecting
to a database running version 5.0 or newer?

Bob


------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users