Archives > Petals View > Page Comparison - Setting up persistent environment (v.6 vs v.7)

Setting up persistent environment

Version 6 by Sandra TRINO
on Jun 09, 2010 14:40.
<< Changes from 5 to 6
compared with
Version 7 by Frédéric Gardes
on Jul 30, 2010 14:19.
(show comment)
Changes from 7 to 8 >>
Key
This line was removed.
This word was removed. This word was added.
This line was added.

Changes (13)

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

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

example: petalview

Create 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)

example: user: view
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

pwd: view
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*

...


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



Save the file.

...



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