|
|
Posted by Jerim on 08/17/07 14:54
On Aug 17, 9:32 am, Rik <luiheidsgoe...@hotmail.com> wrote:
> On Fri, 17 Aug 2007 16:11:33 +0200, Jerim <wyo...@gmail.com> wrote:
> > I am attempting to put together one script that pulls data from one
> > database on its own server, and data from another database on its own
> > server, which is off-site.
>
> > Server 1 - Only allows shared memory access to the database. Also
> > disallows http:// includes. This is where the database of names is
> > stored. This is our internal MySQL server.
>
> > Server 2 - Only allows shared memory access to the database. So
> > anything that calls the connection has to be on the same server. This
> > is our external web server maintained by an outside party.
>
> > To get a list of names, I created a PHP page on Server 2 that simply
> > includes a script from Server 1. The script on Server 1 connects to
> > the database, runs the query and prints the names to the screen. I did
> > this, because we wanted the web page on our web server which is Server
> > 2, but since the the MySQL on Server 1 only accepts shared memory
> > access, the script that called it had to be on the same server.
>
> > Now what I want to do is include the ages of each person. That is
> > information stored in a MySQL database on Server 2, the web server. I
> > can't modify the Script on Server 1 to include the database connection
> > on Server 2 since Server 2 also requires shared memory access. So I
> > tried putting an include file on Server 2 and calling it from Server
> > 1, but Server 2 doesn't allow http:// includes.
>
> > Please keep in mind that I have had problems with the include. You
> > would think that being an include file, it would have access to all
> > the data on the page that called it. I have found this not to be the
> > case. The include script that I called, did not recognize variables
> > that were declared in the file that was calling it. Perhaps because it
> > was on another server?
>
> Indeed.
>
> > The only solution I could find was to pass the
> > variables to the include file through URL. So if I were to put another
> > include statement on the original page on Server 2, the off site
> > include doesn't have access to that database connection. Any help is
> > appreciated.
>
> Hmmms, it seems there's an epedemic of people including by HTTP (search
> the recent archive of this group). While you can include the _output_ of
> an php file by HTTP, a 'real' include, which will recognize your variables
> can only be done using either the local filesystem or by including raw PHP
> code from elsewhere instead of the result.
>
> The fact that these 2 servers can hardly communicate is a real problem.
> You'll either have to get the output data and link it to age 'manually'
> with PHP, or you'll have to really think about the database(server) setup.
> Preferably all related data on one server, possibly a master/slave
> scenario.
We have discussed changing the setup, but are limited in what we are
allowed to do and by how much time we could dedicate to a project.
Which is practically none. (If they would let us shut down the IT
department for a month or so, buy at least one heavy duty server,
merge everything on to it, and adjust the databases to be more
cohesive(15 years of various workers results in a hodge podge of
databases/tables), that would be great. But it isn't going to happen.)
You mention including raw PHP. I don't know what you mean by that.
Could you please describe the process vaguely, so I know what to
search for?
Navigation:
[Reply to this message]
|