ehcp Password Recovery

[ehcpdeveloper]

if you installed ehcp, and somehow forgot/lost your ehcp admin password, or it does not accept password follow these:

Prerquisities:
* You must be able to connect your server by ssh, and you know your root password of your server.
if you dont know root password of server, you can't do anything. in this case, you need to re-install your server or perform root password recovery.

* You must know mysql root password. if you dont know, do one of these:
go to /var/www/vhosts/ehcp dir, cat config.php (look into that file with cat or vi) dbrootpass is written there
or, do mysql password recovery as described in http://www.ehcp.net/?q=node/160

* You must be able to connect your server by ssh and web (port 80)


Steps to recover ehcp admin login pass:
* connect your server by ssh
* on command line, mysql -p
use ehcp;
update panelusers set password=md5('1234') where panelusername='admin';

This way, you should be able to login to your ehcp using password 1234




Restored from old drupal forum, for user uid:1 username:ehcpdeveloper
You may reset your password to access your new account here.

[mnrbig]

I get the following error when following the obove. Does anyone know why?

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ehcp update panelusers set password=md5('1234') where panelusername=('admin')' at line 1


Restored from old drupal forum, for user uid:1 username:ehcpdeveloper
You may reset your password to access your new account here.

[ehcpdeveloper]

you forgot a semicolon, after ehcp
correct is:
use ehcp ;
update panelusers set password=md5('1234') where panelusername='admin';


Restored from old drupal forum, for user uid:3542 username:mnrbig
You may reset your password to access your new account here.

[mnrbig]

Don't you just hate copy and paste (-;

Restored from old drupal forum, for user uid:1 username:ehcpdeveloper
You may reset your password to access your new account here.

[carl97]

What is the Default vmail password ? Admin password does not work
Please does anyone have a solution ?


Restored from old drupal forum, for user uid:3542 username:mnrbig
You may reset your password to access your new account here.

[ehcpdeveloper]

what you mean by vmail password ? I did not understand. explain more.

Restored from old drupal forum, for user uid:3933 username:carl97
You may reset your password to access your new account here.