datahuborg / datahub

An experimental hosted platform (GitHub-like) for organizing, managing, sharing, collaborating, and making sense of data.
https://datahub.csail.mit.edu
MIT License
210 stars 60 forks source link

Manual installation fails when migrate #214

Open marcoarthur opened 6 years ago

marcoarthur commented 6 years ago

Following the manual installation steps. Got this error:

  Rendering model states... DONE
  Applying inventory.0016_public_repos_cards...Traceback (most recent call last):
  File "src/manage.py", line 10, in 
    execute_from_command_line(sys.argv)
  File "/srv/datahub/venv/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 338, in execute_from_command_line
    utility.execute()
  File "/srv/datahub/venv/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 330, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/srv/datahub/venv/local/lib/python2.7/site-packages/django/core/management/base.py", line 390, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/srv/datahub/venv/local/lib/python2.7/site-packages/django/core/management/base.py", line 441, in execute
    output = self.handle(*args, **options)
  File "/srv/datahub/venv/local/lib/python2.7/site-packages/django/core/management/commands/migrate.py", line 221, in handle
    executor.migrate(targets, plan, fake=fake, fake_initial=fake_initial)
  File "/srv/datahub/venv/local/lib/python2.7/site-packages/django/db/migrations/executor.py", line 110, in migrate
    self.apply_migration(states[migration], migration, fake=fake, fake_initial=fake_initial)
  File "/srv/datahub/venv/local/lib/python2.7/site-packages/django/db/migrations/executor.py", line 147, in apply_migration
    state = migration.apply(state, schema_editor)
  File "/srv/datahub/venv/local/lib/python2.7/site-packages/django/db/migrations/migration.py", line 115, in apply
    operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
  File "/srv/datahub/venv/local/lib/python2.7/site-packages/django/db/migrations/operations/special.py", line 183, in database_forwards
    self.code(from_state.apps, schema_editor)
  File "/srv/datahub/venv/local/lib/python2.7/site-packages/factory/django.py", line 345, in wrapper
    return callable_obj(*args, **kwargs)
  File "/srv/datahub/src/account/management/commands/createpublicanonuser.py", line 47, in create_public_user
    username=username, password=password, create_db=False)
  File "/srv/datahub/src/core/db/manager.py", line 1084, in create_user
    username=username, password=password, create_db=create_db)
  File "/srv/datahub/src/core/db/connection.py", line 157, in create_user
    return self.backend.create_user(username, password, create_db)
  File "/srv/datahub/src/core/db/backend/pg.py", line 605, in create_user
    self.execute_sql(query, params)
  File "/srv/datahub/src/core/db/backend/pg.py", line 568, in execute_sql
    _convert_pg_exception(e)
  File "/srv/datahub/src/core/db/backend/pg.py", line 83, in _convert_pg_exception
    raise e
psycopg2.ProgrammingError: unrecognized role option "nocreateuser"
LINE 1: ...ROLE dh_public WITH LOGIN NOCREATEDB NOCREATEROLE NOCREATEUS...
                                                             ^

The host I was trying to install is running postgresql 9.6 in search for this problem I saw this closed https://github.com/ansible/ansible-modules-core/issues/4225 issue, regarding that postgresql 9.6 don't have this option anymore. Somehow the database handler used for deploy is creating a deprecated (not supported) SQL code for PostGresQL