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')) 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 4.html But the resolution was not posted. Thx for any help. Helmut
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')) 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 https://exim4u.org/mailman/listinfo/users
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 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')) 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 https://exim4u.org/mailman/listinfo/users
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 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')) 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 https://exim4u.org/mailman/listinfo/users
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
I have transferred a site to a new server. the old server was using vpopmail one address had a .qmail file that delivered the email locally but ALSO piped it through a php script to write it to a database. I need to replicate this functionality. the user is a virtual user. no attempt at placing a forward file helps. how the heck do i do this? the old .qmail file was like this. /home/vpopmail/domains/[censored]/support/Maildir/ | /usr/local/bin/php -q /home/vpopmail/mail.php the mail.php will be relocated to /home/[censored]/mail.php it delivered a local copy and also piped it through the script. i need to do the same thing in exim4u
participants (3)
-
Chuck Cochems -
Helmut Fritz -
Rimas Kudelis