I have 2 sites, let's call them site1 and site2. They're setup as subdomains such as:
site1.domain.com and site2.domain.com
They're both running Joomla 3.9.24 and I have created a view on site2 database to get their user details from the site1 database.
I have renamed the tables on site2 db:
RENAME TABLE `site2_users` TO `site2_bak_users`;
RENAME TABLE `site2_session` TO `site2_bak_session`;
RENAME TABLE `site2_usergroups` TO `site2_bak_usergroups`;
RENAME TABLE `site2_user_notes` TO `site2_bak_user_notes`;
RENAME TABLE `site2_user_profiles` TO `site2_bak_user_profiles`;
RENAME TABLE `site2_user_usergroup_map` TO `site2_bak_user_usergroup_map`;
RENAME TABLE `site2_viewlevels` TO `site2_bak_viewlevels`;
and then created a view on site2 database to get the user details from site1 database:
CREATE VIEW `site2_users` AS SELECT * FROM `SITE1_DATABASE`.`site1_users`;
CREATE VIEW `site2_session` AS SELECT * FROM `SITE1_DATABASE`.`site1_session`;
CREATE VIEW `site2_usergroups` AS SELECT * FROM `SITE1_DATABASE`.`site1_usergroups`;
CREATE VIEW `site2_user_notes` AS SELECT * FROM `SITE1_DATABASE`.`site1_user_notes`;
CREATE VIEW `site2_user_profiles` AS SELECT * FROM `SITE1_DATABASE`.`site1_user_profiles`;
CREATE VIEW `site2_user_usergroup_map` AS SELECT * FROM `SITE1_DATABASE`.`site1_user_usergroup_map`;
CREATE VIEW `site2_viewlevels` AS SELECT * FROM `SITE1_DATABASE`.`site1_viewlevels`;
This is working great.
Site2 is running Kunena and the users are showing in the users data in Kunena.
I was assuming that if a user is logged into site1, then they should be logged into site2 automatically?
But if I log into site1 and then load site2, I need to log in again (using the same log-in info)
I need the user session to be the same for both sites. Any ideas?