General bootstrap help


#1

I am deploying on Ubuntu 16.04 in a heavily proxied environment that I can mostly get around by setting export http_proxy/export https_proxy in /etc/environment and invoking the bootstrap.sh using

sudo -H -E bootstrap.sh

To force the latest version I also update the bootstrap.sh with the following updates:

# Default branch/version to master if not specified in REDASH_BRANCH env var
REDASH_BRANCH="${REDASH_BRANCH:-v0.12.0.b2449}"
# Install latest version if not specified in REDASH_VERSION env var
REDASH_VERSION=${REDASH_VERSION-0.12.0.b2449}

When I try to to install I get the following error:

Installing collected packages: httplib2, itsdangerous, Werkzeug, MarkupSafe, Jinja2, Flask, wtforms, Flask-Admin, six, pytz, python-dateutil, aniso8601, Flask-RESTful, Flask-Login, requests, oauthlib, requests-oauthlib, Flask-OAuthLib, blinker, flask-mail, flask-sslify, passlib, peewee, psycopg2, redis, sqlparse, Flask-Script, honcho, statsd, gunicorn, billiard, anyjson, amqp, kombu, celery, jsonschema, click, RestrictedPython, wtf-peewee, zope.interface, paste, WebOb, repoze.who, ipaddress, pyasn1, enum34, idna, pycparser, cffi, cryptography, pyOpenSSL, pycrypto, decorator, pysaml2, funcy, contextlib2, raven, semver, xlsxwriter, pystache, parsedatetime
Successfully installed Flask-0.10.1 Flask-Admin-1.1.0 Flask-Login-0.3.2 Flask-OAuthLib-0.9.2 Flask-RESTful-0.3.5 Flask-Script-0.6.6 Jinja2-2.8 MarkupSafe-0.23 RestrictedPython-3.6.0 WebOb-1.6.3 Werkzeug-0.11.3 amqp-1.4.9 aniso8601-1.1.0 anyjson-0.3.3 billiard-3.3.0.23 blinker-1.3 celery-3.1.23 cffi-1.9.1 click-3.3 contextlib2-0.5.4 cryptography-1.4 decorator-4.0.10 enum34-1.1.6 flask-mail-0.9.1 flask-sslify-0.1.5 funcy-1.7.1 gunicorn-19.4.5 honcho-0.5.0 httplib2-0.9.2 idna-2.1 ipaddress-1.0.17 itsdangerous-0.24 jsonschema-2.4.0 kombu-3.0.37 oauthlib-2.0.1 parsedatetime-2.1 passlib-1.6.2 paste-2.0.3 peewee-2.6.1 psycopg2-2.5.2 pyOpenSSL-16.2.0 pyasn1-0.1.9 pycparser-2.17 pycrypto-2.6.1 pysaml2-2.4.0 pystache-0.5.4 python-dateutil-2.4.2 pytz-2016.7 raven-5.27.1 redis-2.10.5 repoze.who-2.3 requests-2.11.1 requests-oauthlib-0.7.0 semver-2.2.1 six-1.10.0 sqlparse-0.1.8 statsd-2.1.2 wtf-peewee-0.2.3 wtforms-2.1 xlsxwriter-0.9.3 zope.interface-4.3.2
Creating redash postgres user & database.
[2016-11-30 14:28:38,311][PID:46395][WARNING][redash.query_runner] BigQuery query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[2016-11-30 14:28:38,315][PID:46395][INFO][requests.packages.urllib3.connectionpool] Starting new HTTP connection (1): 10.20.42.118
[2016-11-30 14:28:49,620][PID:46395][WARNING][redash.query_runner] GoogleSpreadsheet query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[2016-11-30 14:28:49,628][PID:46395][WARNING][redash.query_runner] MongoDB query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[2016-11-30 14:28:49,631][PID:46395][WARNING][redash.query_runner] MySQL query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[2016-11-30 14:28:49,661][PID:46395][WARNING][redash.query_runner] InfluxDB query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[2016-11-30 14:28:49,671][PID:46395][WARNING][redash.query_runner] Presto query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[2016-11-30 14:28:49,675][PID:46395][WARNING][redash.query_runner] Hive query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[2016-11-30 14:28:49,680][PID:46395][WARNING][redash.query_runner] Vertica query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[2016-11-30 14:28:49,683][PID:46395][WARNING][redash.query_runner] TreasureData query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[2016-11-30 14:28:49,693][PID:46395][WARNING][redash.query_runner] Microsoft SQL Server query runner enabled but not supported, not registering. Either disable or install missing dependencies.
Traceback (most recent call last):
File “/opt/redash/redash.0.12.0.b2449/manage.py”, line 9, in
from redash import settings, models, version
File “/opt/redash/redash.0.12.0.b2449/redash/init.py”, line 60, in
reset_new_version_status()
File “/opt/redash/redash.0.12.0.b2449/redash/version_check.py”, line 34, in reset_new_version_status
latest_version = get_latest_version()
File “/opt/redash/redash.0.12.0.b2449/redash/version_check.py”, line 40, in get_latest_version
return redis_connection.get(REDIS_KEY)
File “/usr/local/lib/python2.7/dist-packages/redis/client.py”, line 880, in get
return self.execute_command(‘GET’, name)
File “/usr/local/lib/python2.7/dist-packages/redis/client.py”, line 578, in execute_command
connection.send_command(*args)
File “/usr/local/lib/python2.7/dist-packages/redis/connection.py”, line 563, in send_command
self.send_packed_command(self.pack_command(*args))
File “/usr/local/lib/python2.7/dist-packages/redis/connection.py”, line 538, in send_packed_command
self.connect()
File “/usr/local/lib/python2.7/dist-packages/redis/connection.py”, line 442, in connect
raise ConnectionError(self._error_message(e))
redis.exceptions.ConnectionError: Error 111 connecting to localhost:6379. Connection refused.

Any suggestions for troubleshooting the above would be greatly appreciated!


#2

Seems like the bootstrap script fails for me on setting up redis when in my proxied environment. It looks like it has nothing to do with the proxy, so I will look into this further. I got it to work by manually setting up redis and copying files from the redash setup directory.


#3

You might also have this issue. See my comment below it on how to resolve.