[jboss-user] [jBPM] - jBPM and Mysql

[antonio severino]

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&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20130731/edf2ad81/attachment.html