Help needed: Mutiple OSC sites but single registration

[Carbon_Fibre]

Hi Guys

 

I'd appreciate if anyone has any suggestions on how I can do this:

 

If I have 3 (or more) osCommerce sites (all seperate companies), but I want all the sites to shares users i.e. I need customers to be able to register once but login/shop on each site without having to register on each site individually. What would be the best way of doing this and how would I be able to this:

 

Option 1: With a centralised registration page, which copies the form information into a "customers" row of a seperate MySQL table (i.e. Table 4)

(1 x MySQL database - but with seperate tables for each osc installation. Hence 4 tables <3+1>).

All osc sites run off the same MySQL database but from different tables. I then find a way to amend the oscommerce.sql file so that it queries the "customers" row in Table 4 instead of the original row/table.

 

 

Option 2: With a centralised registration page

(3 x MySQL databases - 1 for each osc installation).

Is there then a way to create an automated process to run, so that the 'process' copies the user details into the "customers" row of the MySQL table of each osc installation; or

 

 

Option 3: Traditional osc registration page for each osc installation

But find a way to have the "customers" row copied to the other databases (or tables) by some automated process, everytime someone registers or on a daily basis

 

 

Any input or ideas on how I can do this will be really appreciated. Thanks in advance.

[♥toyicebear]

Click me>>

[Carbon_Fibre]

Click me>>

Thank you for your suggestion. I will have a look and post my results.

[Carbon_Fibre]

Thank you for your suggestion. I will have a look and post my results.

Click me>>

 

Hi

 

I have looked at that add-on, but it does not meet my requirements.

 

I need customers to be able to register once but login/shop on each site without having to register on each site individually. I looked at this add-on (http://addons.oscommerce.com/info/5510), but this add-on doesn't work. It might require Root Access.

 

Does anybody have any other suggestions or links to another add-on - like Multiple Stores, 1 User Account?

 

Thanks

[satish]

Check Hobzilla contrib for Multi store

[Carbon_Fibre]

Check Hobzilla contrib for Multi store

 

Hi

 

Thanks for the reply

 

Toyicebear suggested that in the thread. I tried that but it's not what I'm looking for.

 

Any other suggestions?

[Carbon_Fibre]

Hi Guys

 

I'd appreciate if anyone has any suggestions on how I can do this:

 

If I have 3 (or more) osCommerce sites (all seperate companies), but I want all the sites to shares users i.e. I need customers to be able to register once but login/shop on each site without having to register on each site individually. What would be the best way of doing this and how would I be able to this:

 

Option 1: With a centralised registration page, which copies the form information into a "customers" row of a seperate MySQL table (i.e. Table 4)

(1 x MySQL database - but with seperate tables for each osc installation. Hence 4 tables <3+1>).

All osc sites run off the same MySQL database but from different tables. I then find a way to amend the oscommerce.sql file so that it queries the "customers" row in Table 4 instead of the original row/table.

 

 

Option 2: With a centralised registration page

(3 x MySQL databases - 1 for each osc installation).

Is there then a way to create an automated process to run, so that the 'process' copies the user details into the "customers" row of the MySQL table of each osc installation; or

 

 

Option 3: Traditional osc registration page for each osc installation

But find a way to have the "customers" row copied to the other databases (or tables) by some automated process, everytime someone registers or on a daily basis

 

 

Any input or ideas on how I can do this will be really appreciated. Thanks in advance.

 

The Multiple Stores, 1 User Account for all (http://addons.oscommerce.com/info/5510), seems like the best way to go, but I can't get it to work. Where do I specify the permision to access the 'user' database?

 

So Option 4 is the 'The Multiple Stores, 1 User Account for all' method. Each of the 3 OSC installation runs on its own database. I then create a 4th database called "users". The question is how can I get the stores to query this "users" database i.e. where do I specifiy the database username and password?

 

NB. I don't have root access

[Carbon_Fibre]

Where did you specify the database username and password for the users database?

 

I get this error when trying to register as a new customer through the store front end, which leads me to believe that I need to specify the database username and password for the 'users' table:

1142 - SELECT command denied to user 'username'@'server43.jnb2.host-h.net' for table 'customers'

select count(*) as total from users.customers where customers_email_address = '[email protected]'

[TEP STOP]

 

I don't have root access as I am on a shared server. I don't mind signing up for a vps server with root access if I can get this working. Does anybody know if this will work on a vps server with root access without any changes i.e. without specifying database username and password for 'users' database?

 

Please help. This is driving me crazy