Troubleshooting

Docker issues

sudo docker-compose up -d not working

This line attempts to configure a datajoint database using an existing docker-image. To diagnose the issue, try the following steps:

• sudo docker-compose ps if nothing is returned, then the issue is likely with docker-compose. Make sure the install is correct and that the config files are in the expected places.

Otherwise, check here.

---

MYSQL issues

mysql -h 127.0.0.1 -u root -P 3306 not working

Depending on the error, a couple things could be wrong. Most commonly, the issue is that mysql is not running in the background and thus can't be logged into.

Fix: https://www.tecmint.com/fix-error-2003-hy000-cant-connect-to-mysql-server-on-127-0-0-1-111/

Summary:

• If ps -Af | grep mysqld only returns an entry with the user name and not with mysql, mysql is not running and needs to be started. Try running: sudo systemctl start mysql.service and/or sudo service mysqld start
• Check again by running ps -Af | grep mysqld
• Get the port information for where mysql is running by: sudo netstat -lnp | grep mysql (default is 3306)
• Try logging into mysql again using that port: mysql -h 127.0.0.1 -u root -P <port> (replacing with the number given in the previous step)