CAS 5.3.8 - Password Management - JDBC - Password's change does not update DB

[Nicola Boldrin]

Hi all,

I'm using CAS 5.3.8 and I'm trying to change my expired password.

I can specify my new password in form and submit it; the application shows the "Password Change Successful" message but DB is not updated.

In the debug mode I see that the method org.apereo.cas.pm.jdbc.JdbcPasswordManagementService.changeInternal(....) returns 1.

    @Override
    public boolean changeInternal(final Credential credential, final PasswordChangeBean bean) {
        final UsernamePasswordCredential c = (UsernamePasswordCredential) credential;
        final PasswordEncoder encoder = PasswordEncoderUtils.newPasswordEncoder(properties.getJdbc().getPasswordEncoder());
        final String password = encoder.encode(bean.getPassword());
        final int count = this.jdbcTemplate.update(properties.getJdbc().getSqlChangePassword(), password, c.getId());
        return count > 0;
    }

What's wrong?

Thanks all.

[Ray Bon]

Nicola,

You can get hibernate to show the sql that it is sending to the database:

https://apereo.github.io/cas/5.3.x/installation/Configuration-Properties-Common.html#hibernate--jdbc

This may provide some more insight into your problem.

Ray

-- 

Ray Bon

Programmer Analyst

Development Services, University Systems

2507218831 | CLE 019 | rb...@uvic.ca

[Nicola Boldrin]

Hi Ray,

I've verified that the SQL is ok. After trying the cas.authn.pm.jdbc.autocommit property needlessly, the application did work perfectly. I suppose that I had a build problem with my Eclipse.

Thanks for your suggestion.

Nicola

[Martin Böhmer]

I experienced the exact same behaviour and solved it by setting autocommit = true. Don't think it is your IDE causing the problem.

[Nicola Boldrin]

Thank you Martin.
I have repeated tests, you are right, the autocommit=true is the definitive solution to the problem.