sql_connection.py error reporting is misleading

[wdwvt1]

Multiple error types are caught by line 153. Specifically, if the database has been dropped, the error will still report that it can't find the right user. As an example:

qiita_env make --no-load-ontologies
qiita_env drop 
qiita webserver start

results in the error:
RuntimeError: Can't connect to database; user wdwvtis not known. Your QIITA configuration file, located at/Users/wdwvt/src/qiita/config_test.txtmust specify the correct user, via theUSERparameter under the[postgres]header. Please refer toINSTALL.md in the QIITA base directory.

[wdwvt1]

An additional error message can get caught by this that we should fail nicely with:

could not connect to server: Connection refused
    Is the server running on host "localhost" (::1) and accepting
    TCP/IP connections on port 5432?
could not connect to server: Connection refused
    Is the server running on host "localhost" (127.0.0.1) and accepting
    TCP/IP connections on port 5432?

This happens when redis-server postgress.app hasn't been started and one tries to start the webserver.

[antgonza]

That error is postgres, no?

[wdwvt1]

yes - you are absolutely right.