Hi community, I installedjBPM with mysqlfollowingthisdocumentation "https://community.jboss.org/wiki/SetUpJBPM54FinalInstallerToUseMySQL-OrHowToRunSection37OfTheUserGuide" and itismostlyworking; butwhen I select "report templates" from "reporting" section and click on "create report" button the report isempty and in server.log thiserrorappears:
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT commanddenied to user 'jbpm5'@'localhost' for table 'processinstancelog'
If I manuallyexecute the select from mysql with use jbpm5 itworksfawlessely... any idea ?
The user was created with the following command:
CREATE USER 'jbpm5'@'localhost' IDENTIFIED BY 'jbpm5'; GRANT ALL PRIVILEGES ON jbpm5.* TO 'jbpm5'@'localhost';