Re: Executing PHP files on remote web server

"Jerry Stuckle" <jstucklex@xxxxxxxxxxxxx> wrote in message
news:gvturi$bbk$1@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
rdyornot wrote:
The good news is we can access the web MySQL database directly from our
domain's web space. Is it possible to move a few of the PHP pages -- the
ones needed to do the inserts into the MySQL database -- to the web host
and point to those remote files in the PHP pages that remain on our own
web server? (From what I can see this needs to include a global
variables file besides the SQL insert scripts. The global variables
include SSI file paths, db name, user name, etc. that don't match on the
two web servers.) The result would be the PHP pages on the web host's
server executing the data insert statements into the web database. I
think I need to pass session variable values to the web host's server
from the session variables on our web server, but I'm a C and Java
programmer from way back, not a PHP programmer (until now!) and I don't
know if these remote operations can be done.

You should have the same security concern for your own MySQL database. You
say you don't want your customers accessing your network to get the data -
why are you leaving your MySQL database open for anyone to access? That
is MUCH MORE of a security concern! What's going to happen when someone
hacks it?

Thanks for the warning, but our MySQL database isn't accessible from the
Internet. We've set up firewalls. It's only accessible from authenticated
users with IP addresses on our network, including our web server. The web
server is also firewalled and only accessible from authenticated users with
IP addresses on our network. If a hacker breaks through the firewalls, then
we're in trouble.

The first thing you need to do is to hire a programmer to figure out what
you've got and then how to do it the right way.

There's no budget to hire another employee, even temporarily. We only have
two employees left who have any IT experience. I'm the Oracle and SQL
Server DBA, database developer, desktop app developer and part-time network
administrator/help desk operator -- and now I'm the MySQL DBA and web
developer, too.

Thanks for the advice.


.

Relevant Pages

  • Re: Executing PHP files on remote web server
    ... Is it possible to move a few of the PHP pages -- the ones needed to do the inserts into the MySQL database -- to the web host and point to those remote files in the PHP pages that remain on our own web server? ...
    (comp.lang.php)
  • Re: Unknown MySQL Server Host localhost
    ... >I'm rather new to both MySQL and PHP. ... What host is the MySQL database on? ... Are you running the command line on the same host as the web server ...
    (comp.lang.php)
  • [Full-disclosure] PHP "multipart/form-data" denial of service
    ... PHP version 5.3.1 was just released. ... the temporary files will be deleted. ... When you send these requests to the web server, ... In a few seconds, the web server is not responding anymore, 65535 ...
    (Full-Disclosure)
  • PHP "multipart/form-data" denial of service
    ... PHP version 5.3.1 was just released. ... the temporary files will be deleted. ... When you send these requests to the web server, ... In a few seconds, the web server is not responding anymore, 65535 ...
    (Bugtraq)
  • Re: Ruby performance woes
    ... Now here's my take on all this: PHP and JSP and what I inquired ... S-expressions used as a directly alternate expression of SGML or XML. ... By the way, I've never had access to a Web server that can run ASP, ...
    (comp.lang.lisp)