Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: PHP exec to restart mysqld
Top Forums Programming PHP exec to restart mysqld Post 302641851 by noPermissions on Wednesday 16th of May 2012 02:40:35 PM
Old 05-16-2012
PHP exec to restart mysqld
I want to do something very very bad. I want to create a button that restarts mysqld. Why is irrelevant for my issue.

Here is my php script ...
Code:
<?php
if(isset($_POST['restart'])){
       	exec("sudo /etc/init.d/mysqld restart");        
}
?>
<form method="POST">
<input type="submit" name="restart" value="restart">
</form>

On any old server this usually can work. But on my locked down amazon ec2 server it doesn't. I tried putting this in the sudoers file but the button still doesn't restart mysqld.

Code:
Cmnd_Alias RESTART_APACHE = /etc/init.d/httpd restart
apache ALL =NOPASSWD: RESTART_APACHE

Cmnd_Alias RESTART_MYSQL = /etc/init.d/mysqld restart
apache ALL =NOPASSWD: RESTART_MYSQL

I'm stumped, at wits end, maybe someone here knows the solution ?
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

how can I restart X server ?

WITHOUT shutdown X ??? thanks , Ivan (6 Replies)
Discussion started by: oneivan
6 Replies

2. BSD

mysqld

Hello I installed mysql41 this is the end of the installation but when I try to launch the mysqld daemon it write this: note: LodelServoo is a CMS which need mysql I verify that the dir mysql existed under /var/db, but it doesn't so naively I created it and launch again the mysqld... (4 Replies)
Discussion started by: SoulCoder
4 Replies

3. Shell Programming and Scripting

Exec bash shell via PHP Site !

Hi everybody ! I writed php code so exec bash shell via php (SMS Send via bash shell) but i have problem as follow : 1. When i exec from linux mode : ./sms.sh --- output is "Messages ... OK". Then all message has been sent. 2. When i exec from PHP site --- return value is "Message ... OK" on... (1 Reply)
Discussion started by: lamthenhan
1 Replies

4. Web Development

Can't restart apache. PHP is broken.

I need to restart my apache, but apachectl configtest tells me that Syntax error on line 208 of /etc/httpd/conf/httpd.conf: Cannot load /usr/local/apache/libexec/libphp4.so into server: /usr/local/apache/libexec/libphp4.so: undefined symbol: ap_signal I've tried rebuilding php, I'm not... (2 Replies)
Discussion started by: tatebn
2 Replies

5. Shell Programming and Scripting

php shell_exec, exec command timeout

HI, Does anybody know if its possible to execute a command through exec, shell exec, system and if the program doesn't terminate in N seconds returns control to PHP ? reg, research3 ---------- Post updated 10-16-09 at 12:20 AM ---------- Previous update was 10-15-09 at 11:03 PM... (1 Reply)
Discussion started by: research3
1 Replies

6. Red Hat

comm: mysqld Not tainted ... Kernel Panic , System totally unresponsive

Hi, I am experiencing frequent system hangs, hard kernel panics, etc almost thrice a day. The system would be totally unresponsive and the only way is to reboot is hard power recycling (plug out the power cable and plug in back after 30 secs). I enabled kdump, but unfortunately the kdump files... (3 Replies)
Discussion started by: massoo
3 Replies

7. UNIX for Dummies Questions & Answers

mysqld overloading cpu of VPS

Hi bros I have a VPS 512mb (Burst 2GB) with Kloxo installed and hosting few sites on it with not much traffic I am facing high cpu load for the last few days and seems mysqld is overloading the cpu Any suggestion will be appreciated Regards Rizwan Top output is as under top -... (2 Replies)
Discussion started by: rizwan65
2 Replies

8. Red Hat

MySQL (mysqld) fails to start!

Hello, I have recently installed MySql and I encourage an error. I am using Fedora 15 and when I am trying to start mysqld service i am getting the following error message: Starting mysqld (via systemctl): Job failed. See system logs and 'systemctl status' for details. If I try to start it... (4 Replies)
Discussion started by: dot_pro
4 Replies

9. Shell Programming and Scripting

Script Variables Inquiry, Values Okay in Standalone Exec, No-Show in Cron Exec

I have the following bash script lines in a file named test.sh. #!/bin/bash # # Write Date to cron.log # echo "Begin SSI Load $(date +%d%b%y_%T)" # # Get the latest rates file for processing. # d=$(ls -tr /rms/data/ssi | grep -v "processed" | tail -n 1) filename=$d export filename... (3 Replies)
Discussion started by: ginowms
3 Replies

10. Homework & Coursework Questions

Mysql missing mysqld.sock (Linux)

I am trying to start a server for a class I am in but... mysql won't start with this error ( ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ) ---------- Post updated at 03:51 PM ---------- Previous update was at 03:50 PM ---------- ... (2 Replies)
Discussion started by: Slayer939
2 Replies

LEARN ABOUT LINUX

mysqld

MYSQLD(8)						       MySQL Database System							 MYSQLD(8)

NAME

       mysqld - the MySQL server

SYNOPSIS

       mysqld [options]

DESCRIPTION

       mysqld, also known as MySQL Server, is the main program that does most of the work in a MySQL installation. MySQL Server manages access to
       the MySQL data directory that contains databases and tables. The data directory is also the default location for other information such as
       log files and status files.

       When MySQL server starts, it listens for network connections from client programs and manages access to databases on behalf of those
       clients.

       The mysqld program has many options that can be specified at startup. For a complete list of options, run this command:

	   shell> mysqld --verbose --help

       MySQL Server also has a set of system variables that affect its operation as it runs. System variables can be set at server startup, and
       many of them can be changed at runtime to effect dynamic server reconfiguration. MySQL Server also has a set of status variables that
       provide information about its operation. You can monitor these status variables to access runtime performance characteristics.

       For a full description of MySQL Server command options, system variables, and status variables, see Section 5.1, "The MySQL Server". For
       information about installing MySQL and setting up the initial configuration, see Chapter 2, Installing and Upgrading MySQL.

COPYRIGHT

       Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.

       This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
       published by the Free Software Foundation; version 2 of the License.

       This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

       You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
       Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.

SEE ALSO

       For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
       at http://dev.mysql.com/doc/.

AUTHOR

       Oracle Corporation (http://dev.mysql.com/).

MySQL 5.5							    01/30/2014								 MYSQLD(8)
All times are GMT -4. The time now is 11:49 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy