Stored Procedure Permission Issue - MySQL

dev google-group-archive
1

I get the following message when I try to execute a stored procedure.
“User does not have access to metadata required to determine stored
procedure parameter types. If rights can not be granted, configure
connection with “noAccessToProcedureBodies=true” to have driver generate
parameters that represent INOUT strings irregardless of actual parameter
types.”

I’ve done GRANT ALL ON PROCEDURE database.proc TO databaseuser@localhost;

Where the database is the database name, the proc is the name of the stored
procedure and the databaseuser is the name of the user I set to Lucee to
connect as.

The GRANT statement executes successfully, but it doesn’t change the
outcome. I still receive this error. I’m doing a very simple two param
call to a stored proc.

    <cfstoredproc procedure="getOpenProjects"> 
        <cfprocparam cfsqltype="cf_sql_date" value="#arguments.d#" />
        <cfprocparam cfsqltype="cf_sql_numeric" value=

“#session.marketid#” />



2

I’ve still got the same issue. I’ve deleted the MySQL user and started
over. Assigned the privileges, didn’t work.

Then FLUSH PRIVILEGES; Still didn’t work.

I’ve used the Lucee syntax for the stored procedure call:
storedproc procedure=“getOpenProjects”
result=“response”
returncode=“true” {
procparam type=“in” cfsqltype=“cf_sql_varchar” value=“someValue”;
procresult resultSet=1 name=“result”;
}

Still didn’t work.

Anyone got this issue or seen something similar? I’ve found this
Stackoverflow that has the same error message, but not sure what to do with
it in regards to Coldfusion/Lucee:

I logged into MySQL as the user that Lucee uses to connect to MySQL
Workbench and I can use:
CALL getOpenProjects(‘2016-10-01’,1);
And it works as it should, so the user has access, as far as I can tell,
since that entire session in MySQL workbench is running as the user Lucee
is using.

Thoughts? Anyone?On Saturday, November 5, 2016 at 9:22:59 AM UTC-5, Mischa Suemnig wrote:

I get the following message when I try to execute a stored procedure.
“User does not have access to metadata required to determine stored
procedure parameter types. If rights can not be granted, configure
connection with “noAccessToProcedureBodies=true” to have driver generate
parameters that represent INOUT strings irregardless of actual parameter
types.”

I’ve done GRANT ALL ON PROCEDURE database.proc TO databaseuser@localhost;

Where the database is the database name, the proc is the name of the
stored procedure and the databaseuser is the name of the user I set to
Lucee to connect as.

The GRANT statement executes successfully, but it doesn’t change the
outcome. I still receive this error. I’m doing a very simple two param
call to a stored proc.

    <cfstoredproc procedure="getOpenProjects"> 
        <cfprocparam cfsqltype="cf_sql_date" value="#arguments.d#" />
        <cfprocparam cfsqltype="cf_sql_numeric" value=

“#session.marketid#” />



3

OK, wow…apparently if you have “returncode=‘false’ or returncode=‘true’”
in your call, it won’t work. Remove that and you should be good.On Saturday, November 5, 2016 at 9:22:59 AM UTC-5, Mischa Suemnig wrote:

I get the following message when I try to execute a stored procedure.
“User does not have access to metadata required to determine stored
procedure parameter types. If rights can not be granted, configure
connection with “noAccessToProcedureBodies=true” to have driver generate
parameters that represent INOUT strings irregardless of actual parameter
types.”

I’ve done GRANT ALL ON PROCEDURE database.proc TO databaseuser@localhost;

Where the database is the database name, the proc is the name of the
stored procedure and the databaseuser is the name of the user I set to
Lucee to connect as.

The GRANT statement executes successfully, but it doesn’t change the
outcome. I still receive this error. I’m doing a very simple two param
call to a stored proc.

    <cfstoredproc procedure="getOpenProjects"> 
        <cfprocparam cfsqltype="cf_sql_date" value="#arguments.d#" />
        <cfprocparam cfsqltype="cf_sql_numeric" value=

“#session.marketid#” />