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

October 24, 2017 211 views
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 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

2 comments
  • 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?

Be the first one to answer this question.