Hi,
I am trying to do fresh install on clean Ubuntu 14 with PostgreSQL 9.5.
Getting error with ProgrammingError: relation “organizations” does not exist
LINE 1: …", “t1”.“name”, “t1”.“slug”, “t1”.“settings” FROM "organizat…

more details :

Requirement already up-to-date: setuptools==23.1.0 in /usr/local/lib/python2.7/dist-packages
The system user `redash’ already exists. Exiting.
psql (PostgreSQL) 9.5.3
redis-cli 2.8.17
[2016-07-13 13:38:56,163][PID:913][WARNING][redash.query_runner] BigQuery query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[2016-07-13 13:38:56,164][PID:913][WARNING][redash.query_runner] BigQueryGCE query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[2016-07-13 13:38:56,165][PID:913][WARNING][redash.query_runner] GoogleSpreadsheet query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[2016-07-13 13:38:56,172][PID:913][WARNING][redash.query_runner] MongoDB query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[2016-07-13 13:38:56,173][PID:913][WARNING][redash.query_runner] MySQL query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[2016-07-13 13:38:56,188][PID:913][WARNING][redash.query_runner] InfluxDB query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[2016-07-13 13:38:56,190][PID:913][WARNING][redash.query_runner] Presto query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[2016-07-13 13:38:56,192][PID:913][WARNING][redash.query_runner] Vertica query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[2016-07-13 13:38:56,193][PID:913][WARNING][redash.query_runner] TreasureData query runner enabled but not supported, not registering. Either disable or install missing dependencies.
[2016-07-13 13:38:56,198][PID:913][WARNING][redash.query_runner] Microsoft SQL Server query runner enabled but not supported, not registering. Either disable or install missing dependencies.
Creating user (admin, Admin)…
Admin: True
Login with Google Auth: False

[2016-07-13 13:38:56,793][PID:913][ERROR][peewee] SELECT “t1”.“id”, “t1”.“updated_at”, “t1”.“created_at”, “t1”.“name”, “t1”.“slug”, “t1”.“settings” FROM “organizations” AS t1 WHERE (“t1”.“slug” = %s) LIMIT 1 [u’default’]
Traceback (most recent call last):
File “/usr/local/lib/python2.7/dist-packages/playhouse/postgres_ext.py”, line 360, in execute_sql
cursor.execute(sql, params or ())
ProgrammingError: relation “organizations” does not exist
LINE 1: …", “t1”.“name”, “t1”.“slug”, “t1”.“settings” FROM "organizat…
^

Traceback (most recent call last):
File “/opt/redash/redash.0.10.1.b1834/manage.py”, line 58, in
manager.run()
File “/usr/local/lib/python2.7/dist-packages/flask_script/init.py”, line 405, in run
result = self.handle(sys.argv[0], sys.argv[1:])
File “/usr/local/lib/python2.7/dist-packages/flask_script/init.py”, line 384, in handle
return handle(app, *positional_args, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/flask_script/commands.py”, line 145, in handle
return self.run(*args, **kwargs)
File “/opt/redash/redash.0.10.1.b1834/redash/cli/users.py”, line 54, in create
org = models.Organization.get_by_slug(‘default’)
File “/opt/redash/redash.0.10.1.b1834/redash/models.py”, line 190, in get_by_slug
return cls.get(cls.slug == slug)
File “/usr/local/lib/python2.7/dist-packages/peewee.py”, line 4012, in get
return sq.get()
File “/usr/local/lib/python2.7/dist-packages/peewee.py”, line 2641, in get
return clone.execute().next()
File “/usr/local/lib/python2.7/dist-packages/peewee.py”, line 2682, in execute
self._qr = ResultWrapper(model_class, self._execute(), query_meta)
File “/opt/redash/redash.0.10.1.b1834/redash/metrics/database.py”, line 50, in metered_execute
result = real_execute(self, *args, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/peewee.py”, line 2371, in _execute
return self.database.execute_sql(sql, params, self.require_commit)
File “/opt/redash/redash.0.10.1.b1834/redash/metrics/database.py”, line 22, in execute_sql
result = super(MeteredPostgresqlExtDatabase, self).execute_sql(*args, **kwargs)
File “/usr/local/lib/python2.7/dist-packages/playhouse/postgres_ext.py”, line 369, in execute_sql
self.commit()
File “/usr/local/lib/python2.7/dist-packages/peewee.py”, line 2922, in exit
reraise(new_type, new_type(*exc_value.args), traceback)
File “/usr/local/lib/python2.7/dist-packages/playhouse/postgres_ext.py”, line 360, in execute_sql
cursor.execute(sql, params or ())
peewee.ProgrammingError: relation “organizations” does not exist
LINE 1: …", “t1”.“name”, “t1”.“slug”, “t1”.“settings” FROM "organizat…

Any Idea how to proceed appriciated.
Thanks
Michal

How did you do the install? With the bootstrap script?

Yes with bootstrap script. Firstly had problems with missing modules from python. Figured out that there is requirements.txt so I manually installed it and then got stacked with this DB part.

Looks like something went wrong the first time you ran it and it’s hard to tell what without seeing the output.

I suggest you just follow the steps the script does and run them manually. I would start from the create tables command.

Had a similar problem… solved that with connecting into psql, dropping roles redash and redash_user, and dropping database redash. Then rreunning tyhe script did pass successfuly these problems.