Any 0.3.1 Mysql password changer?

[kknddandy]

Hi all,

I am newbie here, just tried to install roundcube on my server, I used postfix + mysql to create virual domain and users.

Is there any plugin available for the 0.3.1 version?

thx

[JohnDoh]

There is a password plugin which ships with 0.3.1, it supports changing passwords in sql.

[kknddandy]

Hi, the password plugin is cool, and it could change the password, but the problem is the password stored in my database was encrypted in md5crypt format, and the password seem encrypt the password in DES, I guess, the encrypted password are shorter than original one.
    So, once the user changed their password in roundcube, roundcube could not send any mail any more, cuz the password is in different format I guess.

    Is there any way to make the plugin encrypt password into md5crypt format? Thanks!!!

[SKaero]

I think they are encoded with md5 but there salted, just modify the sql driver to get it to mach your database.

[kknddandy]

Thanks.



i tried to modify config.php.inc , to be like this
$rcmail_config['password_query'] = "UPDATE mailbox SET password = %c, modified=now() WHERE username = %u LIMIT 1;";
the password in database is now in format "$1$", but just something wrong,


I checked the drivers/sql.php, but it is really too hard for me, I don't know which line should be modified.

I used posfixadmin to create mailbox also the encrypted password, will you give me a little help on this?

[SKaero]

Thanks.



i tried to modify config.php.inc , to be like this
$rcmail_config['password_query'] = "UPDATE mailbox SET password = %c, modified=now() WHERE username = %u LIMIT 1;";
the password in database is now in format "$1$", but just something wrong,


I checked the drivers/sql.php, but it is really too hard for me, I don't know which line should be modified.

I used posfixadmin to create mailbox also the encrypted password, will you give me a little help on this?

If you just need to be encoded with MD5 do:
$rcmail_config['password_query'] = "UPDATE mailbox SET password = md5(%p), modified=now() WHERE username = %u LIMIT 1;";

[kknddandy]

Hi , Thanks for replying me so quick.

er.... the password created by postfix admin was encrypted in MD5CRYPT format
but the dovecot can read it, also can smtp it, the setting in dovecot is MD5-CRYPT

So the password must be encrypted in MD5crypt format not MD5 check sum.

[SKaero]

Ah, I don't know as much about MD5-CRYPT, I don't see what wrong with the

Code: [Select]

$rcmail_config['password_query'] = "UPDATE mailbox SET password = %c, modified=now() WHERE username = %u LIMIT 1;"; Do you have a custom salt?

[Martian]

You can change the password encryption format in both postfixadmin and dovecot.  Most SASL formats are supported by both programs.  I think MD5-Crypt is a Dovecot specific thing but I could be wrong.  The key will be finding one that Postfixadmin, Dovecot, and Roundcube can all understand.

I would recommend trying CRAM-MD5.  I know for a fact both Postfixadmin and Dovecot can handle that.  Perhaps Skaero will know how to use CRAM-MD5 in Roundcube.

Martian

[sasi]

Hi, the password plugin is cool, and it could change the password, but the problem is the password stored in my database was encrypted in md5crypt format, and the password seem encrypt the password in DES, I guess, the encrypted password are shorter than original one.
    So, once the user changed their password in roundcube, roundcube could not send any mail any more, cuz the password is in different format I guess.

    Is there any way to make the plugin encrypt password into md5crypt format? Thanks!!!

HI KKnddandy,
     
              can you please explain how to enable the password plugin in roundcube 0.3.1

[waqarhassan41]

Very nice post thanks dear friends thanks agian
Webmaster Forum  Free software

[d3v4]

Thanks.



i tried to modify config.php.inc , to be like this
$rcmail_config['password_query'] = "UPDATE mailbox SET password = %c, modified=now() WHERE username = %u LIMIT 1;";
the password in database is now in format "$1$", but just something wrong,


I checked the drivers/sql.php, but it is really too hard for me, I don't know which line should be modified.

I used posfixadmin to create mailbox also the encrypted password, will you give me a little help on this?

i'm using a little difference from your code

Code: [Select]


$rcmail_config['password_query'] = 'UPDATE mailbox SET password = %c, modified=now() WHERE username = %u LIMIT 1';


worked like a charm, thank you..............