Roundcube Community Forum

Release Support => Resolved Issues => Topic started by: ludo75 on January 03, 2010, 11:56:38 PM

Title: poppassd native code
Post by: ludo75 on January 03, 2010, 11:56:38 PM
i have roundcube 0.3-2
i want to chang password but i have

[04-Jan-2010 06:56:52] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: SELECT update_passwd('$1$\\Sx1z2o:$SN8XYpBxYJvinUZviSPHe0', 'admin')]
[Native code: 1305]
[Native message: FUNCTION roundcubemail.update_passwd does not exist]
Title: poppassd native code
Post by: rosali on January 04, 2010, 12:40:41 AM
You have to define the SQL function 'update_passwd'. See this tutorial User Defined Functions - SQLTeam.com (http://www.sqlteam.com/article/user-defined-functions).
Title: poppassd native code
Post by: ludo75 on January 04, 2010, 04:13:01 AM
Quote from: rosali;24381
You have to define the SQL function 'update_passwd'. See this tutorial User Defined Functions - SQLTeam.com (http://www.sqlteam.com/article/user-defined-functions).


i m not an expert

can you help me
Title: poppassd native code
Post by: rosali on January 04, 2010, 04:26:04 AM
Someone else? I'm not good in SQL stuff.
Title: poppassd native code
Post by: JohnDoh on January 04, 2010, 06:27:01 AM
Just a quick clarification, the title mentions poppassd but then you have an SQL error message. Do you want to use poppassd to change your password or SQL?

MySQL :: MySQL 5.0 Reference Manual :: 12.1.9 CREATE PROCEDURE and CREATE FUNCTION Syntax (http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html) if you are using MySQL then this part of the manual should tell you how to create functions. You can also use a regular SQL statement, something like `UPDATE users SET password = %p WHERE userid=%u;` which is probably easier.
Title: poppassd native code
Post by: ludo75 on January 04, 2010, 07:56:31 AM
Quote from: JohnDoh;24390
Just a quick clarification, the title mentions poppassd but then you have an SQL error message. Do you want to use poppassd to change your password or SQL?


I want use poppassd to change my password.
Title: poppassd native code
Post by: JohnDoh on January 04, 2010, 11:21:51 AM
Are you using the password plugin which comes with version 0.3.x RoundCube?

If you are then you need to rename config.inc.php.dist to config.inc.php and fill in the config; change password_driver to poppassd and make sure the options in the Poppassd Driver options section are correct.
Title: poppassd native code
Post by: ludo75 on January 04, 2010, 11:27:25 PM
Quote from: JohnDoh;24400
Are you using the password plugin which comes with version 0.3.x RoundCube?

If you are then you need to rename config.inc.php.dist to config.inc.php and fill in the config; change password_driver to poppassd and make sure the options in the Poppassd Driver options section are correct.

and now i have

 old password is incorrect for user
Title: poppassd native code
Post by: ludo75 on January 06, 2010, 12:23:27 AM
anybody ???????????
Title: poppassd native code
Post by: JohnDoh on January 06, 2010, 04:25:53 AM
It's probably best if you debug that one yourself since the problem could be anything from a simple typo to something more serious and it is impossible for any one to tell with out more information.

take a look in [rc root]/plugins/password/password.php line 97 is where it checks the current password to make sure its the same as the one you used to login. Also just on the offchance something else is going wrong make sure the [rc root]/logs dir is writable by the webserver and look in the errors file.
Title: poppassd native code
Post by: crusher on January 26, 2010, 03:24:22 PM
I was having a similiar problem with poppassd. Take a look at this (http://www.roundcubeforum.net/7-third-party-contributions/25-old-style-plug-ins/3038-new-file-added-plesk-password-change.html) thread and see if it can help you.
At least you can find instructions there to test if poppassd itself is working correctly on your machine.