On Tue, Jul 7, 2020 at 2:49 PM carlog <[email protected]> wrote:
> Ah! Now we're getting somewhere. > > INO o.a.g.r.auth.AuthenticationService - User "myuser" successfully > authenticated from [ipaddress]. > ERROR o.a.g.rest.RESTExceptionMapper - Unexpected internal error: > ### Error updating database. Cause: > java.sql.SQLIntegrityConstraintViolationException: Column 'user_id' cannot > be null > ### The error may involve > org.apache.guacamole.auth.jdbc.user.UserMapper.insertAttributes-Inline > eters > ### The error occurred while setting parameters > ### SQL: INSERT INTO guacamole_user_attribute ( > user_id,attribute_name,attribute_value) > ### Cause: java.sql.SQLIntegrityConstraintViolationException: Column > 'user_id' cannot be null > > > You said earlier that you have the TOTP extension installed? If that's the case, you likely need to enable the option to auto-create users within the database. Depending on what DB you're using, this is done with one of the following options: mysql-auto-create-accounts: true postgresql-auto-create-accounts: true sqlserver-auto-create-accounts: true This will allow users authenticated through LDAP to be automatically created in the JDBC module, which will then allow them to be configured for TOTP. -Nick
