Eek! I did an update_ispconfig.sh which appeared to work fine. Only something nasty must have happened. I get the login screen with lots of SQL on it and I can't login. Here's the login screen. Anyone got any ideas of how to fix this? Pretty please?
Please check the mysql service status, & restart the service. Additionally paste the output of the apache log file or nginx logs if you are using NGINX
I've stopped and started the service. Apache.log looks interewsting though... [Sun Jun 29 06:28:32 2014] [notice] Digest: generating secret for digest authentication ... [Sun Jun 29 06:28:32 2014] [notice] Digest: done [Sun Jun 29 06:28:32 2014] [notice] FastCGI: process manager initialized (pid 20797) [Sun Jun 29 06:28:32 2014] [error] python_init: Python version mismatch, expected '2.7.2+', found '2.7.3'. [Sun Jun 29 06:28:32 2014] [error] python_init: Python executable found '/usr/bin/python'. [Sun Jun 29 06:28:32 2014] [error] python_init: Python path being used '/usr/lib/python2.7/:/usr/lib/python2.7/plat-linux2:/usr/lib/python2.7/lib-tk:/usr/lib/python2.7/lib-old:/usr/lib/python2.7/lib-dynload'. [Sun Jun 29 06:28:32 2014] [notice] mod_python: Creating 8 session mutexes based on 150 max processes and 0 max threads. [Sun Jun 29 06:28:32 2014] [notice] mod_python: using mutex_directory /tmp [Sun Jun 29 06:28:32 2014] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?) [Sun Jun 29 06:28:32 2014] [notice] Apache/2.2.22 (Ubuntu) DAV/2 SVN/1.6.17 mod_fastcgi/mod_fastcgi-SNAP-0910052141 mod_fcgid/2.3.6 PHP/5.3.10-1ubuntu3.12 with Suhosin-Patch mod_python/3.3.1 Python/2.7.3 mod_ruby/1.2.6 Ruby/1.8.7(2011-06-30) mod_ssl/2.2.22 OpenSSL/1.0.1 configured -- resuming normal operations [Sun Jun 29 06:28:32 2014] [warn] long lost child came home! (pid 2769) [Sun Jun 29 08:15:44 2014] [error] [client 109.190.55.203] script '/var/www/wp-login.php' not found or unable to stat [Sun Jun 29 08:15:48 2014] [error] [client 109.190.55.203] File does not exist: /var/www/blog [Sun Jun 29 08:15:50 2014] [error] [client 109.190.55.203] File does not exist: /var/www/wp [Sun Jun 29 08:15:51 2014] [error] [client 109.190.55.203] File does not exist: /var/www/test [Sun Jun 29 08:15:52 2014] [error] [client 109.190.55.203] File does not exist: /var/www/old [Sun Jun 29 08:15:55 2014] [error] [client 109.190.55.203] File does not exist: /var/www/store [Sun Jun 29 09:49:05 2014] [notice] caught SIGTERM, shutting down [Sun Jun 29 09:49:06 2014] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?) [Sun Jun 29 09:49:06 2014] [notice] suEXEC mechanism enabled (wrapper: /usr/lib/apache2/suexec) [Sun Jun 29 09:49:06 2014] [notice] Digest: generating secret for digest authentication ... [Sun Jun 29 09:49:06 2014] [notice] Digest: done [Sun Jun 29 09:49:06 2014] [notice] FastCGI: process manager initialized (pid 17197) [Sun Jun 29 09:49:06 2014] [error] python_init: Python version mismatch, expected '2.7.2+', found '2.7.3'. [Sun Jun 29 09:49:06 2014] [error] python_init: Python executable found '/usr/bin/python'. [Sun Jun 29 09:49:06 2014] [error] python_init: Python path being used '/usr/lib/python2.7/:/usr/lib/python2.7/plat-linux2:/usr/lib/python2.7/lib-tk:/usr/lib/python2.7/lib-old:/usr/lib/python2.7/lib-dynload'. [Sun Jun 29 09:49:06 2014] [notice] mod_python: Creating 8 session mutexes based on 150 max processes and 0 max threads. [Sun Jun 29 09:49:06 2014] [notice] mod_python: using mutex_directory /tmp [Sun Jun 29 09:49:07 2014] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?) [Sun Jun 29 09:49:07 2014] [notice] Apache/2.2.22 (Ubuntu) DAV/2 SVN/1.6.17 mod_fastcgi/mod_fastcgi-SNAP-0910052141 mod_fcgid/2.3.6 PHP/5.3.10-1ubuntu3.12 with Suhosin-Patch mod_python/3.3.1 Python/2.7.3 mod_ruby/1.2.6 Ruby/1.8.7(2011-06-30) mod_ssl/2.2.22 OpenSSL/1.0.1 configured -- resuming normal operations [Sun Jun 29 09:50:02 2014] [notice] caught SIGTERM, shutting down [Sun Jun 29 09:50:03 2014] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?) [Sun Jun 29 09:50:03 2014] [notice] suEXEC mechanism enabled (wrapper: /usr/lib/apache2/suexec) [Sun Jun 29 09:50:03 2014] [notice] Digest: generating secret for digest authentication ... [Sun Jun 29 09:50:03 2014] [notice] Digest: done [Sun Jun 29 09:50:03 2014] [notice] FastCGI: process manager initialized (pid 23099) [Sun Jun 29 09:50:03 2014] [error] python_init: Python version mismatch, expected '2.7.2+', found '2.7.3'. [Sun Jun 29 09:50:03 2014] [error] python_init: Python executable found '/usr/bin/python'. [Sun Jun 29 09:50:03 2014] [error] python_init: Python path being used '/usr/lib/python2.7/:/usr/lib/python2.7/plat-linux2:/usr/lib/python2.7/lib-tk:/usr/lib/python2.7/lib-old:/usr/lib/python2.7/lib-dynload'. [Sun Jun 29 09:50:03 2014] [notice] mod_python: Creating 8 session mutexes based on 150 max processes and 0 max threads. [Sun Jun 29 09:50:03 2014] [notice] mod_python: using mutex_directory /tmp [Sun Jun 29 09:50:03 2014] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?) [Sun Jun 29 09:50:03 2014] [notice] Apache/2.2.22 (Ubuntu) DAV/2 SVN/1.6.17 mod_fastcgi/mod_fastcgi-SNAP-0910052141 mod_fcgid/2.3.6 PHP/5.3.10-1ubuntu3.12 with Suhosin-Patch mod_python/3.3.1 Python/2.7.3 mod_ruby/1.2.6 Ruby/1.8.7(2011-06-30) mod_ssl/2.2.22 OpenSSL/1.0.1 configured -- resuming normal operations [Sun Jun 29 09:57:54 2014] [error] [client 63.245.66.76] File does not exist: /var/www/phpTest [Sun Jun 29 09:57:54 2014] [error] [client 63.245.66.76] File does not exist: /var/www/phpMyAdmin [Sun Jun 29 09:57:55 2014] [error] [client 63.245.66.76] File does not exist: /var/www/pma [Sun Jun 29 09:57:56 2014] [error] [client 63.245.66.76] File does not exist: /var/www/myadmin [Sun Jun 29 10:01:00 2014] [notice] caught SIGTERM, shutting down [Sun Jun 29 10:01:02 2014] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?) [Sun Jun 29 10:01:02 2014] [notice] suEXEC mechanism enabled (wrapper: /usr/lib/apache2/suexec) [Sun Jun 29 10:01:03 2014] [notice] Digest: generating secret for digest authentication ... [Sun Jun 29 10:01:03 2014] [notice] Digest: done [Sun Jun 29 10:01:03 2014] [notice] FastCGI: process manager initialized (pid 24714) [Sun Jun 29 10:01:06 2014] [error] python_init: Python version mismatch, expected '2.7.2+', found '2.7.3'. [Sun Jun 29 10:01:06 2014] [error] python_init: Python executable found '/usr/bin/python'. [Sun Jun 29 10:01:06 2014] [error] python_init: Python path being used '/usr/lib/python2.7/:/usr/lib/python2.7/plat-linux2:/usr/lib/python2.7/lib-tk:/usr/lib/python2.7/lib-old:/usr/lib/python2.7/lib-dynload'. [Sun Jun 29 10:01:06 2014] [notice] mod_python: Creating 8 session mutexes based on 150 max processes and 0 max threads. [Sun Jun 29 10:01:06 2014] [notice] mod_python: using mutex_directory /tmp [Sun Jun 29 10:01:08 2014] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?) [Sun Jun 29 10:01:08 2014] [notice] Apache/2.2.22 (Ubuntu) DAV/2 SVN/1.6.17 mod_fastcgi/mod_fastcgi-SNAP-0910052141 mod_fcgid/2.3.6 PHP/5.3.10-1ubuntu3.12 with Suhosin-Patch mod_python/3.3.1 Python/2.7.3 mod_ruby/1.2.6 Ruby/1.8.7(2011-06-30) mod_ssl/2.2.22 OpenSSL/1.0.1 configured -- resuming normal operations [Sun Jun 29 10:01:21 2014] [error] [client 192.168.1.65] File does not exist: /var/www/ispconfig/37, referer: https://192.168.1.1:8080/index.php [Sun Jun 29 10:01:39 2014] [error] [client 192.168.1.65] File does not exist: /var/www/ispconfig/37, referer: https://192.168.1.1:8080/index.php [Sun Jun 29 10:06:30 2014] [notice] caught SIGTERM, shutting down [Sun Jun 29 10:08:02 2014] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?) [Sun Jun 29 10:08:02 2014] [notice] suEXEC mechanism enabled (wrapper: /usr/lib/apache2/suexec) [Sun Jun 29 10:08:02 2014] [notice] Digest: generating secret for digest authentication ... [Sun Jun 29 10:08:02 2014] [notice] Digest: done [Sun Jun 29 10:08:02 2014] [notice] FastCGI: process manager initialized (pid 2608) [Sun Jun 29 10:08:02 2014] [error] python_init: Python version mismatch, expected '2.7.2+', found '2.7.3'. [Sun Jun 29 10:08:02 2014] [error] python_init: Python executable found '/usr/bin/python'. [Sun Jun 29 10:08:02 2014] [error] python_init: Python path being used '/usr/lib/python2.7/:/usr/lib/python2.7/plat-linux2:/usr/lib/python2.7/lib-tk:/usr/lib/python2.7/lib-old:/usr/lib/python2.7/lib-dynload'. [Sun Jun 29 10:08:02 2014] [notice] mod_python: Creating 8 session mutexes based on 150 max processes and 0 max threads. [Sun Jun 29 10:08:02 2014] [notice] mod_python: using mutex_directory /tmp [Sun Jun 29 10:08:03 2014] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?) [Sun Jun 29 10:08:03 2014] [notice] Apache/2.2.22 (Ubuntu) DAV/2 SVN/1.6.17 mod_fastcgi/mod_fastcgi-SNAP-0910052141 mod_fcgid/2.3.6 PHP/5.3.10-1ubuntu3.12 with Suhosin-Patch mod_python/3.3.1 Python/2.7.3 mod_ruby/1.2.6 Ruby/1.8.7(2011-06-30) mod_ssl/2.2.22 OpenSSL/1.0.1 configured -- resuming normal operations [Sun Jun 29 15:14:34 2014] [error] [client 193.95.16.118] File does not exist: /var/www/manager [Sun Jun 29 15:26:01 2014] [error] [client 66.249.76.175] File does not exist: /var/www/robots.txt [Sun Jun 29 16:00:04 2014] [error] [client 222.190.118.224] File does not exist: /var/www/manager [Sun Jun 29 23:08:33 2014] [error] [client 66.249.76.172] File does not exist: /var/www/robots.txt [Sun Jun 29 23:36:42 2014] [error] [client 89.248.162.170] File does not exist: /var/www/w00tw00t.at.blackhats.romanian.anti-sec [Sun Jun 29 23:36:43 2014] [error] [client 89.248.162.170] File does not exist: /var/www/phpMyAdmin [Sun Jun 29 23:36:44 2014] [error] [client 89.248.162.170] File does not exist: /usr/share/phpmyadmin/scripts [Sun Jun 29 23:36:44 2014] [error] [client 89.248.162.170] File does not exist: /var/www/pma [Sun Jun 29 23:36:45 2014] [error] [client 89.248.162.170] File does not exist: /var/www/myadmin [Sun Jun 29 23:36:46 2014] [error] [client 89.248.162.170] File does not exist: /var/www/MyAdmin [Sun Jun 29 23:36:46 2014] [error] [client 89.248.162.170] File does not exist: /var/www/mysqladmin [Sun Jun 29 23:36:47 2014] [error] [client 89.248.162.170] File does not exist: /var/www/scripts [Sun Jun 29 23:36:47 2014] [error] [client 89.248.162.170] Invalid URI in request GET HTTP/1.1 [Mon Jun 30 03:17:34 2014] [error] [client 64.251.27.99] File does not exist: /var/www/robots.txt [Mon Jun 30 03:41:05 2014] [error] [client 110.78.173.151] File does not exist: /var/www/phpTest [Mon Jun 30 03:41:06 2014] [error] [client 110.78.173.151] File does not exist: /var/www/phpMyAdmin [Mon Jun 30 03:41:06 2014] [error] [client 110.78.173.151] File does not exist: /var/www/pma [Mon Jun 30 03:41:07 2014] [error] [client 110.78.173.151] File does not exist: /var/www/myadmin [Mon Jun 30 05:15:40 2014] [error] [client 174.139.44.218] File does not exist: /var/www/web-console [Mon Jun 30 11:08:42 2014] [error] [client 64.246.165.190] File does not exist: /var/www/left.html, referer: http://whois.domaintools.com/drsimon.co.nz [Mon Jun 30 11:08:43 2014] [error] [client 64.246.165.190] File does not exist: /var/www/right.html, referer: http://whois.domaintools.com/drsimon.co.nz [Mon Jun 30 11:48:12 2014] [notice] caught SIGTERM, shutting down [Mon Jun 30 11:50:31 2014] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?) [Mon Jun 30 11:50:31 2014] [notice] suEXEC mechanism enabled (wrapper: /usr/lib/apache2/suexec) [Mon Jun 30 11:50:31 2014] [notice] Digest: generating secret for digest authentication ... [Mon Jun 30 11:50:31 2014] [notice] Digest: done [Mon Jun 30 11:50:31 2014] [notice] FastCGI: process manager initialized (pid 2856) [Mon Jun 30 11:50:32 2014] [error] python_init: Python version mismatch, expected '2.7.2+', found '2.7.3'. [Mon Jun 30 11:50:32 2014] [error] python_init: Python executable found '/usr/bin/python'. [Mon Jun 30 11:50:32 2014] [error] python_init: Python path being used '/usr/lib/python2.7/:/usr/lib/python2.7/plat-linux2:/usr/lib/python2.7/lib-tk:/usr/lib/python2.7/lib-old:/usr/lib/python2.7/lib-dynload'. [Mon Jun 30 11:50:32 2014] [notice] mod_python: Creating 8 session mutexes based on 150 max processes and 0 max threads. [Mon Jun 30 11:50:32 2014] [notice] mod_python: using mutex_directory /tmp [Mon Jun 30 11:50:32 2014] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?) [Mon Jun 30 11:50:32 2014] [notice] Apache/2.2.22 (Ubuntu) DAV/2 SVN/1.6.17 mod_fastcgi/mod_fastcgi-SNAP-0910052141 mod_fcgid/2.3.6 PHP/5.3.10-1ubuntu3.12 with Suhosin-Patch mod_python/3.3.1 Python/2.7.3 mod_ruby/1.2.6 Ruby/1.8.7(2011-06-30) mod_ssl/2.2.22 OpenSSL/1.0.1 configured -- resuming normal operations [Mon Jun 30 17:23:22 2014] [error] [client 91.209.192.252] <b>Security Alert!</b> The PHP CGI cannot be accessed directly. [Mon Jun 30 17:23:22 2014] [error] [client 91.209.192.252] [Mon Jun 30 17:23:22 2014] [error] [client 91.209.192.252] <p>This PHP CGI binary was compiled with force-cgi-redirect enabled. This [Mon Jun 30 17:23:22 2014] [error] [client 91.209.192.252] means that a page will only be served up if the REDIRECT_STATUS CGI variable is [Mon Jun 30 17:23:22 2014] [error] [client 91.209.192.252] set, e.g. via an Apache Action directive.</p> [Mon Jun 30 17:23:22 2014] [error] [client 91.209.192.252] <p>For more information as to <i>why</i> this behaviour exists, see the <a href="http://php.net/security.cgi-bin">manual page for CGI security</a>.</p> [Mon Jun 30 17:23:22 2014] [error] [client 91.209.192.252] <p>For more information about changing this behaviour or re-enabling this webserver, [Mon Jun 30 17:23:22 2014] [error] [client 91.209.192.252] consult the installation file that came with this distribution, or visit [Mon Jun 30 17:23:22 2014] [error] [client 91.209.192.252] <a href="http://php.net/install.windows">the manual page</a>.</p> [Mon Jun 30 17:23:22 2014] [error] [client 91.209.192.252] Premature end of script headers: php
There seems to be a problem with the mysql database, maybe missing or broken tables. From which ispconfig release did you update to the current version?
Here's the tail of ispconfig_install.log with the last line of the previous update and the log of the one that went weird. Hope it helps. Thu Sep 12 22:17:06 NZST 2013 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1889: EXECUTED: chmod +x /usr/local/ispconfig/server/scripts/create_daily_nginx_access_logs.sh /usr/local/ispconfig/server/scripts/create_jailkit_chroot.sh /usr/local/ispconfig/server/scripts/create_jailkit_programs.sh /usr/local/ispconfig/server/scripts/create_jailkit_user.sh /usr/local/ispconfig/server/scripts/ispconfig_update.sh /usr/local/ispconfig/server/scripts/run-getmail.sh /usr/local/ispconfig/server/scripts/update_from_svn.sh /usr/local/ispconfig/server/scripts/update_from_tgz.sh Sun Jun 29 09:59:08 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/update.lib.php, Line 49: WARNING: could not read in ispconfig3.sql Sun Jun 29 09:59:17 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 681: chmod on mysql-virtual_*.cf* Sun Jun 29 09:59:17 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 683: chgrp on mysql-virtual_*.cf* Sun Jun 29 09:59:18 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e alias_maps = hash:/etc/aliases, hash:/var/lib/mailman/data/aliases Sun Jun 29 09:59:18 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e alias_database = hash:/etc/aliases, hash:/var/lib/mailman/data/aliases Sun Jun 29 09:59:18 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e virtual_alias_domains = Sun Jun 29 09:59:19 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, proxy:mysql:/etc/postfix/mysql-virtual_email2email.cf, hash:/var/lib/mailman/data/virtual-mailman Sun Jun 29 09:59:19 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf Sun Jun 29 09:59:19 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf Sun Jun 29 09:59:19 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e virtual_mailbox_base = /var/vmail Sun Jun 29 09:59:19 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e virtual_uid_maps = static:5000 Sun Jun 29 09:59:19 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e virtual_gid_maps = static:5000 Sun Jun 29 09:59:19 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e inet_protocols=all Sun Jun 29 09:59:19 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtpd_sasl_auth_enable = yes Sun Jun 29 09:59:19 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e broken_sasl_auth_clients = yes Sun Jun 29 09:59:20 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtpd_sasl_authenticated_header = yes Sun Jun 29 09:59:20 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtpd_recipient_restrictions = check_recipient_access mysql:/etc/postfix/mysql-virtual_recipient.cf, permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination Sun Jun 29 09:59:20 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtpd_use_tls = yes Sun Jun 29 09:59:20 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtpd_tls_security_level = may Sun Jun 29 09:59:20 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtpd_tls_cert_file = /etc/postfix/smtpd.cert Sun Jun 29 09:59:20 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtpd_tls_key_file = /etc/postfix/smtpd.key Sun Jun 29 09:59:20 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e transport_maps = hash:/var/lib/mailman/data/transport-mailman, proxy:mysql:/etc/postfix/mysql-virtual_transports.cf Sun Jun 29 09:59:20 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e relay_domains = mysql:/etc/postfix/mysql-virtual_relaydomains.cf Sun Jun 29 09:59:20 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e relay_recipient_maps = mysql:/etc/postfix/mysql-virtual_relayrecipientmaps.cf Sun Jun 29 09:59:20 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks Sun Jun 29 09:59:21 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtpd_sender_restrictions = check_sender_access mysql:/etc/postfix/mysql-virtual_sender.cf Sun Jun 29 09:59:21 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtpd_client_restrictions = check_client_access mysql:/etc/postfix/mysql-virtual_client.cf Sun Jun 29 09:59:21 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtpd_client_message_rate_limit = 100 Sun Jun 29 09:59:21 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e maildrop_destination_concurrency_limit = 1 Sun Jun 29 09:59:21 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e maildrop_destination_recipient_limit = 1 Sun Jun 29 09:59:21 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e virtual_transport = maildrop Sun Jun 29 09:59:21 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e header_checks = regexp:/etc/postfix/header_checks Sun Jun 29 09:59:21 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e mime_header_checks = regexp:/etc/postfix/mime_header_checks Sun Jun 29 09:59:21 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e nested_header_checks = regexp:/etc/postfix/nested_header_checks Sun Jun 29 09:59:21 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e body_checks = regexp:/etc/postfix/body_checks Sun Jun 29 09:59:21 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e owner_request_special = no Sun Jun 29 09:59:22 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtp_tls_security_level = may Sun Jun 29 09:59:22 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 796: EXECUTED: chown vmail:vmail /var/vmail/.mailfilter Sun Jun 29 09:59:22 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 799: EXECUTED: chmod 600 /var/vmail/.mailfilter Sun Jun 29 09:59:24 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 952: EXECUTED: postconf -e dovecot_destination_recipient_limit = 1 Sun Jun 29 09:59:24 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 952: EXECUTED: postconf -e virtual_transport = dovecot Sun Jun 29 09:59:24 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 952: EXECUTED: postconf -e smtpd_sasl_type = dovecot Sun Jun 29 09:59:24 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 952: EXECUTED: postconf -e smtpd_sasl_path = private/auth Sun Jun 29 09:59:25 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1040: EXECUTED: postconf -e content_filter = amavis:[127.0.0.1]:10024 Sun Jun 29 09:59:25 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1040: EXECUTED: postconf -e receive_override_options = no_address_mappings Sun Jun 29 09:59:25 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1084: EXECUTED: chown -R getmail /etc/getmail Sun Jun 29 09:59:25 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1087: EXECUTED: chmod -R 700 /etc/getmail Sun Jun 29 09:59:26 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1530: EXECUTED: usermod -a -G ispapps www-data Sun Jun 29 09:59:26 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1427: rm -rf /etc/Bastille.backup Sun Jun 29 09:59:26 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1428: mv -f /etc/Bastille /etc/Bastille.backup Sun Jun 29 09:59:26 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1434: cp -f tpl/bastille-firewall.cfg.master /etc/Bastille/bastille-firewall.cfg Sun Jun 29 09:59:26 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1436: chmod 644 /etc/Bastille/bastille-firewall.cfg Sun Jun 29 09:59:27 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1463: mv -f /etc/init.d/bastille-firewall /etc/init.d/bastille-firewall.backup Sun Jun 29 09:59:27 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1464: cp -f apps/bastille-firewall /etc/init.d Sun Jun 29 09:59:27 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1465: chmod 700 /etc/init.d/bastille-firewall Sun Jun 29 09:59:27 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1467: mv -f /sbin/bastille-ipchains /sbin/bastille-ipchains.backup Sun Jun 29 09:59:27 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1468: cp -f apps/bastille-ipchains /sbin Sun Jun 29 09:59:27 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1469: chmod 700 /sbin/bastille-ipchains Sun Jun 29 09:59:27 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1471: mv -f /sbin/bastille-netfilter /sbin/bastille-netfilter.backup Sun Jun 29 09:59:27 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1472: cp -f apps/bastille-netfilter /sbin Sun Jun 29 09:59:27 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1473: chmod 700 /sbin/bastille-netfilter Sun Jun 29 09:59:27 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1475: mkdir /var/lock/subsys Sun Jun 29 09:59:33 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1714: EXECUTED: cp -rf ../interface /usr/local/ispconfig Sun Jun 29 09:59:34 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1718: EXECUTED: cp -rf ../server /usr/local/ispconfig Sun Jun 29 09:59:34 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1862: EXECUTED: chmod -R 750 /usr/local/ispconfig Sun Jun 29 09:59:34 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1866: EXECUTED: chown -R ispconfig:ispconfig /usr/local/ispconfig Sun Jun 29 09:59:34 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1924: EXECUTED: adduser www-data ispconfig Sun Jun 29 09:59:34 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1927: EXECUTED: adduser www-data ispapps Sun Jun 29 09:59:35 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1941: EXECUTED: chmod +x /usr/local/ispconfig/server/scripts/create_daily_nginx_access_logs.sh /usr/local/ispconfig/server/scripts/create_jailkit_chroot.sh /usr/local/ispconfig/server/scripts/create_jailkit_programs.sh /usr/local/ispconfig/server/scripts/create_jailkit_user.sh /usr/local/ispconfig/server/scripts/ispconfig_update.sh /usr/local/ispconfig/server/scripts/run-getmail.sh /usr/local/ispconfig/server/scripts/update_from_dev.sh /usr/local/ispconfig/server/scripts/update_from_svn.sh /usr/local/ispconfig/server/scripts/update_from_tgz.sh
A quick look with phpmyadmin doesn't show anything obviously unpleasant in the db. I'm really stumped by this.
According to the log, the update failed to read in the sql database: Sun Jun 29 09:59:08 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/update.lib.php, Line 49: WARNING: could not read in ispconfig3.sql To fix this, redo the update: 1) backup the current dbispconfig database 2) restore the database version that you had before, you should find a sql dump in /var/backup/.... 3) Edit the ispconfig /usr/local/ispconfig/server/lib/config.inc.php file and set the version number to e.g. 3.0.5.3 4) run the ispconfig_update.sh srcipt again.
Thelevel of weirdness continues. I tried to babkup the db with mysqldump --all-databases > alldb.sql and it responded with mysqldump: unknown option '--Here is entries for some specific programs' and yes, I'm logged in as root. In the logs folder there is the following: drwx------ 2 root root 4096 Mar 27 2013 ispconfig_2013-03-27_12-08 drwx------ 2 root root 4096 Jun 11 2013 ispconfig_2013-06-11_06-35 drwx------ 2 root root 4096 Sep 12 2013 ispconfig_2013-09-12_22-16 drwx------ 2 root root 4096 Jun 29 09:58 ispconfig_2014-06-29_09-58 The recent one only two files, etc.tar.gz ispconfig_software.tar.gz. The others have three files... -rwx------ 1 root root 6670820 Sep 12 2013 etc.tar.gz -rwx------ 1 root root 396981 Sep 12 2013 ispconfig_db_backup.sql -rwx------ 1 root root 3965496 Sep 12 2013 ispconfig_software.tar.gz I'm guess you mean I should restore the one from Sep 12, 2013 yes?
I meant the one from ispconfig_2014-06-29_09-58, but if its not there then you should try to proceed with the database version that you have in dbispconfig at the moment. thats bad and the mysqldump issue is most likely the reason for the missing backup and the failed ispconfig update as the updater uses mysqldump as well. Try to sort out the mysqldump issue first as we cant install the update until the mysqldump and !mysql" commandline tool is working.
Hi Till. I followed what you said and here's ispconfig_install.log for it. Doesn't seem to have made any difference though. Thu Jul 3 07:43:32 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1941: EXECUTED: chmod +x /usr/local/ispconfig/server/scripts/create_daily_nginx_access_logs.sh /usr/local/ispconfig/server/scripts/create_jailkit_chroot.sh /usr/local/ispconfig/server/scripts/create_jailkit_programs.sh /usr/local/ispconfig/server/scripts/create_jailkit_user.sh /usr/local/ispconfig/server/scripts/ispconfig_update.sh /usr/local/ispconfig/server/scripts/run-getmail.sh /usr/local/ispconfig/server/scripts/update_from_dev.sh /usr/local/ispconfig/server/scripts/update_from_svn.sh /usr/local/ispconfig/server/scripts/update_from_tgz.sh Thu Jul 3 19:18:04 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/update.lib.php, Line 49: read in ispconfig3.sql Thu Jul 3 19:18:14 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 681: chmod on mysql-virtual_*.cf* Thu Jul 3 19:18:14 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 683: chgrp on mysql-virtual_*.cf* Thu Jul 3 19:18:15 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e alias_maps = hash:/etc/aliases, hash:/var/lib/mailman/data/aliases Thu Jul 3 19:18:15 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e alias_database = hash:/etc/aliases, hash:/var/lib/mailman/data/aliases Thu Jul 3 19:18:15 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e virtual_alias_domains = Thu Jul 3 19:18:15 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, proxy:mysql:/etc/postfix/mysql-virtual_email2email.cf, hash:/var/lib/mailman/data/virtual-mailman Thu Jul 3 19:18:15 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf Thu Jul 3 19:18:15 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf Thu Jul 3 19:18:15 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e virtual_mailbox_base = /var/vmail Thu Jul 3 19:18:15 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e virtual_uid_maps = static:5000 Thu Jul 3 19:18:15 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e virtual_gid_maps = static:5000 Thu Jul 3 19:18:15 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e inet_protocols=all Thu Jul 3 19:18:15 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtpd_sasl_auth_enable = yes Thu Jul 3 19:18:16 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e broken_sasl_auth_clients = yes Thu Jul 3 19:18:16 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtpd_sasl_authenticated_header = yes Thu Jul 3 19:18:16 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtpd_recipient_restrictions = check_recipient_access mysql:/etc/postfix/mysql-virtual_recipient.cf, permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination Thu Jul 3 19:18:16 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtpd_use_tls = yes Thu Jul 3 19:18:16 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtpd_tls_security_level = may Thu Jul 3 19:18:16 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtpd_tls_cert_file = /etc/postfix/smtpd.cert Thu Jul 3 19:18:16 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtpd_tls_key_file = /etc/postfix/smtpd.key Thu Jul 3 19:18:16 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e transport_maps = hash:/var/lib/mailman/data/transport-mailman, proxy:mysql:/etc/postfix/mysql-virtual_transports.cf Thu Jul 3 19:18:16 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e relay_domains = mysql:/etc/postfix/mysql-virtual_relaydomains.cf Thu Jul 3 19:18:16 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e relay_recipient_maps = mysql:/etc/postfix/mysql-virtual_relayrecipientmaps.cf Thu Jul 3 19:18:16 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks Thu Jul 3 19:18:16 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtpd_sender_restrictions = check_sender_access mysql:/etc/postfix/mysql-virtual_sender.cf Thu Jul 3 19:18:16 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtpd_client_restrictions = check_client_access mysql:/etc/postfix/mysql-virtual_client.cf Thu Jul 3 19:18:16 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtpd_client_message_rate_limit = 100 Thu Jul 3 19:18:16 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e maildrop_destination_concurrency_limit = 1 Thu Jul 3 19:18:16 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e maildrop_destination_recipient_limit = 1 Thu Jul 3 19:18:16 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e virtual_transport = maildrop Thu Jul 3 19:18:16 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e header_checks = regexp:/etc/postfix/header_checks Thu Jul 3 19:18:16 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e mime_header_checks = regexp:/etc/postfix/mime_header_checks Thu Jul 3 19:18:17 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e nested_header_checks = regexp:/etc/postfix/nested_header_checks Thu Jul 3 19:18:17 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e body_checks = regexp:/etc/postfix/body_checks Thu Jul 3 19:18:17 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e owner_request_special = no Thu Jul 3 19:18:17 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 748: EXECUTED: postconf -e smtp_tls_security_level = may Thu Jul 3 19:18:17 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 796: EXECUTED: chown vmail:vmail /var/vmail/.mailfilter Thu Jul 3 19:18:17 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 799: EXECUTED: chmod 600 /var/vmail/.mailfilter Thu Jul 3 19:18:20 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 952: EXECUTED: postconf -e dovecot_destination_recipient_limit = 1 Thu Jul 3 19:18:20 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 952: EXECUTED: postconf -e virtual_transport = dovecot Thu Jul 3 19:18:20 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 952: EXECUTED: postconf -e smtpd_sasl_type = dovecot Thu Jul 3 19:18:20 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 952: EXECUTED: postconf -e smtpd_sasl_path = private/auth Thu Jul 3 19:18:20 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1040: EXECUTED: postconf -e content_filter = amavis:[127.0.0.1]:10024 Thu Jul 3 19:18:20 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1040: EXECUTED: postconf -e receive_override_options = no_address_mappings Thu Jul 3 19:18:21 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1084: EXECUTED: chown -R getmail /etc/getmail Thu Jul 3 19:18:21 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1087: EXECUTED: chmod -R 700 /etc/getmail Thu Jul 3 19:18:23 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1530: EXECUTED: usermod -a -G ispapps www-data Thu Jul 3 19:18:23 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1427: rm -rf /etc/Bastille.backup Thu Jul 3 19:18:23 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1428: mv -f /etc/Bastille /etc/Bastille.backup Thu Jul 3 19:18:24 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1434: cp -f tpl/bastille-firewall.cfg.master /etc/Bastille/bastille-firewall.cfg Thu Jul 3 19:18:24 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1436: chmod 644 /etc/Bastille/bastille-firewall.cfg Thu Jul 3 19:18:24 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1463: mv -f /etc/init.d/bastille-firewall /etc/init.d/bastille-firewall.backup Thu Jul 3 19:18:24 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1464: cp -f apps/bastille-firewall /etc/init.d Thu Jul 3 19:18:24 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1465: chmod 700 /etc/init.d/bastille-firewall Thu Jul 3 19:18:24 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1467: mv -f /sbin/bastille-ipchains /sbin/bastille-ipchains.backup Thu Jul 3 19:18:24 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1468: cp -f apps/bastille-ipchains /sbin Thu Jul 3 19:18:24 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1469: chmod 700 /sbin/bastille-ipchains Thu Jul 3 19:18:24 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1471: mv -f /sbin/bastille-netfilter /sbin/bastille-netfilter.backup Thu Jul 3 19:18:24 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1472: cp -f apps/bastille-netfilter /sbin Thu Jul 3 19:18:24 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1473: chmod 700 /sbin/bastille-netfilter Thu Jul 3 19:18:32 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1714: EXECUTED: cp -rf ../interface /usr/local/ispconfig Thu Jul 3 19:18:32 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1718: EXECUTED: cp -rf ../server /usr/local/ispconfig Thu Jul 3 19:18:33 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1862: EXECUTED: chmod -R 750 /usr/local/ispconfig Thu Jul 3 19:18:33 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1866: EXECUTED: chown -R ispconfig:ispconfig /usr/local/ispconfig Thu Jul 3 19:18:33 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1924: EXECUTED: adduser www-data ispconfig Thu Jul 3 19:18:33 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1927: EXECUTED: adduser www-data ispapps Thu Jul 3 19:18:33 NZST 2014 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1941: EXECUTED: chmod +x /usr/local/ispconfig/server/scripts/create_daily_nginx_access_logs.sh /usr/local/ispconfig/server/scripts/create_jailkit_chroot.sh /usr/local/ispconfig/server/scripts/create_jailkit_programs.sh /usr/local/ispconfig/server/scripts/create_jailkit_user.sh /usr/local/ispconfig/server/scripts/ispconfig_update.sh /usr/local/ispconfig/server/scripts/run-getmail.sh /usr/local/ispconfig/server/scripts/update_from_dev.sh /usr/local/ispconfig/server/scripts/update_from_svn.sh /usr/local/ispconfig/server/scripts/update_from_tgz.sh
I mysqldump working now when you use it manually? and are you able to login to mysql with "mysql" command?
I seem to be able to, yes... root@laphroaig:~# mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 797 Server version: 5.5.37-0ubuntu0.12.04.1 (Ubuntu) Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
Yep, seems to be. root@laphroaig:~# mysqldump -p -A > fred2.sql Enter password: -- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly. root@laphroaig:~#
I had to deal with other stuff for a few weeks and just came back to this issue. Mysqldump and !mysql appear to be behaving correctly but I'm stumped on what to do next. Any ideas?
This is still giving me nightmares. !mysql and mysqldump seem to be working perfectly now. I followed the instructions you gave and ispconfig_update.sh completed but, I noticed this whilst it was running. This application will update ISPConfig 3 on your server. Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]: Creating backup of "/usr/local/ispconfig" directory... Creating backup of "/etc" directory... Checking ISPConfig database .. OK Starting incremental database update. ERROR 1071 (42000) at line 1: Specified key was too long; max key length is 1000 bytes Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0076.sql Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0077.sql ERROR 1091 (42000) at line 1: Can't DROP 'serverdomain'; check that column/key exists Loading SQL patch file: /tmp/ispconfig3_install/install/sql/incremental/upd_0078.sql Reconfigure Permissions in master database? (yes,no) [no]: Reconfigure Services? (yes,no) [yes]: Please, do you have any idea of how I can solve this problem? I'm tearing my hair out here. If needs be, is there some way I can reinstall ispconfig without losing the current configuration? Thanks.
Hmm, ok. Please copy this failed sql message and try to run it in the dbispconfig database with phpmyadmin and post the error that phpmyadmin shows to see why the sql fails.
