pymysql.err.OperationalError

1

Dear All,
I got problems as below and I am new in ERPNExt, so can you all help some answer here?

OperationalError: (2003, “Can’t connect to MySQL server on u’localhost’ ([Errno 111] Connection refused)”)

File “/home/reansey/ibilling/apps/frappe/frappe/middlewares.py”, line 15, in call

return super(StaticDataMiddleware, self).call(environ, start_response)

File “/home/reansey/ibilling/env/lib/python2.7/site-packages/werkzeug/wsgi.py”, line 766, in call

return self.app(environ, start_response)

File “/home/reansey/ibilling/env/lib/python2.7/site-packages/werkzeug/wsgi.py”, line 766, in call

return self.app(environ, start_response)

File “/home/reansey/ibilling/env/lib/python2.7/site-packages/werkzeug/local.py”, line 228, in application

return ClosingIterator(app(environ, start_response), self.cleanup)

File “/home/reansey/ibilling/env/lib/python2.7/site-packages/werkzeug/wrappers.py”, line 308, in application

resp = f(*args[:-2] + (request,))

2

@reansey It seems your Mysql is Down

try this :

sudo /etc/init.d/mysql start

1 Like
3

Are you still facing the issue?

1 Like
4

Let sorry just back from working, so let me working on. And I will added here if it fix. Thanks

5

Hello,
I am still got these message:
reansey@ubuntu:~/ibilling$ sudo /etc/init.d/mysql start
[sudo] password for reansey:
[…] Starting mysql (via systemctl): mysql.serviceJob for mariadb.service failed because the control process exited with error code. See “systemctl status mariadb.service” and “journalctl -xe” for details.
failed!

6

What is the output for systemctl status mariadb.service

1 Like
7

Hello am not at computer, so when I am checking then will answer here. Thanks

8

Hello I got these message:
Starting mysql (via systemctl): mysql.serviceJob for mariadb.service failed because the control process exited with error code. See “systemctl status mariadb.service” and “journalctl -xe” for details.
failed!

9

And how to check systemctl status mariadb.service ?

10

Run it on terminal (ssh)

BTW: you’re from ibilling.asia?