search

sysown / proxysql

High-performance MySQL proxy with a GPL license.
http://www.proxysql.com
GNU General Public License v3.0
6.05k stars 983 forks source link

How to use third-party programs (HTTP access) to filter SQL queries？ #4571

Closed KAgBMan closed 5 months ago

KAgBMan commented 5 months ago

Now I need to control the database query and want to use a third-party program (providing an HTTP interface) to control it. I will use HTTP to return results to decide whether to allow the SQL query. I found that the Lua function can be configured in the apply field of mysql_query_rules, but I couldn't find a specific method. Need help! vision 2.0.15

JavierJF commented 5 months ago

Hi @KAgBMan,

this statement doesn't make sense to me:

I found that the Lua function can be configured in the apply field of mysql_query_rules, but I couldn't find a specific method. Need help!

There is no bindings feature or anything like that for mysql_query_rules. This looks like a misunderstanding of how ProxySQL works and how to perform query filtering using mysql_query_rules. There is plenty of material for that, I'm closing this for now since it doesn't appear to be any issue.

Please feel free to elaborate on this issue, even if closed in case I misunderstood something.

Regards, Javier.