error running syncdb

[wuhland]

I'm trying to get ona stood up and have been following the instructions from here: https://github.com/onaio/onadata/blob/master/install.md

Having some trouble with the initial db setup. When I run

python manage.py syncdb --noinput

I get the following error

Your environment is:"onadata.settings.common"
Traceback (most recent call last):
  File "manage.py", line 21, in <module>
    execute_from_command_line(sys.argv)
  File "/home/ubuntu/.virtualenvs/onadata/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 399, in execute_from_command_line
    utility.execute()
  File "/home/ubuntu/.virtualenvs/onadata/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 392, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/home/ubuntu/.virtualenvs/onadata/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 272, in fetch_command
    klass = load_command_class(app_name, subcommand)
  File "/home/ubuntu/.virtualenvs/onadata/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 75, in load_command_class
    module = import_module('%s.management.commands.%s' % (app_name, name))
  File "/home/ubuntu/.virtualenvs/onadata/local/lib/python2.7/site-packages/django/utils/importlib.py", line 40, in import_module
    __import__(name)
  File "/home/ubuntu/.virtualenvs/onadata/local/lib/python2.7/site-packages/south/management/commands/__init__.py", line 10, in <module>
    import django.template.loaders.app_directories
  File "/home/ubuntu/.virtualenvs/onadata/local/lib/python2.7/site-packages/django/template/loaders/app_directories.py", line 25, in <module>
    raise ImproperlyConfigured('ImportError %s: %s' % (app, e.args[0]))
django.core.exceptions.ImproperlyConfigured: ImportError django_nose: cannot import name setup

Its pretty early on in the instillation and the only thing I have changed are the name user and password in local_settings.py so not sure what I am doing wrong. Wondering if anybody had any issues running syncdb as well

Aha! Link: https://ona.aha.io/features/PROD-677

[allan-karanja]

without changing the user and password in local_settings.py I get to this point

python manage.py syncdb --noinput Your environment is:"onadata.settings.common" Traceback (most recent call last): File "manage.py", line 21, in execute_from_command_line(sys.argv) File "/usr/local/lib/python2.7/dist-packages/django/core/management/init.py", line 399, in execute_from_command_line utility.execute() File "/usr/local/lib/python2.7/dist-packages/django/core/management/init.py", line 392, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/usr/local/lib/python2.7/dist-packages/django/core/management/init.py", line 272, in fetch_command klass = load_command_class(app_name, subcommand) File "/usr/local/lib/python2.7/dist-packages/django/core/management/init.py", line 75, in load_command_class module = import_module('%s.management.commands.%s' % (app_name, name)) File "/usr/local/lib/python2.7/dist-packages/django/utils/importlib.py", line 40, in import_module import(name) File "/usr/local/lib/python2.7/dist-packages/south/management/commands/init.py", line 10, in import django.template.loaders.app_directories File "/usr/local/lib/python2.7/dist-packages/django/template/loaders/app_directories.py", line 23, in mod = import_module(app) File "/usr/local/lib/python2.7/dist-packages/django/utils/importlib.py", line 40, in import_module import(name) File "/usr/local/lib/python2.7/dist-packages/django/contrib/admin/init.py", line 6, in from django.contrib.admin.sites import AdminSite, site File "/usr/local/lib/python2.7/dist-packages/django/contrib/admin/sites.py", line 4, in from django.contrib.admin.forms import AdminAuthenticationForm File "/usr/local/lib/python2.7/dist-packages/django/contrib/admin/forms.py", line 6, in from django.contrib.auth.forms import AuthenticationForm File "/usr/local/lib/python2.7/dist-packages/django/contrib/auth/forms.py", line 17, in from django.contrib.auth.models import User File "/usr/local/lib/python2.7/dist-packages/django/contrib/auth/models.py", line 48, in class Permission(models.Model): File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py", line 96, in new new_class.add_to_class('_meta', Options(meta, kwargs)) File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py", line 264, in add_to_class value.contribute_to_class(cls, name) File "/usr/local/lib/python2.7/dist-packages/django/db/models/options.py", line 124, in contribute_to_class self.db_table = truncate_name(self.db_table, connection.ops.max_name_length()) File "/usr/local/lib/python2.7/dist-packages/django/db/init.py", line 34, in getattr return getattr(connections[DEFAULT_DB_ALIAS], item) File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py", line 199, in getitem conn = backend.DatabaseWrapper(db, alias) File "/usr/local/lib/python2.7/dist-packages/django/contrib/gis/db/backends/postgis/base.py", line 11, in init self.ops = PostGISOperations(self) File "/usr/local/lib/python2.7/dist-packages/django/contrib/gis/db/backends/postgis/operations.py", line 158, in init if self.spatial_version < (1, 3, 4): File "/usr/local/lib/python2.7/dist-packages/django/utils/functional.py", line 49, in get res = instance.dict[self.func.name] = self.func(instance) File "/usr/local/lib/python2.7/dist-packages/django/contrib/gis/db/backends/postgis/operations.py", line 254, in spatial_version self._get_postgis_func('version') File "/usr/local/lib/python2.7/dist-packages/django/contrib/gis/db/backends/postgis/operations.py", line 402, in _get_postgis_func with self.connection.temporary_connection() as cursor: File "/usr/lib/python2.7/contextlib.py", line 17, in enter return self.gen.next() File "/usr/local/lib/python2.7/dist-packages/django/db/backends/init.py", line 527, in temporary_connection cursor = self.cursor() File "/usr/local/lib/python2.7/dist-packages/django/db/backends/init.py", line 160, in cursor cursor = self.make_debug_cursor(self._cursor()) File "/usr/local/lib/python2.7/dist-packages/django/db/backends/init.py", line 132, in _cursor self.ensure_connection() File "/usr/local/lib/python2.7/dist-packages/django/db/backends/init.py", line 127, in ensure_connection self.connect() File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py", line 99, in exit six.reraise(dj_exc_type, dj_exc_value, traceback) File "/usr/local/lib/python2.7/dist-packages/django/db/backends/init.py", line 127, in ensure_connection self.connect() File "/usr/local/lib/python2.7/dist-packages/django/db/backends/init.py", line 115, in connect self.connection = self.get_new_connection(conn_params) File "/usr/local/lib/python2.7/dist-packages/django/db/backends/postgresql_psycopg2/base.py", line 115, in get_new_connection return Database.connect(conn_params) File "/usr/local/lib/python2.7/dist-packages/psycopg2/init.py", line 164, in connect conn = _connect(dsn, connection_factory=connection_factory, async=async) django.db.utils.OperationalError: FATAL: password authentication failed for user "DB_USER" FATAL: password authentication failed for user "DB_USER"

[allankaranja]

i managed to get past this error by uninstalling django-nose and then installing it again with the following pip uninstall django-nose pip install django-nose

[wuhland]

That worked great thanks!!