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:
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:
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
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
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.
<cfprocparam cfsqltype="cf_sql_date" value="#arguments.d#" />
<cfprocparam cfsqltype="cf_sql_numeric" value=