The initialisition error:
Table 'hybris.pcp2wrtblecvrel' doesn't exist
It's a clean developer install of the full 5.3.0.2 commerce suite, the mysql schema is initialised as follows:
CREATE USER 'hybris'@'localhost' IDENTIFIED BY ‘hybris’;
CREATE DATABASE hybris DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
GRANT ALL ON hybris.* TO 'hybris'@‘localhost’;
flush privileges;
The local.properties config for mysql:
db.url=jdbc:mysql://localhost/hybris?useConfigs=maxPerformance&characterEncoding=utf8
db.driver=com.mysql.jdbc.Driver
db.username=hybris
db.password=hybris
db.tableprefix=
db.customsessionsql=SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
mysql.optional.tabledefs=CHARSET=utf8 COLLATE=utf8_bin
mysql.tabletype=InnoDB
mysql.allow.fractional.seconds=true
Version info:
hybris-commerce-suite-5.3.0.2
OpenJDK7u71-2.5.3-0ubuntu0.14.04.1
Mysql Server 5.5.40-0ubuntu0.14.04.1