Installation problem


#1

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


#2

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


#3

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.


#4

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.


#5

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.


Installation Issues - Ubuntu