I have installed redash using the script currently at redash/setup/ubuntu/bootstrap.sh (d22f0d4) on Debian Jessie 8.6
Passed thru various problems with postgresql… but now halted at nginx config.
I’m familiar with Apache, but nginx config is simply black magic for me… and it fails…
Current content of /etc/nginx/sites-available/redash is the standard found at redash/setup/ubuntu/files/nginx_redash_site (90128b9)
But when I point to http://myurl I simply get an error 502 “bad gateway”. When commenting out the line proxy_pass, my url displays the standard nginx welcome page.
Any hint at which errors I might have done or files that need to be changed for Debian?
Thx Arik for the fast answer!
Correct, Nothing was running on port 5000
The script uses ubuntuwise add_service "redash_supervisord"
while debianwise it is service redash_supervisord start
Note: service redash_supervisord _re_start
might not work as expected, so prefer to use service redash_supervisord stop service redash_supervisord start
Mmhhh… seems I still have some trouble with Celery et al.
root@xxxx log/nginx# supervisorctl stop all
root@xxxx log/nginx# supervisorctl status all
redash_celery FATAL Exited too quickly (process log may have details)
redash_celery_scheduled FATAL Exited too quickly (process log may have details)
redash_server FATAL Exited too quickly (process log may have details)
root@xxxx log/nginx# supervisorctl start all
redash_celery: ERROR (abnormal termination)
redash_server: ERROR (abnormal termination)
redash_celery_scheduled: ERROR (abnormal termination)
root@xxxx log/nginx#
B-) the logs are not that clear, see some details at the end.
I have however isolated my source of problem: I have tried to configure mail parameters in .env as defined in http://docs.redash.io/en/latest/setup.html#mail-configuration … but this nukes something, as supervisord then uses just port 9001, and no 5000.
Keeping the .env without these values allows things to run fine, except that redash seems then unable to send mails.
Will try to reintroduce one line after the other to detect the failure point… all suggestions welcome (I would appreciate a working example though)
Extract of api_error.log
Not Working
[2016-09-27 10:19:37 +0000] [30642] [INFO] Starting gunicorn 19.4.5
[2016-09-27 10:19:37 +0000] [30642] [INFO] Listening at: http://127.0.0.1:5000 (30642)
[2016-09-27 10:19:37 +0000] [30642] [INFO] Using worker: sync
[2016-09-27 10:19:37 +0000] [30650] [INFO] Booting worker with pid: 30650
[2016-09-27 10:19:37 +0000] [30650] [ERROR] Exception in worker process:
Traceback (most recent call last):
File “/usr/local/lib/python2.7/dist-packages/gunicorn/arbiter.py”, line 515, in spawn_worker
worker.init_process()
…
File “/opt/redash/redash.0.11.1.b2095/redash/settings.py”, line 133, in
MAIL_USE_TLS = parse_boolean(os.environ.get(‘REDASH_MAIL_USE_TLS’, ‘false’))
File “/opt/redash/redash.0.11.1.b2095/redash/settings.py”, line 41, in parse_boolean
return json.loads(str.lower())
File “/usr/lib/python2.7/json/init.py”, line 338, in loads
return _default_decoder.decode(s)
File “/usr/lib/python2.7/json/decoder.py”, line 366, in decode
obj, end = self.raw_decode(s, idx=_w(s, 0).end())
File “/usr/lib/python2.7/json/decoder.py”, line 384, in raw_decode
raise ValueError(“No JSON object could be decoded”)
ValueError: No JSON object could be decoded
Traceback (most recent call last):
File “/usr/local/lib/python2.7/dist-packages/gunicorn/arbiter.py”, line 515, in spawn_worker
worker.init_process()
File “/usr/local/lib/python2.7/dist-packages/gunicorn/workers/base.py”, line 122, in init_process
self.load_wsgi()
…
[2016-09-27 10:19:37 +0000] [30653] [INFO] Worker exiting (pid: 30653)
Traceback (most recent call last):
File “/usr/local/bin/gunicorn”, line 11, in
sys.exit(run())
File “/usr/local/lib/python2.7/dist-packages/gunicorn/app/wsgiapp.py”, line 74, in run
WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run()
File “/usr/local/lib/python2.7/dist-packages/gunicorn/app/base.py”, line 192, in run
super(Application, self).run()
File “/usr/local/lib/python2.7/dist-packages/gunicorn/app/base.py”, line 72, in run
Arbiter(self).run()
File “/usr/local/lib/python2.7/dist-packages/gunicorn/arbiter.py”, line 206, in run
self.halt(reason=inst.reason, exit_status=inst.exit_status)
File “/usr/local/lib/python2.7/dist-packages/gunicorn/arbiter.py”, line 302, in halt
self.stop()
File “/usr/local/lib/python2.7/dist-packages/gunicorn/arbiter.py”, line 347, in stop
time.sleep(0.1)
File “/usr/local/lib/python2.7/dist-packages/gunicorn/arbiter.py”, line 219, in handle_chld
self.reap_workers()
File “/usr/local/lib/python2.7/dist-packages/gunicorn/arbiter.py”, line 464, in reap_workers
raise HaltServer(reason, self.WORKER_BOOT_ERROR)
gunicorn.errors.HaltServer: <HaltServer ‘Worker failed to boot.’ 3>