create_bacula_database script not present

[bmcclure]

Installing the mysql database fails currently on Ubuntu 12.04. There is no /usr/share/bacula-directory/create_bacula_database script on the system. The make_bacula_tables script is there, but no script to actually create the DB.

It seems like it might be best to require the example42 mysql module and create the database with that before running make_mysql_tables.

[bmcclure]

I'll make a pull request for this as soon as I've got it fully working.

[javierbertoli]

Hi @bmcclure, this module does not force dependency on the mysql module nor does create the tables forcedfully in the same host, because you CAN have the database on ANOTHER host. Therefore, forcing the mysql module here, or installing a database server as a requirement would be wrong. I prefer to let the admin to choose where to install the database, or use an existing one if she prefers so.

You can configure the database parameters following the docs in 04-PARAMETERS.database.md, but you will need to include the database beforehand.

Perhaps that would be of help to you?

[bmcclure]

Understood. I was planning to use mysql::grant, which allows you to run the command on a remote host. You are calling mysql::query already, so I don't think it would create any additional dependencies, but I could be mistaken.

The main problem is that bacula::database tries to use a file which no longer exists (the create_bacula_database script), so at the very least that should probably be updated. I'd much rather see the database creation be managed internally rather than requiring a custom module to set it up, but if that's not desirable for some reason then I can certainly just do it with a custom module.

Thanks for the reply!

[javierbertoli]

Hi @bmcclure, I was not aware of the create_bacula_database being deprecated, as it's been a while I don't install/reinstall bacula :)

Please feel free to send a PR if you're in the mood, or we'll try to fix it when we have some spare time. Will leave this issue open as a reminder.