phpmyadmin
Hi All,
I am having a problem with phpmyadmin that is just driving me nuts.
(I've spent hours troubleshooting and Googling this and just cannot come
up with a solution. I don't know if this problem is misconfiguration or
a bug so I didn't want to turn in a bug report.)
All phpmyadmin will serve is blank pages. (looking at page source in a
browser shows there is nothing being sent from Apache. The page source
is blank.) There are no related errors in the apache2 logs and I have
logging set to "debug" in /etc/apache2/apache2.conf. In fact, calling
http://server_name/phpmyadmin results in a 200 message in the access log.
Here is the output from apache2 -M:
Loaded Modules:
core_module (static)
log_config_module (static)
logio_module (static)
mpm_prefork_module (static)
http_module (static)
so_module (static)
alias_module (shared)
auth_basic_module (shared)
authn_file_module (shared)
authz_default_module (shared)
authz_groupfile_module (shared)
authz_host_module (shared)
authz_user_module (shared)
autoindex_module (shared)
cgi_module (shared)
dir_module (shared)
env_module (shared)
mime_module (shared)
python_module (shared)
negotiation_module (shared)
php5_module (shared)
setenvif_module (shared)
status_module (shared)
Syntax OK
Here is what /var/log/apache2/access.log shows to a call to the url
http://server_name/phpmyadmin/: 127.0.0.1- - [18/Aug/2007:09:23:53
-0700] "GET /phpmyadmin/ HTTP/1.1" 200 - "-" "Mozilla/5.0 (X$en-US;$
Well, it line-wrapped and the end of the line is cut off from copying
and pasting out of nano, but you can see what I mean. All calls to
phpmyadmin have the same entry in the access log. I can call
/phpmyadmin/scripts/setup.php and I get exactly the same entry in the
logs and a blank page. In fact, I've called pretty much all the php
files in /usr/share/phpmyadmin and I get exactly the same response. I
have also enabled all levels of php error logging in php.ini and can
find no errors there either.
However, if I manually call for
http://server_name/phpmyadmin/Documentation.html (which is found in
/usr/share/phpmyadmin/ along will the rest of the phpmyadmin files it
will serve it up.
Starting up wireshark and sniffing packets on the client I see the
client send the GET command for the appropriate page, I see the server
acknowledge it with a 200 message, but nothing is ever sent from the
server in response to calling any of the php files in phpmyadmin.
Permissions in /usr/share/phpmyadmin are world readable and all
subdirectories are world browsable. User and group are both root.
When connecting via a browser I am asked for a user name and password
and they are accepted. I also found a php script on the net that would
connect directly to mysql-server from a browser page and it worked
fine. I was able to successfully connect to mysql. I am running mysql
5 and have a sample database installed and can successfully query it
from a bash prompt.
I am running sid and it is up-to-date as of last night. So I am current
with all packages.
Here is the output of dpkg -l | grep apache2, php5, and mysql:
ii apache2 2.2.4-3 Next generation,
scalable, ext$
ii apache2-mpm-prefork 2.2.4-3 Traditional model
for Apache H$
ii apache2-utils 2.2.4-3 utility programs
for webservers
ii apache2.2-common 2.2.4-3 Next generation,
scalable, ext$
ii libapache2-mod-auth-mysql 4.3.9-4 Apache 2 module for
MySQL auth$
ii libapache2-mod-auth-pgsql 2.0.3-4+b1 Module for Apache2
which provi$
ii libapache2-mod-perl2 2.0.2-2.4 Integration of perl
with the A$
ii libapache2-mod-php5 5.2.3-1+b1 server-side,
HTML-embedded scr$
ii libapache2-mod-python 3.3.1-2 Apache 2 module
that embeds Py$
ii libapache2-mod-python-doc 3.3.1-1 Apache 2 module
that embeds Py$
ii libapache2-mod-php5 5.2.3-1+b1 server-side,
HTML-embedded scr$
ii php5 5.2.3-1 server-side,
HTML-embedded scr$
ii php5-cgi 5.2.3-1+b1 server-side,
HTML-embedded scr$
ii php5-common 5.2.3-1+b1 Common files for
packages buil$
ii php5-gd 5.2.3-1+b1 GD module for php5
ii php5-mcrypt 5.2.3-1+b1 MCrypt module for php5
ii php5-mysql 5.2.3-1+b1 MySQL module for php5
ii php5-pgsql 5.2.3-1+b1 PostgreSQL module
for php5
ii libapache2-mod-auth-mysql 4.3.9-4 Apache 2 module for
MySQL auth$
ii libdbd-mysql-perl 4.005-1 A Perl5 database
interface to $
ii libmysqlclient15off 5.0.45-1 MySQL database
client library
ii mysql-client-5.0 5.0.45-1 MySQL database
client binaries
ii mysql-common 5.0.45-1 MySQL database
common files
ii mysql-server-5.0 5.0.45-1 MySQL database
server binaries
ii php5-mysql 5.2.3-1+b1 MySQL module for php5
ii python-mysqldb 1.2.2-3 A Python interface
to MySQL
Here is a copy of my /etc/phpmyadmin/config.inc.php file. The only
changes I have made to it are to add the following two lines and a
closing php tag as there was none to begin with:
$cfg['Servers'][$i]['user'] = 'myusername';
$cfg['Servers'][$i]['password'] = 'mypassword';
<?php
* * Debian local configuration file
*
* This file overrides the settings made by phpMyAdmin interactive setup
* utility.
*
* For example configuration
see /usr/share/doc/phpmyadmin/examples/config.default.php.gz
*
* NOTE: do not add security sensitive data to this file (like
passwords)
* unless you really know what you're doing. If you do, any user that
can
* run PHP or CGI on your webserver will be able to read them. If you
still
* want to do this, make sure to properly secure the access to this file
* (also on the filesystem level).
*/
/**
* Server(s) configuration
*/
$i = 0;
// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use
$cfg['Servers'][0].
// You can disable a server config entry by setting host to ''.
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
//$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';
/* Optional: User for advanced features */
// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';
/* Optional: Advanced phpMyAdmin features */
// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
// $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
// $cfg['Servers'][$i]['relation'] = 'pma_relation';
// $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
// $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
// $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
// $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
// $cfg['Servers'][$i]['history'] = 'pma_history';
// $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['user'] = 'myusername';
$cfg['Servers'][$i]['password'] = 'mypassword';
/*
* End of servers configuration
*/
/*
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
Do I have something configured wrong, or am I running into a bug? Oh,
and I am using the /etc/phpmyadmin/apache.conf file just as it was
installed. Any help you could provide would be greatly appreciated.
Thanks in advance for your help,
Reply to: