[Resolved] AWS EC2 Server: can't get phpmyadmin to work

Discussion in 'Installation/Configuration' started by Bevan, Jun 14, 2016.

  1. Bevan

    Bevan New Member

    Hello,
    I have an Ubuntu 14.04 server running in AWS
    I have installed ISPConfig 3.0.5.4p9
    I followed the 'Perfect Server' tutorial in this site.
    I can not get phpmyadmin to work. When I click the icon for phpmyadmin, it gives me a 404, requested url not fouind on server.

    Here's the 'test script' output...

    ##### SERVER #####
    IP-address (as per hostname): [localhost]
    IP-address(es) (as per ifconfig): ***.***.***.***
    [WARN] ip addresses from hostname differ from ifconfig output. Please check your ip settings.
    [INFO] ISPConfig is installed.
    ##### ISPCONFIG #####
    ISPConfig version is 3.0.5.4p9
    ##### VERSION CHECK #####
    [INFO] php (cli) version is 5.5.9-1ubuntu4.17
    ##### PORT CHECK #####
    ##### MAIL SERVER CHECK #####
    ##### RUNNING SERVER PROCESSES #####
    [INFO] I found the following web server(s):
    Apache 2 (PID 8481)
    [INFO] I found the following mail server(s):
    Postfix (PID 1948)
    [INFO] I found the following pop3 server(s):
    Dovecot (PID 14596)
    [INFO] I found the following imap server(s):
    Dovecot (PID 14596)
    [INFO] I found the following ftp server(s):
    PureFTP (PID 14672)
    ##### LISTENING PORTS #####
    (only ()
    Local (Address)
    [anywhere]:465 (1948/master)
    ***.***.***.***:53 (14702/named)
    [localhost]:53 (14702/named)
    [anywhere]:21 (14672/pure-ftpd)
    [anywhere]:22 (1060/sshd)
    [localhost]:953 (14702/named)
    [anywhere]:25 (1948/master)
    [anywhere]:993 (14596/dovecot)
    [anywhere]:995 (14596/dovecot)
    [anywhere]:3306 (13235/mysqld)
    [anywhere]:587 (1948/master)
    [localhost]:11211 (1839/memcached)
    [anywhere]:110 (14596/dovecot)
    [anywhere]:143 (14596/dovecot)
    *:*:*:*::*:8080 (8481/apache2)
    *:*:*:*::*:80 (8481/apache2)
    *:*:*:*::*:8081 (8481/apache2)
    *:*:*:*::*:465 (1948/master)
    *:*:*:*::*:53 (14702/named)
    *:*:*:*::*:21 (14672/pure-ftpd)
    *:*:*:*::*:22 (1060/sshd)
    *:*:*:*::*:953 (14702/named)
    *:*:*:*::*:25 (1948/master)
    *:*:*:*::*:443 (8481/apache2)
    *:*:*:*::*:993 (14596/dovecot)
    *:*:*:*::*:995 (14596/dovecot)
    *:*:*:*::*:587 (1948/master)
    [localhost]10 (14596/dovecot)
    [localhost]43 (14596/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 110,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
    root@server1:~#

    So, now what?
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Seems as if phpmyadmin has not been enabled during phpmyadmin install, that's a common mistake. Redo the step by running:

    dpkg-reconfigure phpmyadmin

    when the installer asks for which web server it shall be enabled, select apache 2 by using the tab and space key. there must be a visible cross in that settings, it is not enough to highlight the option!
     
  3. Bevan

    Bevan New Member

    OK, so I tried, but it says no such file.
    >
    root@server1:/home/ubuntu# dpkg-reconfigure phpmyadmin
    dbconfig-common: writing config to /etc/dbconfig-common/phpmyadmin.conf
    Replacing config file /etc/phpmyadmin/config-db.php with new version
    apache2_invoke: Enable configuration phpmyadmin
    Action 'configtest' failed.
    The Apache error log may have more information.
    apache2_reload: Your configuration is broken. Not reloading Apache 2
    * Reloading web server apache2 *
    * The apache2 configtest failed. Not doing anything.
    Output of config test was:
    apache2: Syntax error on line 223 of /etc/apache2/apache2.conf: Could not open configuration file /usr/share/phpmyadmin/apache.conf: No such file or directory
    Action 'configtest' failed.
    The Apache error log may have more information.
    invoke-rc.d: initscript apache2, action "reload" failed.
    root@server1:/home/ubuntu#
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    please post line 223 of the file /etc/apache2/apache2.conf

    Normally, the file is loaded from the mods-enabled folder so my guess is that you might have added this line manually?
     
  5. Bevan

    Bevan New Member

    I've fixed it: I removed the line that was added to apace2.conf that looked for the file apache.conf in /usr/share/phpmyadmin/, and now it works ok.
     

Share This Page