现有roundcube+postfixadmin的环境,
用了roundcube自带的password插件修改密码,但是postfixadmin的密码加密方式是CRAM-MD5,
下面这句就是明文的,
UPDATE mailbox SET password=%p WHERE username=%u
我在phpmyadmin里面看到CRAM-MD5编码方式得到的是
{CRAM-MD5}e242eae7d898607cdade67c99081da7b56fc60aa9acfceb9016b21c80b6872f3
(对应)ABC@123456
怎么写这句sql语句来更新密码呢?
// The SQL query used to change the password.
// The query can contain the following macros that will be expanded as follows:
// %p is replaced with the plaintext new password
// %c is replaced with the crypt version of the new password, MD5 if available
// otherwise DES. More hash function can be enabled using the password_crypt_hash
// configuration parameter.
// %D is replaced with the dovecotpw-crypted version of the new password
// %o is replaced with the password before the change
// %n is replaced with the hashed version of the new password
// %q is replaced with the hashed password before the change
// %h is replaced with the imap host (from the session info)
// %u is replaced with the username (from the session info)
// %l is replaced with the local part of the username
// (in case the username is an email address)
// %d is replaced with the domain part of the username
// (in case the username is an email address)
// Escaping of macros is handled by this module.
// Default: "SELECT update_passwd(%c, %u)"
$config['password_query'] = 'UPDATE mailbox SET password=%d WHERE username=%u';