Author Topic: change password for Postfix+Dovecot+Mysql+RoundCube  (Read 9114 times)

Offline yuanzhou

  • Newbie
  • *
  • Posts: 4
change password for Postfix+Dovecot+Mysql+RoundCube
« 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!


Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,517
    • http://SKaero.com/
Re: change password for Postfix+Dovecot+Mysql+RoundCube
« Reply #1 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

Offline wfong

  • Newbie
  • *
  • Posts: 9
Re: change password for Postfix+Dovecot+Mysql+RoundCube
« Reply #2 on: September 04, 2007, 07:13:08 PM »
UPDATE user_table SET `password` = MD5( 'my_new_password') WHERE id = 1

-william