All was good inside my dev Ubuntu Desktop env, but after I started fiddling around with PostgreSQL (likely after trying to add entries in the pg_hba.conf file, so that I can access PostgreSQL from outside the VM box), I started getting the following error when trying to browse to localhost:8000 (Indico)
sqlalchemy.exc.OperationalError
OperationalError: (psycopg2.OperationalError) FATAL: no pg_hba.conf entry for host “[local]”, user “user”, database “indico”, SSL off
Traceback (most recent call last):
File "/home/user/dev/indico/env/lib/python2.7/site-packages/flask/app.py", line 2463, in __call__
return self.wsgi_app(environ, start_response)
File "/home/user/dev/indico/env/lib/python2.7/site-packages/flask/app.py", line 2449, in wsgi_app
response = self.handle_exception(e)
File "/home/user/dev/indico/env/lib/python2.7/site-packages/flask/app.py", line 1866, in handle_exception
reraise(exc_type, exc_value, tb)
File "/home/user/dev/indico/env/lib/python2.7/site-packages/flask/app.py", line 2446, in wsgi_app
response = self.full_dispatch_request()
File "/home/user/dev/indico/env/lib/python2.7/site-packages/flask/app.py", line 1951, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/home/user/dev/indico/env/lib/python2.7/site-packages/flask/app.py", line 1821, in handle_user_exception
return handler(e)
File "/home/user/dev/indico/src/indico/web/flask/errors.py", line 91, in handle_databaseerror
return handle_exception(exc, _('There was a database error while processing your request.'))
File "/home/user/dev/indico/env/lib/python2.7/site-packages/flask/app.py", line 1947, in full_dispatch_request
rv = self.preprocess_request()
File "/home/user/dev/indico/env/lib/python2.7/site-packages/flask/app.py", line 2241, in preprocess_request
rv = func()
File "/home/user/dev/indico/src/indico/modules/categories/blueprint.py", line 100, in _redirect_to_bootstrap
not User.query.filter_by(is_system=False).has_rows()):
File "/home/user/dev/indico/src/indico/core/db/sqlalchemy/util/models.py", line 60, in has_rows
return self.session.query(self.enable_eagerloads(False).exists()).scalar()
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 3312, in scalar
ret = self.one()
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 3282, in one
ret = self.one_or_none()
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 3251, in one_or_none
ret = list(self)
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 3324, in __iter__
return self._execute_and_instances(context)
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 3346, in _execute_and_instances
querycontext, self._connection_from_session, close_with_result=True
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 3361, in _get_bind_args
mapper=self._bind_mapper(), clause=querycontext.statement, **kw
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 3339, in _connection_from_session
conn = self.session.connection(**kw)
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1124, in connection
execution_options=execution_options,
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1130, in _connection_for_bind
engine, execution_options
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 431, in _connection_for_bind
conn = bind._contextual_connect()
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2226, in _contextual_connect
self._wrap_pool_connect(self.pool.connect, None),
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2266, in _wrap_pool_connect
e, dialect, self
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1536, in _handle_dbapi_exception_noconnection
util.raise_from_cause(sqlalchemy_exception, exc_info)
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 399, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2262, in _wrap_pool_connect
return fn()
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/pool/base.py", line 363, in connect
return _ConnectionFairy._checkout(self)
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/pool/base.py", line 760, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/pool/base.py", line 492, in checkout
rec = pool._do_get()
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/pool/impl.py", line 139, in _do_get
self._dec_overflow()
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/pool/impl.py", line 136, in _do_get
return self._create_connection()
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
return _ConnectionRecord(self)
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/pool/base.py", line 437, in __init__
self.__connect(first_connect_check=True)
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/pool/base.py", line 639, in __connect
connection = pool._invoke_creator(self)
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/home/user/dev/indico/env/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 451, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/home/user/dev/indico/env/lib/python2.7/site-packages/psycopg2/__init__.py", line 126, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
OperationalError: (psycopg2.OperationalError) FATAL: no pg_hba.conf entry for host "[local]", user "user", database "indico", SSL off
(Background on this error at: http://sqlalche.me/e/e3q8)