Share tables between 2 sites on different domain using views

[bonzo_bcn]

I have two joomla installations under two domains in a VPS, they have separate accounts but I managed to share virtuemart product tables by using views on one database.

The problem I have is that admin user cannot be logged in on both sites at the same time. If I log to the backend of one site, the other is automatically logged off, even if the second user is not managing the virtuemart tables.

What can be the problem?

[customnames]

are you sharing the session table ?

If you got this to work drop us a line of how you solved it

[bonzo_bcn]

I did it with the following code:

Code: Select all

GRANT ALL PRIVILEGES ON `installation1\_joomla` . * TO 'installation2_joomla'@'localhost' WITH GRANT OPTION ;
GRANT ALL PRIVILEGES ON `installation1\_joomla` . * TO 'installation2'@'localhost' WITH GRANT OPTION ;

DROP TABLE jos_vm_auth_group;
DROP TABLE jos_vm_auth_user_group;
DROP TABLE jos_vm_auth_user_vendor;
DROP TABLE jos_vm_cart;
DROP TABLE jos_vm_category;
DROP TABLE jos_vm_category_xref;
DROP TABLE jos_vm_country;
DROP TABLE jos_vm_coupons;
DROP TABLE jos_vm_creditcard;
DROP TABLE jos_vm_csv;
DROP TABLE jos_vm_currency;
DROP TABLE jos_vm_export;
DROP TABLE jos_vm_function;
DROP TABLE jos_vm_manufacturer;
DROP TABLE jos_vm_manufacturer_category;
DROP TABLE jos_vm_module;
DROP TABLE jos_vm_orders;
DROP TABLE jos_vm_order_history;
DROP TABLE jos_vm_order_item;
DROP TABLE jos_vm_order_payment;
DROP TABLE jos_vm_order_status;
DROP TABLE jos_vm_order_user_info;
DROP TABLE jos_vm_payment_method;
DROP TABLE jos_vm_product;
DROP TABLE jos_vm_product_attribute;
DROP TABLE jos_vm_product_attribute_sku;
DROP TABLE jos_vm_product_category_xref;
DROP TABLE jos_vm_product_discount;
DROP TABLE jos_vm_product_download;
DROP TABLE jos_vm_product_files;
DROP TABLE jos_vm_product_mf_xref;
DROP TABLE jos_vm_product_price;
DROP TABLE jos_vm_product_product_type_xref;
DROP TABLE jos_vm_product_relations;
DROP TABLE jos_vm_product_reviews;
DROP TABLE jos_vm_product_type;
DROP TABLE jos_vm_product_type_1;
DROP TABLE jos_vm_product_type_parameter;
DROP TABLE jos_vm_product_votes;
DROP TABLE jos_vm_shipping_carrier;
DROP TABLE jos_vm_shipping_label;
DROP TABLE jos_vm_shipping_rate;
DROP TABLE jos_vm_shopper_group;
DROP TABLE jos_vm_shopper_vendor_xref;
DROP TABLE jos_vm_state;
DROP TABLE jos_vm_tax_rate;
DROP TABLE jos_vm_userfield;
DROP TABLE jos_vm_userfield_values;
DROP TABLE jos_vm_user_info;
/*DROP TABLE jos_vm_vendor;*/
DROP TABLE jos_vm_vendor_category;
DROP TABLE jos_vm_waiting_list;
DROP TABLE jos_vm_zone_shipping;
/********/
DROP TABLE `jos_users`;     
DROP TABLE `jos_session`;
DROP TABLE `jos_stats_agents`;
DROP TABLE `jos_core_acl_aro`;
DROP TABLE `jos_core_acl_aro_groups`;
DROP TABLE `jos_core_acl_aro_map`;
DROP TABLE `jos_core_acl_aro_sections`;
DROP TABLE `jos_core_acl_groups_aro_map`;


 
create view jos_vm_auth_group as select * from installation1_joomla.jos_vm_auth_group;
create view jos_vm_auth_user_group as select * from installation1_joomla.jos_vm_auth_user_group;
create view jos_vm_auth_user_vendor as select * from installation1_joomla.jos_vm_auth_user_vendor;
create view jos_vm_cart as select * from installation1_joomla.jos_vm_cart;
create view jos_vm_category as select * from installation1_joomla.jos_vm_category;
create view jos_vm_category_xref as select * from installation1_joomla.jos_vm_category_xref;
create view jos_vm_country as select * from installation1_joomla.jos_vm_country;
create view jos_vm_coupons as select * from installation1_joomla.jos_vm_coupons;
create view jos_vm_creditcard as select * from installation1_joomla.jos_vm_creditcard;
create view jos_vm_csv as select * from installation1_joomla.jos_vm_csv;
create view jos_vm_currency as select * from installation1_joomla.jos_vm_currency;
create view jos_vm_export as select * from installation1_joomla.jos_vm_export;
create view jos_vm_function as select * from installation1_joomla.jos_vm_function;
create view jos_vm_manufacturer as select * from installation1_joomla.jos_vm_manufacturer;
create view jos_vm_manufacturer_category as select * from installation1_joomla.jos_vm_manufacturer_category;
create view jos_vm_module as select * from installation1_joomla.jos_vm_module;
create view jos_vm_orders as select * from installation1_joomla.jos_vm_orders;
create view jos_vm_order_history as select * from installation1_joomla.jos_vm_order_history;
create view jos_vm_order_item as select * from installation1_joomla.jos_vm_order_item;
create view jos_vm_order_payment as select * from installation1_joomla.jos_vm_order_payment;
create view jos_vm_order_status as select * from installation1_joomla.jos_vm_order_status;
create view jos_vm_order_user_info as select * from installation1_joomla.jos_vm_order_user_info;
create view jos_vm_payment_method as select * from installation1_joomla.jos_vm_payment_method;
create view jos_vm_product as select * from installation1_joomla.jos_vm_product;
create view jos_vm_product_category_xref as select * from installation1_joomla.jos_vm_product_category_xref;
create view jos_vm_product_attribute as select * from installation1_joomla.jos_vm_product_attribute;
create view jos_vm_product_attribute_sku as select * from installation1_joomla.jos_vm_product_attribute_sku;
create view jos_vm_product_discount as select * from installation1_joomla.jos_vm_product_discount;
create view jos_vm_product_download as select * from installation1_joomla.jos_vm_product_download;
create view jos_vm_product_files as select * from installation1_joomla.jos_vm_product_files;
create view jos_vm_product_mf_xref as select * from installation1_joomla.jos_vm_product_mf_xref;
create view jos_vm_product_price as select * from installation1_joomla.jos_vm_product_price;
create view jos_vm_product_product_type_xref as select * from installation1_joomla.jos_vm_product_product_type_xref;
create view jos_vm_product_relations as select * from installation1_joomla.jos_vm_product_relations;
create view jos_vm_product_reviews as select * from installation1_joomla.jos_vm_product_reviews;
create view jos_vm_product_type as select * from installation1_joomla.jos_vm_product_type;
create view jos_vm_product_type_1 as select * from installation1_joomla.jos_vm_product_type_1;
create view jos_vm_product_type_parameter as select * from installation1_joomla.jos_vm_product_type_parameter;
create view jos_vm_product_votes as select * from installation1_joomla.jos_vm_product_votes;
create view jos_vm_shipping_carrier as select * from installation1_joomla.jos_vm_shipping_carrier;
create view jos_vm_shipping_label as select * from installation1_joomla.jos_vm_shipping_label;
create view jos_vm_shipping_rate as select * from installation1_joomla.jos_vm_shipping_rate;
create view jos_vm_shopper_group as select * from installation1_joomla.jos_vm_shopper_group;
create view jos_vm_shopper_vendor_xref as select * from installation1_joomla.jos_vm_shopper_vendor_xref;
create view jos_vm_state as select * from installation1_joomla.jos_vm_state;
create view jos_vm_tax_rate as select * from installation1_joomla.jos_vm_tax_rate;
create view jos_vm_userfield as select * from installation1_joomla.jos_vm_userfield;
create view jos_vm_userfield_values as select * from installation1_joomla.jos_vm_userfield_values;
create view jos_vm_user_info as select * from installation1_joomla.jos_vm_user_info;
/*create view jos_vm_vendor as select * from installation1_joomla.jos_vm_vendor;*/
create view jos_vm_vendor_category as select * from installation1_joomla.jos_vm_vendor_category;
create view jos_vm_waiting_list as select * from installation1_joomla.jos_vm_waiting_list;
create view jos_vm_zone_shipping as select * from installation1_joomla.jos_vm_zone_shipping;
	
	CREATE VIEW jos_users AS SELECT * FROM installation1_joomla.jos_users;
	CREATE VIEW jos_session AS SELECT * FROM installation1_joomla.jos_session;
	CREATE VIEW jos_stats_agents AS SELECT * FROM installation1_joomla.jos_stats_agents;
	CREATE VIEW jos_core_acl_aro AS SELECT * FROM installation1_joomla.jos_core_acl_aro;
	CREATE VIEW jos_core_acl_aro_groups AS SELECT * FROM installation1_joomla.jos_core_acl_aro_groups;
	CREATE VIEW jos_core_acl_aro_map AS SELECT * FROM installation1_joomla.jos_core_acl_aro_map;
	CREATE VIEW jos_core_acl_aro_sections AS SELECT * FROM installation1_joomla.jos_core_acl_aro_sections;
	CREATE VIEW jos_core_acl_groups_aro_map AS SELECT * FROM installation1_joomla.jos_core_acl_groups_aro_map;
	
	
	
	
	
/*ACYMAILING*/
DROP TABLE jos_acymailing_config  ;
DROP TABLE 	jos_acymailing_fields ; 
DROP TABLE 	jos_acymailing_filter; 
DROP TABLE 	jos_acymailing_list ;
DROP TABLE 	jos_acymailing_listcampaign;
DROP TABLE 	jos_acymailing_listmail ;
DROP TABLE 	jos_acymailing_listsub 	;
DROP TABLE 	jos_acymailing_mail 	;
DROP TABLE 	jos_acymailing_queue 	;
DROP TABLE 	jos_acymailing_stats 	;
DROP TABLE 	jos_acymailing_subscriber;
DROP TABLE 	jos_acymailing_template; 
DROP TABLE 	jos_acymailing_url 	;
DROP TABLE 	jos_acymailing_urlclick; 
DROP TABLE 	jos_acymailing_userstats;


create view jos_acymailing_config  as select * from installation1_joomla.jos_acymailing_config;
create view jos_acymailing_fields as select * from installation1_joomla.jos_acymailing_fields; 
create view jos_acymailing_filter as select * from installation1_joomla.jos_acymailing_filter; 
create view jos_acymailing_list as select * from installation1_joomla.jos_acymailing_list;
create view jos_acymailing_listcampaign as select * from installation1_joomla.jos_acymailing_listcampaign;
create view jos_acymailing_listmail as select * from installation1_joomla.jos_acymailing_listmail;
create view jos_acymailing_listsub 	as select * from installation1_joomla.jos_acymailing_listsub;
create view jos_acymailing_mail 	as select * from installation1_joomla.jos_acymailing_mail;
create view jos_acymailing_queue 	as select * from installation1_joomla.jos_acymailing_queue;
create view jos_acymailing_stats 	as select * from installation1_joomla.jos_acymailing_stats;
create view jos_acymailing_subscriber as select * from installation1_joomla.jos_acymailing_subscriber;
create view jos_acymailing_template as select * from installation1_joomla.jos_acymailing_template; 
create view jos_acymailing_url 	as select * from installation1_joomla.jos_acymailing_url;
create view jos_acymailing_urlclick as select * from installation1_joomla.jos_acymailing_urlclick; 
create view jos_acymailing_userstats as select * from installation1_joomla.jos_acymailing_userstats;
	
	
 
DROP TABLE jos_content  ;
DROP TABLE jos_content_frontpage	;
create view jos_content  as select * from installation1_joomla.jos_content;
create view jos_content_frontpage  as select * from installation1_joomla.jos_content_frontpage;	
	
	
DROP TABLE 	jos_languages 	 ;
DROP TABLE 		jos_menu  ;
DROP TABLE 		jos_menu_types;
DROP TABLE 		jos_categories;
DROP TABLE 		jos_sections;
DROP TABLE 		jos_jf_content;
DROP TABLE 		jos_jf_tableinfo;

create view	jos_languages 	as select * from installation1_joomla.jos_languages;
create view	jos_menu as select * from installation1_joomla.jos_menu;
create view		jos_menu_types as select * from installation1_joomla.jos_menu_types;
create view		jos_categories as select * from installation1_joomla.jos_categories;
create view		jos_sections as select * from installation1_joomla.jos_sections;
create view 		jos_jf_content as select * from installation1_joomla.jos_jf_content;
create view		jos_jf_tableinfo as select * from installation1_joomla.jos_jf_tableinfo;

Where installation1 is the main ddbb and installation2 the ddbb that will look for data in installation1.