Mysql Udf sys_exec function call to shell script

Question

I am Calling a shell script from mysql UDF function sys_exec :

 SET cmd = CONCAT('cd /home/enablement;sh execute.sh ', CONCAT('1', ' ', '1', ' ', '1'));
SET result = sys_exec(cmd);
SELECT result FROM DUAL;

But I am getting an error code 32512 in result which is probably of two different users one for mysql and other for linux (for execute.sh script) , can you please guide me the way how can I be able to make mysql user to access execute.sh file while invoking sys_exec function.

Thanks In Adv

if that's MYSQL it wont work you need to specify your variables, for example: SET @cmd:= CONCAT('cd /home/enablement;sh execute.sh ', CONCAT('1', ' ', '1', ' ', '1')); — jcho360
– jcho360, Commented Oct 12, 2012 at 12:49
yes varaiable cmd is declared in the procedure , I know the error is becuase of not accessing the file execute.sh , how can I make this shell script (execute.sh) to be accessiable to mySQL user. — Bruce_Wayne
– Bruce_Wayne, Commented Oct 12, 2012 at 13:04

user1722669 · Accepted Answer · 2014-04-21 13:58:39Z

3

I know that this post is old but maybe it would help someone
You should do this
$ sudo /etc/init.d/apparmor stop
Because AppArmor limits execution of your UDF function.

answered Apr 21, 2014 at 13:58

user1722669

5082 gold badges9 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

rsmoorthy Over a year ago

Thank you @user1722669. I have been breaking my head for sometime, as sys_exec was always returning 32512. sudo /etc/init.d/apparmor teardown did help!

caheepirs · Accepted Answer · 2017-12-12 09:43:48Z

0

Please don't stop apparmor completely, just enable your use case in apparmor's mysqld profile. For example i need to use redis inside mysql.

$ sudo vim /etc/apparmor.d/usr.sbin.mysqld

Then insert this line at the end

/usr/bin/redis-cli mr,

save the file and reload apparmor

sudo service apparmor reload

edited Dec 12, 2017 at 9:43

answered Dec 12, 2017 at 6:02

caheepirs

11 bronze badge

Collectives™ on Stack Overflow

Mysql Udf sys_exec function call to shell script

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related