Re: How do I get phpmyadmin working?



Thanks for your help on this Adam. It is indeed something of an arse to set up. No doubt it is something really simple (it usually is) but I really can't see what.

My browsers refuse to read any php file at all so I am guessing that Apache2 is not set up correctly.

To answer your questions:

What do the Apache {access,error}logs show?
Error.log
[Tue May 15 21:42:03 2007] [notice] Apache/2.0.55 (Ubuntu) configured -- resuming normal operations
[Tue May 15 21:42:04 2007] [notice] caught SIGTERM, shutting down
[Tue May 15 21:42:05 2007] [notice] Apache/2.0.55 (Ubuntu) PHP/5.1.6 configured -- resuming normal operations
[Tue May 15 21:44:42 2007] [error] [client 127.0.0.1] File does not exist: /var/www/favicon.ico, referer: http://127.0.0.1/
[Tue May 15 21:48:32 2007] [error] [client 127.0.0.1] File does not exist: /var/www/favicon.ico
[Tue May 15 21:54:40 2007] [error] [client 127.0.0.1] File does not exist: /var/www/favicon.ico, referer: http://127.0.0.1/phpmyadmin/
[Tue May 15 22:04:17 2007] [notice] caught SIGTERM, shutting down
[Tue May 15 22:04:18 2007] [notice] Apache/2.0.55 (Ubuntu) PHP/5.1.6 configured -- resuming normal operations
[Tue May 15 22:12:05 2007] [notice] caught SIGTERM, shutting down
[Tue May 15 22:12:18 2007] [notice] Apache/2.0.55 (Ubuntu) PHP/5.1.6 configured -- resuming normal operations
[Tue May 15 22:13:50 2007] [error] [client 127.0.0.1] File does not exist: /var/www/favicon.ico
[Tue May 15 22:34:40 2007] [notice] caught SIGTERM, shutting down
[Wed May 16 22:37:11 2007] [notice] Apache/2.0.55 (Ubuntu) PHP/5.1.6 configured -- resuming normal operations
[Wed May 16 22:38:01 2007] [error] [client 127.0.0.1] File does not exist: /var/www/favicon.ico, referer: http://127.0.0.1/phpmyadmin/main
[Wed May 16 23:06:40 2007] [notice] caught SIGTERM, shutting down
[Thu May 17 20:35:56 2007] [notice] Apache/2.0.55 (Ubuntu) PHP/5.1.6 configured -- resuming normal operations

Seems to be looking for a missing ico file favicon.ico. I created one and put it in /var/www but no joy

Access.log

127.0.0.1 - - [15/May/2007:21:44:42 +0100] "GET / HTTP/1.1" 200 685 "-" "Opera/9.20 (X11; Linux i686; U; en)"
127.0.0.1 - - [15/May/2007:21:44:42 +0100] "GET /icons/blank.gif HTTP/1.1" 200 148 "http://127.0.0.1/"; "Opera/9.20 (X11; Linux i686; U; en)"
127.0.0.1 - - [15/May/2007:21:44:42 +0100] "GET /favicon.ico HTTP/1.1" 404 294 "http://127.0.0.1/"; "Opera/9.20 (X11; Linux i686; U; en)"
127.0.0.1 - - [15/May/2007:21:44:42 +0100] "GET /icons/folder.gif HTTP/1.1" 200 225 "http://127.0.0.1/"; "Opera/9.20 (X11; Linux i686; U; en)"
127.0.0.1 - - [15/May/2007:21:44:46 +0100] "GET /phpmyadmin/ HTTP/1.1" 200 - "http://127.0.0.1/"; "Opera/9.20 (X11; Linux i686; U; en)"
127.0.0.1 - - [15/May/2007:21:44:46 +0100] "GET /phpmyadmin/ HTTP/1.1" 200 - "http://127.0.0.1/"; "Opera/9.20 (X11; Linux i686; U; en)"
127.0.0.1 - - [15/May/2007:21:44:56 +0100] "GET /phpmyadmin/main HTTP/1.1" 200 - "-" "Opera/9.20 (X11; Linux i686; U; en)"
127.0.0.1 - - [15/May/2007:21:45:02 +0100] "GET /phpmyadmin/main.php HTTP/1.1" 200 - "-" "Opera/9.20 (X11; Linux i686; U; en)"
127.0.0.1 - - [15/May/2007:21:48:32 +0100] "GET /phpmyadmin HTTP/1.1" 301 321 "-" "Mozilla/5.0 (X11; U; Linux i686; en-GB; rv:1.8.1.3) Gecko/20060601 Firefox/2.0.0.3 (Ubuntu-edgy)"
127.0.0.1 - - [15/May/2007:21:48:32 +0100] "GET /phpmyadmin/ HTTP/1.1" 200 - "-" "Mozilla/5.0 (X11; U; Linux i686; en-GB; rv:1.8.1.3) Gecko/20060601 Firefox/2.0.0.3 (Ubuntu-edgy)"
127.0.0.1 - - [15/May/2007:21:48:32 +0100] "GET /favicon.ico HTTP/1.1" 404 294 "-" "Mozilla/5.0 (X11; U; Linux i686; en-GB; rv:1.8.1.3) Gecko/20060601 Firefox/2.0.0.3 (Ubuntu-edgy)"
127.0.0.1 - - [15/May/2007:21:48:56 +0100] "GET /phpmyadmin/ HTTP/1.1" 200 70 "-" "Mozilla/5.0 (X11; U; Linux i686; en-GB; rv:1.8.1.3) Gecko/20060601 Firefox/2.0.0.3 (Ubuntu-edgy)"
127.0.0.1 - - [15/May/2007:21:49:14 +0100] "GET /phpmyadmin/ HTTP/1.1" 200 70 "-" "Mozilla/5.0 (X11; U; Linux i686; en-GB; rv:1.8.1.3) Gecko/20060601 Firefox/2.0.0.3 (Ubuntu-edgy)"
127.0.0.1 - - [15/May/2007:21:49:24 +0100] "GET /phpmyadmin/ HTTP/1.1" 200 70 "-" "Mozilla/5.0 (X11; U; Linux i686; en-GB; rv:1.8.1.3) Gecko/20060601 Firefox/2.0.0.3 (Ubuntu-edgy)"
127.0.0.1 - - [15/May/2007:21:50:09 +0100] "GET /phpmyadmin/ HTTP/1.1" 200 - "-" "Mozilla/5.0 (X11; U; Linux i686; en-GB; rv:1.8.1.3) Gecko/20060601 Firefox/2.0.0.3 (Ubuntu-edgy)"
127.0.0.1 - - [15/May/2007:21:50:12 +0100] "GET /phpmyadmin/ HTTP/1.1" 200 - "-" "Mozilla/5.0 (X11; U; Linux i686; en-GB; rv:1.8.1.3) Gecko/20060601 Firefox/2.0.0.3 (Ubuntu-edgy)"
127.0.0.1 - - [15/May/2007:21:54:40 +0100] "GET /phpmyadmin/ HTTP/1.1" 200 - "-" "Opera/9.20 (X11; Linux i686; U; en)"
127.0.0.1 - - [15/May/2007:21:54:40 +0100] "GET /favicon.ico HTTP/1.1" 404 294 "http://127.0.0.1/phpmyadmin/"; "Opera/9.20 (X11; Linux i686; U; en)"
127.0.0.1 - - [15/May/2007:21:54:47 +0100] "GET /phpmyadmin/main.php HTTP/1.1" 200 - "-" "Opera/9.20 (X11; Linux i686; U; en)"
127.0.0.1 - - [15/May/2007:21:54:59 +0100] "GET /phpmyadmin/main HTTP/1.1" 200 - "-" "Opera/9.20 (X11; Linux i686; U; en)"
127.0.0.1 - - [15/May/2007:21:56:01 +0100] "GET /phpmyadmin/main HTTP/1.1" 200 70 "-" "Opera/9.20 (X11; Linux i686; U; en)"
127.0.0.1 - - [15/May/2007:21:56:26 +0100] "GET /phpmyadmin/main HTTP/1.1" 200 - "-" "Opera/9.20 (X11; Linux i686; U; en)"
127.0.0.1 - - [15/May/2007:22:13:49 +0100] "GET /phpmyadmin HTTP/1.1" 301 321 "http://ubuntuforums.org/showthread.php?t=181121&highlight=How+do+I+get+phpmyadmin+working%3F"; "Mozilla/5.0 (X11; U; Linux i686; en-GB; rv:1.8.1.3) Gecko/20060601 Firefox/2.0.0.3 (Ubuntu-edgy)"
127.0.0.1 - - [15/May/2007:22:13:49 +0100] "GET /phpmyadmin/ HTTP/1.1" 200 - "http://ubuntuforums.org/showthread.php?t=181121&highlight=How+do+I+get+phpmyadmin+working%3F"; "Mozilla/5.0 (X11; U; Linux i686; en-GB; rv:1.8.1.3) Gecko/20060601 Firefox/2.0.0.3 (Ubuntu-edgy)"
127.0.0.1 - - [15/May/2007:22:13:50 +0100] "GET /favicon.ico HTTP/1.1" 404 294 "-" "Mozilla/5.0 (X11; U; Linux i686; en-GB; rv:1.8.1.3) Gecko/20060601 Firefox/2.0.0.3 (Ubuntu-edgy)"
127.0.0.1 - - [15/May/2007:22:21:13 +0100] "GET /phpmyadmin/ HTTP/1.1" 200 - "-" "Mozilla/5.0 (X11; U; Linux i686; en-GB; rv:1.8.1.3) Gecko/20060601 Firefox/2.0.0.3 (Ubuntu-edgy)"
127.0.0.1 - - [16/May/2007:22:38:00 +0100] "GET /phpmyadmin/main HTTP/1.1" 200 - "-" "Opera/9.20 (X11; Linux i686; U; en)"
127.0.0.1 - - [16/May/2007:22:38:01 +0100] "GET /favicon.ico HTTP/1.1" 404 294 "http://127.0.0.1/phpmyadmin/main"; "Opera/9.20 (X11; Linux i686; U; en)"



Have you configured (prolly through /etc/phpmyadmin/)
phpmyadmin
properly?

From what I can work out since everything is on localhost I just need the default configuration

Have you got the mysql extension set-up in php? (try
the bog-standard
<?php phpinfo() ?> approach, if you're unsure) ---
it's an
uncomment in the modules config (usually php.ini)

extension=mysql.so is uncommented. My browser will not read php files at all. It tries to open or download them.

In case it helps:

Have you configured (prolly through /etc/phpmyadmin/)
phpmyadmin
properly?

From what I can work out since everything is on localhost I just need the default configuration

Have you got the mysql extension set-up in php? (try
the bog-standard
<?php phpinfo() ?> approach, if you're unsure) ---
it's an
uncomment in the modules config (usually php.ini)

extension=mysql.so is uncommented. My browser will not read php files at all. It tries to open or download them.

In case it helps:

Have you configured (prolly through /etc/phpmyadmin/)
phpmyadmin
properly?

From what I can work out since everything is on localhost I just need the default configuration

Have you got the mysql extension set-up in php? (try
the bog-standard
<?php phpinfo() ?> approach, if you're unsure) ---
it's an
uncomment in the modules config (usually php.ini)

extension=mysql.so is uncommented. My browser will not read php files at all. It tries to open or download them.

In case it helps
contents of /var/www

drwxr-xr-x 2 root root 4096 2007-05-15 21:42 apache2-default
-rwxrwxrwx 1 root root 198 2007-05-17 21:43 favicon.ico
lrwxrwxrwx 1 root root 21 2007-05-01 22:59 phpmyadmin -> /usr/share/phpmyadmin

Cheers

John



---------------------------------
8:00? 8:25? 8:40? Find a flick in no time
with theYahoo! Search movie showtime shortcut.--
ubuntu-users mailing list
ubuntu-users@xxxxxxxxxxxxxxxx
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users