[HowTo] Password Changer Roundcube 0.3 Stable

[paladino]

yes i'm using the plugin (the second) and its only works with changes.

without change, the plugin only change password on mysql database and email login only is possible with older password

[TheCry]

Sorry, but i can't confirm your problem.
If i change the password and i logged out. I must use the new password.
The old password doesn't work in Roundcube.
Only the new password give me access

[reznor]

Hello TheCry,

first of all: thank you for your great plugin!
I have the same problem as paladino.

I also found out the following:
In my case it's an ispcp installation with courier-imap as imap server.
Courier-imap authorizes users with its provided authdaemon which uses "userdb" to save login/pass information in a flat file as default.
If I change my email password through ispcp, the mail_pass field in the ispcp db is changed appropriately AND ispcp makes this change in the "userdb" file, too.
So if I change the password with ispcp, ispcp "talks" to courier-imap and tells it the new password.
If I change the password with your roundcube plugin, the password is updated correctly in the ispcp db but NOT in the "userdb" flat file.
Are you using dovecot or some other imap server?

Perhaps this problem can be resolved by telling courier-imap's authdaemon to use the ispcp mail_users mysql table to authorize users.
But this leads to the next problem: password encryption.
In ispcp passwords get encrypted with mcrypt, in courier-imap it's crypt as far as I found out.

[TheCry]

Hi reznor!
Yes... I use dovecot...
You explained it very well.
I will change the code how paladino describes...
Then the error will be fixed.
Thank you for testing and explaining!

Edit:
I have attached a modified version for courier on the first site of this thread.

[reznor]

Woah, you are fast!
Thanks again!

[reznor]

Additionally I had to alter the mysql query in sql.php a bit:

PHP Code:

$sql = "UPDATE `mail_users` SET `mail_pass` = %p, status = 'change'  WHERE `mail_addr` = %u LIMIT 1"; 


If I don't alter the query, the ispconfig_daemon does not update the password change in courier.
Even if I telnetted to localhost:9876 and told the daemon "execute query" as shown in send_request() it would not update the password.
After adding "status='change'" to indicate the password change, it worked flawlessly.

[TheCry]

I remember from the old password changer that the table is updated with the status "change".
I've added the line to the driver.
New package updated on the first site of this thread.

[paladino]

Yes, the TheCry explained my problem! I do not know much English and did not know the details about why it not worked before. Also had forgotten to talk about the change in the MySQL query that was necessary. Well that was all resolved. Thanks to everyone and hugs.

[sfera]

Hello.

I have a little big problem hehehe

I'm use the manual and i get some errors.

First I supose I need create the dns (cube.domain.tld)
Is correct?

The second when I logged in the Roundcube Instantaly I get the next error : "Error in the server! (not found) and i get logout from the webmail. I attach a screenshot from the error.

Any idea

Thx in advanced

[TheCry]

Hi sfera,
what you talking about?

Does Roundcube not work or do you have problems after integrating the passwordchanger?

Which version of roundcube are you using?