Installing Tenant Toolboxes

In this section we shall how to install and work with tenant based toolbox.

KPI toolbox, HTTPD analysis toolboxes are one kind of toolboxes which doesn't use the carbon data sources within the script in JDBC storage handler when writing the summarized data. Therefore you can just follow the instructions provided here.

.......................
'mapred.jdbc.driver.class' = 'org.h2.Driver' ,
'mapred.jdbc.url' = 'jdbc:h2:repository/database/samples/WSO2CARBON_DB;AUTO_SERVER=TRUE' ,
'mapred.jdbc.username' = 'wso2carbon' ,
'mapred.jdbc.password' = 'wso2carbon' ,
'hive.jdbc.update.on.duplicate' = 'true'
.......................

For Service Statistics toolbox, Mediation statistics toolbox and Activity Monitoring toolbox, involves additional step more than uploading/installing the toolbox before executing the hive script within it. This is because, within the hive script the carbon data source 'WSO2BAM_DATASOURCE' is used to write the summarized data in JDBC storage.

'wso2.carbon.datasource.name'='WSO2BAM_DATASOURCE'

Therefore you have to add data source called 'WSO2BAM_DATASOURCE', as carbon data source as tenant by following the instructions from here.

If you are using a MySQL server, you need to include the MySQL driver JAR file to the Hive auxiliary JARs properties as shown below and restart the server. Navigate to <BAM_HOME>/repository/conf/advanced/hive-site.xml, and configure the below properties to include MySQL drivers.

<property>
    <name>hive.aux.jars.path</name>
    <value>
        file://${CARBON_HOME}/repository/components/plugins/apache-cassandra_1.1.3.wso2v2.jar,
        file://${CARBON_HOME}/repository/components/plugins/guava_12.0.0.wso2v1.jar,
        file://${CARBON_HOME}/repository/components/plugins/json_2.0.0.wso2v1.jar,
        file://${CARBON_HOME}/repository/components/plugins/commons-dbcp_1.4.0.wso2v1.jar,
        file://${CARBON_HOME}/repository/components/plugins/commons-pool_1.5.6.wso2v1.jar,
        file://${CARBON_HOME}/repository/components/lib/mysql-connector-java-5.1.23-bin.jar
    </value>
</property>

After completing the respective steps for the relevant toolboxes, your toolboxes can be successfully configured and execute.