MySQL database

If you don't have one yet, download and install MySQL server.

Create a database and a user with all rights granted to this database:

$mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.0.60-enterprise-gpl-log MySQL Enterprise Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql:root:(none)> CREATE DATABASE IF NOT EXISTS petals;
Query OK, 1 row affected (0.02 sec)

mysql:root:(none)> GRANT ALL PRIVILEGES ON petals.* TO 'petals'@'%' IDENTIFIED BY 'petals';
Query OK, 0 row affected (0.04 sec)

mysql:root:(none)> quit
Bye
$

petals-view.properties file

Open this file (located in PetalsView-docs directory) and adapt informations to fit your database configuration (database name, users id and password, MySQL server address). Save the file.

MySQL jdbc-driver isn't in classpath directory. You need to copy mysql-connector-java-5.1.x.jar in PetalsView/ WEB-INF/lib

SE-KPI Component configuration

Browse directories to petals-se-kpi.zip/META_INF

Open jbi.xml file.

On this line <petals-se-kpi:hibernateURL>: fill in the "petals-view.properties" file location
example : file:///home/user/Desktop/petals-view.properties

Save the file.

MySQL jdbc-driver isn't in classpath directory. You need to copy mysql-connector-java-5.1.x.jar in your petals-se-kpi component with others dependencies.

Petals View configuration

Go to PetalsView-webapp/PetalsView.war/WEB-INF/spring

Open petals-view-annotation.xml

On the line <property >, in value quotation marks, fill in "petals-view.properties" file location.

Example : file:///home/user/Bureau/petals-view.properties