[prev in list] [next in list] [prev in thread] [next in thread]
List: jboss-user
Subject: [jboss-user] [jBPM] - jBPM and Mysql
From: antonio severino <do-not-reply () jboss ! com>
Date: 2013-07-31 9:57:05
Message-ID: 2-830679-3-157742-1375264617744.jivesbs.jivemailuser () https://community ! jboss ! org
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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]
[Attachment #5 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; \
margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: \
1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; \
-webkit-border-radius: 6px;"> <tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" \
style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: \
6px; -webkit-border-radius: 6px;"> <tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px \
solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; \
-moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; \
-webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; \
margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag \
-->
<!-- Email clients will render the images when the message is read so any \
image -->
<!-- must be made available on a public server, so that all recipients can \
load the image. -->
<a href="https://community.jboss.org/index.jspa" style="text-decoration: \
none; color: #E1E1E1">JBoss Community</a></h1> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; \
color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; \
-moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; \
-webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: \
17px; font-weight: normal;"> jBPM and Mysql
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/antseverino">antonio \
severino</a> in <i>jBPM</i> - <a \
href="https://community.jboss.org/message/830679#830679">View the full discussion</a> \
</span> <hr style="margin: 20px 0; border: none; background-color: #dadada; height: \
1px;">
<div class="jive-rendered-content"><p class="Paragraph SCX245078120" \
style="font-size: 6pt; color: windowtext;"><span class="TextRun SCX245078120" \
style="color: #333333; font-size: 11pt; font-family: Arial, sans-serif;">Hi \
</span><span class="TextRun SCX245078120" style="color: #555555; background-color: \
#eef4f9; font-size: 11pt; font-family: 'Lucida Sans', sans-serif;"><span \
class="NormalTextRun SCX245078120" style="background-color: \
inherit;">community</span></span><span class="TextRun SCX245078120" style="color: \
#333333; font-size: 11pt; font-family: Arial, sans-serif;">,</span><span \
class="LineBreakBlob BlobObject SCX245078120" style="font-size: 11pt; font-family: \
Arial, sans-serif;"><span class="SCX245078120"> </span><br \
class="SCX245078120"/></span><span class="TextRun SCX245078120" style="color: \
#333333; font-size: 11pt; font-family: Arial, sans-serif;"><span class="NormalTextRun \
SCX245078120">I </span><span class="SpellingError SCX245078120" \
style="border-bottom-style: solid; border-bottom-width: 1px; border-bottom-color: \
transparent; background-position: repeat no-repeat;">installed</span><span \
class="NormalTextRun SCX245078120"> </span><span class="SpellingError SCX245078120" \
style="border-bottom-style: solid; border-bottom-width: 1px; border-bottom-color: \
transparent; background-position: repeat no-repeat;">jBPM</span><span \
class="NormalTextRun SCX245078120"> with </span><span class="SpellingError \
SCX245078120" style="border-bottom-style: solid; border-bottom-width: 1px; \
border-bottom-color: transparent; background-position: repeat \
no-repeat;">mysql</span><span class="NormalTextRun SCX245078120"> </span><span \
class="SpellingError SCX245078120" style="border-bottom-style: solid; \
border-bottom-width: 1px; border-bottom-color: transparent; background-position: \
repeat no-repeat;">following</span><span class="NormalTextRun SCX245078120"> \
</span><span class="SpellingError SCX245078120" style="border-bottom-style: solid; \
border-bottom-width: 1px; border-bottom-color: transparent; background-position: \
repeat no-repeat;">this</span><span class="NormalTextRun SCX245078120"> </span><span \
class="SpellingError SCX245078120" style="border-bottom-style: solid; \
border-bottom-width: 1px; border-bottom-color: transparent; background-position: \
repeat no-repeat;">documentation</span><span class="NormalTextRun SCX245078120"> \
"</span><span class="SpellingError SCX245078120" style="border-bottom-style: solid; \
border-bottom-width: 1px; border-bottom-color: transparent; background-position: \
repeat no-repeat;">https</span><span class="NormalTextRun \
SCX245078120">://community.jboss.org/</span><span class="SpellingError SCX245078120" \
style="border-bottom-style: solid; border-bottom-width: 1px; border-bottom-color: \
transparent; background-position: repeat no-repeat;">wiki</span><span \
class="NormalTextRun \
SCX245078120">/SetUpJBPM54FinalInstallerToUseMySQL-OrHowToRunSection37OfTheUserGuide" \
and </span><span class="SpellingError SCX245078120" style="border-bottom-style: \
solid; border-bottom-width: 1px; border-bottom-color: transparent; \
background-position: repeat no-repeat;">it</span><span class="NormalTextRun \
SCX245078120"> </span><span class="SpellingError SCX245078120" \
style="border-bottom-style: solid; border-bottom-width: 1px; border-bottom-color: \
transparent; background-position: repeat no-repeat;">is</span><span \
class="NormalTextRun SCX245078120"> </span><span class="SpellingError SCX245078120" \
style="border-bottom-style: solid; border-bottom-width: 1px; border-bottom-color: \
transparent; background-position: repeat no-repeat;">mostly</span><span \
class="NormalTextRun SCX245078120"> </span><span class="SpellingError SCX245078120" \
style="border-bottom-style: solid; border-bottom-width: 1px; border-bottom-color: \
transparent; background-position: repeat no-repeat;">working</span><span \
class="NormalTextRun SCX245078120">; </span><span class="SpellingError SCX245078120" \
style="border-bottom-style: solid; border-bottom-width: 1px; border-bottom-color: \
transparent; background-position: repeat no-repeat;">but</span><span \
class="NormalTextRun SCX245078120"> </span><span class="SpellingError SCX245078120" \
style="border-bottom-style: solid; border-bottom-width: 1px; border-bottom-color: \
transparent; background-position: repeat no-repeat;">when</span><span \
class="NormalTextRun SCX245078120"> I </span><span class="SpellingError SCX245078120" \
style="border-bottom-style: solid; border-bottom-width: 1px; border-bottom-color: \
transparent; background-position: repeat no-repeat;">select</span><span \
class="NormalTextRun SCX245078120"> "report </span><span class="SpellingError \
SCX245078120" style="border-bottom-style: solid; border-bottom-width: 1px; \
border-bottom-color: transparent; background-position: repeat \
no-repeat;">templates</span><span class="NormalTextRun SCX245078120">" from \
"reporting" </span><span class="SpellingError SCX245078120" \
style="border-bottom-style: solid; border-bottom-width: 1px; border-bottom-color: \
transparent; background-position: repeat no-repeat;">section</span><span \
class="NormalTextRun SCX245078120"> and click on "create report" </span><span \
class="SpellingError SCX245078120" style="border-bottom-style: solid; \
border-bottom-width: 1px; border-bottom-color: transparent; background-position: \
repeat no-repeat;">button</span><span class="NormalTextRun SCX245078120"> the report \
</span><span class="SpellingError SCX245078120" style="border-bottom-style: solid; \
border-bottom-width: 1px; border-bottom-color: transparent; background-position: \
repeat no-repeat;">is</span><span class="NormalTextRun SCX245078120"> </span><span \
class="SpellingError SCX245078120" style="border-bottom-style: solid; \
border-bottom-width: 1px; border-bottom-color: transparent; background-position: \
repeat no-repeat;">empty</span><span class="NormalTextRun SCX245078120"> and in \
server.log </span></span><span class="TextRun SCX245078120" style="color: #333333; \
font-size: 11pt; font-family: Arial, sans-serif;"><span class="NormalTextRun \
SCX245078120"></span><span class="SpellingError SCX245078120" \
style="border-bottom-style: solid; border-bottom-width: 1px; border-bottom-color: \
transparent; background-position: repeat no-repeat;">this</span><span \
class="NormalTextRun SCX245078120"> </span><span class="SpellingError SCX245078120" \
style="border-bottom-style: solid; border-bottom-width: 1px; border-bottom-color: \
transparent; background-position: repeat no-repeat;">error</span><span \
class="NormalTextRun SCX245078120"> </span></span><span class="TextRun SCX245078120" \
style="color: #333333; font-size: 11pt; font-family: Arial, sans-serif;"><span \
class="SpellingError SCX245078120" style="border-bottom-style: solid; \
border-bottom-width: 1px; border-bottom-color: transparent; background-position: \
repeat no-repeat;">appears</span><span class="NormalTextRun \
SCX245078120">:</span></span><span class="LineBreakBlob BlobObject SCX245078120" \
style="font-size: 11pt; font-family: Arial, sans-serif;"><span class="SCX245078120"> \
</span><br class="SCX245078120"/></span><span class="TextRun EmptyTextRun \
SCX245078120" style="color: windowtext; font-size: 11pt;"></span><span class="EOP \
SCX245078120" style="font-size: 11pt;"> </span></p><p class="Paragraph SCX245078120" \
style="font-size: 6pt; color: windowtext;"><span class="TextRun SCX245078120" \
style="color: #333333; font-size: 11pt; font-family: Arial, sans-serif;"><span \
class="SpellingError SCX245078120" style="border-bottom-style: solid; \
border-bottom-width: 1px; border-bottom-color: transparent; background-position: \
repeat no-repeat;">Caused</span><span class="NormalTextRun SCX245078120"> by: \
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT </span><span \
class="SpellingError SCX245078120" style="border-bottom-style: solid; \
border-bottom-width: 1px; border-bottom-color: transparent; background-position: \
repeat no-repeat;">command</span><span class="NormalTextRun SCX245078120"> \
</span><span class="SpellingError SCX245078120" style="border-bottom-style: solid; \
border-bottom-width: 1px; border-bottom-color: transparent; background-position: \
repeat no-repeat;">denied</span><span class="NormalTextRun SCX245078120"> to \
</span><span class="SpellingError SCX245078120" style="border-bottom-style: solid; \
border-bottom-width: 1px; border-bottom-color: transparent; background-position: \
repeat no-repeat;">user</span><span class="NormalTextRun SCX245078120"> \
'jbpm5'@'localhost' for </span><span class="SpellingError SCX245078120" \
style="border-bottom-style: solid; border-bottom-width: 1px; border-bottom-color: \
transparent; background-position: repeat no-repeat;">table</span><span \
class="NormalTextRun SCX245078120"> '</span><span class="SpellingError SCX245078120" \
style="border-bottom-style: solid; border-bottom-width: 1px; border-bottom-color: \
transparent; background-position: repeat no-repeat;">processinstancelog</span><span \
class="NormalTextRun SCX245078120">'</span></span><span class="LineBreakBlob \
BlobObject SCX245078120" style="font-size: 11pt; font-family: Arial, \
sans-serif;"><span class="SCX245078120"> </span><br \
class="SCX245078120"/></span><span class="TextRun EmptyTextRun SCX245078120" \
style="color: #333333; font-size: 11pt; font-family: Arial, sans-serif;"></span><span \
class="EOP SCX245078120" style="font-size: 11pt; font-family: Arial, sans-serif;"> \
</span></p><p class="Paragraph SCX245078120" style="font-size: 6pt; color: \
windowtext;"><span class="TextRun SCX245078120" style="color: #333333; font-size: \
11pt; font-family: Arial, sans-serif;"><span class="NormalTextRun \
SCX245078120"></span></span><span class="EOP SCX245078120" style="font-size: 11pt; \
font-family: Arial, sans-serif;"> </span></p><p class="Paragraph SCX245078120" \
style="font-size: 6pt; color: windowtext;"><span class="TextRun SCX245078120" \
style="color: #333333; font-size: 11pt; font-family: Arial, sans-serif;"><span \
class="SpellingError SCX245078120" style="border-bottom-style: solid; \
border-bottom-width: 1px; border-bottom-color: transparent; background-position: \
repeat no-repeat;">If</span><span class="NormalTextRun SCX245078120"> I </span><span \
class="SpellingError SCX245078120" style="border-bottom-style: solid; \
border-bottom-width: 1px; border-bottom-color: transparent; background-position: \
repeat no-repeat;">manually</span><span class="NormalTextRun SCX245078120"> \
</span><span class="SpellingError SCX245078120" style="border-bottom-style: solid; \
border-bottom-width: 1px; border-bottom-color: transparent; background-position: \
repeat no-repeat;">execute</span><span class="NormalTextRun SCX245078120"> the \
</span><span class="SpellingError SCX245078120" style="border-bottom-style: solid; \
border-bottom-width: 1px; border-bottom-color: transparent; background-position: \
repeat no-repeat;">select</span><span class="NormalTextRun SCX245078120"> from \
</span><span class="SpellingError SCX245078120" style="border-bottom-style: solid; \
border-bottom-width: 1px; border-bottom-color: transparent; background-position: \
repeat no-repeat;">mysql</span><span class="NormalTextRun SCX245078120"> with use \
jbpm5 </span><span class="SpellingError SCX245078120" style="border-bottom-style: \
solid; border-bottom-width: 1px; border-bottom-color: transparent; \
background-position: repeat no-repeat;">it</span><span class="NormalTextRun \
SCX245078120"> </span><span class="SpellingError SCX245078120" \
style="border-bottom-style: solid; border-bottom-width: 1px; border-bottom-color: \
transparent; background-position: repeat no-repeat;">works</span><span \
class="NormalTextRun SCX245078120"> </span><span class="SpellingError SCX245078120" \
style="border-bottom-style: solid; border-bottom-width: 1px; border-bottom-color: \
transparent; background-position: repeat no-repeat;">fawlessely</span><span \
class="NormalTextRun SCX245078120">... </span><span class="SpellingError \
SCX245078120" style="border-bottom-style: solid; border-bottom-width: 1px; \
border-bottom-color: transparent; background-position: repeat \
no-repeat;">any</span><span class="NormalTextRun SCX245078120"> idea \
?</span></span><span class="EOP SCX245078120" style="font-size: 11pt; font-family: \
Arial, sans-serif;"> </span></p><p class="Paragraph SCX245078120" style="min-height: \
8pt; height: 8pt; padding: 0px;"> </p><p class="Paragraph SCX245078120" \
style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p class="Paragraph \
SCX245078120" style="font-size: 6pt; color: windowtext;"><span class="EOP \
SCX245078120" style="font-size: 11pt; font-family: Arial, sans-serif;">The user was \
created with the following command:</span></p><p class="Paragraph SCX245078120" \
style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p class="Paragraph \
SCX245078120" style="font-size: 6pt; color: windowtext;"><span class="EOP \
SCX245078120" style="font-size: 11pt; font-family: Arial, sans-serif;"><code \
class="jive-code" style="font-family: 'Droid Sans Mono', monospace \
!important;">CREATE USER 'jbpm5'@'localhost' IDENTIFIED BY 'jbpm5';<br/>GRANT ALL \
PRIVILEGES ON jbpm5.* TO 'jbpm5'@'localhost';</code><br/></span></p><p \
class="Paragraph SCX245078120" style="min-height: 8pt; height: 8pt; padding: \
0px;"> </p><p class="Paragraph SCX245078120" style="font-size: 6pt; color: \
windowtext;"><span class="EOP SCX245078120" style="font-size: 11pt; font-family: \
Arial, sans-serif;"><br/></span></p><p class="Paragraph SCX245078120" \
style="font-size: 6pt; color: windowtext;"><span class="TextRun SCX245078120" \
style="color: #333333; font-size: 11pt; font-family: Arial, sans-serif;"><span \
class="NormalTextRun SCX245078120"></span></span><span class="EOP SCX245078120" \
style="font-size: 11pt; font-family: Arial, sans-serif;"> </span></p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a \
href="https://community.jboss.org/message/830679#830679">going to Community</a></p> \
<p style="margin: 0;">Start a new discussion in jBPM at <a \
href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic