desperate, db cleared during update

Discussion in 'Installation/Configuration' started by gilas, Nov 7, 2011.

  1. gilas

    gilas Member

    Hi Till and members,
    since today I haven't problems during UPDATES with ISPCONFIG 3.

    Recently I bought a VPS (note: following an offer from your site), so I have a VPS with centOS 5.5 and ISPConfig preinstalled.

    I attempted to update ISPConfig then downloaded the version. I attempted to start from /tmp dir, but ISPConfig tell me to run update.php from inside the install directory, so:

    cd ispconfig3..../install/ and then:

    php ./update.php

    this the result:

    Update from to

    >> Update

    Operating System: Redhat or compatible, unknown version.

    This application will update ISPConfig 3 on your server.
    MySQL root password []: <right password>

    ERROR: Unable to load SQL-Dump into database table.

    just entered in mysql with the right password
    as user ispconfig, the database disappeared :-(

    mysql> use dbispconfig;
    Database changed
    mysql> show tables;
    Empty set (0.00 sec)

    can anyone help me? (I have a db copy, /etc saved, previous ispconfig.tar.gz saved...)
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Which ISPConfig version was installed in the vps?
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    I recommend to follow these steps:

    1) Restore the ispconfig mysql database, you can do this e.g. with phpmyadmin or go back to a recent restore point of your vm.
    2) Update to ispconfig instead of ISPConfig by downloading ispconfig tar.gz, unpack it and run the update.php script in the install folder.
    3) If you want to update to ispconfig 3.0.4, then you can do this now when your system has at least ISPConfig installed.
  4. gilas

    gilas Member

    version and kind of problem

    Dear Till
    I appreciate your help and I discovered what happens (partially).
    Tonight I tried to do a optimize & repair table, but before I have run

    mysql_upgrade -p root -u

    maybe there was some problems with db.

    Infact I want to do the update because since today I was not able to login in ADMIN panel.

    Just issued mysqld_upgrade and repair/optimized all db and tables all is fine.

    Two day ago I experienced that, because this, mysql ran slow and the apache processes grow until lock the VPS. Now all seems to work.

    Anyway I want to try the migration and try to update to 3.0.3 and then 3.0.4 making the backup before.

    please do not close this ticket, so I can confirm that the process is terminated correctlty.
  5. gilas

    gilas Member

    another error...

    This is a minor problem:
    I downloaded ISPConfig v.3.0.3 then ran the update.
    All goes fine; all service was reconfigured and at the end httpd was stopped due this error:

    Syntax error on line 47 of /etc/httpd/conf/sites-enabled/000-ispconfig.vhost:
    Invalid command 'SSLEngine', perhaps misspelled or defined by a module not included in the server configuration

    ok this seems to be the module SSL to install.
    I suppose the next update from 3.0.3 to 30.4 should finish right.

    Till thank very much for your work.
  6. gilas

    gilas Member

    all OK, post closed...

    Hi Till
    the problem was this:

    just upgraded to v. 3.0.3
    the installed asked me to create certificates, then the file 000-ispconfig.vhost was modified

    to restart http I have commented out the (3) lines starting from

    SSL ...

    to remove certificate reference

    then I installed mod_ssl, under centOS:

    yum install mod_ssl

    removed the comment within 000-ispconfig.vhost file but certs was not loaded; apache asked me (ms iexplorer) to confirm and the page was not generated.

    Ok: I updated to v.3.0.4 without regenerate certs and .... now all wors fine and without any problem...

Share This Page