[HowTo] Password Change Roundcube 0.5 (and 0.4.2)

[Sweil]

Update! Tested with Roundcube 0.5 & 0.5.1 => works!
Update! New driver for ispCP 1.0.7 and newer!

As the previous Version is not working for 0.4.2 I made up a new (more robust) one, based on roundube's default password plugin.

1. Download script from attachment depending on your ispCP version:
- for 1.0.7 and newer: ispcp-from-1.0.7.php (beta)
- for older versions: ispcp-to-1.0.6.php

2. Rename file to "ispcp.php" and upload to "[roundcube]/plugins/password/drivers/".

3. Open "[roundcube]/plugins/password/config.inc.php" and change 'password_driver' to "ispcp":

PHP Code:

$rcmail_config['password_driver'] = 'ispcp'; 


4. Set up the MySQL-Login by changing

PHP Code:

$rcmail_config['password_db_dsn'] = 'mysql://roundcube:password@localhost/ispcp'; 


(make sure the choosen MySQL-Connection has permissions to modify at least the 'mail-users'-table in the ispcp-database)
and adding

PHP Code:

// ispCP Driver options
$rcmail_config['ispcp_db_pass_key'] = '';
$rcmail_config['ispcp_db_pass_iv'] = ''; 


at the end of the the file using the keys from "/var/www/ispcp/gui/include/ispcp-db-keys.php".

5. Change any other options you need (e.g. 'password_confirm_current' or 'password_minimum_length').

6. Enable the plugin in "[roundcube]/config/main.inc.php" by modifying the 'plugins' option like this:

PHP Code:

$rcmail_config['plugins'] = array('password'); 


[fulltilt]

hm - the password changer did not work for me ...
i'm able to login, receive and sent mails but if i try to change password:

Code:

new password not saved

### edit ###

i fixed permissions for roundcube mysql user:

Code:

mysql -p
GRANT SELECT , UPDATE ON `ispcp`.`mail_users` TO 'roundcube'@'localhost';
quit

now it's working!

[Sweil]

Thx for testing. I added a note about the mysql-permissions in the howto.

[Canabalooza]

This doesn't seem to be working for me on the new 1.0.7 final release. When resetting the password via roundcube 0.4.2 the email password does not update and unless you login to the ispcp mysql database to change the status field back to "OK" you are unable to edit the account via the admin panel. The account still logs in ok but using the old password. I've tested this with full permissions for the roundcube user as well as with only update access to the mail_pass and status fields. I have also verified my database keys and redone all of the settings on two separate servers. Any help would be greatly appreciated.

[gandalf4711]

Hello together,

I had the same problem. I used some other pw changer before, that doesn't worked at all.
With that code, it tells me that the pw is changed, but when I try to log in, it only works with the old pw.
In the ispcp db, mail_users, the status is set to 'change'.
I had to run the ISPCP Demon Tool to set the mail_users Status to 'OK'
Then the pw is changed ...
any suggestions

regards

[kr00ft]

Hello,

I have the same problem, in webmail the status is set to 'change', in the mysql table the users pass is changed, but in webmail login the old password work, new not.

Any suggestions?

[Sweil]

Hi Folks, ispCP 1.0.7 changes the way how a new password is set. So this HowTo will only work for versions <= 1.0.6. As I didn't upgrade yet, I won't fix it within the next weeks.

Edit: There is an update in first post.

[kr00ft]

(11-30-2010 10:33 PM)Sweil Wrote:  Hi Folks, ispCP 1.0.7 changes the way how a new password is set. So this HowTo will only work for versions <= 1.0.6. As I didn't upgrade yet, I won't fix it within the next weeks.

Hi,



Thanks, I'll be waiting

[Sweil]

Update in first post. Happy testing!

[kr00ft]

Hi,

I have tested, don't work
Same problem.

---

Hey,

the log in syslog:

===
Dec 4 18:37:35 hst01 ispcp_daemon[11394]: child 11394 started!
Dec 4 18:37:35 hst01 ispcp_daemon[11394]: send_line(): socket write error: Connection reset by peer
Dec 4 18:37:36 hst01 authdaemond: stopping authdaemond children
Dec 4 18:37:36 hst01 authdaemond: modules="authuserdb authpam", daemons=5
Dec 4 18:37:36 hst01 authdaemond: Installing libauthuserdb
Dec 4 18:37:36 hst01 authdaemond: Installation complete: authuserdb
Dec 4 18:37:36 hst01 authdaemond: Installing libauthpam
Dec 4 18:37:36 hst01 authdaemond: Installation complete: authpam
Dec 4 18:37:36 hst01 ispcp_daemon[4218]: EINTR was received! continue;
===