SQL on screen and I can't log in.

Discussion in 'Installation/Configuration' started by Trunkles, Jun 29, 2014.

  1. Trunkles

    Trunkles Member

    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.

    [​IMG]

    Anyone got any ideas of how to fix this? Pretty please?
     
  2. srijan

    srijan New Member HowtoForge Supporter

    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
     
  3. Trunkles

    Trunkles Member

    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
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    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?
     
  5. Trunkles

    Trunkles Member

    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
     
  6. Trunkles

    Trunkles Member

    So whichever version was current in last September. :)
     
  7. Trunkles

    Trunkles Member

    A quick look with phpmyadmin doesn't show anything obviously unpleasant in the db. I'm really stumped by this. :(
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  9. Trunkles

    Trunkles Member

    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. :confused:

    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?
     
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  11. Trunkles

    Trunkles Member

    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
     
  12. till

    till Super Moderator Staff Member ISPConfig Developer

    I mysqldump working now when you use it manually? and are you able to login to mysql with "mysql" command?
     
  13. Trunkles

    Trunkles Member

    I seem to be able to, yes...

    [email protected]:~# 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>
     
  14. till

    till Super Moderator Staff Member ISPConfig Developer

    Ok. And the mysqldump that failed before is working again too?
     
  15. Trunkles

    Trunkles Member

    Yep, seems to be.

    [email protected]:~# mysqldump -p -A > fred2.sql
    Enter password:
    -- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
    [email protected]:~#
     
  16. Trunkles

    Trunkles Member

    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. :confused:

    Any ideas?
     
  17. Trunkles

    Trunkles Member

    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.
     
  18. till

    till Super Moderator Staff Member ISPConfig Developer

    the update errors are not critical, so the database content and scheme should be ok.
     
  19. Trunkles

    Trunkles Member

    Great, trouble is, I still get the SQL on the screen and can't log in. :(
     
  20. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     

Share This Page