ehcp Upgrade to version 0.29

Please use


New info:
Update script that may help you is at
download and run that script at your server's console..

Old info:
Unfortunately, There is no fully automatic upgrade script/program yet...
it is better to re-install if you have a few domains..
Look at too
Or you need to handle it manually as follows:

Basicly, there is no major/core change in ehcp ver. 0.28,
So, if you copy new version files to where you installed (/var/www/vhosts/ehcp),
ehcp starts to work, without error.. i think..
after copy, run /etc/init.d/ehcp restart

new version introduces some minor db changes,
so you will get some db errors if you add new domain or do something in panel.

To fix those errors, alter your tables accordingly..
For example, if you get like: mysql error, field xxxx not found,
then add that field to your mysql manually...
You may compare your sql structure, with ehcp.sql file, included in new download, and add required fields to your tables..

most tables has an additional field called host,
script table added field commandsaftercopy text,
scripts_log table added in ver 0.28,

New in mails:
Since ver 0.28 supports e-mail user login,
mail user passwords changed to be plaintext,
so, your old emails wont work with new version.
To fix this, reset all email passwords to a fixed value and inform your email users..
to do this, you may issue sql: update emailusers set password='123';

more explanation may be written here soon. or mail me..

You may apply this info for all versions->0.28 upgrade..
Sory for, not having time to write an upgrade program.
if somebody writes such a program/script, attach/comment here please..
Only mysql queries enaugh too..

How safe is it to upgrade from 0.27 to 0.29 with this script? What can go wrong?

After you can upgrade... if something goes wrong, you may restore them..
The risk depends on your system... Normally, this only upgrades ehcp... i tested and states to be working..

Your domains is not deleted, your ehcp db is not deleted, the risk rarely maybe: your sites maynot function if something is wrong related to your apache settings.. in this case, you may just restore your files/db.

I upgraded to 0.29 and everything works ok. I had a few problems with the mysql password, but after changing the password for the ehcp user it worked.

new feature with ehcp ver 0.29: Upgrade db tables automatically..
ehcp automatically checks for ehcp tables for any missing fields that are added recently to tables, and add those fields automatically to ehcp db upon first run..
This way, when you go to your ehcp page first time, any missin "new" fields automatically added..

Using the download goes well also is the extraction but than a sql related error is displayed.

Please advice!

--2009-11-17 13:50:53--
Connecting to||:80... connected.
HTTP request sent, awaiting response... 403 Forbidden
2009-11-17 13:50:53 ERROR 403: Forbidden. line 13: ehcpupgrade.sql: No such file or directory
cp: cannot stat `ehcp.bck.Tue': No such file or directory
cp: cannot stat `Nov': No such file or directory
cp: cannot stat `17': No such file or directory
cp: cannot stat `13:50:40': No such file or directory
cp: cannot stat `CET': No such file or directory
cp: cannot stat `2009/config.php': No such file or directory
upgrade finished.
Reading package lists... Done
Building dependency tree
Reading state information... Done
webalizer is already the newest version.
php5-curl is already the newest version.
php5-xmlrpc is already the newest version.
php-pear is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

Although there is one error the installed EHCP version seems to be 0.29.11

You're not your job. You're not how much money you have in the bank. You're not the car you drive. You're not the contents of your wallet. You're not your fucking khakis. You're the all-singing, all-dancing crap of the world.

as stated on above of this page, please follow

The script in your case may be out of date,
best is to follow , as of now (2009-11-17, Ymd)
maybe in future, i will automate this task more..