Installing Tenant Toolbox

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 mysql server, then you need to include the my sql driver jar to the hive auxiliary jars properties, as shown below and restart the server. Go to $BAM_HOME/repository/conf/advanced/hive-site.xml and check the below propery with my sql driver.

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.