HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Server Operation (http://www.howtoforge.com/forums/forumdisplay.php?f=5)
-   -   phpmyadmin is 404 file not found (http://www.howtoforge.com/forums/showthread.php?t=51780)

CSU-Bill 8th March 2011 03:29

phpmyadmin is 404 file not found
 
I hope I have not posted this in the wrong location.

While following your instructions at http://www.howtoforge.com/installing...ntu-10.10-lamp I had a learning curve. Thank you for providing a good set of instructions.

I have played with Linux (Ubuntu) for a very short time. I need a server, so decided to build one. I first loaded the latest Ubuntu (10.10) and then searched for instructions. I tried several and ended up reloading Ubuntu a few times (I have since learned how to un-install things). I found your instructions and loaded MySQL (have not checked it yet), Apache2 (It Works!), PHP5 (Vi was another learning experience, but info.php works). Then I tried to install PHPMyAdmin.

First, I made a mistake and said yes to using dbconfig-common for setting up the database. That got me into a loop asking for a password. This is where I learned "apt-get --purge remove phpmyadmin" and again started the phpmyadmin install. This last one appeared to work, but there are no files in the www folder other than info.php and index.html.

What should I do now? Should I get the phpmyadmin page from my windows machine (and any supporting php include files)? Should I try another install of phpmyadmin? Is there a file folder I can check to see if the files installed?

falko 8th March 2011 18:20

Can you post the outputs of
Code:

ls -la /etc/apache2/conf.d/
and
Code:

ls -la /etc/phpmyadmin/
?

CSU-Bill 9th March 2011 00:06

The result of ls -la /etc/apache2/conf.d/
is:
drwxr-xr-x 2 root root 4096 2011-03-06 21:52 .
drwxr-xr-x 7 root root 4096 2011-03-06 16:51 ..
-rw-r--r-- 1 root root 269 2010-11-18 16:16 charset
lrwxrwxrwx 1 root root 45 2011-03-06 21:52 javascript-common.conf -> /etc/javascript-common/javascript-common.conf
-rw-r--r-- 1 root root 3296 2010-11-18 16:16 localized-error-pages
-rw-r--r-- 1 root root 143 2010-11-18 16:16 other-vhosts-access-log
-rw-r--r-- 1 root root 1481 2010-11-18 16:16 security

The output of ls -la /etc/phpmyadmin/
is:
drwxr-xr-x 2 root root 4096 2011-03-06 21:52 .
drwxr-xr-x 142 root root 12288 2011-03-08 17:45 ..
-rw-r--r-- 1 root root 871 2011-02-15 14:04 apache.conf
-rw-r----- 1 root www-data 517 2011-03-06 21:52 config-db.php
-rw-r--r-- 1 root root 168 2011-02-15 14:04 config.footer.inc.php
-rw-r--r-- 1 root root 168 2011-02-15 14:04 config.header.inc.php
-rw-r--r-- 1 root root 3918 2011-02-15 14:04 config.inc.php
-rw-r----- 1 root www-data 8 2011-03-06 21:52 htpasswd.setup
-rw-r--r-- 1 root root 570 2011-02-15 14:04 lighttpd.conf
-rw-r--r-- 1 root root 295 2011-02-15 14:04 phpmyadmin.service

Hope that provides what you asked for.

Bill

falko 9th March 2011 17:12

Please try this:

Code:

ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf.d/phpmyadmin.conf
/etc/init.d/apache2 restart


CSU-Bill 10th March 2011 03:24

Falko,

Thanks. I know I am getting closer to having things operational. Once I remembered to sudo su, I managed to get to the PHPMyAdmin login.

When I tried to login, I received this: #1045 Cannot log in to the MySQL server

What do I need to do now?

Is there a phpmyadmin config file that I need to edit?

Do I need to do something to MySQL?

Getting closer one-step-at-a-time. :)

falko 10th March 2011 17:06

What's the output of
Code:

netstat -tap
?

CSU-Bill 11th March 2011 00:04

This is the results:

Code:

Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address          Foreign Address        State      PID/Program name
tcp        0      0 localhost.localdo:mysql *:*                    LISTEN      1129/mysqld   
tcp        0      0 localhost.localdoma:ipp *:*                    LISTEN      1064/cupsd     
tcp        0      0 server01:46824          yw-in-f164.1e100.ne:www ESTABLISHED 1655/firefox-bin
tcp        0      0 server01:50216          yw-in-f139.1e100.ne:www ESTABLISHED 1655/firefox-bin
tcp        0      0 server01:55917          74.125.229.28:www      ESTABLISHED 1655/firefox-bin
tcp        0      0 server01:53277          74.125.229.8:https      TIME_WAIT  -             
tcp        0      0 server01:36499          74.125.229.27:www      ESTABLISHED 1655/firefox-bin
tcp        0      0 server01:43008          a96-6-45-58.deploy.:www ESTABLISHED 1655/firefox-bin
tcp        0    28 server01:59142          gx-in-f103.1e100.:https FIN_WAIT1  -             
tcp        0      0 server01:49306          yi-in-f139.1e100.ne:www ESTABLISHED 1655/firefox-bin
tcp        0      0 server01:60233          yw-in-f113.1e100.ne:www ESTABLISHED 1655/firefox-bin
tcp        0      0 server01:59136          gx-in-f103.1e100.:https TIME_WAIT  -             
tcp        0      0 server01:60993          gw-in-f139.1e100.ne:www TIME_WAIT  -             
tcp        0      0 server01:36296          74.125.229.29:https    TIME_WAIT  -             
tcp        0      0 server01:40484          yx-in-f164.1e100.:https TIME_WAIT  -             
tcp        0    28 server01:40974          gw-in-f120.1e100.:https FIN_WAIT1  -             
tcp        0      0 server01:34512          yu-in-f155.1e100.ne:www ESTABLISHED 1655/firefox-bin
tcp        0      0 server01:59521          gx-in-f103.1e100.ne:www TIME_WAIT  -             
tcp        0      0 server01:59818          yx-in-f83.1e100.n:https ESTABLISHED 1655/firefox-bin
tcp        0      0 server01:34522          yu-in-f155.1e100.ne:www ESTABLISHED 1655/firefox-bin
tcp        0    28 server01:38296          yw-in-f97.1e100.n:https FIN_WAIT1  -             
tcp        0      0 server01:43004          a96-6-45-58.deploy.:www ESTABLISHED 1655/firefox-bin
tcp        0      0 server01:54113          gx-in-f105.1e100.ne:www TIME_WAIT  -             
tcp        0      0 server01:54111          gx-in-f105.1e100.ne:www ESTABLISHED 1655/firefox-bin
tcp        0    28 server01:59076          74.125.229.0:https      FIN_WAIT1  -             
tcp        0      0 server01:59161          gw-in-f18.1e100.n:https ESTABLISHED 1655/firefox-bin
tcp6      0      0 [::]:www                [::]:*                  LISTEN      1145/apache2   
tcp6      0      0 server01:ipp            [::]:*                  LISTEN      1064/cupsd


falko 11th March 2011 15:57

Please open /etc/mysql/my.cnf and make MySQL listen on all interfaces (comment out bind-address = 127.0.0.1). Then restart MySQL.

CSU-Bill 12th March 2011 02:11

I have modified my.cnf to have

# bind-address = 127.0.0.1

I still get the "#1045 Cannot log in to the MySQL server" error when I try to log in to phpmyadmin.

Just in case, here is the netstat -tap results:

Code:

Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address          Foreign Address        State      PID/Program name
tcp        0      0 *:mysql                *:*                    LISTEN      1103/mysqld   
tcp        0      0 localhost.localdoma:ipp *:*                    LISTEN      993/cupsd     
tcp        0      0 server01:60122          gx-in-f17.1e100.n:https ESTABLISHED 1621/firefox-bin
tcp        0  1189 server01:50566          gw-in-f104.1e100.ne:www ESTABLISHED 1621/firefox-bin
tcp        0      0 server01:34700          gw-in-f83.1e100.n:https ESTABLISHED 1621/firefox-bin
tcp        0      0 server01:60123          gx-in-f17.1e100.n:https ESTABLISHED 1621/firefox-bin
tcp        0    971 server01:51605          a96-17-147-25.deplo:www ESTABLISHED 1621/firefox-bin
tcp6      0      0 [::]:www                [::]:*                  LISTEN      1138/apache2   
tcp6      0      0 server01:ipp            [::]:*                  LISTEN      993/cupsd


falko 12th March 2011 19:09

Do you use the correct MySQL user/password to log in?


All times are GMT +2. The time now is 15:33.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.