Hello, I would like to run CommonsNotifier on fawiki. I have followed the instructions, and everything seems OK except for the database part. When I run bin/first-run, I get the following error
Traceback (most recent call last): File "/mnt/nfs/labstore-secondary-tools-project/nn1l2bot/bot/virtualenv/lib/python3.5/site-packages/pymysql/connections.py", line 920, in connect **kwargs) File "/usr/lib/python3.5/socket.py", line 712, in create_connection raise err File "/usr/lib/python3.5/socket.py", line 703, in create_connection sock.connect(sa) ConnectionRefusedError: [Errno 111] Connection refused During handling of the above exception, another exception occurred: Traceback (most recent call last): File "./make-list.py", line 11, in <module> userdb = mysql.connect() File "/mnt/nfs/labstore-secondary-tools-project/nn1l2bot/bot/commonsbot/mysql.py", line 33, in connect use_unicode=True) File "/mnt/nfs/labstore-secondary-tools-project/nn1l2bot/bot/virtualenv/lib/python3.5/site-packages/pymysql/__init__.py", line 90, in Connect return Connection(*args, **kwargs) File "/mnt/nfs/labstore-secondary-tools-project/nn1l2bot/bot/virtualenv/lib/python3.5/site-packages/pymysql/connections.py", line 699, in __init__ self.connect() File "/mnt/nfs/labstore-secondary-tools-project/nn1l2bot/bot/virtualenv/lib/python3.5/site-packages/pymysql/connections.py", line 967, in connect raise exc pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ([Errno 111] Connection refused)") CRITICAL: Exiting due to uncaught exception <class 'pymysql.err.OperationalError'>
I want to run the code by User:4nn1l2bot from toolforge. Currently, my.cnf file reads:
[client] password = <redacted> user = s53099 host = tools.db.svc.eqiad.wmflabs database = s53099__commonsbot
I have spent several hours to get familiar with the process, but I'm stuck. I would appreciate your help.