Deploy cannot connect to mysql

[jameslzhu]

Fabric attempts to connect through the default socket file: /var/run/mysql/mysql.sock. However this is non-existent on the OCF apphost.

TODO: research how the default mysql command connects to the mariadb server, and setup django to use that instead of the socket. (Or find the socket file.)

[jvperrin]

This should be possible through just using the hostname mysql (as mentioned in the docs) and the account username/password. The mysql command I believe uses /etc/mysql/my.cnf for configuration, which just has this:

[client]
host=mysql
password

[jvperrin]

https://stackoverflow.com/a/29655281 might be relevant, not sure how much that would help. Does fabric need to connect from the machine you are deploying from, or does it connect from where the django app is being deployed to?

[jameslzhu]

Hm, it looks more like a deployed project issue than a fabric issue. The fabfile (https://github.com/compserv/hknweb/blob/deploy/fabfile.py) doesn’t do anything with MySQL.

In hknweb/settings/common.py (https://github.com/compserv/hknweb/blob/863407747d1f4e0cbfb5212354c8f4eb5d37e8d9/hknweb/settings/common.py), the DATABASES variable should be responsible for the MySQL settings, but right now (I’m the deploy branch) I’ve only set HOST and NAME (the database name), and leaned on the MySQL config file hierarchy for user credentials.

[jameslzhu]

Fixed! eec0971

Among other things, I specified the mysql conf file at ~/.my.cnf on the apphost, and the mysql host name mysql.

This does break the mysql connection on the Vagrant VM, however.