antonio severino [
https://community.jboss.org/people/antseverino] created the discussion
"jBPM and Mysql"
To view the discussion, visit:
https://community.jboss.org/message/830679#830679
--------------------------------------------------------------
Hi community,
I installed jBPM with mysql following this documentation
"https://community.jboss.org/wiki/SetUpJBPM54FinalInstallerToUseMySQL-OrHowToRunSection37OfTheUserGuide"
and it is mostly working; but when I select "report templates" from
"reporting" section and click on "create report" button the report is
empty and in server.log this error appears:
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command
denied to user 'jbpm5'@'localhost' for table 'processinstancelog'
If I manually execute the select from mysql with use jbpm5 it works fawlessely... 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';
--------------------------------------------------------------
Reply to this message by going to Community
[
https://community.jboss.org/message/830679#830679]
Start a new discussion in jBPM at Community
[
https://community.jboss.org/choose-container!input.jspa?contentType=1&...]