[Bug]: Oauth providers not visible after switching to ENTERPRISE mode

[martkaczmarek]

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

After switching my local installation (2.5.1) to ENTERPRISE mode from SAAS, I cannot log into Lowcoder using proviously available Oauth provider. Even after creating a new provider, it's not visible on the list nor on the login form. API endpoint also only returns EMAIL type login:

{
    "code": 1,
    "message": "",
    "data": {
        "authConfigs": [
            {
                "authType": "FORM",
                "id": "EMAIL",
                "enable": false,
                "enableRegister": true,
                "source": "EMAIL",
                "sourceName": "EMAIL",
                "authType": "FORM"
            }
        ],
        "workspaceMode": "ENTERPRISE",
        "selfDomain": false,
        "cookieName": "LOWCODER_CE_SELFHOST_TOKEN",
        "cloudHosting": false
    },
    "success": true
}

Applications, data sources, saved queries, logins and user groups seem to correctly transfer from SAAS organisation.
Interestingly, the user's e-mail binding to Oauth identity seems to still be working - after logging in with email/password, I can still access data in application that would normally require the Oauth credentials.
It's important to note I have not checked whether it happens with clean ENTERPRISE installation.

Expected Behavior

Oauth providers should carry over to SAAS mode

Steps to reproduce

1. Create multi-Docker installation in SAAS mode
2. Create one organisation
3. Create Oauth provider
4. Change mode to ENTERPRISE
5. Restart docker instances and try to login - only a Email login is possible (if it's enabled)
6. Login as admin
7. Go to Providers configuration page and create another provider
8. Provider does not appear on the list

Environment

Lowcoder multi-docker, 2.5.1

Additional Information

No response

[adnanqaops]

On ENTERPRISE Mode, I ( as Admin / Super Admin ) can add and see OAuth Providers , successfully. I have checked it locally.

[martkaczmarek]

@adnanqaops was it on a clean install or after change from SAAS to ENTERPRISE?
My scenario occurs after changing my installation from SAAS to ENTERPRISE.

I managed to test it in clean install and it shows up.

[ill-git]

Maybe this helps:

1. I created a new installation using SAAS and just signed up with an admin
2. Switched to ENTERPRISE Mode
3. logged in with the admin
4. added an oauth-provider > got a success toast, but provider doesn't show up in the list. only the e-mail provider is in there
5. repeated to add a provider > got again a success toast, but doesn't show up in the list
6. switched back to SAAS
7. logged in with the admin
8. my added provider both are in the list

[martkaczmarek]

I have a new detail to add: in the 'faulty' environment (now 2.5.3) , after I logged in as a super-admin in the SAAS mode, I noticed there was another workspace (created automatically for another user, I guess). I didn't see it before, because I was using workspace admin, not super admin.
After I deleted all the workspaces except my main one and THEN switched to the ENTERPRISE mode, everything works again. I can add new auth providers and the old ones are visible.
So I guess only when there are multiple workspaces and we switch to ENTERPRISE mode, the app doesn't know what to do and doesn't return any auth providers.

[adnanqaops]

This has been fixed and deployed. So, closing out this ticket.