Can't get phpMyAdmin to work on Server 2008 R2 RSS

• • Reply
  

  DavidRPotter

  11 Posts

  Can't get phpMyAdmin to work on Server 2008 R2

  Nov 01, 2009 09:04 AM|LINK

  I just installed Windows Server 2008 R2 and got IIS fully installed.  I installed the following:

  • <div mce_keep="true">MySQL 5.1.40 (community)</div>
  • <div mce_keep="true">PHP 5.3.0</div>
  • <div mce_keep="true">phpMyAdmin 3.2.3</div>

  I created the phpMyAdmin config.inc.php as described on my blog (which I've used on several occasions):

  http://dpotter.net/Technical/2009/03/installing-phpmyadmin-on-windows-and-iis-60/

  I am able to navigate to my phpmyadmin URL and I get the login page.  However, after waiting about 30 seconds, the following page is displayed:

   

  <div id=header>

  Server Error in Application "DEFAULT WEB SITE/PHPMYADMIN"

  </div> <div id=server_version>

  Internet Information Services 7.5

  </div> <div id=content> <div class=content-container>

  Error Summary

  HTTP Error 500.0 - Internal Server Error

  The page cannot be displayed because an internal server error has occurred.

  </div> <div class=content-container>

  Detailed Error Information

  <div id=details-left>

  Module	FastCgiModule
  Notification	ExecuteRequestHandler
  Handler	PHP_via_FastCGI
  Error Code	0x00000000

  </div> <div id=details-right>

  Requested URL	http://localhost:80/phpmyadmin/index.php
  Physical Path	C:\inetpub\wwwroot\phpMyAdmin\index.php
  Logon Method	Anonymous
  Logon User	Anonymous

  <div class=clear></div></div>

  </div> <div class=content-container>

  Most likely causes:

  • IIS received the request; however, an internal error occurred during the processing of the request. The root cause of this error depends on which module handles the request and what was happening in the worker process when this error occurred.
  • IIS was not able to access the web.config file for the Web site or application. This can occur if the NTFS permissions are set incorrectly.
  • IIS was not able to process configuration for the Web site or application.
  • The authenticated user does not have permission to use this DLL.
  • The request is mapped to a managed handler but the .NET Extensibility Feature is not installed.

  </div> <div class=content-container>

  Things you can try:

  • Ensure that the NTFS permissions for the web.config file are correct and allow access to the Web server's machine account.
  • Check the event logs to see if any additional information was logged.
  • Verify the permissions for the DLL.
  • Install the .NET Extensibility feature if the request is mapped to a managed handler.
  • Create a tracing rule to track failed requests for this HTTP status code. For more information about creating a tracing rule for failed requests, click here.

  </div> <div class=content-container>

  Links and More Information

  This error means that there was a problem while processing the request. The request was received by the Web server, but during processing a fatal error occurred, causing the 500 error.

  View more information »

  Microsoft Knowledge Base Articles:

  • 294807

  </div></div>

  I've been searching the forums for a couple hours now and haven't found anything that will solve this.  Can someone help?

  Thanks,
  David

  FastCGI phpMyadmin 5.3.0 HTTP Error 500 Windows Server 2008 R2 IIS 7.5

• • Reply
  

  don.raman

  1207 Posts

  Microsoft

  Moderator

  Re: Can't get phpMyAdmin to work on Server 2008 R2

  Nov 02, 2009 10:06 PM|LINK

  Hi,

  I used below configuration:

  • <div mce_keep="true">MYSQL 5.1.39 (community version and Essential)</div>
  • <div mce_keep="true">phpMyAdmin 3.2.3</div>
  • <div mce_keep="true">PHP 5.2.11</div>
  • <div mce_keep="true">Windows 2k8 R2</div>

  I was able to install phpMyAdmin properly and the site is running well. I can login with my MySQL credentials and can manage all the database. I also tried with PHP 5.3 and it worked with that too.

  I am not sure why you are getting into this. Can you tell more please.

  Thanks,

  Don.

• • Reply
  

  don.raman

  1207 Posts

  Microsoft

  Moderator

  Re: Can't get phpMyAdmin to work on Server 2008 R2

  Nov 02, 2009 10:08 PM|LINK

  BTW, I tried exactly similar configuration with PHP 5.2.11 on Vista SP2 too. And it works there too.

  Thanks,

  Don.

• • Reply
  

  DavidRPotter

  11 Posts

  Re: Can't get phpMyAdmin to work on Server 2008 R2

  Nov 06, 2009 12:59 AM|LINK

  This problem turned out to be that I had not enabled TCP networking on MySQL as a security measure.  I uninstalled and reinstalled everything, this time enabling networking and it worked.

  Thanks for the help.
  David

• • Reply
  

  wang2013

  9 Posts

  Re: Can't get phpMyAdmin to work on Server 2008 R2

  Dec 31, 2009 04:08 AM|LINK

  I am having the same problem. tell me the detail on how you enable TCP networking on MySQL as a security measure.  thanks

• • Reply
  

  don.raman

  1207 Posts

  Microsoft

  Moderator

  Re: Can't get phpMyAdmin to work on Server 2008 R2

  Dec 31, 2009 06:10 PM|LINK

  Hi,

  Please ensure that at the time of installing MySQL you have checked 'Enable TCP/IP Networking' and port number set to 3306. But before you do a reinstallation please ensure below things:

  • <div mce_keep="true">Your PHP installation is correct and a simple PHPINFO page is displayed properly.</div>
  • <div mce_keep="true">Are you able to login to MySQL using MySQL command line utility by giving root password?</div>

  There is lot of material on the Web which will tell you step by step instruction to install MySQL on Windows. I have found http://www.ricocheting.com/server/mysql.html useful.

  Thanks,

  Don.

• • Reply
  

  wang2013

  9 Posts

  Re: Can't get phpMyAdmin to work on Server 2008 R2

  Jan 02, 2010 01:20 AM|LINK

  I am running Windows Web Server 2008 at my home.  the URL: http://project.dyndns.ws/phpinfo.php

  I checked Php and MySQL. they both are working fine. I am not sure why I can not open phpMyAdmin after log on (http://project.dyndns.ws/phpmyAdmin/ )

  If you have any ideas, please let me know.  thanks.

  • Edited by wang2013 on Jan 02, 2010 01:42 AM
• • Reply
  

  don.raman

  1207 Posts

  Microsoft

  Moderator

  Re: Can't get phpMyAdmin to work on Server 2008 R2

  Jan 02, 2010 01:29 AM|LINK

  Hi,

  Please do not give username/password in the forum, it can be bad. What error message you are getting when you are trying to login?

  Thanks,

  Don.

• • Reply
  

  wang2013

  9 Posts

  Re: Can't get phpMyAdmin to work on Server 2008 R2

  Jan 02, 2010 01:47 AM|LINK

  Thanks for the quick response.  I got the error message on my computer client below

   

  500 - Internal server error.

  There is a problem with the resource you are looking for, and it cannot be displayed.

   

   I checked my server and ran a test. I got the error message with more details below

  HTTP Error 500.0 - Internal Server ErrorThe page cannot be displayed because an internal server error has occurred.Detailed Error Information

  Module	FastCgiModule
  Notification	ExecuteRequestHandler
  Handler	PHP_via_FastCGI
  Error Code	0x00000000

   

  Requested URL	http://localhost:80/phpmyadmin/index.php
  Physical Path	C:\inetpub\wwwroot\phpMyAdmin\index.php
  Logon Method	Anonymous
  Logon User	Anonymous

• • Reply
  

  don.raman

  1207 Posts

  Microsoft

  Moderator

  Re: Can't get phpMyAdmin to work on Server 2008 R2

  Jan 02, 2010 02:02 AM|LINK

  So you are not even getting the login page. Right?

  Thanks,

  Don.