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-content/roundcube/patch/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.

Code Select Expand

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

Code Select Expand

$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