POSTIN

/bin/sh

umask 077
for f in create_sqlite3_database drop_sqlite3_database drop_sqlite3_tables \
    grant_sqlite3_privileges make_sqlite3_tables update_sqlite3_tables ; do
    ln -snf $f /usr/lib64/bacula/${f/sqlite3/bacula}
done
ln -snf bacula-dir-sqlite3 /usr/sbin/bacula-dir
ln -snf bscan-sqlite3 /usr/sbin/bscan
ln -snf dbcheck-sqlite3 /usr/sbin/dbcheck
[ -s /var/lib/bacula/bacula.db ] && \
	DB_VER=`echo "select * from Version;" | \
		sqlite3 /var/lib/bacula/bacula.db | tail -n 1 2>/dev/null`
if [ -z "$DB_VER" ]; then
# grant privileges and create tables
	/usr/lib64/bacula/grant_bacula_privileges > dev/null
	/usr/lib64/bacula/create_bacula_database > dev/null
	/usr/lib64/bacula/make_bacula_tables > dev/null
elif [ "$DB_VER" -lt "10" ]; then
	echo "Backing up bacula tables"
	echo ".dump" | sqlite3 /var/lib/bacula/bacula.db | bzip2 > /var/lib/bacula/bacula_backup.sql.bz2
	echo "Upgrading bacula tables"
	if [ "$DB_VER" -lt "8" ]; then
		echo "your bacula database version is too old to be upgraded automatically"
	else
	    for v in `seq 9 $((10 - 1))`; do
		if [ "$DB_VER" -lt "$v" ]; then
			/usr/lib64/bacula/update_sqlite3_tables_$((v - 1))_to_$v
		fi
	    done
	fi
	/usr/lib64/bacula/update_bacula_tables

	echo "If bacula works correctly you can remove the backup file /var/lib/bacula/bacula_backup.sql.bz2"
fi
chown -R bacula:bacula /var/lib/bacula
chmod -R u+rX,go-rwx /var/lib/bacula