Roundcube and password plugin

_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users

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.', '[hidden email]')) 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 list
[hidden email]
https://exim4u.org/mailman/listinfo/users

_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users

_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users

_______________________________________________
users mailing list
[hidden email]
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 [[hidden email]] 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 [[hidden email]] On Behalf Of Rimas Kudelis
Sent: Wednesday, January 04, 2017 10:04 PM
To: [hidden email]
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.', '[hidden email]')) 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 list

[hidden email]

https://exim4u.org/mailman/listinfo/users

 

_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users

_______________________________________________
users mailing list
[hidden email]
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



_______________________________________________
users mailing list
[hidden email]
https://exim4u.org/mailman/listinfo/users