Home »
Imported messages »
comp.lang.php »
linking between 2 databases (on different servers)
| Re: linking between 2 databases (on different servers) [message #170352 is a reply to message #170349] |
Sat, 30 October 2010 10:35   |
info_at_inhousetraini
Messages: 2
Registered: October 2010
Karma:
|
Junior Member |
|
|
responding to
http://www.1-script.com/forums/linking-between-2-databases-on-different-ser vers-article132561--7.htm
ANF wrote:
ANF wrote:
> Hi,
> I use 2 servers containing separate content. The content is accessed
> using the same username and password. I have the ip remote server
> address
> for one of the servers but the second server providers are refusing to
> hand out the same information because of security concerns. The info I
> store on this second server does have to be kept safe. Is there a way
> of
> creating a link between the databases using php code which does not
> require the ip address of the second server? I do not want to
> compromise
> on security. Thank you for your time. ANF
> -------------------------------------
Thanks for your effort. I have no background in php or MySql but I'm
learning quickly because this has called a halt to the website
development. If anyone has further suggestions please send them to me.
The username/password registration occurs on the more secure server (if
not handing out remote connection ip addresses makes the second more
secure). The first server contains content which is accessed via
username/password stored on the other server database. In effect the
databases have to link. I did think of storing a table with
authentication details on the first server - a copy of the registration
table on the second server. Thus authentication takes place directly.
However, I've been told it is not a good idea to have two tables with the
same info for the same purpose in php. MySql provide a 'federated engine'
solution for cross server access but I don't think that applies here as
quieries (it seems to me) are only one way. Again, any ideas would be
most welcome. ANF
-------------------------------------
|
|
|
|
Current Time: Mon Nov 25 04:01:52 GMT 2024
Total time taken to generate the page: 0.03250 seconds
Calendar
Search
Help
Members
Register
Login
Home
]