Thread: Password plugins

Anyone have an idea ? other plugins ?

PHP Code:

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


... assuming you are using MySQL. Also you have analyze the table structure of mailbox and to adjust ...

PHP Code:

$rcmail_config['password_query'] = 'UPDATE `hm_accounts` SET `accountpassword` = %c, `accountpwencryption` = '2' WHERE `accountaddress` = %u LIMIT 1;'; 


The example above is for hMailServer. I don't know postfix database structure. You have to adjust the query string accordingly. For available macros check the hints in the config file.

Hi rosali,

Big thank for your solution, I try this in few hours...

I post here if your solution resolve my problem (or no ... )

Rémi

rosali, Your solution work perfectly !

Big thank !
Now ... fire in the skins

Please help with password plugin.

I'm having the error: "Could not save new password."

my /usr/local/www/roundcube/plugin/password/config.inc.php
-----------------------------------------------------------
$rcmail_config['password_driver'] = 'sql';

$rcmail_config['password_db_dsn'] = 'mysql://postfix:mypass@localhost/postfix';

// I tried this too:
// $rcmail_config['password_db_dsn'] = 'mysql://postfix:mypass@unix(/tmp/mysql.sock)/postfix';

$rcmail_config['password_query'] = "UPDATE `mailbox` SET `password` = '%c', `modified` = date_format(now(),'%Y-%m-%d %H:%i:%s') WHERE `username` = '%u' LIMIT 1";
-----------------------------------------------------------
Can you see any errors on my settings?

Is there some LOG where I could watch to see if my query is being executed?

Thank you in advance for any help!

$rcmail_config['password_db_dsn'] = 'mysql://postfix:mypass@localhost/postfix';

Is the password for mysql postfix user really mypass ?

Also it should not be necessary to quote macros.

Hi,

PHP Code:

`modified` = date_format(now(),'%Y-%m-%d %H:%i:%s') 


remove this ! I think the password dont change because, no quote for dateformat ....


N.B. My english sucks very well ... no ?

( it WORKED! )

Hi Rosali.

No, no, my password for mysql postfix is another one. And I verified it and it is correct, i.e. I connect using a mysql-client with my "real" password and it works. On my "real" config.inc.php, I use my "real" pass unless "mypass".

I removed:

PHP Code:

`modified` = date_format(now(),'%Y-%m-%d %H:%i:%s') 


and I removed quotes on macros %c and %u:

PHP Code:


$rcmail_config['password_query'] = "UPDATE `mailbox` SET `password` = %c WHERE `username` = %u LIMIT 1";

// and this way works too:

$rcmail_config['password_query'] = "UPDATE `mailbox` SET `password` = %c, modified=now() WHERE `username` = %u LIMIT 1"; 


(it worked! -- let me ask: is there any LOG where I could watch and look for errors like this one?)

thank you !!!

Using postfix admin, this worked for me:

its based off of fms's

PHP Code:

$rcmail_config['password_query'] = "UPDATE mailbox SET password = ENCRYPT(%p), modified=now() WHERE username = %u LIMIT 1;" 


Sean