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 helped 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'] = '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,
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact
[EMAIL PROTECTED]
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] with
a subject of "unsubscribe". Trouble? Contact
[EMAIL PROTECTED]
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a
subject of "unsubscribe". Trouble? Contact
[EMAIL PROTECTED]
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a
subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
