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 3.0.2.1 to 3.0.2.2 >> 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...)
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 3.0.3.3 instead of ISPConfig 3.0.2.2 by downloading ispconfig 3.0.3.3 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 3.0.3.3 installed.
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.
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.
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...
