Question
Hello,, i created a telegram bot that will check the server especially apache and mysql server.. why i cant use "systemctl stop mysql"?
By the way, the “systemctl stop mysql” code is implemented in the python source code. If I’m using in the terminal or putty, its succeed.. but by implementing it in the python source code for the telegram bot that been integrated with the server itself, it cant be done..
:- Ubuntu server 16.04
:- Wordpress 4.7
:- Windows 8.1
:- Python Source Code
:- Telegram application for Android 6.0
Source code is:
def stopmysql(self, stopmysql):
stop = “systemctl stop mysql”
if stopmysql == “/mysqlstop”:
process = subprocess.Popen(stop.split(), stdout=subprocess.PIPE, shell=True)
output = “MySQL Stop: \n” + process.communicate()[0]
else:
print “Debug message: nothing to do :&(”
return output
Just a wild guess. can you use full path to mysql like /etc/init.d./mysql stop
better way of doing this to issue mysqldmin to shut itself. this is the finest and safest way of shutting down mysql without any data crashes
mysqladmin -u'root’ -p'Password’ shutdown
this will definitely work.
@superdevop it seems that this code “mysqladmin -u'root’ -p'Password’ shutdown” sent me a bad request (400) in bot.. “sudo /etc/init.d./mysql stop”, i have done this but still not actions taken.. if my password wordpress same as mysql, can i made it?