XF 2.3 Multiple Xenforo OAuth Connected Accounts

dunowat

Member
Running Xenforo 2.3.6

Is it possible to have multiple xenforo connected accounts? It appears right now that I can only do one xenforo connected account. Ideally I'd be able to add one more. Is this possible or is it limited to one connection?
 
Solution
Yes I was successful with it..

Step 1 Create the Connected Account
Code:
INSERT INTO xf_connected_account_provider (provider_id, provider_class, display_order, options) VALUES ('Xenforo2', 'XF:Provider\\Xenforo', 100, '[]');

Step 2 Insert the info.
Code:
UPDATE xf_connected_account_provider
SET provider_class = 'XF:Provider\\XenForo',
    options = '{"display_title":"[Site Name]","board_url":"https://example.com","client_id":"[your-client-id]","client_secret":"[your-client-secret]"}'
WHERE provider_id = '[your-provider-id]';

After you insert the info then you'll see it show up in ACP > Connected Accounts

From there you can edit it.
There is no GUI to do that but it should be pretty easy:
Just add a new record with a new...
There is no GUI to do that but it should be pretty easy:
Just add a new record with a new provider_id and provider_class = XF:Provider\XenForo to table xf_connected_account_provider.

For example
SQL:
INSERT INTO xf_connected_account_provider (provider_id, provider_class, display_order, options) VALUES ('xenforo2', 'XF:Provider\\Xenforo'), 100, '[]')
 
Last edited:
There is no GUI to do that but it should be pretty easy:
Have you been successful with just doing the table entry? When I do the table entries there are no additional providers listed at admin.php?connected-accounts. Below are screenshots of the table entries I tried previously and the results.

I would take no offense whatsoever if you were to point out if I'm doing something stupid and is why it's not working. 😁

1743715824398.webp
1743715909359.webp
 
Have you been successful with just doing the table entry?
Yes. I originally filed a bug report that led to code changes which enable this behaviour so I am pretty confident it works (at least it does for me :)).

 
Yes I was successful with it..

Step 1 Create the Connected Account
Code:
INSERT INTO xf_connected_account_provider (provider_id, provider_class, display_order, options) VALUES ('Xenforo2', 'XF:Provider\\Xenforo', 100, '[]');

Step 2 Insert the info.
Code:
UPDATE xf_connected_account_provider
SET provider_class = 'XF:Provider\\XenForo',
    options = '{"display_title":"[Site Name]","board_url":"https://example.com","client_id":"[your-client-id]","client_secret":"[your-client-secret]"}'
WHERE provider_id = '[your-provider-id]';

After you insert the info then you'll see it show up in ACP > Connected Accounts

From there you can edit it.
There is no GUI to do that but it should be pretty easy:
Just add a new record with a new provider_id and provider_class = XF:Provider\XenForo to table xf_connected_account_provider.

For example
SQL:
INSERT INTO xf_connected_account_provider (provider_id, provider_class, display_order, options) VALUES ('xenforo2', 'XF:Provider\Xenforo'), 100, '[]')

Very helpful. Thank you for the lead. Confirmed it works. There was just a small syntax issue in the command.
 
Solution
Step 2 Insert the info.
AH! That's what I missed, thank you! I was thinking that after doing the manual entry to create the 'xenforo2' provider that it would then be available via the ACP but I didn't catch that it needs a manual update to set the values for it.

Thanks, guys, you made my night! :cool:

Happy New Year Vintage GIF
 
Back
Top Bottom