Hi, I m not sure if anyone could help me on this one, but i have a big problem with ispconfig and phpmyadmin. Whenever i access phpmyadmin, and go in a table, it crash the whole ispconfig and the whole system for a while (like a good minute), then, everything goes back to normal, i can't use it... Any idea ? Feel free to ask any piece of information you would need, i'll provide everything. Thanks a lot !
phpmyadmin runs on apache with mod_php, ispconfig is not involved there. So your problem is somewhere outside of ispconfig. The reason that ispconfig is unreachable is simply that your apache or mysql is crashed and without apache or mysql, you cant reach ispconfig. How much ram does the server has?
root@www-ispconfig:cat /etc/*-release DISTRIB_ID=Ubuntu DISTRIB_RELEASE=12.04 DISTRIB_CODENAME=precise DISTRIB_DESCRIPTION="Ubuntu 12.04.4 LTS" NAME="Ubuntu" VERSION="12.04.4 LTS, Precise Pangolin" ID=ubuntu ID_LIKE=debian PRETTY_NAME="Ubuntu precise (12.04.4 LTS)" VERSION_ID="12.04" root@www-ispconfig:/free -m total used free shared buffers cached Mem: 63677 63185 491 0 1825 52983 -/+ buffers/cache: 8376 55300 Swap: 64765 7 64758 root@www-ispconfig:/grep MemTotal /proc/meminfo MemTotal: 65205636 kB root@www-ispconfig:/var/www/ocef.nc# Tasks: 269 total, 2 running, 267 sleeping, 0 stopped, 0 zombie Cpu(s): 8.2%us, 0.8%sy, 0.0%ni, 65.5%id, 25.4%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 65205636k total, 64691344k used, 514292k free, 1869592k buffers Swap: 66320380k total, 7496k used, 66312884k free, 54018384k cached Unknown command - try 'h' for help PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 17453 www-data 20 0 385m 117m 14m D 33 0.2 0:41.97 php-cgi 17017 web94 20 0 305m 51m 25m S 9 0.1 0:20.86 php-cgi 30812 web94 20 0 304m 50m 25m S 8 0.1 0:01.86 php-cgi 16685 web94 20 0 297m 43m 25m S 6 0.1 0:21.12 php-cgi 30289 www-data 20 0 376m 19m 3052 S 3 0.0 0:00.89 /usr/sbin/apach 30847 root 20 0 283m 20m 8928 D 2 0.0 0:00.05 php 313 root 20 0 0 0 0 D 1 0.0 264:13.74 jbd2/sda1-8 17457 www-data 20 0 299m 45m 25m S 1 0.1 0:11.51 php-cgi 24993 root 20 0 73584 3752 2872 S 1 0.0 0:17.26 sshd 30011 mysql 20 0 4424m 312m 8800 S 1 0.5 6819:46 mysqld 30506 root 20 0 17476 1428 952 R 1 0.0 0:00.52 top 30852 www-data 20 0 376m 17m 2044 S 1 0.0 0:00.02 /usr/sbin/apach 10819 root 20 0 481m 8428 2148 S 0 0.0 173:48.66 fail2ban-server 13937 root 20 0 21752 4544 2096 S 0 0.0 0:06.44 vlogger (access 14061 root 20 0 0 0 0 S 0 0.0 0:03.70 kworker/u:0 14248 root 20 0 106m 59m 1052 D 0 0.1 1:01.55 tar 14249 root 20 0 8812 664 428 S 0 0.0 26:47.09 gzip 30351 www-data 20 0 376m 19m 3068 D 0 0.0 0:00.24 /usr/sbin/apach 30420 www-data 20 0 376m 19m 3172 S 0 0.0 0:00.27 /usr/sbin/apach 30790 www-data 20 0 376m 19m 3028 S 0 0.0 0:00.58 /usr/sbin/apach 30798 www-data 20 0 376m 19m 3132 S 0 0.0 0:00.03 /usr/sbin/apach 30811 www-data 20 0 376m 19m 3052 D 0 0.0 0:00.03 /usr/sbin/apach 30849 www-data 20 0 376m 18m 2744 S 0 0.0 0:00.01 /usr/sbin/apach 30850 www-data 20 0 283m 11m 7540 D 0 0.0 0:00.01 php-cgi 30853 www-data 20 0 376m 17m 2036 R 0 0.0 0:00.01 /usr/sbin/apach 1 root 20 0 24448 2060 1092 S 0 0.0 1:20.91 init 2 root 20 0 0 0 0 S 0 0.0 0:01.43 kthreadd 3 root 20 0 0 0 0 S 0 0.0 29:18.64 ksoftirqd/0 6 root RT 0 0 0 0 S 0 0.0 3:53.50 migration/0 7 root RT 0 0 0 0 S 0 0.0 2:02.77 watchdog/0 8 root RT 0 0 0 0 S 0 0.0 1:19.94 migration/1 10 root 20 0 0 0 0 S 0 0.0 8:31.16 ksoftirqd/1 12 root RT 0 0 0 0 S 0 0.0 1:30.18 watchdog/1 13 root RT 0 0 0 0 S 0 0.0 5:32.40 migration/2
Hello, I wonder what is the error log of the web site that causes the crash? I guess you have pma with a global alias like phpmyadmin/ in all websites... What if you can install pma in a dedicated web site like pma.mydomain.com and see if it helps... Also in open base dir you could add: /usr/share/php:/tmp:/usr/share/phpmyadmin:/etc/phpmyadmin:/var/lib/phpmyadmin and see if it helps too... Depends on the error you have though and may be many things.
