Roundcube 1.0.2 with plugin change password

[amjad]

Hello,

I need help with plugin change password , i'm using Roundcube Webmail 1.0.2 & cPanel Version 11.44.1

I have try with cPanel Driver options & sql Driver options but both doesn't work & get error An error occurred! ,Could not save new password


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

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

// The cPanel admin password
$config['password_cpanel_password'] = 'password of cpanel';

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


---------------------------------------------
// SQL Driver options
// ------------------
// PEAR database DSN for performing the query. By default
// Roundcube DB settings are used.
$config['password_db_dsn'] = 'mysql://username:password@localhost/database';

// The SQL query used to change the password.

// Default: "SELECT update_passwd(%c, %u)"
$config['password_query'] = 'SELECT update_passwd(%c, %u)';

$config['password_crypt_hash'] = 'md5';
$config['password_idn_ascii'] = false;
$config['password_dovecotpw_method'] = 'CRAM-MD5';
$config['password_dovecotpw_with_method'] = false;
$config['password_hash_algorithm'] = 'sha1';
$config['password_hash_base64'] = false;

----------------------------------------------------------
wish to help to activation options of change password with any driver options

[SKaero]

Did you follow the steps in the README in the password plugin directory?

[amjad]

Did you follow the steps in the README in the password plugin directory?

Yes , I did

[SKaero]

OK then what is in the error log?

[amjad]

Message of error is "Could not save new password." when I try to change the Password

[amjad]

Error log as below :

[13-Sep-2014 02:26:02 -0500]: DB Error: [1305] FUNCTION db_mail.update_passwd does not exist (SQL Query: SELECT update_passwd('xxx', 'username@mydomain.com')) in /home/acco/public_html/mail/program/lib/Roundcube/rcube_db.php on line 467 (POST /?_task=settings&_action=plugin.password-save?_task=&_action=)

[SKaero]

Its trying to use the sql driver, if your server is using cPanel you need to use the cPanel driver.

[amjad]

I am grateful to you for your help

I have try with cPanel driver option but it doesn't work also , and nothing in Error log , But I get same error ("Could not save new password.") when I try to change password .

Information of cPanel Driver options as below :

$config['password_cpanel_host'] = 'xxxxx.com';
$config['password_cpanel_username'] = 'user_cpanel';
$config['password_cpanel_password'] = 'password_cpanel';
$config['password_cpanel_port'] = 2082;

I have also Installed cPanel XMLAPI Client Class into Roundcube program/lib directory

Information of xmlapi.php as below :

    // should debugging statements be printed?
    private $debug         = false;

    // The host to connect to
    private $host            =   'xxxxx.com';

    // the port to connect to
    private $port            =   '2082';

    // should be the literal strings http or https
    private $protocol      =   'http';

    // output that should be given by the xml-api
    private $output      =   'simplexml';

    // literal strings hash or password
    private $auth_type    = null;

    //  the actual password or hash
    private $auth          = null;

    // username to authenticate as
    private $user            = null;

    // The HTTP Client to use
    private $http_client      = 'curl';

Note : The old Roundcube Version 0.8.1 which was working with cPanel Driver options it has some difference with the new Roundcube 1.0.2 as below :

1- It was have two config extra

$rcmail_config['password_cpanel_ssl'] = false;
$rcmail_config['password_cpanel_theme'] = 'x3'; .

2- It wasn't need to Installe cPanel XMLAPI Client Class .

Now the plugin doesn't work in Roundcube 1.0.2 , Please help me to make it work
 

[amjad]

Any help please

Can anyone help me in my issues please 

[SKaero]

There should be an error log somewhere that would have useful information in it. Without an error log I can't tell anything else without having access to the server.

[amjad]

When I use cPanel driver options it doesn't wrote any error in logs errors of roundcube , suport of hostgator told me I should to use sql driver options , So can u help me to correction my config  of sql driver options please 

My config of sql driver options

// PEAR database DSN for performing the query. By default
// Roundcube DB settings are used.
$config['password_db_dsn'] = 'mysql://username:password@localhost/database';

// The SQL query used to change the password.

// Default: "SELECT update_passwd(%c, %u)"
$config['password_query'] = 'SELECT update_passwd(%c, %u)';

$config['password_crypt_hash'] = 'md5';
$config['password_idn_ascii'] = false;
$config['password_dovecotpw_method'] = 'CRAM-MD5';
$config['password_dovecotpw_with_method'] = false;
$config['password_hash_algorithm'] = 'sha1';
$config['password_hash_base64'] = false;

The error in logs errors is

DB Error: [1305] FUNCTION dbmail.update_passwd does not exist (SQL Query: SELECT update_passwd('xxxx', 'user@domain.com')) in /home/projects/public_html/x_mail/lib/Roundcube/rcube_db.php on line 467 (POST /?_task=settings&_action=plugin.password-save?_task=&_action=)

I'm tired with this issue

[SKaero]

If your hosted on HostGator then you can't use the SQL option you have to use the cPanel option. Also if I had to guess you need to set the protocol to https but I can't say for sure without being able to look at it myself.

[amjad]

Thanks for ur help

I will try again with cPanel driver options and will ask host supports to check it

[ralfie]

Hi i dont know if you got the solution already, but if you still need, I think i have solution for that

[ralfie]

Yes I have the same problem that you had before. here some informations

1. I hosted on bluehost ( i do not know where did you host yours)
2. using cpanel
3. I installed the new version of roundcube 1.0.5
4. I used plugin_manager from myroundcube.com

before I have a problem in changing and saving a new password, it went to white blank page. To make work i did like this.

1. registed the password plugin in the config.inc.php it is located in config folder in order to activate it. it looks like this:

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


2. I was not using the cpanel driver ( plugins/password/drivers/cpanel.php )  from the roundcube version 1.0.5. which is @version 3.0 * @author Christian Chech <christian-chechfr>
 But i still used the previous on from the version 0.8 or 0.9 that is the @version 2.0 * @author Fulvio Venturelli <fulvio@venturelli.org>

I just simple replace it with the version 2.0


3. edit the config.inc.php  (" located in plugins/password/ ")
 change the plugin option from sql (default) to cpanel like below

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


then scroll down find the cpanel driver option,it looks like this:



// cPanel Driver options
// --------------------------
// The cPanel Host name
$config['password_cpanel_host'] = 'box804.bluehost.com';  <---this host cpanel of bluehost

// The cPanel admin username
$config['password_cpanel_username'] = 'xxxxxxx';   <------------your Cpanel's username

// The cPanel admin password
$config['password_cpanel_password'] = 'xxxxxx';<---------------------your password

// The cPanel port to use
$config['password_cpanel_port'] = 2083; <--------the port that using to access your cpanel

in the new configuration in roundcube version 1.0.5 its end here, but i was still adding the two lines just like in the previous version as below:
-------------------------------------------------------------------------------------------------------

the previous version was look like this


// Using ssl for cPanel connections?
$rcmail_config['password_cpanel_ssl'] = true;

// The cPanel theme in use
$rcmail_config['password_cpanel_theme'] = 'rsx3';



BUT I CHANGE to THIS (change the $rcmail_config to $config)


// Using ssl for cPanel connections?
$config['password_cpanel_ssl'] = true; 

// The cPanel theme in use
$config['password_cpanel_theme'] = 'rsx3';


I don not know if it gonna work with you but mine is working just find