Change Password Patch for roundcube & vhcs2

[daniel.rosiles]

hi everybody, I'm new in this forum, and looking for a "change password patch" for roundcube & vhcs2 i found the oslad patch that is not compatible at all with vhcs2 panel, then i did a little retouch on this.

Steps to use the oslad patch with vhcs2 panel

Step 1

install the oslad patch
http://roundcubeforum.net/forum/index.php?topic=42.0

Step 2
Replace the original passwd.inc file with this one http://www.daniel.rosiles.com.mx/wp-...tch/passwd.inc
be sure the new passwd.inc file have the same user permissions than old passwd.inc file

Step 3
Open phpMyAdmin in your browser (should be http://yourdomain.tld/pma)
Open the query window (icon at the upper left corner) select the vhcs2 database and paste the following querys.
Important!!: Change ***PASSWORD*** to the password the new user should have.

GRANT USAGE ON vhcs2.* 
TO 'vhcs2-mail-user'@'localhost' IDENTIFIED BY '***PASSWORD***' 
WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;
GRANT SELECT (
`domain_id` , `domain_name`
) ON `vhcs2`.`domain` TO 'vhcs2-mail-user'@'localhost';
GRANT SELECT (
`mail_acc` , `domain_id`
), UPDATE (
`mail_pass` , `status`
) ON `vhcs2`.`mail_users` TO 'vhcs2-mail-user'@'localhost';

press OK.

Step 4

we need to edit "main.inc.php roundcube config file" and add the follow lines

$rcmail_config[’vhcs2_host’] = “localhost”;
$rcmail_config[’vhcs2_db’] = “vhcs2″; //your vhcs2 database
$rcmail_config[’vhcs2_user’] = “vhcs2-mail-user”; //your new mysql user
$rcmail_config[’vhcs2_passwd’] = “pass”; //pass for your new user
$rcmail_config[’pwd_length’] = 6; //minimum password length

Thats it

note: ***
I did this steps on VHCS® Pro v2.4.7.1 panel with Roundcube-0.1beta2; Linux dist debian etch amd64 on testing server

by the way one... excuse my english
by the way two... thanks for your patch oslad