Password in Roundcube is not working

[baysaye]

I am using Roundcube webmail in my nework. I installed it under AMPPS and it is running well.
However, the Password plugin is not working well. When I try to change my password I get the message: "Could not save new password. Encryption function missing". All searches on this forum and other forums explain about Postfix and Dovecot. But I do not have both in my installation. Was Ampps suppose to install the Dovecot and Postfix? Most of the topics brought by the search engines mostly explain the Roundcube under Ubuntu, not MS Windows. I am running Windows Server 2016.
The installation of the Roundcube was done within the AMPPS interface. There, under mails I clicked on Roundcube and it was downloaded and installed. Everything else is running fine, only the Password Plugin.

Is there any way I can configure this to work under the above environment?

[SKaero]

What password driver and hash setting are you trying to use?

[baysaye]

What password driver and hash are there for Windows installation? Here are my roundcube main and Password plugin configuration files. I have removed most of the comments to make my post compact (but the comments are in my original files). The values in the files below are real live values:


<?php

/*
 +-----------------------------------------------------------------------+
 | Main configuration file with default settings                         |
 |                                                                       |
 | This file is part of the Roundcube Webmail client                     |
 | Copyright (C) 2005-2013, The Roundcube Dev Team                       |
 |                                                                       |
 | Licensed under the GNU General Public License version 3 or            |
 | any later version with exceptions for skins & plugins.                |
 | See the README file for a full license statement.                     |
 +-----------------------------------------------------------------------+
*/

$config = array();

// ----------------------------------
// SQL DATABASE
// ----------------------------------

$config['db_dsnw'] = 'mysql://jspawebmail:971(SF@pP6@localhost/jspawebmail';
$config['db_dsnr'] = '';
$config['db_dsnw_noread'] = false;
$config['db_persistent'] = false;
$config['db_prefix'] = 'rcur_';
$config['db_table_dsn'] = array();
$config['db_max_allowed_packet'] = null;

// ----------------------------------
// LOGGING/DEBUGGING
// ----------------------------------

$config['debug_level'] = 1;
$config['log_driver'] = 'file';
$config['log_date_format'] = 'd-M-Y H:i:s O';
$config['log_session_id'] = 8;
$config['syslog_id'] = 'roundcube';
$config['syslog_facility'] = LOG_USER;
$config['per_user_logging'] = false;
$config['smtp_log'] = true;
$config['log_logins'] = false;
$config['log_session'] = false;
$config['sql_debug'] = false;
$config['imap_debug'] = false;
$config['ldap_debug'] = false;
$config['smtp_debug'] = false;
$config['memcache_debug'] = false;
$config['apc_debug'] = false;

// ----------------------------------
// IMAP
// ----------------------------------

$config['default_host'] = 'mail.jspanet.local';
$config['default_port'] = 143;
$config['imap_auth_type'] = null;
$config['imap_conn_options'] = null;
$config['imap_timeout'] = 0;
$config['imap_auth_cid'] = null;
$config['imap_auth_pw'] = null;
$config['imap_delimiter'] = null;
$config['imap_vendor'] = null;
$config['imap_ns_personal'] = null;
$config['imap_ns_other']    = null;
$config['imap_ns_shared']   = null;
$config['imap_force_caps'] = false;
$config['imap_force_lsub'] = false;
$config['imap_force_ns'] = false;
$config['imap_skip_hidden_folders'] = false;
$config['imap_disabled_caps'] = array();
$config['imap_log_session'] = false;
$config['imap_cache'] = null;
$config['messages_cache'] = false;
$config['imap_cache_ttl'] = '10d';
$config['messages_cache_ttl'] = '10d';
$config['messages_cache_threshold'] = 50;

// ----------------------------------
// SMTP
// ----------------------------------

$config['smtp_server'] = 'mail.jspanet.local';
$config['smtp_port'] = 25;
$config['smtp_user'] = '%u';
$config['smtp_pass'] = '%p';
$config['smtp_auth_type'] = '';
$config['smtp_auth_cid'] = null;
$config['smtp_auth_pw'] = null;
$config['smtp_helo_host'] = '';
$config['smtp_timeout'] = 0;
$config['smtp_conn_options'] = null;

// ----------------------------------
// LDAP
// ----------------------------------

$config['ldap_cache'] = 'db';
$config['ldap_cache_ttl'] = '10m';

// ----------------------------------
// CACHE(S)
// ----------------------------------

$config['memcache_hosts'] = null; // e.g. array( 'localhost:11211', '192.168.1.12:11211', 'unix:///var/tmp/memcached.sock' );

$config['memcache_pconnect'] = true;

$config['memcache_timeout'] = 1;
$config['memcache_retry_interval'] = 15;
$config['redis_hosts'] = null; // e.g. array( 'localhost:6379' );  array( '192.168.1.1:6379:1:secret' );
$config['memcache_max_allowed_packet'] = '2M';
$config['apc_max_allowed_packet'] = '2M';

// ----------------------------------
// SYSTEM
// ----------------------------------

$config['enable_installer'] = false;
$config['dont_override'] = array();
$config['disabled_actions'] = array();
$config['advanced_prefs'] = array();
$config['support_url'] = '';
$config['skin_logo'] = null;
$config['auto_create_user'] = true;
$config['user_aliases'] = false;
$config['log_dir'] = RCUBE_INSTALL_PATH . 'logs/';
$config['temp_dir'] = RCUBE_INSTALL_PATH . 'temp/';
$config['temp_dir_ttl'] = '48h';
$config['force_https'] = false;
$config['use_https'] = false;
$config['login_autocomplete'] = 0;
$config['login_lc'] = 2;
$config['login_username_maxlen'] = 1024;
$config['login_password_maxlen'] = 1024;
$config['login_username_filter'] = null;
$config['login_rate_limit'] = 3;
$config['skin_include_php'] = false;
$config['display_version'] = false;
$config['session_lifetime'] = 10;
$config['session_domain'] = '';
$config['session_name'] = null;
$config['session_auth_name'] = null;
$config['session_path'] = null;
$config['session_storage'] = 'db';
$config['ip_check'] = false;
$config['proxy_whitelist'] = array();
$config['referer_check'] = false;
$config['x_frame_options'] = 'sameorigin';
$config['des_key'] = 'PTN*Ops5g1$CnmiDpKD6LUB5';
$config['cipher_method'] = 'DES-EDE3-CBC';
$config['username_domain'] = '';
$config['username_domain_forced'] = false;
$config['mail_domain'] = '';
$config['password_charset'] = 'ISO-8859-1';
$config['sendmail_delay'] = 0;
$config['max_message_size'] = '100M';
$config['max_recipients'] = 0;
$config['max_disclosed_recipients'] = 5;
$config['max_group_members'] = 0;
$config['product_name'] = 'JSPA WebMail System';
$config['useragent'] = 'Roundcube Webmail/'.RCMAIL_VERSION;
$config['include_host_config'] = false;
$config['generic_message_footer'] = '';
$config['generic_message_footer_html'] = '';
$config['http_received_header'] = false;
$config['http_received_header_encrypt'] = false;
$config['line_length'] = 72;
$config['send_format_flowed'] = true;
$config['mdn_use_from'] = false;
$config['identities_level'] = 0;
$config['identity_image_size'] = 64;
$config['client_mimetypes'] = null;  # null == default
$config['mime_magic'] = null;
$config['mime_types'] = null;
$config['im_identify_path'] = null;
$config['im_convert_path'] = null;
$config['image_thumbnail_size'] = 240;
$config['contact_photo_size'] = 160;
$config['email_dns_check'] = false;
$config['no_save_sent_messages'] = false;
$config['use_secure_urls'] = false;
$config['assets_path'] = '';
$config['assets_dir'] = '';

// ----------------------------------
// PLUGINS
// ----------------------------------

$config['plugins'] = array('password');

// ----------------------------------
// USER INTERFACE
// ----------------------------------

$config['message_sort_col'] = '';
$config['message_sort_order'] = 'DESC';
$config['list_cols'] = array('subject', 'status', 'fromto', 'date', 'size', 'flag', 'attachment');
$config['language'] = 'en_US';
$config['date_format'] = 'Y-m-d';
$config['date_formats'] = array('Y-m-d', 'Y/m/d', 'Y.m.d', 'd-m-Y', 'd/m/Y', 'd.m.Y', 'j.n.Y');
$config['time_format'] = 'H:i';
$config['time_formats'] = array('G:i', 'H:i', 'g:i a', 'h:i A');
$config['date_short'] = 'D H:i';
$config['date_long'] = 'Y-m-d H:i';
$config['drafts_mbox'] = 'Drafts';
$config['junk_mbox'] = 'Junk';
$config['sent_mbox'] = 'Sent';
$config['trash_mbox'] = 'Trash';
$config['create_default_folders'] = true;
$config['protect_default_folders'] = true;
$config['show_real_foldernames'] = True;
$config['quota_zero_as_unlimited'] = true;
$config['enable_spellcheck'] = true;
$config['spellcheck_dictionary'] = false;
$config['spellcheck_engine'] = 'googie';
$config['spellcheck_uri'] = '';
$config['spellcheck_languages'] = NULL;
$config['spellcheck_ignore_caps'] = false;
$config['spellcheck_ignore_nums'] = false;
$config['spellcheck_ignore_syms'] = false;
$config['recipients_separator'] = ',';
$config['sig_max_lines'] = 15;
$config['max_pagesize'] = 200;
$config['min_refresh_interval'] = 60;
$config['upload_progress'] = false;
$config['undo_timeout'] = 0;
$config['compose_responses_static'] = array();

// ----------------------------------
// ADDRESSBOOK SETTINGS
// ----------------------------------

$config['address_book_type'] = 'sql';
$config['ldap_public'] = array();
/*
 * example config for Verisign directory
 *
$config['ldap_public']['Verisign'] = array(
  'name'          => 'Verisign.com',
  'hosts'         => array('directory.verisign.com'),
  'port'          => 389,
  'use_tls'       => false,
  'ldap_version'  => 3,       
  'network_timeout' => 10,   
  'user_specific' => false,   
  'base_dn'       => '',
  'bind_dn'       => '',
  'bind_pass'     => '',
  'search_base_dn' => '',
  'search_filter'  => '', 
  'search_bind_dn' => '',
  'search_bind_pw' => '',
  'domain_base_dn' => '',
  'domain_filter'  => '',
  'search_bind_attrib' => array(),
  'search_dn_default' => '',
  'auth_cid'       => '',
  'auth_method'    => '',
  'hidden'        => false,
  'searchonly'    => false,
  'writable'       => false,
  'LDAP_Object_Classes' => array('top', 'inetOrgPerson'),
  'LDAP_rdn'       => 'cn',
  'required_fields' => array('cn', 'sn', 'mail'),
  'search_fields'   => array('mail', 'cn'),  // fields to search in
  'fieldmap' => array(
    'name'        => 'cn',
    'surname'     => 'sn',
    'firstname'   => 'givenName',
    'jobtitle'    => 'title',
    'email'       => 'mail:*',
    'phone:home'  => 'homePhone',
    'phone:work'  => 'telephoneNumber',
    'phone:mobile' => 'mobile',
    'phone:pager' => 'pager',
    'phone:workfax' => 'facsimileTelephoneNumber',
    'street'      => 'street',
    'zipcode'     => 'postalCode',
    'region'      => 'st',
    'locality'    => 'l',
    'country'      => 'c',
    'organization' => 'o',
    'department'   => 'ou',
    'jobtitle'     => 'title',
    'notes'        => 'description',
    'photo'        => 'jpegPhoto',
  ),
  'sub_fields' => array(),
  'autovalues' => array(),
  'sort'           => 'cn',   
  'scope'          => 'sub',
  'filter'         => '(objectClass=inetOrgPerson)',   
  'fuzzy_search'   => true,         
  'vlv'            => false,       
  'vlv_search'     => false,   
  'numsub_filter'  => '(objectClass=organizationalUnit)',
  'config_root_dn' => 'cn=config',
  'sizelimit'      => '0',         
  'timelimit'      => '0',       
  'referrals'      => false,     
  'dereference'    => 0,       
  'groups'  => array(
    'base_dn'           => '',
    'scope'             => 'sub',
    'filter'            => '(objectClass=groupOfNames)',
    'object_classes'    => array('top', 'groupOfNames'), 
    'member_attr'       => 'member',   
    'name_attr'         => 'cn',       
    'email_attr'        => 'mail',     
    'member_filter'     => '(objectclass=*)', 
    'vlv'               => false,     
    'class_member_attr' => array(     
      'groupofnames'       => 'member',
      'groupofuniquenames' => 'uniquemember'
    ),
  ),
  'group_filters' => array(
    'departments' => array(
      'name'    => 'Company Departments',
      'scope'   => 'list',
      'base_dn' => 'ou=Groups,dc=mydomain,dc=com',
      'filter'  => '(|(objectclass=groupofuniquenames)(objectclass=groupofurls))',
      'name_attr' => 'cn',
    ),
    'customers' => array(
      'name'    => 'Customers',
      'scope'   => 'sub',
      'base_dn' => 'ou=Customers,dc=mydomain,dc=com',
      'filter'  => '(objectClass=inetOrgPerson)',
      'name_attr' => 'sn',
    ),
  ),
);
*/

$config['autocomplete_addressbooks'] = array('sql');
$config['autocomplete_min_length'] = 1;
$config['autocomplete_threads'] = 0;
$config['autocomplete_max'] = 15;
$config['address_template'] = '{street}<br/>{locality} {zipcode}<br/>{country} {region}';
$config['addressbook_search_mode'] = 0;
$config['contactlist_fields'] = array('name', 'firstname', 'surname', 'email');
$config['contact_search_name'] = '{name} <{email}>';

// ----------------------------------
// USER PREFERENCES
// ----------------------------------

$config['default_charset'] = 'ISO-8859-1';
$config['skin'] = 'larry';
$config['standard_windows'] = false;
$config['mail_pagesize'] = 50;
$config['addressbook_pagesize'] = 50;
$config['addressbook_sort_col'] = 'surname';
$config['addressbook_name_listing'] = 0;
$config['timezone'] = 'auto';
$config['prefer_html'] = true;
$config['show_images'] = 0;
$config['message_extwin'] = false;
$config['compose_extwin'] = false;
$config['htmleditor'] = 0;
$config['compose_save_localstorage'] = true;
$config['prettydate'] = true;
$config['draft_autosave'] = 300;
$config['layout'] = 'widescreen';
$config['mail_read_time'] = 0;
$config['logout_purge'] = false;
$config['logout_expunge'] = false;
$config['inline_images'] = true;
$config['mime_param_folding'] = 1;
$config['skip_deleted'] = false;
$config['read_when_deleted'] = true;
$config['flag_for_deletion'] = false;
$config['refresh_interval'] = 60;
$config['check_all_folders'] = false;
$config['display_next'] = true;
$config['default_list_mode'] = 'list';
$config['autoexpand_threads'] = 0;
$config['reply_mode'] = 0;
$config['strip_existing_sig'] = true;
$config['show_sig'] = 1;
$config['sig_below'] = false;
$config['sig_separator'] = true;
$config['force_7bit'] = false;
$config['search_mods'] = null;
'to'=>1));
$config['addressbook_search_mods'] = null;
$config['delete_always'] = false;
$config['delete_junk'] = false;
$config['mdn_requests'] = 0;
$config['mdn_default'] = 0;
$config['dsn_default'] = 0;
$config['reply_same_folder'] = false;
$config['forward_attachment'] = false;
$config['default_addressbook'] = null;
$config['spellcheck_before_send'] = false;
$config['autocomplete_single'] = false;
$config['default_font'] = 'Verdana';
$config['default_font_size'] = '10pt';
$config['message_show_email'] = false;
$config['reply_all_mode'] = 0;

[baysaye]

Password Plugin Configuration file:

<?php

$config['password_driver'] = 'sql';
$config['password_confirm_current'] = true;
$config['password_minimum_length'] = 8;
$config['password_require_nonalpha'] = true;
$config['password_log'] = true;
$config['password_login_exceptions'] = null;
$config['password_hosts'] = null;
$config['password_force_save'] = false;
$config['password_force_new_user'] = false;
$config['password_algorithm'] = 'clear';
$config['password_algorithm_prefix'] = '';
$config['password_dovecotpw'] = '/usr/local/sbin/dovecotpw'; // for dovecot-1.x
$config['password_dovecotpw_method'] = 'CRAM-MD5';
$config['password_dovecotpw_with_method'] = false;
$config['password_blowfish_cost'] = 12;
$config['password_crypt_rounds'] = 50000;
$config['password_disabled'] = false;


// SQL Driver options
// ------------------

$config['password_db_dsn'] = 'mysql://jspawebmail:971(SF@pP6@localhost/jspawebmail';

$config['password_query'] = 'UPDATE mailbox SET password=%D,passwordlastchange=NOW() WHERE username=%u';
$config['password_crypt_hash'] = 'md5';
$config['password_idn_ascii'] = false;
$config['password_hash_algorithm'] = 'sha1';
$config['password_hash_base64'] = false;


// Poppassd Driver options
// -----------------------
// The host which changes the password (default: localhost)
// Supported replacement variables:
//   %n - hostname ($_SERVER['SERVER_NAME'])
//   %t - hostname without the first part
//   %d - domain (http hostname $_SERVER['HTTP_HOST'] without the first part)
//   %h - IMAP host
//   %z - IMAP domain without first part
//   %s - domain name after the '@' from e-mail address provided at login screen
$config['password_pop_host'] = 'localhost';

$config['password_pop_port'] = 106;


// SASL Driver options
// -------------------
// Additional arguments for the saslpasswd2 call
$config['password_saslpasswd_args'] = '';


// LDAP and LDAP_SIMPLE Driver options
// -----------------------------------
// LDAP server name to connect to.
// You can provide one or several hosts in an array in which case the hosts are tried from left to right.
// Exemple: array('ldap1.exemple.com', 'ldap2.exemple.com');
// Default: 'localhost'
$config['password_ldap_host'] = 'localhost';

// LDAP server port to connect to
// Default: '389'
$config['password_ldap_port'] = '389';

$config['password_ldap_starttls'] = false;
$config['password_ldap_version'] = '3';
$config['password_ldap_basedn'] = 'dc=exemple,dc=com';
$config['password_ldap_method'] = 'user';

// LDAP Admin DN
$config['password_ldap_adminDN'] = null;

// LDAP Admin Password
$config['password_ldap_adminPW'] = null;

// LDAP user DN mask
$config['password_ldap_userDN_mask'] = 'uid=%login,ou=people,dc=exemple,dc=com';

// LDAP search DN
$config['password_ldap_searchDN'] = 'cn=roundcube,ou=services,dc=example,dc=com';

// LDAP search password
$config['password_ldap_searchPW'] = 'secret';

// LDAP search base
$config['password_ldap_search_base'] = 'ou=people,dc=example,dc=com';

// LDAP search filter
$config['password_ldap_search_filter'] = '(uid=%login)';

// LDAP password hash type
$config['password_ldap_encodage'] = 'crypt';

// LDAP password attribute
$config['password_ldap_pwattr'] = 'userPassword';

// LDAP password force replace
$config['password_ldap_force_replace'] = true;

// LDAP Password Last Change Date
$config['password_ldap_lchattr'] = '';

// LDAP Samba password attribute, e.g. sambaNTPassword
$config['password_ldap_samba_pwattr'] = '';
 
// LDAP Samba Password Last Change Date attribute, e.g. sambaPwdLastSet
$config['password_ldap_samba_lchattr'] = '';

// LDAP PPolicy Driver options
// -----------------------------------

// LDAP Change password command - filename of the perl script
$config['password_ldap_ppolicy_cmd'] = 'change_ldap_pass.pl';

// LDAP URI
$config['password_ldap_ppolicy_uri'] = 'ldap://localhost/';

// LDAP base name (root directory)
$config['password_ldap_ppolicy_basedn'] = 'dc=example,dc=com';

$config['password_ldap_ppolicy_searchDN'] = 'cn=someuser,dc=example,dc=com';

$config['password_ldap_ppolicy_searchPW'] = 'secret';

// LDAP search filter
$config['password_ldap_ppolicy_search_filter'] = '(uid=%login)';

// CA Certificate file if in URI is LDAPS connection
$config['password_ldap_ppolicy_cafile'] = '/etc/ssl/cacert.crt';



// DirectAdmin Driver options
// --------------------------
$config['password_directadmin_host'] = 'tcp://localhost';

// TCP port used for DirectAdmin connections
$config['password_directadmin_port'] = 2222;


// vpopmaild Driver options
// -----------------------
// The host which changes the password
$config['password_vpopmaild_host'] = 'localhost';

// TCP port used for vpopmaild connections
$config['password_vpopmaild_port'] = 89;

// Timeout used for the connection to vpopmaild (in seconds)
$config['password_vpopmaild_timeout'] = 10;


// cPanel Driver options
// --------------------------
// The cPanel Host name
$config['password_cpanel_host'] = 'host.domain.com';

// The cPanel admin username
$config['password_cpanel_username'] = 'username';

$config['password_cpanel_password'] = 'password';

// The cPanel admin hash
$config['password_cpanel_hash'] = '';

// The cPanel port to use
$config['password_cpanel_port'] = 2087;


// cPanel Webmail Driver options
// -----------------------------
// The cPanel Host name
$config['password_cpanel_webmail_host'] = 'host.domain.com';

$config['password_cpanel_webmail_port'] = 2096;


// XIMSS (Communigate server) Driver options
// -----------------------------------------
$config['password_ximss_host'] = 'mail.example.com';

// XIMSS port on Communigate server
$config['password_ximss_port'] = 11024;

// chpasswd Driver options
// ---------------------
// Command to use (see "Sudo setup" in README)
$config['password_chpasswd_cmd'] = 'sudo /usr/sbin/chpasswd 2> /dev/null';


// XMail Driver options
// ---------------------
$config['xmail_host'] = 'localhost';
$config['xmail_user'] = 'YourXmailControlUser';
$config['xmail_pass'] = 'YourXmailControlPass';
$config['xmail_port'] = 6017;


// hMail Driver options
// -----------------------
// Remote hMailServer configuration
$config['hmailserver_remote_dcom'] = false;
$config['hmailserver_server'] = array(
    'Server'   => 'localhost',      // hostname or ip address
    'Username' => 'administrator',  // windows username
    'Password' => 'password'        // windows user password
);


// Virtualmin Driver options
// -------------------------
$config['password_virtualmin_format'] = 0;


// pw_usermod Driver options
// --------------------------
$config['password_pw_usermod_cmd'] = 'sudo /usr/sbin/pw usermod -h 0 -n';


// DBMail Driver options
// -------------------
// Additional arguments for the dbmail-users call
$config['password_dbmail_args'] = '-p sha512';


// Expect Driver options
// ---------------------
// Location of expect binary
$config['password_expect_bin'] = '/usr/bin/expect';

// Location of expect script (see helpers/passwd-expect)
$config['password_expect_script'] = '';

$config['password_expect_params'] = '';

// smb Driver options
// ---------------------
$config['password_smb_host'] = 'localhost';
$config['password_smb_cmd'] = '/usr/bin/smbpasswd';

// gearman driver options
// ---------------------
$config['password_gearman_host'] = 'localhost';


// Plesk/PPA Driver options
// --------------------
$config['password_plesk_host'] = '10.0.0.5';

// Plesk RPC Username
$config['password_plesk_user'] = 'admin';

$config['password_plesk_pass'] = 'password';

// Plesk RPC Port
$config['password_plesk_rpc_port'] = '8443';

// Plesk RPC Path
$config['password_plesk_rpc_path'] = 'enterprise/control/agent.php';


// kasswd Driver options
// ---------------------
// Command to use
$config['password_kpasswd_cmd'] = '/usr/bin/kpasswd';

[SKaero]

The way you currently have the password query configured it would be trying to run "/usr/local/sbin/dovecotpw" to generate the new password. Since your on a Windows system that wouldn't work, not sure if there is an equivalent command on windows but hopefully that give you a starting point to look for a solution.

[alec]

If you really store clear text passwords in database all you need is to change %D to %P in your query.

[JohnDoh]

You appear to have posted both your database credentials and your des_key. Please confirm that is not the case.

[baysaye]

JohnDoh, I just copied and inserted my entire configuration files in the post here above. They may indeed contain both information you are asking. All values in the above posts are real and live; running on my internal network with no link going out.
Furthermore, most of the configuration was automatically done by the roundcube (Ampps) app.
I will test alec's suggestion out and share the result with the forum.

Thanks for your contribution, everyone.

[baysaye]

Hi alec et all, I modified my password config.inc.php file with your above suggestion. Now I get the error: "COULD NOT SAVE NEW PASSWORD."

Maybe it is still looking for the Dovecot and Postfix, which are not installed on my system. Can I download and install both of them manually? Does the Password plugin actually work under the Windows installation? I see that the ubuntu installation has folders for both Dovecot and Postfix.