Search code examples
phpmysqlproxyprocedure

Php cannot run procedure on Proxysql

I made my "Laravel" project connected to "Proxysql". Every query works fine (select, insert, update, func etc.) but if I add a SELECT query without INTO the procedure does not answer to php.

If I connect to "Proxysql" via Mysql WorkBench and call the procedure that works.

I tried to disabled all of the rules and also added a rule about CALL but it doesn't work.

Any idea?

Edit: I talkted to Rene from Proxysql, We understand the problem is coming from Laravel but i still didn't fix the problem, what kind of data should i share about it?

Proxysql issue

Solution

  • Set in PDO constructor attribute PDO::ATTR_EMULATE_PREPARES to TRUE. It solves the problem.