I am using roundcube Password Plugin. I enabled sql driver with this query. pgsql is my backend db.
$rcmail_config['password_query'] = 'UPDATE dbmail_users SET passwd=%p WHERE userid=%u AND passwd=%o'; I think there is a problem in creating new md5 crypt password file. i can use passwd=md5(%p) but seems there is different between dbmail-users and this function. dbmail-users -a [email protected] -p md5 -w mypassword dbmail=# SELECT userid,passwd,encryption_type FROM dbmail_users WHERE userid = '[email protected]'; userid | passwd | encryption_type ---------------------+------------------------------------+----------------- [email protected] | $1$I3h0HAbH$fbyAtdRM1nGtpDu0d61DM/ | md5 dbmail=# SELECT md5('mypassword'); md5 ---------------------------------- 34819d7beeabb9260a5c854bc85b3e44 (1 row) On Mon, Feb 24, 2014 at 12:53 AM, Reindl Harald <[email protected]>wrote: > > > Am 23.02.2014 22:17, schrieb Mr.Pine: > > but a new problem with roundcube: can not change user password with md5 > crypted passwd > > how do you expect roundcube which is a imap client to change the > password in the dbmail database? > > > _______________________________________________ > DBmail mailing list > [email protected] > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > >
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
