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)
