FUDforum: comp.lang.php » linking between 2 databases (on different servers)

Home » Imported messages » comp.lang.php » linking between 2 databases (on different servers)

Show: Today's Messages :: Polls :: Message Navigator

linking between 2 databases (on different servers) [message #170349]

Fri, 29 October 2010 22:50

info_at_inhousetraini
Messages: 2
Registered: October 2010

Karma: 0

Junior Member

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

-------------------------------------

--
+-----------------------------[ SERVER SIGNATURE ]--+
| Article posted via Web Developer's USENET Archive |
| http://www.1-script.com/forums/ |
| Web and RSS gateway to your favorite newsgroup - |
| comp.lang.php |
+---------------------------------------------------+

Report message to a moderator

Re: linking between 2 databases (on different servers) [message #170350 is a reply to message #170349]

Sat, 30 October 2010 00:01

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma: 0

Senior Member

On 10/29/2010 6:50 PM, 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
>
>
> -------------------------------------
>
>
>
>

How are you going to access the database if you can't access the server?

Additionally, many hosts firewall databases from external access for
security reasons. If that's the case, it wouldn't be accessible no
matter what.

But this isn't really a PHP question - it's a database question. What
you're asking pertains to any programming language - but only to the
database(s) in question.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================

Report message to a moderator

Re: linking between 2 databases (on different servers) [message #170351 is a reply to message #170349]

Sat, 30 October 2010 01:44

Magno
Messages: 49
Registered: October 2010

Karma: 0

Member

On 10/29/2010 07:50 PM, 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

You could write a PHP service in the other side, which can process some
(because of obvious potential security issues) pre-made queries and
return them to your script, all the communication being made through curl.

The only issues would be, bandwidth consumption (might not worry you in
some cases), and delay because of the communication between servers.

Report message to a moderator

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: 0

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

-------------------------------------

Report message to a moderator

Re: linking between 2 databases (on different servers) [message #170366 is a reply to message #170352]

Sat, 30 October 2010 15:55

Peter H. Coffin
Messages: 245
Registered: September 2010

Karma: 0

Senior Member

On Sat, 30 Oct 2010 10:35:13 +0000, ANF wrote:
> 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

It's a database issue, and not one that you can solve directly with PHP.
You cannot access the second database system, nor can you access the
information on it. The only way to make it happen is to get the data
onto the database system than you CAN access. Therefore, it's a DATABASE
problem that requires a DATABASE fix.

--
If any foreign minister begins to defend to the death a "peace
conference," you can be sure his government has already placed its
orders for new battleships and airplanes. -Joseph Stalin

Report message to a moderator

Previous Topic:	How to post data without waiting for the response
Next Topic:	Stats comp.lang.php (last 7 days)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 10 19:57:03 GMT 2025

Total time taken to generate the page: 0.06420 seconds