Problem while update

Discussion in 'Installation/Configuration' started by MichalCerny, Jul 27, 2012.

  1. MichalCerny

    MichalCerny New Member

    Hey,

    I run ispconfig_update.sh command and after selecting stable and yes for backup its stop at this http://cl.ly/ILnj if I select stable and no for backup its stop too. ISPconfig now dont working and I cant update. Someone can help me? Thanks
     
  2. MichalCerny

    MichalCerny New Member

    I updated because monitor in ispconfig not work and today if created database its shows in ispconfig but I cant login in to it in phpmyadmin. Thanks for support.
     
  3. MichalCerny

    MichalCerny New Member

    Ok i found in install log this, perhaps it will help.

    HTML:
    Fri Jul 27 01:06:04 CEST 2012 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/update.lib.php, Line 38: read in ispconfig3.sql
     
  4. till

    till Super Moderator

    This is ost likely a issue with the shell, the script is not stopped,you just dont see the cursor prompt. Please press return.

    The most likely reason is that your mysql root password has been changed and you did not set the new root password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf. This can also be the resaon for your update problem. You might also want to check your php.ini file if there are any functions disabled.
     
  5. MichalCerny

    MichalCerny New Member

    If i press enter its do nothing http://cl.ly/INp6 what about the error in ispconfig_install.log?

    Fri Jul 27 10:29:27 CEST 2012 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/update.lib.php, Line 38: read in ispconfig3.sql
     
  6. MichalCerny

    MichalCerny New Member

    Ok I changed db user and password in usr/local/ispconfig/server/lib/config.php to db user and password same in usr/local/ispconfig/server/lib/mysql_clientdb.conf and now after backup in update its type this

    mysqldump: Got error: 23: Out of resources when opening file './dbispconfig/web_folder.MYD' (Errcode: 24) when using LOCK TABLES
    Checking ISPConfig database ..

    ispconfig_install.log still type
    Fri Jul 27 10:50:01 CEST 2012 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/update.lib.php, Line 38: read in ispconfig3.sql

    any suggestions, help? Thanks
     
  7. till

    till Super Moderator

    Thats not a god idea, please undo that before your setup gets broken. The file /usr/local/ispconfig/server/lib/config.php may never contain the root user and password.

    This indicates a resource problem, e.g. a full harddisk. Please post the output of:

    df -h

    and run a repair in phpmyadmin on all tables in the dbispconfig database.
     
  8. MichalCerny

    MichalCerny New Member

    Filesystem Size Used Avail Use% Mounted on
    /dev/sda2 59G 2.3G 54G 5% /
    tmpfs 1004M 0 1004M 0% /dev/shm
    /dev/sda1 291M 45M 232M 17% /boot
     
  9. till

    till Super Moderator

    Ok. And what about the database check?

    And please post the output of the command:

    free
     
  10. MichalCerny

    MichalCerny New Member

    I have problem now I backup back the config.php file and cant access to phpmyadmin type "#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)"

    and error log in httpd types .. kill me now I'm idiot

    [Fri Jul 27 11:39:27 2012] [notice] caught SIGTERM, shutting down
    [Fri Jul 27 11:39:28 2012] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
    [Fri Jul 27 11:39:28 2012] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
    [Fri Jul 27 11:39:28 2012] [warn] RSA server certificate CommonName (CN) `31.31.7.6' does NOT match server name!?
    [Fri Jul 27 11:39:28 2012] [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
    panic: fold_constants JMPENV_PUSH returned 2 at /usr/local/ispconfig/server/scripts/vlogger line 229.
    [Fri Jul 27 11:39:28 2012] [notice] Digest: generating secret for digest authentication ...
    [Fri Jul 27 11:39:28 2012] [notice] Digest: done
    DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 257
    [Fri Jul 27 11:39:28 2012] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
    [Fri Jul 27 11:39:28 2012] [warn] RSA server certificate CommonName (CN) `31.31.7.6' does NOT match server name!?
    [Fri Jul 27 11:39:28 2012] [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC 4366)
    [Fri Jul 27 11:39:28 2012] [notice] Apache/2.2.15 (Unix) DAV/2 mod_fcgid/2.3.6 PHP/5.3.2 mod_ruby/1.3.0 Ruby/1.8.7(2010-06-23) mod_ssl/2.2.15 OpenSSL/1.0.0-fips configured -- resuming normal operations
    DBI connect('database=dbispconfig;host=localhost:3306','ispconfig',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/local/ispconfig/server/scripts/vlogger line 514
    DBI Error: at /usr/local/ispconfig/server/scripts/vlogger line 514, <STDIN> line 2.
     
  11. MichalCerny

    MichalCerny New Member

    Its ok! I restarted mysql and httpd and now work :)

    dbispconfig.attempts_login repair status OK
    dbispconfig.client repair status OK
    dbispconfig.client_template repair status OK
    dbispconfig.country repair status OK
    dbispconfig.cron repair status OK
    dbispconfig.dns_rr repair status OK
    dbispconfig.dns_slave repair status OK
    dbispconfig.dns_soa repair status OK
    dbispconfig.dns_template repair status OK
    dbispconfig.domain repair status OK
    dbispconfig.firewall repair status OK
    dbispconfig.ftp_user repair status OK
    dbispconfig.help_faq repair status OK
    dbispconfig.help_faq_sections repair status OK
    dbispconfig.iptables repair status OK
    dbispconfig.mail_access repair status OK
    dbispconfig.mail_content_filter repair status OK
    dbispconfig.mail_domain repair status OK
    dbispconfig.mail_forwarding repair status OK
    dbispconfig.mail_get repair status OK
    dbispconfig.mail_mailinglist repair status OK
    dbispconfig.mail_relay_recipient repair status OK
    dbispconfig.mail_traffic repair status OK
    dbispconfig.mail_transport repair status OK
    dbispconfig.mail_user repair status OK
    dbispconfig.mail_user_filter repair status OK
    dbispconfig.monitor_data repair info Found block with too small length at 21888; Skippe...
    dbispconfig.monitor_data repair info Found link that points at 32433639618131258 (outsi...
    dbispconfig.monitor_data repair info Found block that points outside data file at 59620
    dbispconfig.monitor_data repair info Found block with too small length at 69320; Skippe...
    dbispconfig.monitor_data repair info Found block with too small length at 69348; Skippe...
    dbispconfig.monitor_data repair info Found block with too small length at 71192; Skippe...
    dbispconfig.monitor_data repair info Found link that points at 32433613949248085 (outsi...
    dbispconfig.monitor_data repair info Found block with too small length at 73812; Skippe...
    dbispconfig.monitor_data repair info Found block that points outside data file at 77364
    dbispconfig.monitor_data repair info Found block that points outside data file at 77440
    dbispconfig.monitor_data repair info Found block that points outside data file at 80628
    dbispconfig.monitor_data repair info Found block that points outside data file at 81024
    dbispconfig.monitor_data repair info Found block that points outside data file at 84324
    dbispconfig.monitor_data repair info Found block that points outside data file at 84468
    dbispconfig.monitor_data repair info Found block that points outside data file at 85660
    dbispconfig.monitor_data repair info Found block with too small length at 85712; Skippe...
    dbispconfig.monitor_data repair info Found block that points outside data file at 85924
    dbispconfig.monitor_data repair info Found block that points outside data file at 86680
    dbispconfig.monitor_data repair info Found block that points outside data file at 86808
    dbispconfig.monitor_data repair info Found block that points outside data file at 86916
    dbispconfig.monitor_data repair info Found block that points outside data file at 86948
    dbispconfig.monitor_data repair info Found block that points outside data file at 89260
    dbispconfig.monitor_data repair info Found block that points outside data file at 89772
    dbispconfig.monitor_data repair info Found block that points outside data file at 90176
    dbispconfig.monitor_data repair info Found block that points outside data file at 90704
    dbispconfig.monitor_data repair info Found block with too small length at 94732; Skippe...
    dbispconfig.monitor_data repair info Found block that points outside data file at 96636
    dbispconfig.monitor_data repair info Found block that points outside data file at 96680
    dbispconfig.monitor_data repair info Found block that points outside data file at 99024
    dbispconfig.monitor_data repair info Found block with too small length at 112792; Skipp...
    dbispconfig.monitor_data repair info Found block with too small length at 112824; Skipp...
    dbispconfig.monitor_data repair info Found block that points outside data file at 11288...
    dbispconfig.monitor_data repair warning Number of rows changed from 38 to 15
    dbispconfig.monitor_data repair status OK
    dbispconfig.openvz_ip repair status OK
    dbispconfig.openvz_ostemplate repair status OK
    dbispconfig.openvz_template repair status OK
    dbispconfig.openvz_traffic repair status OK
    dbispconfig.openvz_vm repair status OK
    dbispconfig.remote_session repair status OK
    dbispconfig.remote_user repair status OK
    dbispconfig.server repair status OK
    dbispconfig.server_ip repair status OK
    dbispconfig.shell_user repair status OK
    dbispconfig.software_package repair status OK
    dbispconfig.software_repo repair status OK
    dbispconfig.software_update repair status OK
    dbispconfig.software_update_inst repair status OK
    dbispconfig.spamfilter_policy repair status OK
    dbispconfig.spamfilter_users repair status OK
    dbispconfig.spamfilter_wblist repair status OK
    dbispconfig.support_message repair status OK
    dbispconfig.sys_config repair status OK
    dbispconfig.sys_datalog repair status OK
    dbispconfig.sys_dbsync repair status OK
    dbispconfig.sys_filesync repair status OK
    dbispconfig.sys_group repair status OK
    dbispconfig.sys_ini repair status OK
    dbispconfig.sys_log repair status OK
    dbispconfig.sys_remoteaction repair status OK
    dbispconfig.sys_session repair status OK
    dbispconfig.sys_user repair status OK
    dbispconfig.webdav_user repair status OK
    dbispconfig.web_database repair status OK
    dbispconfig.web_domain repair status OK
    dbispconfig.web_folder repair status OK
    dbispconfig.web_folder_user repair status OK
    dbispconfig.web_traffic repair status OK
     
  12. MichalCerny

    MichalCerny New Member

    Thanks for support! Its works now and I have latest ispconfig. Monitor in inspconfig works perfect and databases created in ispconfig now works too. Thank you again!! You are great!
     

Share This Page