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'] = '';
/* 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 you could provide would be greatly appreciated.

Thanks in advance for your ,


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

Have you taken a look at the phpmyadmin site? I had some trouble
getting it to work on my system too and their was a rather nice
troubleshooting page there that ed me out.

On Aug 19, 2007, at 10:58 PM, Freddy Freeloader wrote:

> 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'] = '';
> /* 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 you could provide would be greatly appreciated.
>
> Thanks in advance for your ,
>
>
> --
> To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org with a
> subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
>


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

ArcticFox wrote:
> Have you taken a look at the phpmyadmin site? I had some trouble
> getting it to work on my system too and their was a rather nice
> troubleshooting page there that ed me out.
Yeah, I have. I've also read the documentation installed in
/usr/share/phpmyadmin/Documentation.html, and spent quite a while with
Google too.

I just don't really understand what is going on as the same server will
serve up other php pages, but phpmyadmin seems only able to serve html
pages.

>
> On Aug 19, 2007, at 10:58 PM, Freddy Freeloader wrote:
>
>> 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'] = '';
>> /* 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 you could provide would be greatly appreciated.
>>
>> Thanks in advance for your ,
>>
>>
>> --
>> To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org with a
>> subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
>>
>
>


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

On Aug 20, 2007, at 12:10 AM, Freddy Freeloader wrote:

> ArcticFox wrote:
>> Have you taken a look at the phpmyadmin site? I had some trouble
>> getting it to work on my system too and their was a rather nice
>> troubleshooting page there that ed me out.
> Yeah, I have. I've also read the documentation installed in
> /usr/share/phpmyadmin/Documentation.html, and spent quite a while with
> Google too.
> I just don't really understand what is going on as the same server
> will serve up other php pages, but phpmyadmin seems only able to serve
> html pages.

You didn't by any chance disable FollowSymlinks did you? In your apache
config file. The new install of Debian I have phpmyadmin worked out of
the box.

The other thing to try would be to delete the existing install and try
installing a fresh copy downloaded from their website.
>>
>> On Aug 19, 2007, at 10:58 PM, Freddy Freeloader wrote:
>>
>>> 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'] = '';
>>> /* 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 you could provide would be greatly
>>> appreciated.
>>>
>>> Thanks in advance for your ,
>>>
>>>
>>> --
>>> To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org with a
>>> subject of "unsubscribe". Trouble? Contact
>>> listmaster@lists.debian.org
>>>
>>
>>
>
>
> --
> To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org with a
> subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
>


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

ArcticFox wrote:
>
> On Aug 20, 2007, at 12:10 AM, Freddy Freeloader wrote:
>
>> ArcticFox wrote:
>>> Have you taken a look at the phpmyadmin site? I had some trouble
>>> getting it to work on my system too and their was a rather nice
>>> troubleshooting page there that ed me out.
>> Yeah, I have. I've also read the documentation installed in
>> /usr/share/phpmyadmin/Documentation.html, and spent quite a while
>> with Google too.
>> I just don't really understand what is going on as the same server
>> will serve up other php pages, but phpmyadmin seems only able to
>> serve html pages.
>
> You didn't by any chance disable FollowSymlinks did you? In your
> apache config file. The new install of Debian I have phpmyadmin worked
> out of the box.
>
> The other thing to try would be to delete the existing install and try
> installing a fresh copy downloaded from their website.
Nope, didn't disable FollowSymlinks. This was a fresh Apache and
phpmyadmin install and it has done this since I installed it. Looking
at all the config files it "should" work, but it doesn't.

>>>
>>> On Aug 19, 2007, at 10:58 PM, Freddy Freeloader wrote:
>>>
>>>> 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'] = '';
>>>> /* 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 you could provide would be greatly
>>>> appreciated.
>>>>
>>>> Thanks in advance for your ,
>>>>
>>>>
>>>> --
>>>> To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org with
>>>> a subject of "unsubscribe". Trouble? Contact
>>>> listmaster@lists.debian.org
>>>>
>>>
>>>
>>
>>
>> --
>> To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org with a
>> subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
>>
>
>


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

On Aug 20, 2007, at 8:01 AM, Freddy Freeloader wrote:

> ArcticFox wrote:
>>
>> On Aug 20, 2007, at 12:10 AM, Freddy Freeloader wrote:
>>
>>> ArcticFox wrote:
>>>> Have you taken a look at the phpmyadmin site? I had some trouble
>>>> getting it to work on my system too and their was a rather nice
>>>> troubleshooting page there that ed me out.
>>> Yeah, I have. I've also read the documentation installed in
>>> /usr/share/phpmyadmin/Documentation.html, and spent quite a while
>>> with Google too.
>>> I just don't really understand what is going on as the same server
>>> will serve up other php pages, but phpmyadmin seems only able to
>>> serve html pages.
>>
>> You didn't by any chance disable FollowSymlinks did you? In your
>> apache config file. The new install of Debian I have phpmyadmin
>> worked out of the box.
>>
>> The other thing to try would be to delete the existing install and
>> try installing a fresh copy downloaded from their website.
> Nope, didn't disable FollowSymlinks. This was a fresh Apache and
> phpmyadmin install and it has done this since I installed it. Looking
> at all the config files it "should" work, but it doesn't.

Hum. Try running the index.php file from the command line to make sure
your PHP processor is working right. If that works create a file (call
it something like test.php) and put this in it:

<?php
phpinfo();
?>

then try to access that from your web browser. You should see a huge
list of everything php knows.
>>>>
>>>> On Aug 19, 2007, at 10:58 PM, Freddy Freeloader wrote:
>>>>
>>>>> 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'] = '';
>>>>> /* 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 you could provide would be greatly
>>>>> appreciated.
>>>>>
>>>>> Thanks in advance for your ,
>>>>>
>>>>>
>>>>> --
>>>>> To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org with
>>>>> a subject of "unsubscribe". Trouble? Contact
>>>>> listmaster@lists.debian.org
>>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org with a
>>> subject of "unsubscribe". Trouble? Contact
>>> listmaster@lists.debian.org
>>>
>>
>>
>
>
> --
> To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org with a
> subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
>


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

On Aug 20, 2007, at 10:17 AM, ArcticFox wrote:

>
> On Aug 20, 2007, at 8:01 AM, Freddy Freeloader wrote:
>
>> ArcticFox wrote:
>>>
>>> On Aug 20, 2007, at 12:10 AM, Freddy Freeloader wrote:
>>>
>>>> ArcticFox wrote:
>>>>> Have you taken a look at the phpmyadmin site? I had some trouble
>>>>> getting it to work on my system too and their was a rather nice
>>>>> troubleshooting page there that ed me out.
>>>> Yeah, I have. I've also read the documentation installed in
>>>> /usr/share/phpmyadmin/Documentation.html, and spent quite a while
>>>> with Google too.
>>>> I just don't really understand what is going on as the same server
>>>> will serve up other php pages, but phpmyadmin seems only able to
>>>> serve html pages.
>>>
>>> You didn't by any chance disable FollowSymlinks did you? In your
>>> apache config file. The new install of Debian I have phpmyadmin
>>> worked out of the box.
>>>
>>> The other thing to try would be to delete the existing install and
>>> try installing a fresh copy downloaded from their website.
>> Nope, didn't disable FollowSymlinks. This was a fresh Apache and
>> phpmyadmin install and it has done this since I installed it.
>> Looking at all the config files it "should" work, but it doesn't.
>
> Hum. Try running the index.php file from the command line to make sure
> your PHP processor is working right. If that works create a file (call
> it something like test.php) and put this in it:
>
> <?php
> phpinfo();
> ?>
>
> then try to access that from your web browser. You should see a huge
> list of everything php knows.
Durh, I should have said to stick it in the phpmyadmin directory before
running it. Sorry.
>>>>>
>>>>> On Aug 19, 2007, at 10:58 PM, Freddy Freeloader wrote:
>>>>>
>>>>>> 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'] = '';
>>>>>> /* 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';
>>>>>>
>>>>>> /*