View Source

h1. *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:


{code}
$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
$
{code}

h1. *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.

!PetalsView-Properties.png|thumbnail,border=1,align=center!


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

h1. *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.

!kpi-jbi-xml.png|thumbnail,border=1,align=center!\\

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.




h1. *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]





!petalsview-annotation.png|thumbnail,border=1,align=center!