0 Replies Latest reply on Jul 31, 2013 5:56 AM by antseverino

    jBPM and Mysql


      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';