Roundcube Community Forum

Release Support => Older Versions => Release Candidate 1 => Topic started by: yuanzhou on August 06, 2007, 05:39:51 AM

Title: change password for Postfix+Dovecot+Mysql+RoundCube
Post by: yuanzhou on August 06, 2007, 05:39:51 AM
Postfix+Dovecot+Mysql+RoundCube

the user's password stored in mysql
+----------+--------------+------+-----+---------+----------------+
| Field    | Type      | Null | Key | Default | Extra       |
+----------+--------------+------+-----+---------+----------------+
| id     | int(10)     | NO  | PRI | NULL  | auto_increment |
| account | varchar(255) | NO  |  |    |        |
| domain  | varchar(255) | NO |  |    |        |
| password | varchar(32) | NO |  |    |        |
| quota  | int(10)     | NO |  | 0   |        |
| alias   | int(10)     | NO |  | 0   |        |
+----------+--------------+------+-----+---------+----------------+



for example:
+----+---------+--------------+----------------------------------+-------+-------+
| id | account | domain     | password                 | quota | alias  |
+----+---------+--------------+----------------------------------+-------+-------+
| 1 | test1  |          | c4ca4238a0b923820dcc509a6f75849b |  0 |  0 |
| 2 | test2  |          | c4ca4238a0b923820dcc509a6f75849b |  0 |  0 |
| 3 | test3  |          | c4ca4238a0b923820dcc509a6f75849b |  0 |  0 |
+----+---------+--------------+----------------------------------+-------+-------+

How could I add the change_password to roundcubemail-0.1-rc1.1?

waht files should I change?

Please give me the details!

Regards!

Title: Re: change password for Postfix+Dovecot+Mysql+RoundCube
Post by: SKaero on August 06, 2007, 01:33:21 PM
Sorry but that can't be done that only there for the session cookie, that a sever side function.This is a plug-in for Roundcube to change your password in cpanel: http://roundcubeforum.net/forum/index.php?topic=42.0
Title: Re: change password for Postfix+Dovecot+Mysql+RoundCube
Post by: wfong on September 04, 2007, 07:13:08 PM
UPDATE user_table SET `password` = MD5( 'my_new_password') WHERE id = 1

-william