Password Plugin Issues - Beating a Dead Horse

[crachnbrn]

I have a Joomla! Site hosted on Josthost.com ad with a sql backend.  I have attempted to follow the tutorials on enabling the password plugin, but I am still failing.  I am new to Joomla! and cpanel, but I have been learning quickly thanks to the boards.  I decided to use roundcube because I can customize the interface that is used.  I have turned on logging and I am getting the following error:


   DB Error: MDB2 Error: not found Query: _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT update_passwd('$##7jjz/XYr$m/lJnP27g#MlG8Up%UPox/', '[email protected]')] [Native code: 1305] [Native message: FUNCTION goitgcom_rnd1.update_passwd does not exist]  in /home1/goitgcom/public_html/mail/program/include/rcube_mdb2.php on line 717 (POST /~goitgcom/mail/?_task=settings&_action=plugin.password-save?_task=&_action=)


I could really use some help figuring out the correct sql query for the password change to work.

Thank you in advance for any help..

[SKaero]

If you are using cPanel then use the cPanel password driver not the SQL one.

[crachnbrn]

If you are using cPanel then use the cPanel password driver not the SQL one.

I have to apologize for my ignorance, but how do you configure that?  I have followed the available tutorials and it still fails so I am left guessing that it must be a db query issue.  In fact, I am not sure what the problem is though.  Thats why I posted the log error.

Thanks for your response - can you please explain further though?

[SKaero]

In /plugins/password/config.inc.php
Set password_driver to cpanel:

Code Select Expand

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

Then set the cPanel settings:

Code Select Expand

// The cPanel Host name
$rcmail_config['password_cpanel_host'] = 'host.domain.com';

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

// The cPanel admin password
$rcmail_config['password_cpanel_password'] = 'password';

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

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

// The cPanel theme in use
$rcmail_config['password_cpanel_theme'] = 'x';
To find the appropriate settings login to cPanel and when on the main page look at the url, it should look something like:

Code Select Expand

http://example.com:2082/frontend/x3/index.html
This is the data needed:

Code Select Expand

http://[B]Host[/B]:[B]Port[/B]/frontend/[B]Theme[/B]/index.html

This is what it should look like in the config file:

Code Select Expand

$rcmail_config['password_cpanel_host'] = '[B]Host[/B]';

$rcmail_config['password_cpanel_username'] = 'Your CPanel username';

$rcmail_config['password_cpanel_password'] = 'Your Cpanel password';

$rcmail_config['password_cpanel_port'] = [B]Port[/B];

$rcmail_config['password_cpanel_ssl'] = true;

$rcmail_config['password_cpanel_theme'] = '[B]Theme[/B]';


[crachnbrn]

Thanks skaero - that was very helpful, but I still have a couple of questions...  In my main.inc.php, I have the following:

// The cPanel Host name
$rcmail_config['password_cpanel_host'] = 'go-itg.com';

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

// The cPanel admin password
$rcmail_config['password_cpanel_password'] = 'password';

// The cPanel port to use
$rcmail_config['password_cpanel_port'] = 2083;

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

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

Am I supposed to type the actual Username and Password in this file, or is it just a variable for whomever is logged into the system?

Also, my cpanel URL looks like this when I am logged in:  
https://login.justhost.com/frontend/justhost/index.html

So, where does this information go?

Thanks again....

In /plugins/password/config.inc.php
Set password_driver to cpanel:

Code Select Expand


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


Then set the cPanel settings:

Code Select Expand

// The cPanel Host name
$rcmail_config['password_cpanel_host'] = 'host.domain.com';

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

// The cPanel admin password
$rcmail_config['password_cpanel_password'] = 'password';

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

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

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

To find the appropriate settings login to cPanel and when on the main page look at the url, it should look something like:

Code Select Expand

http://example.com:2082/frontend/x3/index.html

This is the data needed:

Code Select Expand


http://[B]Host[/B]:[B]Port[/B]/frontend/[B]Theme[/B]/index.html


This is what it should look like in the config file:

Code Select Expand


$rcmail_config['password_cpanel_host'] = '[B]Host[/B]';

$rcmail_config['password_cpanel_username'] = 'Your CPanel username';

$rcmail_config['password_cpanel_password'] = 'Your Cpanel password';

$rcmail_config['password_cpanel_port'] = [B]Port[/B];

$rcmail_config['password_cpanel_ssl'] = true;

$rcmail_config['password_cpanel_theme'] = '[B]Theme[/B]';