Bitnami Stack upgrade

First off the requirements for the following guide are the following:

  • You need to have a Bitnami Installation of Reportserver of version 3.0.3 or higher for this to work. In this example we upgrade 3.1.0.

Now we want to explain the guide in several steps containing pictures for certain steps. But before the explanation starts we need to make sure to have the requirements set for this guide which look like this:

A complete backup in case something goes wrong. This includes at least:

  • A complete DB-backup of your current bitnami reportserver metadata database including all relevant tables and data. Be sure you can return to the previous state in case something goes wrong.
  • All relevant files of your current installation (any drivers you may use, reportserver.properties, web.xml if you changed the default one, etc). In the bitnami installation you can find the external configuration directory here:
    • C:\Bitnami\reportserverenterprise-3.7.1.6048-1\apps\reportserver\reportserver-conf

The easiest and most complete backup is a complete SNAPSHOT of your current installation. Be sure you can return to the previous state in case something goes wrong.

  • The latest bitnami installer you want to upgrade to (for this guide we use bitnami 3.7.1 as of now which is the latest version of ReportServer)
  • Windows 10 OS with command line interface (CLI) (this is analogous for other platforms like Linux)

Lets start with the explanation of this guide and a how-to explaining the steps with some pictures mixed in:

  1. First of we need to stop the reportserver application and the apache tomcat in order to perform the following steps. This is done by going into the installation folder of bitnami reportserver and stop the application:
  2. Create a dumpfile of your current bitnami reportserver database.
    1. For this navigate to your bitnami installation folder into the bin folder:
    2. Now you need to find out the credentials of your rs database user. They are found within the bitnami installation in particular within the persistence.properties file as shown here:
    3. Now you create the dumpfile via the following command mysqldump -u bn_reportserver -pa95f96a6d1 bitnami_reportserver > <path_to_dumpfile_on_hdd_or_ssd> in the cli:
    4. After that you should have a dumpfile succesfully created as shown in the folder:
  3. Now you need to uninstall your current bitnami Reportserver installation and need to install the latest version of Reportserver with your installer package from bitnami (from 3.1.0 to 3.7.1 as in this guide)
  4. After the successful installation of bitnami reportserver you need to delete the current database that the Reportserver uses in order for replacing this database with your backup you just have created via the dumpfile as seen in step 1. You do this the in the following manner:
    1. Open a new Command window and navigate to your new bin folder of your bitnami installation as seen in step 1.a.
    2. Use the following command mysql -u bn_reportserver -pa95f96a6d1 to activate the mysql environment for further code to be written.
    3. Now check for the current databases that exist in your mariadb dbms with the following sql command “show databases;”:
    4. After that you can use the drop ddl sqls for your old version within the bitnami Reportserver Installation (located in your ddls folder) to delete the metadata that the reportserver uses via the following command mysql -u bn_reportserver -pa95f96a6d1 bitnami_reportserver < <path_of_the_drop_ddl_sqls>:
    5. The empty set as shown with the sql command “show tables in bitnami_reportserver;” is the result and you basically succesfully deleted the internal RS DB.
  5. Now comes our bitnami_backup into play. You need to follow these steps in order to backup your original database and transfer it into the latest version of Reportserver. This is how you do it.
    1. So we basically now import the dumpfile into our new system. It looks like this with the command mysql -u bn_reportserver -pa95f96a6d1 bitnami_reportserver < <path_to_dumpfile_backup>:
    2. Thanks to the sql command “show tables from bitnami_reportserver;” we can see that the dumpfile importing was succesful and have finished step 4.
  6. Now we can restart the application again via restarting the apache tomcat as shown here: 
  7. Please check the logs within the apache-tomcat folder as seen in step 6 for this small update within the logs as shown here:
    The important part to check is the Performing database update RS3.0-XY -> RS3.0-XY and the Update Running script RS3.0-XY-MySQL5_UPDATE.sql
  8. Then call the address 127.0.0.1/reportserver/ in the browser of your choice and the bitnami reportserver should start up like this:
  9. Now log in with your credentials you have put up during the installation of bitnami reportserver
  10. Please go to administration datasource and within the folder “internal datasources” you need to change back the password for the internal db to the current iteration from your new installation to overwrite the old pw you gained via the dumpfile backup.
  11. Now press on apply and press the button test connection. If it shows no errors you have succesfully migrated your old database from your old bitnami installation to the latest version of bitnami Reportserver with all your current content from your old database. Congratulations!
  12. If you edited the default config files (e.g. for SSO) you can replace them with your backup files after again stopping Tomcat (refer to the C:\Bitnami\reportserverenterprise-3.7.1.6048-1\apps\reportserver\reportserver-conf directory of the backup-section of this guide)

404