Restart MySql Server From The Browser Using PHP/Shell Script In Linux

Question

I want to restart mysql service on click of the button using php.

I have developed application using php till now I tried below things and facing the problem

<?php
if ($_GET['run']) {
  # This code will run if ?run=true is set.
  var_dump(exec("sh rst.sh"));
  exit;
}
?>

<!-- This link will add ?run=true to your URL, myfilename.php?run=true -->
<a href="?run=true">Click Me!</a>

What I am getting is:

string(55) "Restarting mysql (via systemctl): mysql.service failed!"

rest.sh:

#!/bin/bash
/etc/init.d/mysql restart

while executing above file from the commnad line it asks for the password.

any help will be appreciated.

Thanks

That's the error message from your CLI script and has nothing to do with PHP. — Dormilich, Apr 20 '18 at 12:24
Does the apache user have permission to execute `rst.sh` and whatever functions that calls? — chris85, Apr 20 '18 at 12:28
@Dormilich If I run the script from the terminal it asks for the password how do I achieve it using php ? — Casual Coder, Apr 20 '18 at 12:28
What does the shell script do? If you sudo over to the apache user can you execute the script, without doing anything outside of `sh rst.sh`? — chris85, Apr 20 '18 at 12:32
@chris85 my shell script has: #!/bin/bash /etc/init.d/mysql restart — Casual Coder, Apr 20 '18 at 12:34
You are sure your apache user has permissions to execute `/etc/init.d/mysql restart`? What do your error logs show? — chris85, Apr 20 '18 at 12:38
@chris85 it is giving me the following error: Failed to restart mysql.service: Interactive authentication required. See system logs and 'systemctl status mysql.service' for details — Casual Coder, Apr 20 '18 at 12:43
I've never seen `Interactive authentication required` but from an Ubuntu thread that is a request for root permissions. So it sounds like your apache user doesn't have permission, which also is a good idea not to have. — chris85, Apr 20 '18 at 12:46
Why do you need to restart the service from the browser? Maybe just have a CRON do it? Restarting the service multiple times though sounds like you are just masking the real issue. This question would probably be better on ubuntu or serverfault since it is about server security and permissions, not coding. — chris85, Apr 20 '18 at 12:59
I know that you can do input with `proc_*()` but never have used it at this low lever (i.e. only used libraries that use it). — Dormilich, Apr 20 '18 at 13:24

score 2 · Accepted Answer · answered Apr 20 '18 at 12:44

Granting the user that runs PHP/web server permissions to restart any service is generally a bed idea from security perspective not even taking about permission to manage all system daemons or full sudo.

Once you have been warned, you have to make sure the user that is running the PHP script has the permission to run the restart command. As already stated, the issue has likely little to do with PHP. There are several ways from you to proceed here:

You can grant the PHP user the sudo permission to run the desired command and nothing else (how to do that is covered elsewhere) and invoke the command directly from PHP: sudo systemctl restart mysql.
Keep the rst.sh file, get it owned by root, writeable by noone else but root and set SUID bit on that file. This way you can invoke the script without sudo but the script will be run as root thanks to the SUID bit.

#1 feels safer and simpler.

score 0 · Answer 2 · answered Apr 20 '18 at 12:29

0

You could also try with system():

<?php
if ($_GET['run']) {
  # This code will run if ?run=true is set.
  var_dump(system("sh rst.sh"));
  exit;
}
?>

<!-- This link will add ?run=true to your URL, myfilename.php?run=true -->
<a href="?run=true">Click Me!</a>

Though your problem is coming from the script you are running (rst.sh). Check the commands in script, you probably need to a systemctl call with sudo.

answered Apr 20 '18 at 12:29

Stasa Stanisic

34
1
4

Restarting mysql (via systemctl): mysql.service failed! string(55) "Restarting mysql (via systemctl): mysql.service failed!" Still getting the same output. – Casual Coder Apr 20 '18 at 12:31
I can't insert the password from the broswer so how it is possible ? – Casual Coder Apr 20 '18 at 12:32
https://stackoverflow.com/questions/3173201/sudo-in-php-exec But take care, as your password will be plain text in that file. – Stasa Stanisic Apr 20 '18 at 12:39
I am not able to understand the thing can you please give me the example which suits my question ? – Casual Coder Apr 20 '18 at 12:50

score 0 · Answer 3 · edited Aug 13 '23 at 14:16

0

In php try using this command

exec("/etc/init.d/mysql restart");

or push this command to rst.sh

be ensure have chmod +x on file rst.sh

edited Aug 13 '23 at 14:16

Makyen

31,849
12
86
121

answered Apr 20 '18 at 12:35

Kamil Dąbrowski

984
11
17

still the same problem output: string(55) "Restarting mysql (via systemctl): mysql.service failed!" rst.sh does have the execute permission – Casual Coder Apr 20 '18 at 12:36
try make it for direction on server, and check is it okey, becouse you shouldn't get information is failed – Kamil Dąbrowski Apr 20 '18 at 12:37
this solutions help you https://stackoverflow.com/questions/24470559/restart-mysql-by-php – Kamil Dąbrowski Apr 20 '18 at 12:39

Restart MySql Server From The Browser Using PHP/Shell Script In Linux

3 Answers3