I am using phpmyadmin. I am using a trigger in mysql which calls a php script after inserting something in a table. My trigger contains this.
DECLARE result INT;
SET result=(select sys_exec('C:/xampp/php/php.exe C:/xampp/htdocs/mysite/hello.php'));
But i got this error while trying to insert something to the table.
#1305 FUNCTION db.sys_exec does not exists
(my database name is db) Help me with this.Thanks.
sys_exec is not a standard mysql function. It's provided by an external UDF plugin, and must be installed separately: https://github.com/mysqludf/lib_mysqludf_sys#readme
In Linux Ubuntu system and few other distributions, mysql server package contains apparmor which limits UDF functions.
Stop apparmor
sudo service apparmor stop
Check apparmor status
sudo service apparmor status
Even then if you get the same error, restart mysql service
Restart mysql
sudo service mysql restart
Git clone the files on machine having MySQL deployed
git clone https://github.com/mysqludf/lib_mysqludf_sys
Execute below command in the directory where the above repo is checked out :
gcc -DMYSQL_DYNAMIC_PLUGIN -fPIC -Wall -m64 -I/usr/include/mysql -I. -shared lib_mysqludf_sys.c -o lib_mysqludf_sys.so
Copy the file lib_mysqludf_sys.so to /usr/lib/mysql/plugin/ The location /usr/lib/mysql/plugin/ is one to be verified by running below command in mysql shell
SHOW VARIABLES where variable_name = 'plugin_dir';
Now finally create the function in my sql shell;
CREATE FUNCTION sys_exec RETURNS INT SONAME 'lib_mysqludf_sys.so';
Verify that the function is created, using below command in mysql shell. This command shall return rows with one containing sys_exec as well:
select * from mysql.func;
