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.

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

New user impossible sign in #4314

Closed
med4u opened this issue Mar 21, 2025 · 3 comments
Closed

New user impossible sign in #4314

med4u opened this issue Mar 21, 2025 · 3 comments

Comments

@med4u
Copy link

med4u commented Mar 21, 2025

Since recent update , i suppose this one : 0b87549

error :

onyx-stack-api_server-1 | ERROR: 03/21/2025 11:23:02 AM file.py 30: Failed to read file static/images/logo.png: [Errno 2] No such file or directory: 'static/images/logo.png'
onyx-stack-api_server-1 | ERROR: 03/21/2025 11:23:02 AM main.py 258: Resource not found: db=<function get_logo_filename at 0x7f4f6230c0e0> static=static/images/logo.png

and no mail is sent to new user with token generated to create account.

@med4u
Copy link
Author

med4u commented Mar 21, 2025

basic auth

@pablonyx
Copy link
Contributor

This should be fixed by #4339

@med4u
Copy link
Author

med4u commented Mar 28, 2025

Sorry that didn't fixed the problem: it hangs on sign in. No email sent.

onyx-stack-relational_db-1 | 2025-03-28 23:33:30.748 UTC [36] ERROR: relation "public.user_tenant_mapping" does not exist at character 233
onyx-stack-relational_db-1 | 2025-03-28 23:33:30.748 UTC [36] STATEMENT: SELECT public.user_tenant_mapping.email AS public_user_tenant_mapping_email, public.user_tenant_mapping.tenant_id AS public_user_tenant_mapping_tenant_id, public.user_tenant_mapping.active AS public_user_tenant_mapping_active
onyx-stack-relational_db-1 | FROM public.user_tenant_mapping
onyx-stack-relational_db-1 | WHERE public.user_tenant_mapping.email IN ('[email protected]') AND public.user_tenant_mapping.tenant_id = 'public'
onyx-stack-api_server-1 | ERROR: 03/28/2025 11:33:30 PM user_mapping.py 139: Failed to remove users from tenant public: (psycopg2.errors.UndefinedTable) relation "public.user_tenant_mapping" does not exist
onyx-stack-api_server-1 | LINE 2: FROM public.user_tenant_mapping
onyx-stack-api_server-1 | ^
onyx-stack-api_server-1 |
onyx-stack-api_server-1 | [SQL: SELECT public.user_tenant_mapping.email AS public_user_tenant_mapping_email, public.user_tenant_mapping.tenant_id AS public_user_tenant_mapping_tenant_id, public.user_tenant_mapping.active AS public_user_tenant_mapping_active
onyx-stack-api_server-1 | FROM public.user_tenant_mapping
onyx-stack-api_server-1 | WHERE public.user_tenant_mapping.email IN (%(email_1_1)s) AND public.user_tenant_mapping.tenant_id = %(tenant_id_1)s]
onyx-stack-api_server-1 | [parameters: {'tenant_id_1': 'public', 'email_1_1': '[email protected]'}]
onyx-stack-api_server-1 | (Background on this error at: https://sqlalche.me/e/20/f405)
onyx-stack-api_server-1 | Traceback (most recent call last):
onyx-stack-api_server-1 | File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1968, in _exec_single_context
onyx-stack-api_server-1 | self.dialect.do_execute(
onyx-stack-api_server-1 | File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 920, in do_execute
onyx-stack-api_server-1 | cursor.execute(statement, parameters)
onyx-stack-api_server-1 | psycopg2.errors.UndefinedTable: relation "public.user_tenant_mapping" does not exist
onyx-stack-api_server-1 | LINE 2: FROM public.user_tenant_mapping
onyx-stack-api_server-1 | ^
onyx-stack-api_server-1 |
onyx-stack-api_server-1 |
onyx-stack-api_server-1 | The above exception was the direct cause of the following exception:
onyx-stack-api_server-1 |
onyx-stack-api_server-1 | Traceback (most recent call last):
onyx-stack-api_server-1 | File "/app/ee/onyx/server/tenants/user_mapping.py", line 131, in remove_users_from_tenant
onyx-stack-api_server-1 | .all()
onyx-stack-api_server-1 | ^^^^^
onyx-stack-api_server-1 | File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2692, in all
onyx-stack-api_server-1 | return self._iter().all() # type: ignore
onyx-stack-api_server-1 | ^^^^^^^^^^^^
onyx-stack-api_server-1 | File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2846, in _iter
onyx-stack-api_server-1 | result: Union[ScalarResult[_T], Result[_T]] = self.session.execute(
onyx-stack-api_server-1 | ^^^^^^^^^^^^^^^^^^^^^
onyx-stack-api_server-1 | File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2232, in execute
onyx-stack-api_server-1 | return self._execute_internal(
onyx-stack-api_server-1 | ^^^^^^^^^^^^^^^^^^^^^^^
onyx-stack-api_server-1 | File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2127, in _execute_internal
onyx-stack-api_server-1 | result: Result[Any] = compile_state_cls.orm_execute_statement(
onyx-stack-api_server-1 | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
onyx-stack-api_server-1 | File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/context.py", line 293, in orm_execute_statement
onyx-stack-api_server-1 | result = conn.execute(
onyx-stack-api_server-1 | ^^^^^^^^^^^^^
onyx-stack-api_server-1 | File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1413, in execute
onyx-stack-api_server-1 | return meth(
onyx-stack-api_server-1 | ^^^^^
onyx-stack-api_server-1 | File "/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 483, in _execute_on_connection
onyx-stack-api_server-1 | return connection._execute_clauseelement(
onyx-stack-api_server-1 | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
onyx-stack-api_server-1 | File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1637, in _execute_clauseelement
onyx-stack-api_server-1 | ret = self._execute_context(
onyx-stack-api_server-1 | ^^^^^^^^^^^^^^^^^^^^^^
onyx-stack-api_server-1 | File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context
onyx-stack-api_server-1 | return self._exec_single_context(
onyx-stack-api_server-1 | ^^^^^^^^^^^^^^^^^^^^^^^^^^
onyx-stack-api_server-1 | File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1987, in _exec_single_context
onyx-stack-api_server-1 | self._handle_dbapi_exception(
onyx-stack-api_server-1 | File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2344, in _handle_dbapi_exception
onyx-stack-api_server-1 | raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
onyx-stack-api_server-1 | File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1968, in _exec_single_context
onyx-stack-api_server-1 | self.dialect.do_execute(
onyx-stack-api_server-1 | File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 920, in do_execute
onyx-stack-api_server-1 | cursor.execute(statement, parameters)
onyx-stack-api_server-1 | sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "public.user_tenant_mapping" does not exist
onyx-stack-api_server-1 | LINE 2: FROM public.user_tenant_mapping
onyx-stack-api_server-1 | ^
onyx-stack-api_server-1 |
onyx-stack-api_server-1 | [SQL: SELECT public.user_tenant_mapping.email AS public_user_tenant_mapping_email, public.user_tenant_mapping.tenant_id AS public_user_tenant_mapping_tenant_id, public.user_tenant_mapping.active AS public_user_tenant_mapping_active
onyx-stack-api_server-1 | FROM public.user_tenant_mapping
onyx-stack-api_server-1 | WHERE public.user_tenant_mapping.email IN (%(email_1_1)s) AND public.user_tenant_mapping.tenant_id = %(tenant_id_1)s]
onyx-stack-api_server-1 | [parameters: {'tenant_id_1': 'public', 'email_1_1': '[email protected]'}]
onyx-stack-api_server-1 | (Background on this error at: https://sqlalche.me/e/20/f405)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants