MySQL
Get
MySQL from
http://www.mysql.com/ and follow the install instructions.
Create a new database using something like...
/path/to/mysql/bin/mysqladmin -u root -p rootpassword create Peer
Then go to the mysql command line for the database with something like...
mysql -u username -ppassword Peer
Create a new user account using somthing like...
GRANT ALL
ON Peer.*
TO username IDENTIFIED BY 'password'
Make sure that the Plugin config variables match the database setup:
my $reviewTable = "reviews";
my $tempTable = "temp";
my $tempOutTable= "tempout";
my $tempCountTable = "tempcount";
my $tempBestTable = "tempbest";
my $dataBase = "dbi:mysql:Peer";
my $dbUsername = "username";
my $dbPassword = "password";
The following table needS to be created manually:
CREATE TABLE reviews
(Reviewer VARCHAR(255) NOT NULL,
Topic VARCHAR(255) NOT NULL,
TopicRev INT,
Notify INT NOT NULL,
Quality INT NOT NULL,
Relevance INT,
Completeness INT,
Timeliness INT,
Comment VARCHAR(255),
DateTime DATETIME)
The following tables are automatically created by Review.pm - this allows each connection to have private tables with the same name...make sure that the user has create privileges.
CREATE TEMPORARY TABLE temp
(Reviewer VARCHAR(255) NOT NULL,
Topic VARCHAR(255) NOT NULL,
TopicRev INT,
Notify INT NOT NULL,
Quality INT NOT NULL,
Relevance INT,
Completeness INT,
Timeliness INT,
Comment VARCHAR(255),
DateTime DATETIME)
CREATE TEMPORARY TABLE tempout
(Reviewer VARCHAR(255) NOT NULL,
Topic VARCHAR(255) NOT NULL,
TopicRev INT,
Notify INT NOT NULL,
Quality INT NOT NULL,
Relevance INT,
Completeness INT,
Timeliness INT,
Comment VARCHAR(255),
DateTime DATETIME)
CREATE TEMPORARY TABLE tempcount
(Topic VARCHAR(255),
Count INT)
CREATE TEMPORARY TABLE tempbest
(Topic VARCHAR(255),
Quality INT,
Metric INT)