After a lot of searching and asking people who are far more clued up than myself, I have concluded that this is impossible mainly because it requires two concurrent DB connections.
In the end, my SSO solution was to build a more traditional SSO system that creates users in the remote site using the user data from the main site. It also updates them on each login to make sure the profiles always stay up to date.
Related Posts:
- Shared Members between two different wordpress installations with different databases
- What is the fastest way to generate a unique id number when registering a user
- Enter user registration information in the database
- User accounts for saving form data?
- Insert Extra fields added in the front end registration form to DB
- wp_usermeta key problem
- How to resolve ORA-011033: ORACLE initialization or shutdown in progress
- Oracle SQL query for Date format
- Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
- Can I have multiple primary keys in a single table?
- Using wpdb to connect to a separate database
- Database connection close
- How to create bulk page and content? [closed]
- Importing posts from old website to new conflicting post ID’s?
- Exporting revisions
- WP_Options ID high
- Best way to move live site local
- The revisions table in my database is at 70% capacity and growing. What should I do?
- WordPress for a very large website
- How to use multiple database in wordpress?
- WP_list_table bulk_action get edit and delete
- How to display data from custom table in wordpress database?
- Is removing orphaned wp_postmeta records safe?
- Add search Value to wp_list_table pagination
- stdObject stored in database. How does one convert it to usable format?
- I have a table I created, how do I make a form for a user to filter the data?
- What ALL can cause “Another update is currently in progress.”? [closed]
- Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
- Set Display Name to first and last name (phpmyadmin SQL Query)
- Trigger Plugin database update after git pull
- Does WordPress ever need multiple databases?
- Why are no posts showing despite my apparently correct DB restoration?
- How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
- Cannot update custom database table row
- SQL Error wp_commentmeta – incorrect table definition
- Change WordPress prefix for only one table?
- Two websites one database, administrator not working on second website
- Select two sums with single get_var statement
- How to get the SQL of the changes made to the database from an update or upgrade?
- How can i add custom fields into the contact form 7 [closed]
- Make an Items attribute searchable (taxonomy using existing attribute)
- Store partial database to an archive database time to time
- Move out of sync posts from one database to another
- Call to undefined function get_user_meta() – trying to access data in MySQL from custom fields
- When to use custom DB tables or add_option?
- Have working sql query… trying to adjust it to use $wpdb
- Best host for running large mem and processor intensive WordPress sites?
- Will there be any concern if I upgrade my current WordPress Database server from Centos 7 Mariadb 5.5 to Centos 8 Mariadb 10.3?
- In which format the data is stored in WordPress Databases?
- Strange characters added to the database
- Is it possible to rebuild the website while not accesseing the original database?
- Error message on blog posts only on my local environment [closed]
- how to read database fields
- $wpdb->query can’t insert data
- After database migration, theme mods don’t show [closed]
- Remote database connection and local development
- How can I detect right db type?
- Add search bar to Custom Database Table in WordPress Dashboard
- Custom search query by category id
- Design problems when exporting remote database for local development
- Website displays old version of page
- Image link issues after importing a database backup to my local web server
- multiple wordpress installs w/shared user database but separate content databases
- A change in URL slug in database returns 404, how can I do auto-redirect?
- Updating seperate database when post attachment is changed
- add featured image dialog box disappear
- Displaying table data on a page
- muliple wordpress installs (network) on different databases
- WordPress Database – wp_usermeta and the correct number of session_tokens rows
- Continuous SQL query errors from outside source
- How to get a list of articles related to a particular category from my other WordPress website?
- Whats the best practise on how to store json data from a custom settings page?
- Recovery – Restore Database after moving folder location locally
- Migrate Users From laravel to wordpress
- /wp-admin not accessible after migrating to local host (no plugin issue)
- Job and Employee Performance Tracking with Product Safety
- how add more field to wp user and save it to database
- set_transient fails if the value has more than 60.000 characters
- How do I cleanup my database with data that is no longer being used?
- Set SQL_BIG_SELECTS and MAX_JOIN_SIZE on a WP_Query
- How to optimize wp_option table?
- How can I get $wpdb to show MySQL warnings?
- About wp database hooks (error establishing connection)
- Database for JQuery Autocomplete field
- Create Tables in WordPress
- Catchable fatal error in formatting.php
- Wrong url for the images while using same database for two WordPress installations
- WordPress Failed to Login (DB Error)
- Sending WordPress database information to cross domain the safe way?
- Database Name Change
- Share WordPress Database
- Where To Find bb_profile_data(); In bbPress?
- ERROR: “Table Prefix” must not be empty
- How do you build a database-centric site in WP?
- WordPress: Interact with Database Query Data and Login
- Attach posts based on category and position
- Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
- How to properly configure SSL connection to remote azure database for running queries within a WordPress environment
- Database Queries are crashing the server
- Uploading to WordPress Database