Re: [Bacula-users] how to tell 9.6 director to use mysql?

[Gary R. S. <gr...@mc...>]

On 21/07/2020 10:38, Greg Woods wrote:
> 
> 
> On Mon, Jul 20, 2020 at 5:43 PM Dmitri Maziuk <dmi...@gm... 
> <mailto:dmi...@gm...>> wrote:
> 
>     On 7/20/2020 6:31 PM, Gary R. Schmidt wrote:
>      > On 21/07/2020 09:21, Greg Woods wrote:
>      >>
>      >> Has this always been the case?
>      > Yes.
>      >
> 
>     Wow. I could swear I installed a backend-specific library RPM and
>     made a
>     symlink or something in the version we're using. It all must've been a
>     figment of my imagination I guess.
> 
> 
> Maybe not, because I found the answer. I tried downgrading as I 
> suggested to myself above, but it didn't work. I was running the exact 
> same RPM packages for Bacula that I was running on my older system, and 
> it still complained that Bacula was compiled for Postgres.
> 
> It turns out that Fedora has this "alternatives" system. It defines, for 
> example, whether "/usr/bin/sendmail" will point to "sendmail" or 
> "postfix" for mail delivery. They have done this for Bacula too; there 
> is a library called "libbaccats.so" which is apparently linked to by 
> their Bacula binaries, and the alternatives system can be used to 
> determine whether this points to a MySQL, PostgreSQL, or SQLite3 
> version. I finally hit upon the right Google search words to find this: 
> https://src.fedoraproject.org/rpms/bacula . Since I have always run my 
> Director on a Fedora machine, this explains why I didn't realize Bacula 
> was designed to be hard-compiled for a single database backend.
> 
> After reading this, I knew that PostgreSQL is the default, but it can be 
> changed by running "alternatives --config libbaccats.so" and selecting 
> the MySQL option.
> 
> The alternatives system is quite slick as can be seen here; it's easy to 
> use one set of Bacula packages no matter which database you are using; 
> no separate package or compiling from source necessary. But it's not 
> always easy to figure out which things have "alternatives" and how to 
> use them. Worse still, it appears that I must have gone down this road 
> before, as even on my older system, Postgres is the default but it had 
> already been set to use MySQL. I really wish my Google search fu was 
> better, then I could have avoided all this.
> 

Every day that you learn something new is a good day!

I had no idea that Fedora had anything like that - I've seen it on 
Solaris - I will have to add it to my "things that you needed to know 
before you broke that" list.  :-)

	Cheers,
		Gary	B-)