Hi Helmut, glad I could help. 'sha512' is one of the schemes mentioned in the comments in config.inc.php, so yes, it's a valid choice, and the correct one in your situation. After all, both Roundcube and Exim4U use same PHP methods to hash passwords. Cheers, Rimas 2017-01-05 08:40, Helmut Fritz wrote:
Indeed the crypt scheme is set in public_html/exim4u/config/variables.php. Somebody please correct me if wrong.
In the password config.inc.php file the original is so:
$config['password_crypt_hash'] = 'md5';
Mine has been changed to match the exim4U crypt scheme to such:
$config['password_crypt_hash'] = 'sha512';
As for the rest, thank you Rimas!
That does indeed do the trick.
Helmut
*From:*users [mailto:users-bounces(a)exim4u.org] *On Behalf Of *Helmut Fritz *Sent:* Wednesday, January 04, 2017 10:20 PM *To:* 'Exim4U General Discussion' *Subject:* Re: [Exim4U] Roundcube and password plugin
Rimas,
Thx! Will reply back with results.
Helmut
*From:*users [mailto:users-bounces(a)exim4u.org] *On Behalf Of *Rimas Kudelis *Sent:* Wednesday, January 04, 2017 10:04 PM *To:* users(a)exim4u.org <mailto:users(a)exim4u.org> *Subject:* Re: [Exim4U] Roundcube and password plugin
Hi Helmut,
assuming this part is the same as in Vexim, I think you should be able to use the following:
$config['password_query'] = 'UPDATE users SET crypt = %c WHERE username = %u';
It's probably also worthy to change $config['password_crypt_hash'] from 'md5' to something stronger. I think the crypt scheme is also being specified in Exim4U config file, so you should probably just put the same value here and see if that works as expected.
Regards, Rimas
2017-01-05 05:57, Helmut Fritz wrote:
Hello All,
I am trying to get the Roundcube password plugin working, but I am no SQL guy and I need to know what to put for the password query line in the password/config.inc.php (I think!).
It currently contains:
$config['password_query'] = 'SELECT update_passwd(%c, %u)';
I understand that the plugin needs to connect to the exim4u database and change the users password there. Please correct me if I am wrong; I do have the dsn configured. The error I get is that the FUNCTION does not exist:
[04-Jan-2017 19:11:21 -0800]: <ggorh7v1> DB Error: [1305] FUNCTION exim4u.update_passwd does not exist
(SQL Query: SELECT update_passwd('$1$mgJJ/WAK$hSmBBmaC.Tpv/2ACIZsmq.', 'user(a)email.com <mailto:user(a)email.com>')) in /us
r/home/exim4u/public_html/webmail/program/lib/Roundcube/rcube_db.php on line 543 (POST /webmail/?_task
=settings&_action=plugin.password-save?_task=&_action=)
From my research I have determined that the query line needs to be correct to change the password in the exim4U database.
I did find one thread in the archive:
http://users.exim4u.org/Which-Webmail-How-do-users-change-passwords-tp402362...
But the resolution was not posted.
Thx for any help.
Helmut
_______________________________________________
users mailing list
users(a)exim4u.org <mailto:users(a)exim4u.org>
https://exim4u.org/mailman/listinfo/users
_______________________________________________ users mailing list users(a)exim4u.org https://exim4u.org/mailman/listinfo/users