phpmyadmin - 404 not found

Discussion in 'Server Operation' started by prouxx, Jan 2, 2015.

  1. prouxx

    prouxx New Member

    Hello ladies and gents, a happy new year to you all!

    I'm running ubuntu 14.04 with ispconfig 3 which I installed using the perfect server guide (the same one everyone uses).

    I've been having a lot of issues with my server in that nothing seems to work. Yesterday I was trying to set up webmail and couldn't get emails to send and today I'm trying to access mysql DBs but when I click on the link to the database in the ispconfig panel it takes me to serverip:8080/phpmyadmin and displays 404 - not found.

    I'll be honest, I've no idea what's causing the problem aside from the fact that /etc/apache2/conf.d does not exist. So here is what I've done to try and fix things.
    Code:
    dpkg-reconfigure -plow phpmyadmin - reinstalled and reconfigured phpmyadmin
    
    ln -s /usr/share/phpmyadmin /var/www/html/phpmyadmin - worked
    
    sudo /etc/init.d/apache2 reload - works fine
    
    sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf.d/phpmyadmin.conf - ln: failed to create symbolic link ‘/etc/apache2/conf.d/phpmyadmin.conf’: No such file or directory
    
    I'm not the most experienced user and would definitely say that I've still got a lot to learn about running my server. Because of this, I don't really know what could be causing these problems or what log files to look at etc. I've spent about 3 hours last night and another hour this morning surfing forums to try and find a solution but nothing has helped. I'd really appreciate any help you lovely people can give me.

    Thanks very much :D
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

  3. prouxx

    prouxx New Member

    Thanks for the fast response. Here is the output:

    Code:
    
    ##### SERVER #####
    IP-address (as per hostname): ***.***.***.***
    IP-address(es) (as per ifconfig): ***.***.***.***
    [INFO] ISPConfig is installed.
    
    ##### ISPCONFIG #####
    ISPConfig version is 3.0.5.4p4
    
    
    ##### VERSION CHECK #####
    
    [INFO] php (cli) version is 5.5.9-1ubuntu4.5
    
    ##### PORT CHECK #####
    
    [WARN] Port 465 (SMTP server SSL) seems NOT to be listening
    
    ##### MAIL SERVER CHECK #####
    
    [WARN] I found no "submission" entry in your postfix master.cf
    [INFO] this is not critical, but if you want to offer port 587 for smtp connections yo
    u have to enable this.
    [WARN] I found no "smtps" entry in your postfix master.cf
    [INFO] this is not critical, but if you want to offer SSL for smtp (not TLS) connectio
    ns you have to enable this.
    
    ##### RUNNING SERVER PROCESSES #####
    
    [INFO] I found the following web server(s):
            Apache 2 (PID 6398)
    [INFO] I found the following mail server(s):
            Postfix (PID 32760)
    [INFO] I found the following pop3 server(s):
            Dovecot (PID 1200)
    [INFO] I found the following imap server(s):
            Dovecot (PID 1200)
    [INFO] I found the following ftp server(s):
            PureFTP (PID 6270)
    
    ##### LISTENING PORTS #####
    (only           ()
    Local           (Address)
    [localhost]:11211               (6176/memcached)
    [anywhere]:139          (650/smbd)
    [anywhere]:110          (1200/dovecot)
    [anywhere]:143          (1200/dovecot)
    [localhost]:783         (1643/spamd.pid)
    [anywhere]:30033                (6651/ts3server_linu)
    [anywhere]:6001         (6335/Xvnc4)
    [anywhere]:21           (6270/pure-ftpd)
    ***.***.***.***:53              (1319/named)
    [localhost]:53          (1319/named)
    [anywhere]:22           (1449/sshd)
    ***.***.***.***:27415           (8158/srcds_linux)
    [anywhere]:25           (32760/master)
    [anywhere]:8089         (10572/7DaysToDie.x8)
    [localhost]:953         (1319/named)
    [anywhere]:8090         (10572/7DaysToDie.x8)
    ***.***.***.***:27515           (4675/srcds_linux)
    [anywhere]:10011                (6651/ts3server_linu)
    [anywhere]:445          (650/smbd)
    [anywhere]:37697                (4675/srcds_linux)
    [anywhere]:993          (1200/dovecot)
    [anywhere]:995          (1200/dovecot)
    ***.***.***.***:27015           (6646/srcds_linux)
    [anywhere]:12679                (6348/perl)
    [localhost]:10025               (32760/master)
    [anywhere]:3306         (1360/mysqld)
    [localhost]39           (650/smbd)
    *:*:*:*::*:5901         (6335/Xvnc4)
    [localhost]10           (1200/dovecot)
    [localhost]43           (1200/dovecot)
    *:*:*:*::*:783          (1643/spamd.pid)
    *:*:*:*::*:8080         (6398/apache2)
    *:*:*:*::*:80           (6398/apache2)
    *:*:*:*::*:8081         (6398/apache2)
    ***.***.***.***:27315           (6566/java)
    *:*:*:*::*:21           (6270/pure-ftpd)
    *:*:*:*::*:53           (1319/named)
    *:*:*:*::*:22           (1449/sshd)
    *:*:*:*::*:25           (32760/master)
    *:*:*:*::*:953          (1319/named)
    *:*:*:*::*:443          (6398/apache2)
    ***.***.***.***:27325           (6566/java)
    *:*:*:*::*:445          (650/smbd)
    *:*:*:*::*:993          (1200/dovecot)
    *:*:*:*::*:995          (1200/dovecot)
    
    
    
    
    ##### IPTABLES #####
    Chain INPUT (policy ACCEPT)
    target     prot opt source               destination
    fail2ban-postfix-sasl  tcp  --  [anywhere]/0            [anywhere]/0            multip
    ort dports 25
    fail2ban-dovecot-pop3imap  tcp  --  [anywhere]/0            [anywhere]/0            mu
    ltiport dports 110,995,143,993
    fail2ban-pureftpd  tcp  --  [anywhere]/0            [anywhere]/0            multiport
    dports 21
    fail2ban-ssh  tcp  --  [anywhere]/0            [anywhere]/0            multiport dport
    s 22
    
    Chain FORWARD (policy ACCEPT)
    target     prot opt source               destination
    
    Chain OUTPUT (policy ACCEPT)
    target     prot opt source               destination
    
    Chain fail2ban-dovecot-pop3imap (1 references)
    target     prot opt source               destination
    RETURN     all  --  [anywhere]/0            [anywhere]/0
    
    Chain fail2ban-postfix-sasl (1 references)
    target     prot opt source               destination
    RETURN     all  --  [anywhere]/0            [anywhere]/0
    
    Chain fail2ban-pureftpd (1 references)
    target     prot opt source               destination
    RETURN     all  --  [anywhere]/0            [anywhere]/0
    
    Chain fail2ban-ssh (1 references)
    target     prot opt source               destination
    RETURN     all  --  [anywhere]/0            [anywhere]/0
    
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Ok, so you are using apache. Please post the output of:

    ls -la /etc/apache2
     
  5. prouxx

    prouxx New Member

    Here you go:

    Code:
    [email protected] ~ # ls -la /etc/apache2
    total 96
    drwxr-xr-x   8 root root  4096 Aug  4 18:57 .
    drwxr-xr-x 137 root root 12288 Jan  1 22:51 ..
    -rw-r--r--   1 root root  7109 Aug  4 19:57 apache2.conf
    drwxr-xr-x   2 root root  4096 Jan  1 21:35 conf-available
    drwxr-xr-x   2 root root  4096 Jan  1 21:35 conf-enabled
    -rw-r--r--   1 root root  1782 Jan  3  2014 envvars
    -rw-r--r--   1 root root 31063 Jan  3  2014 magic
    drwxr-xr-x   2 root root 12288 Oct 31 17:13 mods-available
    drwxr-xr-x   2 root root  4096 Aug  4 19:38 mods-enabled
    -rw-r--r--   1 root root   365 Oct 27 20:15 ports.conf
    drwxr-xr-x   2 root root  4096 Jan  1 18:18 sites-available
    drwxr-xr-x   2 root root  4096 Jan  1 18:18 sites-enabled
    
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Thats really strange, there should be a conf.d directory. Maybe it got deleted accidently? Please recreate it:

    mkdir /etc/apache2/conf.d

    then run:

    sudo apt-get remove --purge phpmyadmin
    sudo apt-get install phpmyadmin
     
  7. prouxx

    prouxx New Member

    Still getting the 404 error. Here's what I did:
    Code:
    [email protected] ~ # mkdir /etc/apache2/conf.d
    [email protected] ~ # sudo apt-get remove --purge phpmyadmin
    Reading package lists... Done
    Building dependency tree
    Reading state information... Done
    The following packages were automatically installed and are no longer required:
      dbconfig-common javascript-common libjs-codemirror libjs-jquery
      libjs-jquery-cookie libjs-jquery-event-drag libjs-jquery-metadata
      libjs-jquery-mousewheel libjs-jquery-tablesorter libjs-jquery-ui
      libjs-underscore libnss3-1d libpcap0.8:i386 php-gettext php-net-sieve
      roundcube-core roundcube-mysql tinymce wine-gecko2.24 wine-gecko2.24:i386
      wine-mono4.5.2
    Use 'apt-get autoremove' to remove them.
    The following packages will be REMOVED:
      ogppanel* phpmyadmin*
    0 upgraded, 0 newly installed, 2 to remove and 3 not upgraded.
    After this operation, 23.0 MB disk space will be freed.
    Do you want to continue? [Y/n] y
    (Reading database ... 121854 files and directories currently installed.)
    Removing ogppanel (3199) ...
    dpkg: warning: while removing ogppanel, directory '/var/www/js/modules' not empty so not removed
    dpkg: warning: while removing ogppanel, directory '/var/www/modules/server' not empty so not removed
    dpkg: warning: while removing ogppanel, directory '/var/www/modules/user_games' not empty so not removed
    dpkg: warning: while removing ogppanel, directory '/var/www/modules/ftp' not empty so not removed
    dpkg: warning: while removing ogppanel, directory '/var/www/modules/subusers' not empty so not removed
    dpkg: warning: while removing ogppanel, directory '/var/www/modules/gamemanager' not empty so not removed
    dpkg: warning: while removing ogppanel, directory '/var/www/modules/extras' not empty so not removed
    dpkg: warning: while removing ogppanel, directory '/var/www/modules/config_games/server_configs' not empty so not removed
    dpkg: warning: while removing ogppanel, directory '/var/www/modules/mysql' not empty so not removed
    dpkg: warning: while removing ogppanel, directory '/var/www/modules/administration/images' not empty so not removed
    dpkg: warning: while removing ogppanel, directory '/var/www/images/icons' not empty so not removed
    dpkg: warning: while removing ogppanel, directory '/var/www/includes' not empty so not removed
    Removing phpmyadmin (4:4.0.10-1) ...
    dbconfig-common: dumping mysql database phpmyadmin to /var/tmp/phpmyadmin.phpmyadmin.2015-01-02-20.29.mysql.XfhdrJ.
    dbconfig-common: dropping mysql database phpmyadmin.
    dropping database phpmyadmin: success.
    verifying database phpmyadmin was dropped: success.
    dbconfig-common: revoking privileges for user prouxx on phpmyadmin.
    revoking access to database phpmyadmin from [email protected]: success.
    Purging configuration files for phpmyadmin (4:4.0.10-1) ...
    Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
    Processing triggers for hicolor-icon-theme (0.13-1) ...
    [email protected] ~ # sudo apt-get install phpmyadmin
    Reading package lists... Done
    Building dependency tree
    Reading state information... Done
    The following packages were automatically installed and are no longer required:
      libnss3-1d libpcap0.8:i386 php-net-sieve roundcube-core roundcube-mysql
      tinymce wine-gecko2.24 wine-gecko2.24:i386 wine-mono4.5.2
    Use 'apt-get autoremove' to remove them.
    Suggested packages:
      www-browser
    The following NEW packages will be installed:
      phpmyadmin
    0 upgraded, 1 newly installed, 0 to remove and 3 not upgraded.
    Need to get 4,224 kB of archives.
    After this operation, 23.0 MB of additional disk space will be used.
    Get:1 http://archive.ubuntu.com/ubuntu/ trusty/universe phpmyadmin all 4:4.0.10-1 [4,224 kB]
    Fetched 4,224 kB in 0s (4,701 kB/s)
    Preconfiguring packages ...
    Selecting previously unselected package phpmyadmin.
    (Reading database ... 117587 files and directories currently installed.)
    Preparing to unpack .../phpmyadmin_4%3a4.0.10-1_all.deb ...
    Unpacking phpmyadmin (4:4.0.10-1) ...
    Processing triggers for hicolor-icon-theme (0.13-1) ...
    Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
    Setting up phpmyadmin (4:4.0.10-1) ...
    dbconfig-common: writing config to /etc/dbconfig-common/phpmyadmin.conf
    
    Creating config file /etc/dbconfig-common/phpmyadmin.conf with new version
    
    Creating config file /etc/phpmyadmin/config-db.php with new version
    granting access to database phpmyadmin for [email protected]: success.
    verifying access for [email protected]: success.
    creating database phpmyadmin: success.
    verifying database phpmyadmin exists: success.
    populating database via sql...  done.
    dbconfig-common: flushing administrative password
    
    
    Haha, looks like I just accidentally removed my game panel. Oops.
     
  8. prouxx

    prouxx New Member

    Rightttt. It seems to be working now. This is so weird.

    What I was doing was logging into the ispconfig panel as a client user, I then navigate to databases and click on the icon on the bottom left.
    [​IMG]
    So that shows me a 404 error. Now, because my game panel is uninstalled when I put in my server IP it comes up with a list of directories. Clicked the phpmyadmin one and everything is right there. At least now I can access mysql but, as I said, this is all a bit weird. It seems like something has gone a bit wrong somewhere.
     
  9. prouxx

    prouxx New Member

    I don't know if I should make a new thread, cry or just delete my whole server.

    I reinstalled Open Game Panel. That seems to be working great. MySQL is fine.
    I went to check ispconfig a few minutes ago.
    Boom.
    500 - internal server error.
    No idea how or why.
    Code:
    
    cat htf_report.txt | more
    
    ##### SERVER #####
    IP-address (as per hostname): ***.***.***.***
    IP-address(es) (as per ifconfig): ***.***.***.***
    [INFO] ISPConfig is installed.
    
    ##### ISPCONFIG #####
    ISPConfig version is 3.0.5.4p4
    
    
    ##### VERSION CHECK #####
    
    [INFO] php (cli) version is 5.5.9-1ubuntu4.5
    
    ##### PORT CHECK #####
    
    [WARN] Port 465 (SMTP server SSL) seems NOT to be listening
    
    ##### MAIL SERVER CHECK #####
    
    [WARN] I found no "submission" entry in your postfix master.cf
    [INFO] this is not critical, but if you want to offer port 587 for smtp connections you have to enable
    this.
    [WARN] I found no "smtps" entry in your postfix master.cf
    [INFO] this is not critical, but if you want to offer SSL for smtp (not TLS) connections you have to e
    nable this.
    
    ##### RUNNING SERVER PROCESSES #####
    
    [INFO] I found the following web server(s):
            Apache 2 (PID 23116)
    [INFO] I found the following mail server(s):
            Postfix (PID 6054)
    [INFO] I found the following pop3 server(s):
            Dovecot (PID 1186)
    [INFO] I found the following imap server(s):
            Dovecot (PID 1186)
    [INFO] I found the following ftp server(s):
            PureFTP (PID 6085)
    
    ##### LISTENING PORTS #####
    (only           ()
    Local           (Address)
    [localhost]:11211               (5888/memcached)
    [anywhere]:139          (664/smbd)
    [anywhere]:110          (1186/dovecot)
    [anywhere]:143          (1186/dovecot)
    [localhost]:783         (1985/spamd.pid)
    [anywhere]:30033                (6197/ts3server_linu)
    [anywhere]:6001         (5993/Xvnc4)
    [anywhere]:21           (6085/pure-ftpd)
    ***.***.***.***:53              (1303/named)
    [localhost]:53          (1303/named)
    [anywhere]:22           (1458/sshd)
    ***.***.***.***:27415           (7712/srcds_linux)
    [anywhere]:8089         (2111/7DaysToDie.x86)
    [anywhere]:25           (6054/master)
    [localhost]:953         (1303/named)
    [anywhere]:8090         (2111/7DaysToDie.x86)
    ***.***.***.***:27515           (7406/srcds_linux)
    [anywhere]:10011                (6197/ts3server_linu)
    [anywhere]:445          (664/smbd)
    [anywhere]:993          (1186/dovecot)
    [anywhere]:995          (1186/dovecot)
    ***.***.***.***:27015           (7507/srcds_linux)
    [anywhere]:12679                (7248/perl)
    [anywhere]:49352                (7406/srcds_linux)
    [localhost]:10025               (6054/master)
    [anywhere]:3306         (1366/mysqld)
    [localhost]39           (664/smbd)
    *:*:*:*::*:5901         (5993/Xvnc4)
    [localhost]10           (1186/dovecot)
    [localhost]43           (1186/dovecot)
    *:*:*:*::*:783          (1985/spamd.pid)
    *:*:*:*::*:8080         (23116/apache2)
    *:*:*:*::*:80           (23116/apache2)
    *:*:*:*::*:8081         (23116/apache2)
    ***.***.***.***:27315           (7445/java)
    *:*:*:*::*:21           (6085/pure-ftpd)
    *:*:*:*::*:53           (1303/named)
    *:*:*:*::*:22           (1458/sshd)
    *:*:*:*::*:25           (6054/master)
    *:*:*:*::*:953          (1303/named)
    *:*:*:*::*:443          (23116/apache2)
    ***.***.***.***:27325           (7445/java)
    *:*:*:*::*:445          (664/smbd)
    *:*:*:*::*:993          (1186/dovecot)
    *:*:*:*::*:995          (1186/dovecot)
    
    
    
    
    ##### IPTABLES #####
    Chain INPUT (policy ACCEPT)
    target     prot opt source               destination
    fail2ban-postfix-sasl  tcp  --  [anywhere]/0            [anywhere]/0            multiport dports 25
    fail2ban-dovecot-pop3imap  tcp  --  [anywhere]/0            [anywhere]/0            multiport dports 1
    10,995,143,993
    fail2ban-pureftpd  tcp  --  [anywhere]/0            [anywhere]/0            multiport dports 21
    fail2ban-ssh  tcp  --  [anywhere]/0            [anywhere]/0            multiport dports 22
    
    Chain FORWARD (policy ACCEPT)
    target     prot opt source               destination
    
    Chain OUTPUT (policy ACCEPT)
    target     prot opt source               destination
    
    Chain fail2ban-dovecot-pop3imap (1 references)
    target     prot opt source               destination
    RETURN     all  --  [anywhere]/0            [anywhere]/0
    
    Chain fail2ban-postfix-sasl (1 references)
    target     prot opt source               destination
    RETURN     all  --  [anywhere]/0            [anywhere]/0
    
    Chain fail2ban-pureftpd (1 references)
    target     prot opt source               destination
    RETURN     all  --  [anywhere]/0            [anywhere]/0
    
    Chain fail2ban-ssh (1 references)
    target     prot opt source               destination
    RETURN     all  --  [anywhere]/0            [anywhere]/0
    
    Everything seems to be as it should be. That is, aside from the internal server error. Help :(

    -Edit-

    checked /var/log/apache2/error.log and am getting lots of 'client denied by server configuration' errors.
     
    Last edited: Jan 3, 2015
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    Is OpenGamePanel a server controlpanel that modifeod the apache configuration? If yes, then it most likely damaged the ispconfig configuration. In most cases you cant run more then one controlpabnel on a server as tehy will always cause conflicts.
     

Share This Page