[jira] [Created] (NIFI-8378) PutDatabaseRecord / MySQL does not allowed queries

["DEOM Damien (Jira)" <ji...@apache.org>]

DEOM Damien created NIFI-8378:
---------------------------------

             Summary: PutDatabaseRecord / MySQL does not allowed queries
                 Key: NIFI-8378
                 URL: https://issues.apache.org/jira/browse/NIFI-8378
             Project: Apache NiFi
          Issue Type: Bug
            Reporter: DEOM Damien
         Attachments: image-2021-03-29-20-05-13-207.png, image-2021-03-29-20-05-35-615.png

 
PutDatabaseRecord and MySQL seems to make 'meta' queries outside the specified database if the statement type is predefined.

These queries are not allowed on non admin sql users. The pb is that it is not obious to track tem. I get this error message:
{quote}
 PutDatabaseRecord[id=6fd1383b-aab8-194b-8622-babb62ae1376] Failed to process StandardFlowFileRecord[uuid=a6ca67dd-a921-4714-84d0-0dbf2c1f40dd,claim=StandardContentClaim [resourceClaim=StandardResourceClaim[id=1617036481159-111, container=default, section=111], offset=300938, length=417],offset=0,name=a6ca67dd-a921-4714-84d0-0dbf2c1f40dd,size=417] due to java.sql.SQLSyntaxErrorException: SELECT command denied to user 'pda-user-int'@'192.168.50.6' for table 'channel':
{quote}
 

Could you explain what queries are done ?

Thx


Here is my configuration:

 

!image-2021-03-29-20-05-13-207.png!

MySQL user:

!image-2021-03-29-20-05-35-615.png!



--
This message was sent by Atlassian Jira
(v8.3.4#803005)