PHP not loading any mysql code

Question

I recently moved from one dedicated to the next. I'm using the same repos for my apache, mysql, and php installations. However, when attempting to load a known-good file, php is unable to handle the request.

It is very basic mysql queries, just loads a blank white page.

As well, when trying to install WordPress, using the correct information, the webserver is unable to connect to the intended remote installation database.

php-mysql and -mysqli have been installed.

Using CentOS 6.2, Apache 2.2.15, PHP 5.3.10, and Zend 2.3.0.

Edit1:

I want to add that if I call the file from terminal, using "php file.php" - it performs as expected. Its just when apache gets involved that there is a problem. Otherwise, this is the error in /var/log/httpd pastie.org/3814963 To note, it's not being told to use root. Neither is it being told to use localhost. pastie.org/3814965

Edit2: php is not set in safe mode.

service mysqld start | service httpd restart. Beyond that, you've got Zend, and you've got your Web error logs. You should be able to glean way more information than we can from the outside. — John Green
– John Green, Commented Apr 19, 2012 at 5:24
firstly add error_reporting(E_ALL) to your script, that will spit out an error and not just a blank page, plus check the servers listening on the correct ports with shell $# sudo netstat --tcp --listening --programs — Lawrence Cherone
– Lawrence Cherone, Commented Apr 19, 2012 at 5:36
I want to add that if I call the file from terminal, using "php file.php" - it performs as expected. Its just when apache gets involved that there is a problem. Otherwise, this is the error in /var/log/httpd pastie.org/3814963 To note, it's not being told to use root. Neither is it being told to use localhost. pastie.org/3814965 — Asphodan
– Asphodan, Commented Apr 19, 2012 at 6:03

Wayne · Accepted Answer · 2012-04-19 06:36:28Z

1

My guess from your looking at your code, the error message, and the documentation for mysql_connect that your server has safe_mode enabled.

http://php.net/manual/en/function.mysql-connect.php

The relevant part:

server

The MySQL server. It can also include a port number. e.g. "hostname:port" or a path to a local socket e.g. ":/path/to/socket" for the localhost. If the PHP directive mysql.default_host is undefined (default), then the default value is 'localhost:3306'. In SQL safe mode, this parameter is ignored and value 'localhost:3306' is always used.

username

The username. Default value is defined by mysql.default_user. In SQL safe mode, this parameter is ignored and the name of the user that owns the server process is used. password

password

The password. Default value is defined by mysql.default_password. In SQL safe mode, this parameter is ignored and empty password is used.

Edit your PHP.INI file and set safe_mode to off.

answered Apr 19, 2012 at 6:36

Wayne

111 bronze badge

Sign up to request clarification or add additional context in comments.

3 Comments

Asphodan Over a year ago

safe_mode = Off safe_mode_gid = Off safe_mode_include_dir = safe_mode_exec_dir = safe_mode_allowed_env_vars = PHP_ safe_mode_protected_env_vars = LD_LIBRARY_PATH ;open_basedir = disable_functions = disable_classes =

Wayne Over a year ago

Run a phpinfo() and check the status of safe mode in there. Safe mode is the only thing that makes sense; the results you're getting exactly fit that situation. It will ignore the parameters and connect to localhost with root as the username and no password in that situation. Exactly as you are seeing here.

Wayne Over a year ago

Checking the php.ini file is not sufficient to ensure safe_mode isd disabled. It could be enabled in the Apache configuration or even in an .htaccess file.

Collectives™ on Stack Overflow

PHP not loading any mysql code

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related