search

standardnotes / server

Server ecosystem for Standard Notes; fully self-hostable.
https://standardnotes.com/help/self-hosting/docker
GNU General Public License v3.0
249 stars 60 forks source link

self host docker error Cant Login #899

Closed ghost closed 11 months ago

ghost commented 11 months ago

self host show error when try login on new devices

Unfortunately, we couldn't handle your request. Please try again or contact our support if the error persists.

but in old devices thats already signed in all normal

also healt check show OK

moughxyz commented 11 months ago

Please provide logs: https://github.com/standardnotes/server/issues/861#issuecomment-1781121107

ghost commented 11 months ago

head logs/auth*

==> logs/auth-worker.err <== localhost (127.0.0.1:3103) open [ioredis] Unhandled error event: Error: connect ECONNREFUSED 172.23.0.5:6379 at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1595:16) at TCPConnectWrap.callbackTrampoline (node:internal/async_hooks:130:17) [ioredis] Unhandled error event: Error: connect ETIMEDOUT at Socket. (/opt/server/.yarn/cache/ioredis-npm-5.3.2-58471071b1-0140f055ef.zip/node_modules/ioredis/built/Redis.js:170:41) at Object.onceWrapper (node:events:628:28) at Socket.emit (node:events:514:28) at Socket._onTimeout (node:net:589:8) at listOnTimeout (node:internal/timers:573:17)

==> logs/auth-worker.log <== localhost:3103 is unavailable yet - waiting for it to start localhost:3103 is unavailable yet - waiting for it to start localhost:3103 is unavailable yet - waiting for it to start localhost:3103 is up. Proceeding to startup. query: SELECT VERSION() AS version info: All classes found using provided glob pattern "/opt/server/packages/auth/dist/src/Bootstrap/../../migrations/mysql/*.js" : "/opt/server/packages/auth/dist/migrations/mysql/1606470249553-init_database.js,/opt/server/packages/auth/dist/migrations/mysql/1610015065194-add_revoked_sessions.js,/opt/server/packages/auth/dist/migrations/mysql/1610025371088-add_foreign_key_to_revoked_sessions.js,/opt/server/packages/auth/dist/migrations/mysql/1612191669523-add_roles_and_permissions.js,/opt/server/packages/auth/dist/migrations/mysql/1612255683992-add_roles_and_permissions_data.js,/opt/server/packages/auth/dist/migrations/mysql/1612433739754-add_more_roles_and_permissions.js,/opt/server/packages/auth/dist/migrations/mysql/1614678016791-add_user_settings.js,/opt/server/packages/auth/dist/migrations/mysql/1614771815912-add_encrypted_version.js,/opt/server/packages/auth/dist/migrations/mysql/1614775877590-add_encrypted_version_for_user.js,/opt/server/packages/auth/dist/migrations/mysql/1624434102642-update_roles_and_permissions.js,/opt/server/packages/auth/dist/migrations/mysql/1625164984414-change_setting_timestamps.js,/opt/server/packages/auth/dist/migrations/mysql/1625227894975-change_setting_value_size.js,/opt/server/packages/auth/dist/migrations/mysql/1625767770284-change_setting_value_to_nullable.js,/opt/server/packages/auth/dist/migrations/mysql/1625807999951-add_unique_setting_index.js,/opt/server/packages/auth/dist/migrations/mysql/1626268390207-remove_unique_setting_index.js,/opt/server/packages/auth/dist/migrations/mysql/1626689139110-add_user_subscriptions.js,/opt/server/packages/auth/dist/migrations/mysql/1626717016896-fix_subscription_foreign_key.js,/opt/server/packages/auth/dist/migrations/mysql/1627638504691-move_mfa_items_to_user_settings.js,/opt/server/packages/auth/dist/migrations/mysql/1629215600192-generate_user_server_key.js,/opt/server/packages/auth/dist/migrations/mysql/1629217630132-encrypt_encoded_mfa_settings.js,/opt/server/packages/auth/dist/migrations/mysql/1629223072059-flatten_mfa_setting_and_encrypt.js,/opt/server/packages/auth/dist/migrations/mysql/1629703896382-add_markdown_math.js,/opt/server/packages/auth/dist/migrations/mysql/1629705289178-add_sensitive_flag.js,/opt/server/packages/auth/dist/migrations/mysql/1629972294975-fix_basic_and_core_user.js,/opt/server/packages/auth/dist/migrations/mysql/1630661830850-fix_encryption_version_on_mfa_settings.js,/opt/server/packages/auth/dist/migrations/mysql/1630905831679-add-cancelled-flag.js,/opt/server/packages/auth/dist/migrations/mysql/1634064348750-add_offline_settings.js,/opt/server/packages/auth/dist/migrations/mysql/1634102065310-add_offline_subscriptions.js,/opt/server/packages/auth/dist/migrations/mysql/1634102764797-add_offline_user_roles.js,/opt/server/packages/auth/dist/migrations/mysql/1635167238332-remove_spreadsheets_from_plus_plan.js,/opt/server/packages/auth/dist/migrations/mysql/1635172524403-add_subscription_id.js,/opt/server/packages/auth/dist/migrations/mysql/1635344737460-add_missing_permissions.js,/opt/server/packages/auth/dist/migrations/mysql/1635860707639-add_mandatory_subscription_id.js,/opt/server/packages/auth/dist/migrations/mysql/1638388151083-add_tags_and_focus_permissions.js,/opt/server/packages/auth/dist/migrations/mysql/1639998097029-add_role_version.js,/opt/server/packages/auth/dist/migrations/mysql/1640701224273-add-smart-tags.js,/opt/server/packages/auth/dist/migrations/mysql/1640862425427-remove_no_distraction_theme.js,/opt/server/packages/auth/dist/migrations/mysql/1645094434931-add_sign_in_alerts_permission.js,/opt/server/packages/auth/dist/migrations/mysql/1646817642385-add_markdown_visual_editor_permissions.js,/opt/server/packages/auth/dist/migrations/mysql/1647253634773-fix_storage_quota_on_plans.js,/opt/server/packages/auth/dist/migrations/mysql/1647421277767-remove_user_agent.js,/opt/server/packages/auth/dist/migrations/mysql/1647862631224-add_readonly_sessions.js,/opt/server/packages/auth/dist/migrations/mysql/1648112718114-add_tag_nesting_permission.js,/opt/server/packages/auth/dist/migrations/mysql/1648458841415-add_shared_subscription_invitations.js,/opt/server/packages/auth/dist/migrations/mysql/1648550676786-add_subscription_types.js,/opt/server/packages/auth/dist/migrations/mysql/1648629732139-add_beta_files_user_role.js,/opt/server/packages/auth/dist/migrations/mysql/1649660400536-add_subscription_settings.js,/opt/server/packages/auth/dist/migrations/mysql/1649679945386-remove_files_settings_from_user_settings.js,/opt/server/packages/auth/dist/migrations/mysql/1650890853447-change_upload_quota_tiers.js,/opt/server/packages/auth/dist/migrations/mysql/1651046286472-add_2fa.js,/opt/server/packages/auth/dist/migrations/mysql/1651064332146-remove_2fa_manager.js,/opt/server/packages/auth/dist/migrations/mysql/1652258146238-add_missing_plus_permissions.js,/opt/server/packages/auth/dist/migrations/mysql/1652786070920-remove_basic_user_role.js,/opt/server/packages/auth/dist/migrations/mysql/1652880249670-add_analytics_entities.js,/opt/server/packages/auth/dist/migrations/mysql/1654760926952-add_email_backup_permission.js,/opt/server/packages/auth/dist/migrations/mysql/1654877423147-add_advanced_checklist_editor_permission.js,/opt/server/packages/auth/dist/migrations/mysql/1661771230400-revoked_session_data.js,/opt/server/packages/auth/dist/migrations/mysql/1663073954000-add_subcription_sharing_permission.js,/opt/server/packages/auth/dist/migrations/mysql/1663321030000-add_renewed_at_column.js,/opt/server/packages/auth/dist/migrations/mysql/1664971834974-groups.js,/opt/server/packages/auth/dist/migrations/mysql/1665047863774-remove-groups.js,/opt/server/packages/auth/dist/migrations/mysql/1667818539829-remove_analytics.js,/opt/server/packages/auth/dist/migrations/mysql/1671448907955-add_session_traces.js,/opt/server/packages/auth/dist/migrations/mysql/1671561748264-add_session_traces_compound_index.js,/opt/server/packages/auth/dist/migrations/mysql/1672223738686-add_authenticators.js,/opt/server/packages/auth/dist/migrations/mysql/1672227471677-add_authenticator_challenges.js,/opt/server/packages/auth/dist/migrations/mysql/1672232035280-fix_authenticator_data_types.js,/opt/server/packages/auth/dist/migrations/mysql/1672299743840-add_unique_index_on_challenges.js,/opt/server/packages/auth/dist/migrations/mysql/1672307975117-remove_compound_index.js,/opt/server/packages/auth/dist/migrations/mysql/1672317378817-add_authenticator_name.js,/opt/server/packages/auth/dist/migrations/mysql/1673951291148-add_super_editor.js,/opt/server/packages/auth/dist/migrations/mysql/1674739193816-fix-client-id-type-in-authenticators.js,/opt/server/packages/auth/dist/migrations/mysql/1678110075698-remove-sign-in-emails-on-free-acounts.js,/opt/server/packages/auth/dist/migrations/mysql/1678266947362-add-internal-team-user-role.js,/opt/server/packages/auth/dist/migrations/mysql/1678340701766-remove-authenticator-names-from-server.js,/opt/server/packages/auth/dist/migrations/mysql/1680597887475-emergency-access-invitations.js,/opt/server/packages/auth/dist/migrations/mysql/1681984540867-enable-u2f.js,/opt/server/packages/auth/dist/migrations/mysql/1682926032072-cache-entries.js,/opt/server/packages/auth/dist/migrations/mysql/1683017908845-change-cache-table-name.js,/opt/server/packages/auth/dist/migrations/mysql/1692348191367-add-transition-role.js,/opt/server/packages/auth/dist/migrations/mysql/1694000575425-add-shared-vault-users.js,/opt/server/packages/auth/dist/migrations/mysql/1694157482134-add_vaults_user.js,/opt/server/packages/auth/dist/migrations/mysql/1695283870612-add-designated-survivor.js,/opt/server/packages/auth/dist/migrations/mysql/1697704066569-remove-transition-role.js" {"level":"info","message":"Starting worker...","service":"auth"} localhost:3103 is unavailable yet - waiting for it to start localhost:3103 is unavailable yet - waiting for it to start localhost:3103 is unavailable yet - waiting for it to start

==> logs/auth.err <== localhost (127.0.0.1:3101) open [ioredis] Unhandled error event: Error: connect ECONNREFUSED 172.23.0.5:6379 at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1595:16) at TCPConnectWrap.callbackTrampoline (node:internal/async_hooks:130:17) [ioredis] Unhandled error event: Error: connect ETIMEDOUT at Socket. (/opt/server/.yarn/cache/ioredis-npm-5.3.2-58471071b1-0140f055ef.zip/node_modules/ioredis/built/Redis.js:170:41) at Object.onceWrapper (node:events:628:28) at Socket.emit (node:events:514:28) at Socket._onTimeout (node:net:589:8) at listOnTimeout (node:internal/timers:573:17)

==> logs/auth.log <== localhost:3101 is unavailable yet - waiting for it to start localhost:3101 is up. Proceeding to startup. query: SELECT VERSION() AS version info: All classes found using provided glob pattern "/opt/server/packages/auth/dist/src/Bootstrap/../../migrations/mysql/.js" : "/opt/server/packages/auth/dist/migrations/mysql/1606470249553-init_database.js,/opt/server/packages/auth/dist/migrations/mysql/1610015065194-add_revoked_sessions.js,/opt/server/packages/auth/dist/migrations/mysql/1610025371088-add_foreign_key_to_revoked_sessions.js,/opt/server/packages/auth/dist/migrations/mysql/1612191669523-add_roles_and_permissions.js,/opt/server/packages/auth/dist/migrations/mysql/1612255683992-add_roles_and_permissions_data.js,/opt/server/packages/auth/dist/migrations/mysql/1612433739754-add_more_roles_and_permissions.js,/opt/server/packages/auth/dist/migrations/mysql/1614678016791-add_user_settings.js,/opt/server/packages/auth/dist/migrations/mysql/1614771815912-add_encrypted_version.js,/opt/server/packages/auth/dist/migrations/mysql/1614775877590-add_encrypted_version_for_user.js,/opt/server/packages/auth/dist/migrations/mysql/1624434102642-update_roles_and_permissions.js,/opt/server/packages/auth/dist/migrations/mysql/1625164984414-change_setting_timestamps.js,/opt/server/packages/auth/dist/migrations/mysql/1625227894975-change_setting_value_size.js,/opt/server/packages/auth/dist/migrations/mysql/1625767770284-change_setting_value_to_nullable.js,/opt/server/packages/auth/dist/migrations/mysql/1625807999951-add_unique_setting_index.js,/opt/server/packages/auth/dist/migrations/mysql/1626268390207-remove_unique_setting_index.js,/opt/server/packages/auth/dist/migrations/mysql/1626689139110-add_user_subscriptions.js,/opt/server/packages/auth/dist/migrations/mysql/1626717016896-fix_subscription_foreign_key.js,/opt/server/packages/auth/dist/migrations/mysql/1627638504691-move_mfa_items_to_user_settings.js,/opt/server/packages/auth/dist/migrations/mysql/1629215600192-generate_user_server_key.js,/opt/server/packages/auth/dist/migrations/mysql/1629217630132-encrypt_encoded_mfa_settings.js,/opt/server/packages/auth/dist/migrations/mysql/1629223072059-flatten_mfa_setting_and_encrypt.js,/opt/server/packages/auth/dist/migrations/mysql/1629703896382-add_markdown_math.js,/opt/server/packages/auth/dist/migrations/mysql/1629705289178-add_sensitive_flag.js,/opt/server/packages/auth/dist/migrations/mysql/1629972294975-fix_basic_and_core_user.js,/opt/server/packages/auth/dist/migrations/mysql/1630661830850-fix_encryption_version_on_mfa_settings.js,/opt/server/packages/auth/dist/migrations/mysql/1630905831679-add-cancelled-flag.js,/opt/server/packages/auth/dist/migrations/mysql/1634064348750-add_offline_settings.js,/opt/server/packages/auth/dist/migrations/mysql/1634102065310-add_offline_subscriptions.js,/opt/server/packages/auth/dist/migrations/mysql/1634102764797-add_offline_user_roles.js,/opt/server/packages/auth/dist/migrations/mysql/1635167238332-remove_spreadsheets_from_plus_plan.js,/opt/server/packages/auth/dist/migrations/mysql/1635172524403-add_subscription_id.js,/opt/server/packages/auth/dist/migrations/mysql/1635344737460-add_missing_permissions.js,/opt/server/packages/auth/dist/migrations/mysql/1635860707639-add_mandatory_subscription_id.js,/opt/server/packages/auth/dist/migrations/mysql/1638388151083-add_tags_and_focus_permissions.js,/opt/server/packages/auth/dist/migrations/mysql/1639998097029-add_role_version.js,/opt/server/packages/auth/dist/migrations/mysql/1640701224273-add-smart-tags.js,/opt/server/packages/auth/dist/migrations/mysql/1640862425427-remove_no_distraction_theme.js,/opt/server/packages/auth/dist/migrations/mysql/1645094434931-add_sign_in_alerts_permission.js,/opt/server/packages/auth/dist/migrations/mysql/1646817642385-add_markdown_visual_editor_permissions.js,/opt/server/packages/auth/dist/migrations/mysql/1647253634773-fix_storage_quota_on_plans.js,/opt/server/packages/auth/dist/migrations/mysql/1647421277767-remove_user_agent.js,/opt/server/packages/auth/dist/migrations/mysql/1647862631224-add_readonly_sessions.js,/opt/server/packages/auth/dist/migrations/mysql/1648112718114-add_tag_nesting_permission.js,/opt/server/packages/auth/dist/migrations/mysql/1648458841415-add_shared_subscription_invitations.js,/opt/server/packages/auth/dist/migrations/mysql/1648550676786-add_subscription_types.js,/opt/server/packages/auth/dist/migrations/mysql/1648629732139-add_beta_files_user_role.js,/opt/server/packages/auth/dist/migrations/mysql/1649660400536-add_subscription_settings.js,/opt/server/packages/auth/dist/migrations/mysql/1649679945386-remove_files_settings_from_user_settings.js,/opt/server/packages/auth/dist/migrations/mysql/1650890853447-change_upload_quota_tiers.js,/opt/server/packages/auth/dist/migrations/mysql/1651046286472-add_2fa.js,/opt/server/packages/auth/dist/migrations/mysql/1651064332146-remove_2fa_manager.js,/opt/server/packages/auth/dist/migrations/mysql/1652258146238-add_missing_plus_permissions.js,/opt/server/packages/auth/dist/migrations/mysql/1652786070920-remove_basic_user_role.js,/opt/server/packages/auth/dist/migrations/mysql/1652880249670-add_analytics_entities.js,/opt/server/packages/auth/dist/migrations/mysql/1654760926952-add_email_backup_permission.js,/opt/server/packages/auth/dist/migrations/mysql/1654877423147-add_advanced_checklist_editor_permission.js,/opt/server/packages/auth/dist/migrations/mysql/1661771230400-revoked_session_data.js,/opt/server/packages/auth/dist/migrations/mysql/1663073954000-add_subcription_sharing_permission.js,/opt/server/packages/auth/dist/migrations/mysql/1663321030000-add_renewed_at_column.js,/opt/server/packages/auth/dist/migrations/mysql/1664971834974-groups.js,/opt/server/packages/auth/dist/migrations/mysql/1665047863774-remove-groups.js,/opt/server/packages/auth/dist/migrations/mysql/1667818539829-remove_analytics.js,/opt/server/packages/auth/dist/migrations/mysql/1671448907955-add_session_traces.js,/opt/server/packages/auth/dist/migrations/mysql/1671561748264-add_session_traces_compound_index.js,/opt/server/packages/auth/dist/migrations/mysql/1672223738686-add_authenticators.js,/opt/server/packages/auth/dist/migrations/mysql/1672227471677-add_authenticator_challenges.js,/opt/server/packages/auth/dist/migrations/mysql/1672232035280-fix_authenticator_data_types.js,/opt/server/packages/auth/dist/migrations/mysql/1672299743840-add_unique_index_on_challenges.js,/opt/server/packages/auth/dist/migrations/mysql/1672307975117-remove_compound_index.js,/opt/server/packages/auth/dist/migrations/mysql/1672317378817-add_authenticator_name.js,/opt/server/packages/auth/dist/migrations/mysql/1673951291148-add_super_editor.js,/opt/server/packages/auth/dist/migrations/mysql/1674739193816-fix-client-id-type-in-authenticators.js,/opt/server/packages/auth/dist/migrations/mysql/1678110075698-remove-sign-in-emails-on-free-acounts.js,/opt/server/packages/auth/dist/migrations/mysql/1678266947362-add-internal-team-user-role.js,/opt/server/packages/auth/dist/migrations/mysql/1678340701766-remove-authenticator-names-from-server.js,/opt/server/packages/auth/dist/migrations/mysql/1680597887475-emergency-access-invitations.js,/opt/server/packages/auth/dist/migrations/mysql/1681984540867-enable-u2f.js,/opt/server/packages/auth/dist/migrations/mysql/1682926032072-cache-entries.js,/opt/server/packages/auth/dist/migrations/mysql/1683017908845-change-cache-table-name.js,/opt/server/packages/auth/dist/migrations/mysql/1692348191367-add-transition-role.js,/opt/server/packages/auth/dist/migrations/mysql/1694000575425-add-shared-vault-users.js,/opt/server/packages/auth/dist/migrations/mysql/1694157482134-add_vaults_user.js,/opt/server/packages/auth/dist/migrations/mysql/1695283870612-add-designated-survivor.js,/opt/server/packages/auth/dist/migrations/mysql/1697704066569-remove-transition-role.js" query: SELECT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'sn_db' AND TABLE_NAME = 'migrations' query: SELECT * FROM sn_db.migrations migrations ORDER BY id DESC No migrations are pending {"level":"info","message":"Server started on port 3103","service":"auth"} localhost:3101 is unavailable yet - waiting for it to start localhost:3101 is unavailable yet - waiting for it to start

and

tail logs/auth*

==> logs/auth-worker.err <== [ioredis] Unhandled error event: Error: getaddrinfo ENOTFOUND cache at GetAddrInfoReqWrap.onlookup [as oncomplete] (node:dns:107:26) at GetAddrInfoReqWrap.callbackTrampoline (node:internal/async_hooks:130:17) [ioredis] Unhandled error event: Error: getaddrinfo ENOTFOUND cache at GetAddrInfoReqWrap.onlookup [as oncomplete] (node:dns:107:26) at GetAddrInfoReqWrap.callbackTrampoline (node:internal/async_hooks:130:17) [ioredis] Unhandled error event: Error: getaddrinfo ENOTFOUND cache at GetAddrInfoReqWrap.onlookup [as oncomplete] (node:dns:107:26) at GetAddrInfoReqWrap.callbackTrampoline (node:internal/async_hooks:130:17) localhost (127.0.0.1:3103) open

==> logs/auth-worker.log <== {"level":"info","message":"Starting worker...","service":"auth"} localhost:3103 is unavailable yet - waiting for it to start localhost:3103 is unavailable yet - waiting for it to start localhost:3103 is unavailable yet - waiting for it to start localhost:3103 is unavailable yet - waiting for it to start localhost:3103 is unavailable yet - waiting for it to start localhost:3103 is up. Proceeding to startup. query: SELECT VERSION() AS version info: All classes found using provided glob pattern "/opt/server/packages/auth/dist/src/Bootstrap/../../migrations/mysql/*.js" : "/opt/server/packages/auth/dist/migrations/mysql/1606470249553-init_database.js,/opt/server/packages/auth/dist/migrations/mysql/1610015065194-add_revoked_sessions.js,/opt/server/packages/auth/dist/migrations/mysql/1610025371088-add_foreign_key_to_revoked_sessions.js,/opt/server/packages/auth/dist/migrations/mysql/1612191669523-add_roles_and_permissions.js,/opt/server/packages/auth/dist/migrations/mysql/1612255683992-add_roles_and_permissions_data.js,/opt/server/packages/auth/dist/migrations/mysql/1612433739754-add_more_roles_and_permissions.js,/opt/server/packages/auth/dist/migrations/mysql/1614678016791-add_user_settings.js,/opt/server/packages/auth/dist/migrations/mysql/1614771815912-add_encrypted_version.js,/opt/server/packages/auth/dist/migrations/mysql/1614775877590-add_encrypted_version_for_user.js,/opt/server/packages/auth/dist/migrations/mysql/1624434102642-update_roles_and_permissions.js,/opt/server/packages/auth/dist/migrations/mysql/1625164984414-change_setting_timestamps.js,/opt/server/packages/auth/dist/migrations/mysql/1625227894975-change_setting_value_size.js,/opt/server/packages/auth/dist/migrations/mysql/1625767770284-change_setting_value_to_nullable.js,/opt/server/packages/auth/dist/migrations/mysql/1625807999951-add_unique_setting_index.js,/opt/server/packages/auth/dist/migrations/mysql/1626268390207-remove_unique_setting_index.js,/opt/server/packages/auth/dist/migrations/mysql/1626689139110-add_user_subscriptions.js,/opt/server/packages/auth/dist/migrations/mysql/1626717016896-fix_subscription_foreign_key.js,/opt/server/packages/auth/dist/migrations/mysql/1627638504691-move_mfa_items_to_user_settings.js,/opt/server/packages/auth/dist/migrations/mysql/1629215600192-generate_user_server_key.js,/opt/server/packages/auth/dist/migrations/mysql/1629217630132-encrypt_encoded_mfa_settings.js,/opt/server/packages/auth/dist/migrations/mysql/1629223072059-flatten_mfa_setting_and_encrypt.js,/opt/server/packages/auth/dist/migrations/mysql/1629703896382-add_markdown_math.js,/opt/server/packages/auth/dist/migrations/mysql/1629705289178-add_sensitive_flag.js,/opt/server/packages/auth/dist/migrations/mysql/1629972294975-fix_basic_and_core_user.js,/opt/server/packages/auth/dist/migrations/mysql/1630661830850-fix_encryption_version_on_mfa_settings.js,/opt/server/packages/auth/dist/migrations/mysql/1630905831679-add-cancelled-flag.js,/opt/server/packages/auth/dist/migrations/mysql/1634064348750-add_offline_settings.js,/opt/server/packages/auth/dist/migrations/mysql/1634102065310-add_offline_subscriptions.js,/opt/server/packages/auth/dist/migrations/mysql/1634102764797-add_offline_user_roles.js,/opt/server/packages/auth/dist/migrations/mysql/1635167238332-remove_spreadsheets_from_plus_plan.js,/opt/server/packages/auth/dist/migrations/mysql/1635172524403-add_subscription_id.js,/opt/server/packages/auth/dist/migrations/mysql/1635344737460-add_missing_permissions.js,/opt/server/packages/auth/dist/migrations/mysql/1635860707639-add_mandatory_subscription_id.js,/opt/server/packages/auth/dist/migrations/mysql/1638388151083-add_tags_and_focus_permissions.js,/opt/server/packages/auth/dist/migrations/mysql/1639998097029-add_role_version.js,/opt/server/packages/auth/dist/migrations/mysql/1640701224273-add-smart-tags.js,/opt/server/packages/auth/dist/migrations/mysql/1640862425427-remove_no_distraction_theme.js,/opt/server/packages/auth/dist/migrations/mysql/1645094434931-add_sign_in_alerts_permission.js,/opt/server/packages/auth/dist/migrations/mysql/1646817642385-add_markdown_visual_editor_permissions.js,/opt/server/packages/auth/dist/migrations/mysql/1647253634773-fix_storage_quota_on_plans.js,/opt/server/packages/auth/dist/migrations/mysql/1647421277767-remove_user_agent.js,/opt/server/packages/auth/dist/migrations/mysql/1647862631224-add_readonly_sessions.js,/opt/server/packages/auth/dist/migrations/mysql/1648112718114-add_tag_nesting_permission.js,/opt/server/packages/auth/dist/migrations/mysql/1648458841415-add_shared_subscription_invitations.js,/opt/server/packages/auth/dist/migrations/mysql/1648550676786-add_subscription_types.js,/opt/server/packages/auth/dist/migrations/mysql/1648629732139-add_beta_files_user_role.js,/opt/server/packages/auth/dist/migrations/mysql/1649660400536-add_subscription_settings.js,/opt/server/packages/auth/dist/migrations/mysql/1649679945386-remove_files_settings_from_user_settings.js,/opt/server/packages/auth/dist/migrations/mysql/1650890853447-change_upload_quota_tiers.js,/opt/server/packages/auth/dist/migrations/mysql/1651046286472-add_2fa.js,/opt/server/packages/auth/dist/migrations/mysql/1651064332146-remove_2fa_manager.js,/opt/server/packages/auth/dist/migrations/mysql/1652258146238-add_missing_plus_permissions.js,/opt/server/packages/auth/dist/migrations/mysql/1652786070920-remove_basic_user_role.js,/opt/server/packages/auth/dist/migrations/mysql/1652880249670-add_analytics_entities.js,/opt/server/packages/auth/dist/migrations/mysql/1654760926952-add_email_backup_permission.js,/opt/server/packages/auth/dist/migrations/mysql/1654877423147-add_advanced_checklist_editor_permission.js,/opt/server/packages/auth/dist/migrations/mysql/1661771230400-revoked_session_data.js,/opt/server/packages/auth/dist/migrations/mysql/1663073954000-add_subcription_sharing_permission.js,/opt/server/packages/auth/dist/migrations/mysql/1663321030000-add_renewed_at_column.js,/opt/server/packages/auth/dist/migrations/mysql/1664971834974-groups.js,/opt/server/packages/auth/dist/migrations/mysql/1665047863774-remove-groups.js,/opt/server/packages/auth/dist/migrations/mysql/1667818539829-remove_analytics.js,/opt/server/packages/auth/dist/migrations/mysql/1671448907955-add_session_traces.js,/opt/server/packages/auth/dist/migrations/mysql/1671561748264-add_session_traces_compound_index.js,/opt/server/packages/auth/dist/migrations/mysql/1672223738686-add_authenticators.js,/opt/server/packages/auth/dist/migrations/mysql/1672227471677-add_authenticator_challenges.js,/opt/server/packages/auth/dist/migrations/mysql/1672232035280-fix_authenticator_data_types.js,/opt/server/packages/auth/dist/migrations/mysql/1672299743840-add_unique_index_on_challenges.js,/opt/server/packages/auth/dist/migrations/mysql/1672307975117-remove_compound_index.js,/opt/server/packages/auth/dist/migrations/mysql/1672317378817-add_authenticator_name.js,/opt/server/packages/auth/dist/migrations/mysql/1673951291148-add_super_editor.js,/opt/server/packages/auth/dist/migrations/mysql/1674739193816-fix-client-id-type-in-authenticators.js,/opt/server/packages/auth/dist/migrations/mysql/1678110075698-remove-sign-in-emails-on-free-acounts.js,/opt/server/packages/auth/dist/migrations/mysql/1678266947362-add-internal-team-user-role.js,/opt/server/packages/auth/dist/migrations/mysql/1678340701766-remove-authenticator-names-from-server.js,/opt/server/packages/auth/dist/migrations/mysql/1680597887475-emergency-access-invitations.js,/opt/server/packages/auth/dist/migrations/mysql/1681984540867-enable-u2f.js,/opt/server/packages/auth/dist/migrations/mysql/1682926032072-cache-entries.js,/opt/server/packages/auth/dist/migrations/mysql/1683017908845-change-cache-table-name.js,/opt/server/packages/auth/dist/migrations/mysql/1692348191367-add-transition-role.js,/opt/server/packages/auth/dist/migrations/mysql/1694000575425-add-shared-vault-users.js,/opt/server/packages/auth/dist/migrations/mysql/1694157482134-add_vaults_user.js,/opt/server/packages/auth/dist/migrations/mysql/1695283870612-add-designated-survivor.js,/opt/server/packages/auth/dist/migrations/mysql/1697704066569-remove-transition-role.js" {"level":"info","message":"Starting worker...","service":"auth"}

==> logs/auth.err <== at Socket._onTimeout (node:net:589:8) at listOnTimeout (node:internal/timers:573:17) at process.processTimers (node:internal/timers:514:7) [ioredis] Unhandled error event: Error: getaddrinfo ENOTFOUND cache at GetAddrInfoReqWrap.onlookup [as oncomplete] (node:dns:107:26) at GetAddrInfoReqWrap.callbackTrampoline (node:internal/async_hooks:130:17) [ioredis] Unhandled error event: Error: getaddrinfo ENOTFOUND cache at GetAddrInfoReqWrap.onlookup [as oncomplete] (node:dns:107:26) at GetAddrInfoReqWrap.callbackTrampoline (node:internal/async_hooks:130:17) localhost (127.0.0.1:3101) open

==> logs/auth.log <== query: SELECT session.uuid AS session_uuid, session.user_uuid AS session_user_uuid, session.hashed_access_token AS session_hashed_access_token, session.hashed_refresh_token AS session_hashed_refresh_token, session.access_expiration AS session_access_expiration, session.refresh_expiration AS session_refresh_expiration, session.api_version AS session_api_version, session.user_agent AS session_user_agent, session.created_at AS session_created_at, session.updated_at AS session_updated_at, session.readonly_access AS session_readonly_access FROM sessions session WHERE session.uuid = ? -- PARAMETERS: ["5daae3c6-02c3-492c-a10f-9eL498261848"] query: SELECT revoked_session.uuid AS revoked_session_uuid, revoked_session.user_uuid AS revoked_session_user_uuid, revoked_session.received AS revoked_session_received, revoked_session.created_at AS revoked_session_created_at, revoked_session.received_at AS revoked_session_received_at, revoked_session.user_agent AS revoked_session_user_agent, revoked_session.api_version AS revoked_session_api_version FROM revoked_sessions revoked_session WHERE revoked_session.uuid = ? -- PARAMETERS: ["5daae3c6-02c3-492c-a10f-9eL498261848"] query: SELECT session.uuid AS session_uuid, session.user_uuid AS session_user_uuid, session.hashed_access_token AS session_hashed_access_token, session.hashed_refresh_token AS session_hashed_refresh_token, session.access_expiration AS session_access_expiration, session.refresh_expiration AS session_refresh_expiration, session.api_version AS session_api_version, session.user_agent AS session_user_agent, session.created_at AS session_created_at, session.updated_at AS session_updated_at, session.readonly_access AS session_readonly_access FROM sessions session WHERE session.uuid = ? -- PARAMETERS: ["5daae3c6-02c3-492c-a10f-9eL498261848"] query: SELECT revoked_session.uuid AS revoked_session_uuid, revoked_session.user_uuid AS revoked_session_user_uuid, revoked_session.received AS revoked_session_received, revoked_session.created_at AS revoked_session_created_at, revoked_session.received_at AS revoked_session_received_at, revoked_session.user_agent AS revoked_session_user_agent, revoked_session.api_version AS revoked_session_api_version FROM revoked_sessions revoked_session WHERE revoked_session.uuid = ? -- PARAMETERS: ["5daae3c6-02c3-492c-a10f-9eL498261848"] query: SELECT session.uuid AS session_uuid, session.user_uuid AS session_user_uuid, session.hashed_access_token AS session_hashed_access_token, session.hashed_refresh_token AS session_hashed_refresh_token, session.access_expiration AS session_access_expiration, session.refresh_expiration AS session_refresh_expiration, session.api_version AS session_api_version, session.user_agent AS session_user_agent, session.created_at AS session_created_at, session.updated_at AS session_updated_at, session.readonly_access AS session_readonly_access FROM sessions session WHERE session.uuid = ? -- PARAMETERS: ["5daae3c6-02c3-492c-a10f-9eL498261848"] query: SELECT revoked_session.uuid AS revoked_session_uuid, revoked_session.user_uuid AS revoked_session_user_uuid, revoked_session.received AS revoked_session_received, revoked_session.created_at AS revoked_session_created_at, revoked_session.received_at AS revoked_session_received_at, revoked_session.user_agent AS revoked_session_user_agent, revoked_session.api_version AS revoked_session_api_version FROM revoked_sessions revoked_session WHERE revoked_session.uuid = ? -- PARAMETERS: ["5daae3c6-02c3-492c-a10f-9eL498261848"] query: SELECT session.uuid AS session_uuid, session.user_uuid AS session_user_uuid, session.hashed_access_token AS session_hashed_access_token, session.hashed_refresh_token AS session_hashed_refresh_token, session.access_expiration AS session_access_expiration, session.refresh_expiration AS session_refresh_expiration, session.api_version AS session_api_version, session.user_agent AS session_user_agent, session.created_at AS session_created_at, session.updated_at AS session_updated_at, session.readonly_access AS session_readonly_access FROM sessions session WHERE session.uuid = ? -- PARAMETERS: ["5daae3c6-02c3-492c-a10f-9eL498261848"] query: SELECT revoked_session.uuid AS revoked_session_uuid, revoked_session.user_uuid AS revoked_session_user_uuid, revoked_session.received AS revoked_session_received, revoked_session.created_at AS revoked_session_created_at, revoked_session.received_at AS revoked_session_received_at, revoked_session.user_agent AS revoked_session_user_agent, revoked_session.api_version AS revoked_session_api_version FROM revoked_sessions revoked_session WHERE revoked_session.uuid = ? -- PARAMETERS: ["5daae3c6-02c3-492c-a10f-9eL498261848"] query: SELECT session.uuid AS session_uuid, session.user_uuid AS session_user_uuid, session.hashed_access_token AS session_hashed_access_token, session.hashed_refresh_token AS session_hashed_refresh_token, session.access_expiration AS session_access_expiration, session.refresh_expiration AS session_refresh_expiration, session.api_version AS session_api_version, session.user_agent AS session_user_agent, session.created_at AS session_created_at, session.updated_at AS session_updated_at, session.readonly_access AS session_readonly_access FROM sessions session WHERE session.uuid = ? -- PARAMETERS: ["5daae3c6-02c3-492c-a10f-9eL498261848"] query: SELECT revoked_session.uuid AS revoked_session_uuid, revoked_session.user_uuid AS revoked_session_user_uuid, revoked_session.received AS revoked_session_received, revoked_session.created_at AS revoked_session_created_at, revoked_session.received_at AS revoked_session_received_at, revoked_session.user_agent AS revoked_session_user_agent, revoked_session.api_version AS revoked_session_api_version FROM revoked_sessions revoked_session WHERE revoked_session.uuid = ? -- PARAMETERS: ["5daae3c6-02c3-492c-a10f-9eL498261848"]

karolsojko commented 11 months ago

Seems like your Redis container did not start - can you check docker compose logs -f and see if cache is ok ?

ghost commented 11 months ago

yes the cache work and ready to accept connection normal

ghost commented 11 months ago

i se the auth.log show this

{"level":"error","message":"Error: Unsupported state or unable to authenticate data\n at Decipheriv.final (node:internal/crypto/cipher:193:29)\n at CryptoNode.aes256GcmDecrypt (/opt/server/packages/sncrypto-node/dist/src/CryptoNode.js:23:103)\n at CrypterNode.decryptUserServerKey (/opt/server/packages/auth/dist/src/Domain/Encryption/CrypterNode.js:71:32)\n at CrypterNode.decryptForUser (/opt/server/packages/auth/dist/src/Domain/Encryption/CrypterNode.js:53:51)\n at SettingCrypter.decrypt (/opt/server/packages/auth/dist/src/Domain/Setting/SettingCrypter.js:40:33)\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n at async GetSetting.execute (/opt/server/packages/auth/dist/src/Domain/UseCase/GetSetting/GetSetting.js:34:36)\n at async VerifyMFA.execute (/opt/server/packages/auth/dist/src/Domain/UseCase/VerifyMFA.js:86:38)\n at async AnnotatedAuthController.pkceParams (/opt/server/packages/auth/dist/src/Infra/InversifyExpressUtils/Base/BaseAuthController.js:136:35)","resource.service.name":"Auth","service":"auth","span_id":"dca128293a89aa00","trace_flags":"00","trace_id":"6545230d62614af323d5a2933047e6a3"}

and also i look over database the table authenticators empty

karolsojko commented 11 months ago

authenticators is for U2F devices.

This error though: Unsupported state or unable to authenticate data\n at Decipheriv.final - would hint me towards the fact that the proper env vars are not set up?

Do you have these in your .env file: 

########
# KEYS #
########

AUTH_JWT_SECRET=
AUTH_SERVER_ENCRYPTION_SERVER_KEY=
VALET_TOKEN_SECRET=

?

ghost commented 11 months ago

yes all i set

karolsojko commented 11 months ago

is this a new user or one that was created before the env vars were set?

Seems related to this: https://github.com/standardnotes/server/issues/618

ghost commented 11 months ago

this is old user thats work from 2 years ago

ghost commented 11 months ago

also on api-gateway.log its show this

{"level":"error","message":"Could not pass the request to http://localhost:3103/auth/pkce_params on underlying service: Status: undefined, code: ERR_BAD_RESPONSE, message: Request failed with status code 500","service":"api-gateway"}

karolsojko commented 11 months ago

this is old user thats work from 2 years ago

I assume you didn't have the env vars set in that case and recreated the server with new env vars?

The issue here is that the server is trying to compare password with different encryption keys. The previous one (created most probably upon user creation) was dynamically generated. The encryption key was lost upon recreating the server. We've fixed that along the way by requiring to input it in the env vars (those 3 I mentioned before) - so that it is persistent. So unless you have the same keys that you had when you created the user you have to re-register and import a backup. On the other hand if you have those key values from before please input them in the env vars.

ghost commented 11 months ago

Fixed by remove MFA Entry From Setting by phpmyadmin