bareos: master 6f4dc6d4

Author Committer Branch Timestamp Parent
joergs mvwieringen master 2014-01-30 10:00 master 04288ee4 Pending
Affected Issues  0000236: Hardcoded path for postgres (verison) in scripts
Changeset Rework database scripting.

Having the actual DDL (Data Definition Language) in scripts is not very
flexible so we move all DDL into seperate files. We also dropped all
database specific scripting and as such the generic script now knows
for all supported database types what to do on create/update/grant and
drop.

You can also have a read-only user on your database that is allowed
to select stuff but not anything else that might be interesting for
Management Queries.

The update script now can also upgrade from a database that is several
versions old. For now that means you can upgrade from a Bacula database
to the first Bareos database schema and also to the new Database schema
we are introducing with this patch. For the future it means the script
will perform all needed updates for you if its has the wanted so called
conversion available (e.g. the way to go from one version to an other.)

We also added more functionality to the bareos-config script and splitted
the function into a bareos-config-lib which can be included by scripts
so they can get config information like the working dir etc. This is
already used in all the new database scripts.

We also no longer use explicit absolute pathnames for database utilities
but make sure the utility can be found via the PATH, if your PATH already
provides the utility it will be used and otherwise the value will be used
that was determined at compile time.

Fixes 0000236: Hardcoded path for postgres (verison) in scripts
mod - autoconf/configure.in Diff File
mod - debian/bareos-common.install Diff File
mod - debian/bareos-database-mysql.install Diff File
mod - debian/bareos-database-postgresql.install Diff File
mod - debian/bareos-database-sqlite3.install Diff File
mod - platforms/packaging/bareos.spec Diff File
mod - scripts/Makefile.in Diff File
add - scripts/bareos-config-lib.sh.in Diff File
mod - scripts/bareos-config.in Diff File
mod - src/cats/Makefile.in Diff File
mod - src/cats/create_bareos_database.in Diff File
rm - src/cats/create_ingres_database.in Diff File
rm - src/cats/create_mysql_database.in Diff File
rm - src/cats/create_postgresql_database.in Diff File
rm - src/cats/create_sqlite3_database.in Diff File
add - src/cats/ddl/drops/postgresql.sql Diff File
add - src/cats/ddl/grants/ingres-readonly.sql Diff File
add - src/cats/ddl/grants/ingres.sql Diff File
add - src/cats/ddl/grants/mysql-readonly.sql Diff File
add - src/cats/ddl/grants/mysql.sql Diff File
add - src/cats/ddl/grants/postgresql-readonly.sql Diff File
add - src/cats/ddl/grants/postgresql.sql Diff File
add - src/cats/ddl/updates/mysql.14_2001.sql Diff File
add - src/cats/ddl/updates/mysql.2001_2002.sql Diff File
add - src/cats/ddl/updates/postgresql.14_2001.sql Diff File
add - src/cats/ddl/updates/postgresql.2001_2002.sql Diff File
add - src/cats/ddl/updates/sqlite3.14_2001.sql Diff File
add - src/cats/ddl/updates/sqlite3.2001_2002.sql Diff File
mod - src/cats/delete_catalog_backup.in Diff File
mod - src/cats/drop_bareos_database.in Diff File
mod - src/cats/drop_bareos_tables.in Diff File
rm - src/cats/drop_ingres_database.in Diff File
rm - src/cats/drop_mysql_database.in Diff File
rm - src/cats/drop_postgresql_database.in Diff File
rm - src/cats/drop_postgresql_tables.in Diff File
rm - src/cats/drop_sqlite3_database.in Diff File
rm - src/cats/drop_sqlite3_tables.in Diff File
rm - src/cats/fix_postgresql_tables Diff File
mod - src/cats/grant_bareos_privileges.in Diff File
rm - src/cats/grant_ingres_privileges.in Diff File
rm - src/cats/grant_mysql_privileges.in Diff File
rm - src/cats/grant_postgresql_privileges.in Diff File
rm - src/cats/grant_privileges Diff File
rm - src/cats/grant_sqlite3_privileges.in Diff File
rm - src/cats/ingres.in Diff File
mod - src/cats/make_bareos_tables.in Diff File
mod - src/cats/make_catalog_backup.in Diff File
mod - src/cats/make_ingres_catalog_backup.in Diff File
rm - src/cats/mysql.in Diff File
rm - src/cats/postgresql.in Diff File
mod - src/cats/restore_ingres_catalog_backup.in Diff File
rm - src/cats/sqlite.in Diff File
mod - src/cats/update_bareos_tables.in Diff File
rm - src/cats/update_ingres_tables.in Diff File
rm - src/cats/update_mysql_tables.in Diff File
rm - src/cats/update_postgresql_tables.in Diff File
rm - src/cats/update_sqlite3_tables.in Diff File