Allow Remote DB Connections

If you use Direct Connection method and run into this error "Could not connect to server: Connection refused", it's likely that you haven't configured your database to allow remote database connection.

If that is the case, please follow these steps:


Open postgresql.conf (usually in /etc/postgresql/9.x/main/) and enable the following:

listen_addresses = '*'

Also, add the following lines to pg_hba.conf:

host all all md5
host all all md5

And restart your database to take effect:

sudo service postgresql restart


Open my.conf and comment out bind-address line:

# bind-address =

Then restart MySQL for the change to take effect:

sudo /etc/init.d/mysql restart
# or
sudo service mysql restart

If you are using SSH tunneling and your bastion server is the same as your DB host, then the steps above are not necessary since the DB connection will look like a local connection.