Mysql error #1305 FUNCTION db.sys_exec does not exists

Question

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.

Solution

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

Comments

[user3496195]

thanks.. did i need to install lib_mysqludf_sys.sql or any other extension?

[VMai]

You've got to install the binary lib_mysqludf_sys.so first. Maybe you've got to compile this binary for your platform to get this up and running.

[VMai]

@user3496195 And please read the note of caution in the documentation github.com/mysqludf/lib_mysqludf_sys/blob/master/…

[user3496195]

@VMai please provide me some page which has complete installation procedure

[VMai]

@user3496195: A bit more readable: htmlpreview.github.io/?https://github.com/mysqludf/… and have a look at the MySQL manual chapter dev.mysql.com/doc/refman/5.6/en/adding-functions.html

[nl-x]

@user3496195 This is exactly what I tried telling you here: stackoverflow.com/questions/24432115/… But you were too lazy to read through the link I gave you in the comments. You replied "sorry needed something clear".

[VMai]

@user3496195 You've got to compile this module for Windows, the binary at github isn't a windows executable, it's an ELF format file.