Password Roundcube Plugin

[las2conB]

Hi, I've followed the instructions here but I get an error every time I try to save a new password, it shows an alert saying the password couldn't be saved. I've checked the postfix Mysql password and also tried the config.inc.php-dist file and nothing worked.

What may I be doing wrong?

Thanks in advance.

[Me.B]

For sure and better if you ask help there or ping the user who posted the tutorial.

M B

[las2conB]

Hi @Me.B, unfortunately he's very busy and can't help me right now. Anyone else that may give a hand?

Thanks in advance.

[apinto]

@ las2conB
have you checked the file permissions?
did you double checked every setting?

If you want help spend a bit more time explaining your issue, the steps you did to install the plugin, what is the exact error you are getting and provide us any other information you might think it is relevant.
Without correct information all we can do is guess, not help.

[las2conB]

@ @[las2conB]
have you checked the file permissions?
did you double checked every setting?

If you want help spend a bit more time explaining your issue, the steps you did to install the plugin, what is the exact error you are getting and provide us any other information you might think it is relevant.
Without correct information all we can do is guess, not help.

Hi @apinto sorry for the delay in my reply, I was not subscribe to the topic and I've just found out that you did it quite a long time ago.

So I've double checked every setting and here's what I have:

- I've the following file in my /etc/sentora/panel/etc/apps/webmail/plugins/password folder:

 4 -rwxrwxrwx 1 root root   865 May 13 00:00 config.inc.php

- Here's its content (following the mentioned post instructions):

Code:

$rcmail_config['password_driver'] = 'sql';

$rcmail_config['password_confirm_current'] = true;
$rcmail_config['password_minimum_length'] = 0;
$rcmail_config['password_require_nonalpha'] = false;
$rcmail_config['password_log'] = false;

// SQL Driver options
$rcmail_config['password_db_dsn'] = 'mysql://postfix:'the_actual_postfix_mysql_password'@localhost/sentora_postfix';
// Intended on fleshing this out a bit, but wanted to get something working first
$rcmail_config['password_query'] = 'UPDATE mailbox SET password=%D WHERE username=%u';
$rcmail_config['password_idn_ascii'] = false;
// Also tried making a shell script called dovecotpw that just passes the arguments on to doveadm pw, no difference
$rcmail_config['password_dovecotpw'] = '/usr/bin/doveadm pw';
$rcmail_config['password_dovecotpw_method'] = 'PLAIN-MD5';
$rcmail_config['password_dovecotpw_with_method'] = true;

When I log in my webmail and try to change the password, here's what I get (in spanish): see attachement.

Translation of the alert box: "An error has occurred" "A new password couldn't be saved".

I have double checked the password (hidden here for security reasons) and it's the right one.

Any help would be mostly appreciated.

Best regards.

P.S. If I set the same password, success message shows up, just in case it helps.

[sknd]

Could not save new password. Encryption function missing..How to fix this pls

[maymaster]

Could not save new password. Encryption function missing..How to fix this pls

already checked the location of the file encryption?

you must put your location

Could not save new password. Encryption missing..How to Fix This function pls

$rcmail_config['password_dovecotpw'] = '/usr/bin/doveadm pw';



'/usr/bin/doveadm pw';

[td2000]

I even can not find main.inc.php

#ls

/etc/sentora/configs/roundcube/ -al
total 20
drwxrwxrwx. 2 root root 4096 Oct 22 13:30 .
drwxrwxrwx. 13 root root 4096 Oct 3 09:02 ..
-rwxrwxrwx. 1 root root 4735 Oct 22 13:28 roundcube_config.inc.php
-rwxrwxrwx. 1 root root 2902 Oct 3 09:29 sieve_config.inc.php

Can anyone set me full content of main.inc.php, I will add it by hand.

[TGates]

Roundcube no longer uses main.inc.php

Check the file config.inc.php inside the /etc/sentora/panel/etc/apps/webmail/config/ folder.

[Diablo925]

PHP Code:

Edit config.inc.php inside password folder

$config['password_driver'] = 'sql';

// SQL Driver options
// ------------------
// PEAR database DSN for performing the query. By default
// Roundcube DB settings are used.
$rcmail_config['password_db_dsn'] = 'mysql://postfix:POSTFIX_PASSWORD@localhost/sentora_postfix';
// 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'] = 'SELECT update_passwd(%c, %u)';
$config['password_query'] = 'UPDATE mailbox SET password=CONCAT(\'{PLAIN-MD5}\',MD5(%p)) WHERE username=%u AND password=CONCAT(\'{PLAIN-MD5}\',MD5(%o)) LIMIT 1';
// By default the crypt() function which is used to create the '%c' 
// parameter uses the md5 algorithm. To use different algorithms 
// you can choose between: des, md5, blowfish, sha256, sha512.
// Before using other hash functions than des or md5 please make sure
// your operating system supports the other hash functions.
$config['password_crypt_hash'] = 'md5';
// By default domains in variables are using unicode.
// Enable this option to use punycoded names
$config['password_idn_ascii'] = false;
// Path for dovecotpw (if not in $PATH)
// $config['password_dovecotpw'] = '/usr/bin/doveadm pw';
// Dovecot method (dovecotpw -s 'method')
$config['password_dovecotpw_method'] = 'PLAIN-MD5';
// Enables use of password with crypt method prefix in %D, e.g. {MD5}$1$LUiMYWqx$fEkg/ggr/L6Mb2X7be4i1/
$config['password_dovecotpw_with_method'] = false;
// Using a password hash for %n and %q variables.
// Determine which hashing algorithm should be used to generate
// the hashed new and current password for using them within the
// SQL query. Requires PHP's 'hash' extension.
$config['password_hash_algorithm'] = 'sha1';
// You can also decide whether the hash should be provided
// as hex string or in base64 encoded format.
$config['password_hash_base64'] = false; 


Works on my webmail