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
Maybe you used a guide with nginx and not apache? Please use the test script from here https://www.howtoforge.com/community/threads/please-read-before-posting.58408/ and post the output.
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
Here you go: Code: root@Ubuntu-1404-trusty-64-minimal ~ # 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
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
Still getting the 404 error. Here's what I did: Code: root@Ubuntu-1404-trusty-64-minimal ~ # mkdir /etc/apache2/conf.d root@Ubuntu-1404-trusty-64-minimal ~ # 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 prouxx@localhost: 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) ... root@Ubuntu-1404-trusty-64-minimal ~ # 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 phpmyadmin@localhost: success. verifying access for phpmyadmin@localhost: 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.
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. 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.
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.
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.
