poppassd native code

[ludo75]

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]

[rosali]

You have to define the SQL function 'update_passwd'. See this tutorial User Defined Functions - SQLTeam.com.

[ludo75]

You have to define the SQL function 'update_passwd'. See this tutorial User Defined Functions - SQLTeam.com.

i m not an expert

can you help me

[rosali]

Someone else? I'm not good in SQL stuff.

[JohnDoh]

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 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.

[ludo75]

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.

[JohnDoh]

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.

[ludo75]

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

[ludo75]

anybody ??

[JohnDoh]

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.

[crusher]

I was having a similiar problem with poppassd. Take a look at this 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.