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

Subscribe
Share

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

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
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!