MySQL + PHP on IIS6
am 04.12.2007 17:32:32 von gstar
Hi,
I followed many great articles online, here as an example [http://
www.atksolutions.com/articles/install_php_mysql_iis.html].
All steps work fine, PHP is installed with the testpage OK, Mysql
installed OK & database created. I then rebooted the server but when I
try to load the page in IE7 on server 2003 it simply loads a blank
page, no 404 just blank.!
The source of the loaded page states:
The testmysql.php is:
//remember to change the password to whatever you set
//it to in mysql instance configuration
//first parameter is server name, 2nd username 'root', 3rd is password
$rst = @mysql_connect("localhost","root","password");
if (!$rst){
echo( "Unable to connect to database manager.
");
die('Could not connect: ' . mysql_error());
exit();
} else {
echo("Successfully Connected to MySQL Database Manager!
");
}
if (! @mysql_select_db("mysql") ){
echo( "Unable to connect database...
");
exit();
} else {
echo("Successfully Connected to Database 'MYSQL'!
");
}
?>
I know IIS can read PHP as the php test file is good?
Any ideas?
Re: MySQL + PHP on IIS6
am 05.12.2007 10:07:36 von David Wang
On Dec 4, 8:32 am, gstar wrote:
> Hi,
> I followed many great articles online, here as an example [http://www.atksolutions.com/articles/install_php_mysql_iis. html].
>
> All steps work fine, PHP is installed with the testpage OK, Mysql
> installed OK & database created. I then rebooted the server but when I
> try to load the page in IE7 on server 2003 it simply loads a blank
> page, no 404 just blank.!
>
> The source of the loaded page states:
>
>
>
>
>
>
> The testmysql.php is:
>
>
> //remember to change the password to whatever you set
> //it to in mysql instance configuration
>
> //first parameter is server name, 2nd username 'root', 3rd is password
> $rst = @mysql_connect("localhost","root","password");
>
> if (!$rst){
> echo( "Unable to connect to database manager.
");
> die('Could not connect: ' . mysql_error());
> exit();} else {
>
> echo("Successfully Connected to MySQL Database Manager!
");
>
> }
>
> if (! @mysql_select_db("mysql") ){
> echo( "Unable to connect database...
");
> exit();} else {
>
> echo("Successfully Connected to Database 'MYSQL'!
");}
>
> ?>
>
> I know IIS can read PHP as the php test file is good?
>
> Any ideas?
http://blogs.msdn.com/david.wang/archive/2005/12/31/HOWTO_Ba sics_of_IIS6_Troubleshooting.aspx
For the problematic URL, perform the above analysis and report the
contents of the relevant log files.
//David
http://w3-4u.blogspot.com
http://blogs.msdn.com/David.Wang
//
Re: MySQL + PHP on IIS6
am 06.12.2007 10:09:28 von gstar
> http://blogs.msdn.com/david.wang/archive/2005/12/31/HOWTO_Ba sics_of_I...
>
> For the problematic URL, perform the above analysis and report the
> contents of the relevant log files.
>
> //Davidhttp://w3-4u.blogspot.comhttp://blogs.msdn.com/David. Wang
> //- Hide quoted text -
>
> - Show quoted text -
Erm, thanx for replying but I am lost as to where you are going with
it? Are you suggesting I read your entire blog about II6 problem
solving to fix an issue with MySQL & PHP?
With respect I run 5 business websites on IIS6 & SQL 2000 but this is
the first time I have come across MySQL & PHP, hence the question?
Confused..
Re: MySQL + PHP on IIS6
am 06.12.2007 11:53:36 von David Wang
On Dec 6, 1:09 am, gstar wrote:
> >http://blogs.msdn.com/david.wang/archive/2005/12/31/HOWTO_B asics_of_I...
>
> > For the problematic URL, perform the above analysis and report the
> > contents of the relevant log files.
>
> > //Davidhttp://w3-4u.blogspot.comhttp://blogs.msdn.com/David. Wang
> > //- Hide quoted text -
>
> > - Show quoted text -
>
> Erm, thanx for replying but I am lost as to where you are going with
> it? Are you suggesting I read your entire blog about II6 problem
> solving to fix an issue with MySQL & PHP?
>
> With respect I run 5 business websites on IIS6 & SQL 2000 but this is
> the first time I have come across MySQL & PHP, hence the question?
>
> Confused..
With Respect, if you think this is a MySQL & PHP problem, then you
should go to their respective support forums for questions.
I am asking you to read one specific blog entry which has lots of
information on which logs to gather information to troubleshoot issues
starting from IIS. If you do not gather this information, very few
people can help you other than provide guesses. I assume that you want
concrete support, not random guesses.
Now, if you are saying that you are unwilling or unable to learn to
help yourself (via the blog entry and many other related blog
entries), then your only avenues of support are to pray for someone's
good graces, or to pay professionals like Microsoft PSS for support.
I don't know anything about MySQL or PHP, but I'm hoping that you can
be my eyes and ears for IIS's view of the issue, so that I can tell
you whether this issue is within IIS or not. If it is within IIS, then
we can proceed further if you desire. If it is not within IIS, then
you should proceed to PHP or MySQL forums for additional support.
Where am I going? Trying to help you isolate the issue and make
forward progress without charging you for several hundred dollars
worth of services. Your choice as to whether you want help or not.
//David
http://w3-4u.blogspot.com
http://blogs.msdn.com/David.Wang
//