Hello,, i created a telegram bot that will check the server especially apache and mysql server.. why i cant use "systemctl stop mysql"?

Posted October 24, 2017
WordPress MySQL Python Ubuntu 16.04

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 stop_mysql(self, stop_mysql): stop = “systemctl stop mysql” if stop_mysql == “/mysql_stop”: 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

ravelxtreme93

ravelxtreme93 • October 25, 2017

@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?

Super Devop • October 24, 2017

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.

Submit an answer