Problem Description:
Just installed PMA, access in Firefox, will see the whiteboard, nothing output. 500 Errors (Server internal error) can be seen with IE
After opening an error, I found
Warning:require_once (./libraries/common.inc.php) [Function.require-once]: failed to open stream:no such file or Directo Ry in ***\mousebomb\pma\index.php on line 35
Fatal error:require_once () [function.require]: Failed opening required './libraries/common.inc.php ' (include_path= '); C:\php5\pear ') in ***\mousebomb\pma\index.php on line 35
The file is actually present and IUSR (IIS anonymous Access user) has permission.
Solution:
Whiteboard Resolution: Modify the php.ini in the relevant error output settings, the default php.ini only need to change the Display_error=off to Display_error=on can be
Require error resolution: require all./Start relative path files, you must turn the IUSR of the parent directory on the readable permission. Not only configure the PMA, no matter what website, under the WIMP should pay attention to./The file to be accessed must be readable by the parent directory .
Related literature:
Sometimes when the phpMyAdmin is installed, the following situation will appear in IE when accessed:
Warning:require_once (./libraries/common.lib.php): Failed to open stream:no such file or directory in ***\index.php on Li NE 40
Fatal Error:main (): Failed opening required './libraries/common.lib.php ' (include_path= '.; C:\php5\pear ') in ***\index.php on line 40
There are several reasons why this problem occurs:
1. Your phpMyAdmin directory is placed in the root directory of the disk
2, your phpMyAdmin directory and the upper directory of the permissions set issues
Workaround:
• Do not place the phpMyAdmin directory in the root directory of the disk, as in D:\SiteManage\phpmyadmin
• Set the permissions for the phpMyAdmin directory and the upper directory as follows:
Users Read and run
IUSR_ ... Read and run
Another workaround:
-----------------
Have a strange problem. After installing phpMyAdmin, the following error is reported:
Warning:require_once (./libraries/common.lib.php) [Function.require-once]: failed to open stream:no such file or Directo Ry in X:\Xxxxx\phpmyadmin\index.php on line 36
Fatal error:require_once () [function.require]: Failed opening required './libraries/common.lib.php ' (include_path= '); C:\php5\pear ') in X:\Xxxxx\phpmyadmin\index.php on line 36
The MySQL database into the newly installed Mysql5.2, open the blog home, but still reported similar errors.
After a while debugging finally found the solution:
Original phpMyAdmin and PHP installation directory of the superior ACLs permission is not enough, ah!
To phpmyadmin,php, and their previous level of directory the same ACLs user read rights, and then open the blog, successful! ^_^
Precautions and security Risks:
1, do not install phpMyAdmin in the site or virtual host root directory, because the guest user will have the root directory permissions.
2. Give phpmyadmin to the IIS process running user and IIS anonymous user Read permission. We strongly recommend that you do not include everyone in the ACLs permissions list.
3, everyone in the debugging program or configuration script environment, please try to look at faq! and then from the error code to find the reason ... (for example, the above-mentioned wrong language, you open the 36th line of index.php, see what the PHP code executes the command is clear the reason for the error)
Note tips:
1, do not install phpMyAdmin decompression in the root directory, because so that the guest user will have the root directory permissions.
2, give phpmyadmin to give IIS user rights, user group users permissions can. It is not recommended to add the Everyone permission.
---------
The above two methods of thinking, we can try