Rimas,
Thx!�� Will reply back with results.
Helmut
From: users [mailto:users-bounces@exim4u.org] On Behalf Of Rimas Kudelis
Sent: Wednesday, January 04, 2017 10:04 PM
To: users@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@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-tp4023624.html
But the resolution was not posted.
Thx for any help.
Helmut
_______________________________________________users mailing listusers@exim4u.orghttps://exim4u.org/mailman/listinfo/users