[CAS 6.2.0-SNAPSHOT] - Password management errors

[Nicola Boldrin]

Hi all,

my DB is PostgreSQL and the application server is Tomcat.

My configuration is

spring.mail.host=127.0.0.1
spring.mail.port=25
spring.mail.testConnection=true
spring.mail.properties.mail.smtp.auth=false
#spring.mail.properties.mail.smtp.starttls.enable=true
${configurationKey}.mail.from=no-replay@...................
${configurationKey}.mail.text=Reset password email subject
${configurationKey}.mail.subject=Reset password


cas.authn.pm.enabled=true

cas.authn.pm.jdbc.sqlSecurityQuestions=...................
cas.authn.pm.jdbc.sqlFindEmail=...................
cas.authn.pm.jdbc.sqlFindPhone=...................
cas.authn.pm.jdbc.sqlFindUser=...................
cas.authn.pm.jdbc.sqlChangePassword=...................
cas.authn.pm.reset.mail.from=no-replay@...................
cas.authn.pm.reset.mail.text=Reset your password with this link: %s
cas.authn.pm.reset.mail.subject=Password Reset Request
cas.authn.pm.jdbc.autocommit=true

When I use the "Reset your password" feature I receive the following error after email sent

ERROR [org.apereo.cas.ticket.registry.JpaTicketRegistry] - <Error getting ticket [TST-1-z4L3066xFP1dpV0XaSv-9gEFRct9C-Nb] from registry.>
 javax.persistence.PersistenceException: org.hibernate.HibernateException: org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode.

I have tried to set

 cas.authn.pm.jdbc.autocommit=false

without success.

When I use the "Forgot your username?" feature, instead, I can't send email due to the following error

WARN [org.apereo.cas.util.io.CommunicationsManager] - <Could not send email to [dbuser@...........] because either no from/to/subject/text is defined or email settings are not configured.>
ERROR [org.apereo.cas.pm.web.flow.actions.SendForgotUsernameInstructionsAction] - <Failed to send the username to the given email address>
WARN [org.apereo.cas.web.view.CasReloadableMessageBundle] - <The code [Failed to send the username to the given email address.] cannot be found in the default language bundle and will be used as the message itself.>

Any idea?

Thanks