24 Feb

Howto install Alfresco audit analysis and reporting patch from v1.0 to v1.1

In this post I would like to describe howto install the Alfresco audit analysis and reporting patch from v1.0 to v1.1 after the release announced in this post.

First of all you have to download the installation patch from the Download page on Google code.

Inside the zip file you will find the scripts and files useful to the patch:

  • AAAR_DataMart – Patch to v1.0 on ….sql – Script containing the patch for the Data Mart structure.
  • AAAR_ Kettle.sql – Script containing the E.T.L. repository structure and data (used by Pentaho Data Integration – Kettle).
  • reports.zip – Archive containing the new version of the 5 prpt files, one for each report.

Below are described the main installation steps:

  1. Replace and reconfigure the AAAR_Kettle database.
  2. Update the AAAR_DataMart database.
  3. Deploy the new version of the sample reports.

Replace and reconfigure the AAAR_Kettle database.

The first step of installation is the Pentaho Data Intergration (Kettle) ETL contained in the AAAR_Kettle database. Let’s start with tasks:

  • Using your preferred database administration client, make a backup of the AAAR_Kettle database and delete it.
  • Install again the new version of the AAAR_Kettle database following the instructions described here.

Update the AAAR_DataMart database.

With this script some index are added to the Data Mart structure to query it more faster. Let’s start with tasks:

  • Open a terminal
  • For the PostgreSQL platform use:
cd <PostgreSQL bin>
psql –U postgres -d AAAR_DataMart –f “<AAAR folder>/AAAR_DataMart - Patch to v1.0 on PostgresSQL.sql”

(use ‘psql.exe’ on Windows platform and ‘./psql’ on Linux based platforms)

  • For the MySql platform use:
cd <MySQL bin>
mysql –uroot –p<password> < “<AAAR folder>AAAR_DataMart - Patch to v1.0 on MySQL.sql”

(use ‘mysql.exe’ on Windows platform and ‘./mysql’ on Linux based platforms)

Deploy the new version of the sample reports.

With this deployment, a new version of the sample reports are released to insure compressed times with a big quantity of audit data. Let’s start with tasks:

  • Extract ‘reports.zip’ in the ‘data-integration’ folder. ‘report.zip’ contains 5 files with ‘prpt’ extension, each one containing one Pentaho Reporting Designer report. By default, and to let the report production simpler, are saved in the default folder: ‘data-integration’.
  • For the PostgreSQL platform: check if the ‘alfresco’ user of the database has password equal to ‘alfresco’. If yes, jump to the next task otherwise you have to update the connection in all the prpt reports. To update the password of all the prpt reports, follow that tasks:
    • For each prpt report in the ‘data-integration’ folder, execute what is described below.
    • Open the prpt report, one by one, with the Pentaho Reporting Designer.
    • Click on the ‘Data’ tab on the top right of the interface.
    • Right click on the JDBC:AAAR_DataMart in the Data sets.
    • Select ‘Edit Datasource’.
    • Select the ‘AAAR_DataMart’ in the left list. Pay attention to select the PostgreSQL one because two connections are defined: one for PostgreSQL and one for Mysql.
    • Click on the pencil.
    • Modify the password.
    • (OPTIONAL) If you want to test the connection remember that it could fail even if the password it’s correct because you could need the JDBC library in the ‘lib/jdbc’ folder of your Pentaho Reporting Designer installation.
    • Save the report.
    • Remember to repeat the tasks for all the prpt reports.
  • For the MySql platform: check if the ‘root’ user of the database has password equal to ‘root’. If yes, jump to the next task otherwise you have to update the connection in all the prpt reports. To update the password of all the prpt reports, follow that tasks:
    • For each prpt report in the ‘data-integration’ folder, execute what is described below.
    • Open the prpt report, one by one, with the Pentaho Reporting Designer.
    • Click on the ‘Data’ tab on the top right of the interface.
    • Right click on the JDBC:AAAR_DataMart in the Data sets.
    • Select ‘Edit Datasource’.
    • Select the ‘AAAR_DataMart’ in the left list. Pay attention to select the MySql one because two connections are defined: one for PostgreSQL and one for Mysql.
    • Click on the pencil.
    • Modify the password.
    • (OPTIONAL) If you want to test the connection remember that it could fail even if the password it’s correct because you could need the JDBC library in the ‘lib/jdbc’ folder of your Pentaho Reporting Designer installation.
    • Save the report.
    • Remember to repeat the tasks for all the prpt reports.

That’s all!

For informations or questions, let me know.

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.