Current time: 06-21-2018, 07:16 AM Hello There, Guest! (LoginRegister)


Post Reply 
[HowTo] Password Change Roundcube 0.5 (and 0.4.2)
Author Message
Sweil Offline
Junior Member
*

Posts: 24
Joined: Mar 2009
Reputation: 2
Post: #1
[HowTo] Password Change Roundcube 0.5 (and 0.4.2)
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'); 


Attached File(s)
.php  ispcp-from-1.0.7.php (Size: 4.5 KB / Downloads: 290)
.php  ispcp-to-1.0.6.php (Size: 3.14 KB / Downloads: 58)
(This post was last modified: 03-19-2011 08:20 PM by Sweil.)
10-17-2010 09:52 AM
Find all posts by this user Quote this message in a reply
fulltilt Offline
Member
***

Posts: 1,225
Joined: Apr 2007
Reputation: 5
Post: #2
RE: [HowTo] Password Change Roundcube 0.4.2
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!
(This post was last modified: 10-18-2010 10:41 PM by fulltilt.)
10-18-2010 07:39 PM
Find all posts by this user Quote this message in a reply
Sweil Offline
Junior Member
*

Posts: 24
Joined: Mar 2009
Reputation: 2
Post: #3
RE: [HowTo] Password Change Roundcube 0.4.2
Thx for testing. I added a note about the mysql-permissions in the howto.
10-19-2010 01:15 AM
Find all posts by this user Quote this message in a reply
Canabalooza Offline


Posts: 3
Joined: Nov 2009
Reputation: 0
Post: #4
RE: [HowTo] Password Change Roundcube 0.4.2
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.
(This post was last modified: 11-27-2010 02:44 PM by Canabalooza.)
11-27-2010 02:43 PM
Find all posts by this user Quote this message in a reply
gandalf4711 Offline
Junior Member
*

Posts: 18
Joined: Jan 2009
Reputation: 0
Post: #5
RE: [HowTo] Password Change Roundcube 0.4.2
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
11-28-2010 03:18 AM
Visit this user's website Find all posts by this user Quote this message in a reply
kr00ft Offline
Newbie
*

Posts: 5
Joined: Nov 2010
Reputation: 0
Post: #6
RE: [HowTo] Password Change Roundcube 0.4.2
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?
11-30-2010 05:49 AM
Find all posts by this user Quote this message in a reply
Sweil Offline
Junior Member
*

Posts: 24
Joined: Mar 2009
Reputation: 2
Post: #7
RE: [HowTo] Password Change Roundcube 0.4.2
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.
(This post was last modified: 12-05-2010 03:20 AM by Sweil.)
11-30-2010 10:33 PM
Find all posts by this user Quote this message in a reply
kr00ft Offline
Newbie
*

Posts: 5
Joined: Nov 2010
Reputation: 0
Post: #8
RE: [HowTo] Password Change Roundcube 0.4.2
(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,

Sad

Thanks, I'll be waiting Wink
12-01-2010 02:11 AM
Find all posts by this user Quote this message in a reply
Sweil Offline
Junior Member
*

Posts: 24
Joined: Mar 2009
Reputation: 2
Post: #9
RE: [HowTo] Password Change Roundcube 0.4.2
Update in first post. Happy testing!
12-05-2010 03:19 AM
Find all posts by this user Quote this message in a reply
kr00ft Offline
Newbie
*

Posts: 5
Joined: Nov 2010
Reputation: 0
Post: #10
RE: [HowTo] Password Change Roundcube 0.4.2
Hi,

I have tested, don't work Sad
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;
===
(This post was last modified: 12-05-2010 04:38 AM by kr00ft.)
12-05-2010 04:32 AM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)