4 sites on 4 different hosting, on 1 database - GoFuckYourself.com

Bronze · 10-24-2005, 10:07 AM

Hi,
I was wondering if anyone ever done this before, or ever come across an issue like this and they have a solution. I have 4 paysites on 4 different server, that I want to combine them, so that when a user sign up they will put into a database. The next time they login, they can login from any of these site using 1 login, if they cancel, they will be wipe from the database and they can't login to any of these site again. Is there anyway possible to do this? I've call CCBill and they said there's no way to write across 4 different server. Just wondering if anyone ever come across this or know of a solution for this.

darksoul · 10-24-2005, 10:10 AM

Its doable.
Just have on each server a script that syncs with the master.

Bronze · 10-24-2005, 10:11 AM

This would be doing it from the paysites end or the processor End?

darksoul · 10-24-2005, 10:12 AM

paysites end.

RobbieRye · 10-24-2005, 10:15 AM

On one of the servers load all user data into a MySQL database. Allow access to that database from a specific user when requested from the IP of one of the other servers.

Or, if you want to get fancy, you could setup an LDAP directory.

Bronze · 10-24-2005, 10:22 AM

I know of a way someone told, that it's possible to use with .htaccess transferring every minute or so, but there's still some time gap and i'm not sure just transferring and replace .htaccess is the optimal solution. Instant synchronization is more what i'm looking for. Do you know of a program that would do this? or know an info somewhere I can look up?

Bronze · 10-24-2005, 10:27 AM

Thx but that's what CCbill told me when I call them. It's possible probably to authenticate a MySql database across server, but their script can't write example a new user across server. They don't seem to able to possible do this across server it seem.

Quote:

Originally Posted by RobbieRye

On one of the servers load all user data into a MySQL database. Allow access to that database from a specific user when requested from the IP of one of the other servers.

Or, if you want to get fancy, you could setup an LDAP directory.

darksoul · 10-24-2005, 10:40 AM

You can use mod_auth_sql which will connect to the master server to authentificate.

Bronze · 10-24-2005, 10:49 AM

Now I think about it, there'll be problems If I use .htaccess because there will be duplicate name from the 2 different site. So this is not an option.

I can authenticate by MySql most likely, but CCbill script can't or won't write across server to the Database for new user. Each site have 4 different script, they all need to write across server.

darksoul · 10-24-2005, 10:53 AM

You can replace the ccbill script with your own.

Bronze · 10-24-2005, 12:38 PM

Anyone know of a program that do this? I don't like to have make the scripts, if it's the last thing I need.

RobbieRye · 10-24-2005, 01:02 PM

Quote:

Originally Posted by darksoul

You can replace the ccbill script with your own.

Yeah, this is the way that I'd go too. If you can't write it yourself, ask for some consulting help from this forum.

Before writing the new program, I would likely check out the existing one to see if there is a simple way to do it.

The only other option that I can think of is to add a second IP to each of the servers and privately forward all authentication tasks to the central server.

10-24-2005, 10:07 AM	#1
Bronze Registered User Join Date: May 2004 Posts: 39	4 sites on 4 different hosting, on 1 database Hi, I was wondering if anyone ever done this before, or ever come across an issue like this and they have a solution. I have 4 paysites on 4 different server, that I want to combine them, so that when a user sign up they will put into a database. The next time they login, they can login from any of these site using 1 login, if they cancel, they will be wipe from the database and they can't login to any of these site again. Is there anyway possible to do this? I've call CCBill and they said there's no way to write across 4 different server. Just wondering if anyone ever come across this or know of a solution for this.

10-24-2005, 10:10 AM	#2
darksoul Confirmed User Join Date: Apr 2002 Location: /root/ Posts: 4,997	Its doable. Just have on each server a script that syncs with the master. __________________ 1337 5y54\|)m1n: 157717888 BM-2cUBw4B2fgiYAfjkE7JvWaJMiUXD96n9tN Cambooth

10-24-2005, 10:12 AM	#4
darksoul Confirmed User Join Date: Apr 2002 Location: /root/ Posts: 4,997	paysites end. __________________ 1337 5y54\|)m1n: 157717888 BM-2cUBw4B2fgiYAfjkE7JvWaJMiUXD96n9tN Cambooth

10-24-2005, 10:40 AM	#8
darksoul Confirmed User Join Date: Apr 2002 Location: /root/ Posts: 4,997	You can use mod_auth_sql which will connect to the master server to authentificate. __________________ 1337 5y54\|)m1n: 157717888 BM-2cUBw4B2fgiYAfjkE7JvWaJMiUXD96n9tN Cambooth

10-24-2005, 10:53 AM	#10
darksoul Confirmed User Join Date: Apr 2002 Location: /root/ Posts: 4,997	You can replace the ccbill script with your own. __________________ 1337 5y54\|)m1n: 157717888 BM-2cUBw4B2fgiYAfjkE7JvWaJMiUXD96n9tN Cambooth

10-24-2005, 10:11 AM	#3
Bronze Registered User Join Date: May 2004 Posts: 39	This would be doing it from the paysites end or the processor End?

10-24-2005, 10:15 AM	#5
RobbieRye Registered User Join Date: Oct 2005 Location: The Middle of Nowhere Posts: 616	On one of the servers load all user data into a MySQL database. Allow access to that database from a specific user when requested from the IP of one of the other servers. Or, if you want to get fancy, you could setup an LDAP directory.

10-24-2005, 10:22 AM	#6
Bronze Registered User Join Date: May 2004 Posts: 39	I know of a way someone told, that it's possible to use with .htaccess transferring every minute or so, but there's still some time gap and i'm not sure just transferring and replace .htaccess is the optimal solution. Instant synchronization is more what i'm looking for. Do you know of a program that would do this? or know an info somewhere I can look up?

10-24-2005, 10:49 AM	#9
Bronze Registered User Join Date: May 2004 Posts: 39	Now I think about it, there'll be problems If I use .htaccess because there will be duplicate name from the 2 different site. So this is not an option. I can authenticate by MySql most likely, but CCbill script can't or won't write across server to the Database for new user. Each site have 4 different script, they all need to write across server.

10-24-2005, 12:38 PM	#11
Bronze Registered User Join Date: May 2004 Posts: 39	Anyone know of a program that do this? I don't like to have make the scripts, if it's the last thing I need.