Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Cannot login into InvenTree #7

Open
tionebrr opened this issue Dec 5, 2020 · 4 comments
Open

Cannot login into InvenTree #7

tionebrr opened this issue Dec 5, 2020 · 4 comments

Comments

@tionebrr
Copy link

tionebrr commented Dec 5, 2020

Hello,
After being able to run the composition, I get an error when trying to login, and nginx is giving me a good old 500.
Here is the log from docker-compose:

nginx_1      | 192.168.0.16 - - [05/Dec/2020:07:26:11 +0000] "GET /static/css/bootstrap_3.3.7_css_bootstrap.min.css HTTP/1.1" 404 0 "http://192.168.0.14:9080/login?next=/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:83.0) Gecko/20100101 Firefox/83.0" "-"
inventree    | Internal Server Error: /login
inventree    | Traceback (most recent call last):
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 86, in _execute
inventree    |     return self.cursor.execute(sql, params)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 74, in execute
inventree    |     return self.cursor.execute(query, args)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
inventree    |     res = self._query(query)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
inventree    |     db.query(q)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/MySQLdb/connections.py", line 259, in query
inventree    |     _mysql.connection.query(self, query)
inventree    | MySQLdb._exceptions.ProgrammingError: (1146, "Table 'inventree.auth_user' doesn't exist")
inventree    | 
inventree    | The above exception was the direct cause of the following exception:
inventree    | 
inventree    | Traceback (most recent call last):
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/core/handlers/base.py", line 113, in _get_response
inventree    |     response = wrapped_callback(request, *callback_args, **callback_kwargs)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/views/generic/base.py", line 71, in view
inventree    |     return self.dispatch(request, *args, **kwargs)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/utils/decorators.py", line 43, in _wrapper
inventree    |     return bound_method(*args, **kwargs)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/views/decorators/debug.py", line 76, in sensitive_post_parameters_wrapper
inventree    |     return view(request, *args, **kwargs)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/utils/decorators.py", line 43, in _wrapper
inventree    |     return bound_method(*args, **kwargs)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/utils/decorators.py", line 130, in _wrapped_view
inventree    |     response = view_func(request, *args, **kwargs)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/utils/decorators.py", line 43, in _wrapper
inventree    |     return bound_method(*args, **kwargs)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/views/decorators/cache.py", line 44, in _wrapped_view_func
inventree    |     response = view_func(request, *args, **kwargs)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/contrib/auth/views.py", line 63, in dispatch
inventree    |     return super().dispatch(request, *args, **kwargs)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/views/generic/base.py", line 97, in dispatch
inventree    |     return handler(request, *args, **kwargs)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/views/generic/edit.py", line 141, in post
inventree    |     if form.is_valid():
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/forms/forms.py", line 180, in is_valid
inventree    |     return self.is_bound and not self.errors
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/forms/forms.py", line 175, in errors
inventree    |     self.full_clean()
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/forms/forms.py", line 377, in full_clean
inventree    |     self._clean_form()
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/forms/forms.py", line 404, in _clean_form
inventree    |     cleaned_data = self.clean()
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/contrib/auth/forms.py", line 214, in clean
inventree    |     self.user_cache = authenticate(self.request, username=username, password=password)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/contrib/auth/__init__.py", line 72, in authenticate
inventree    |     user = backend.authenticate(request, **credentials)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/contrib/auth/backends.py", line 46, in authenticate
inventree    |     user = UserModel._default_manager.get_by_natural_key(username)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/contrib/auth/base_user.py", line 44, in get_by_natural_key
inventree    |     return self.get(**{self.model.USERNAME_FIELD: username})
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/models/manager.py", line 82, in manager_method
inventree    |     return getattr(self.get_queryset(), name)(*args, **kwargs)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/models/query.py", line 411, in get
inventree    |     num = len(clone)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/models/query.py", line 258, in __len__
inventree    |     self._fetch_all()
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/models/query.py", line 1261, in _fetch_all
inventree    |     self._result_cache = list(self._iterable_class(self))
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/models/query.py", line 57, in __iter__
inventree    |     results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1152, in execute_sql
inventree    |     cursor.execute(sql, params)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 68, in execute
inventree    |     return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 77, in _execute_with_wrappers
inventree    |     return executor(sql, params, many, context)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 86, in _execute
inventree    |     return self.cursor.execute(sql, params)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/utils.py", line 90, in __exit__
inventree    |     raise dj_exc_value.with_traceback(traceback) from exc_value
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 86, in _execute
inventree    |     return self.cursor.execute(sql, params)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 74, in execute
inventree    |     return self.cursor.execute(query, args)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
inventree    |     res = self._query(query)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
inventree    |     db.query(q)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/MySQLdb/connections.py", line 259, in query
inventree    |     _mysql.connection.query(self, query)
inventree    | django.db.utils.ProgrammingError: (1146, "Table 'inventree.auth_user' doesn't exist")
inventree    | 
inventree    | During handling of the above exception, another exception occurred:
inventree    | 
inventree    | Traceback (most recent call last):
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 86, in _execute
inventree    |     return self.cursor.execute(sql, params)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 74, in execute
inventree    |     return self.cursor.execute(query, args)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
inventree    |     res = self._query(query)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
inventree    |     db.query(q)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/MySQLdb/connections.py", line 259, in query
inventree    |     _mysql.connection.query(self, query)
inventree    | MySQLdb._exceptions.ProgrammingError: (1146, "Table 'inventree.error_report_error' doesn't exist")
inventree    | 
inventree    | The above exception was the direct cause of the following exception:
inventree    | 
inventree    | Traceback (most recent call last):
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/core/handlers/exception.py", line 34, in inner
inventree    |     response = get_response(request)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/core/handlers/base.py", line 115, in _get_response
inventree    |     response = self.process_exception_by_middleware(e, request)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/core/handlers/base.py", line 155, in process_exception_by_middleware
inventree    |     response = middleware_method(request, exception)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/error_report/middleware.py", line 27, in process_exception
inventree    |     error = Error.objects.create(
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/models/manager.py", line 82, in manager_method
inventree    |     return getattr(self.get_queryset(), name)(*args, **kwargs)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/models/query.py", line 433, in create
inventree    |     obj.save(force_insert=True, using=self.db)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/models/base.py", line 745, in save
inventree    |     self.save_base(using=using, force_insert=force_insert,
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/models/base.py", line 782, in save_base
inventree    |     updated = self._save_table(
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/models/base.py", line 887, in _save_table
inventree    |     results = self._do_insert(cls._base_manager, using, fields, returning_fields, raw)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/models/base.py", line 924, in _do_insert
inventree    |     return manager._insert(
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/models/manager.py", line 82, in manager_method
inventree    |     return getattr(self.get_queryset(), name)(*args, **kwargs)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/models/query.py", line 1204, in _insert
inventree    |     return query.get_compiler(using=using).execute_sql(returning_fields)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1392, in execute_sql
inventree    |     cursor.execute(sql, params)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 68, in execute
inventree    |     return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 77, in _execute_with_wrappers
inventree    |     return executor(sql, params, many, context)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 86, in _execute
inventree    |     return self.cursor.execute(sql, params)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/utils.py", line 90, in __exit__
inventree    |     raise dj_exc_value.with_traceback(traceback) from exc_value
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 86, in _execute
inventree    |     return self.cursor.execute(sql, params)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 74, in execute
inventree    |     return self.cursor.execute(query, args)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
inventree    |     res = self._query(query)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
inventree    |     db.query(q)
inventree    |   File "/opt/venv/lib/python3.9/site-packages/MySQLdb/connections.py", line 259, in query
inventree    |     _mysql.connection.query(self, query)
inventree    | django.db.utils.ProgrammingError: (1146, "Table 'inventree.error_report_error' doesn't exist")
nginx_1      | 192.168.0.16 - - [05/Dec/2020:07:26:21 +0000] "POST /login?next=/ HTTP/1.1" 500 145 "http://192.168.0.14:9080/login?next=/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:83.0) Gecko/20100101 Firefox/83.0" "-"
nginx_1      | 192.168.0.16 - - [05/Dec/2020:07:26:22 +0000] "GET /favicon.ico HTTP/1.1" 302 0 "http://192.168.0.14:9080/login?next=/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:83.0) Gecko/20100101 Firefox/83.0" "-"
nginx_1      | 192.168.0.16 - - [05/Dec/2020:07:26:22 +0000] "GET /login?next=/favicon.ico HTTP/1.1" 200 754 "http://192.168.0.14:9080/login?next=/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:83.0) Gecko/20100101 Firefox/83.0" "-"

I am missing something... again
@tionebrr
Copy link
Author

tionebrr commented Dec 5, 2020

Here is the full run logs:
https://pastebin.com/RfVkVsNE

@tionebrr
Copy link
Author

tionebrr commented Dec 6, 2020

Ah also, I noticed that the page styling of the login page is absent. Firefox cannot get the favicon and css sheet.

@tionebrr
Copy link
Author

Hello @Zeigren .
Are you still maintaining/using inventree-docker?
I'm going to dig into this a bit more seriously today.

@Zeigren
Copy link
Owner

Zeigren commented Mar 26, 2021

Try using 0.1.7, see if that fixes it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@Zeigren @tionebrr