[ 
https://issues.apache.org/jira/browse/GUACAMOLE-1476?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17458391#comment-17458391
 ] 

Murat BÜLBÜL commented on GUACAMOLE-1476:
-----------------------------------------

 

[...]

ldap-hostname: 1.2.3.4

ldap-port: 389

ldap-user-base-dn: dc=test,dc=local

ldap-search-bind-dn: cn=ldap,cn=Users,dc=test,dc=local

ldap-search-bind-password: test123

ldap-username-attribute: sAMAccountName

ldap-user-search-filter: 
(&(objectCategory=person)(objectClass=user)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))

ldap-max-search-results: 40000

ldap-encryption-method: none

ldap-operation-timeout: 5

ldap-group-base-dn: dc=test,dc=local

ldap-group-name-attribute: sAMAccountName

mysql-user-required: false

 

[...]

 

 

Backend log:

 

13:28:53.238 [https-openssl-apr-8443-exec-9] 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

### The error occurred while setting parameters

### SQL: INSERT INTO guacamole_user_attribute (             user_id,            
 attribute_name,             attribute_value         )         VALUES           
                     (?,                  ?,                  ?)              , 
                 (?,                  ?,                  ?)

### Cause: java.sql.SQLIntegrityConstraintViolationException: *Column 'user_id' 
cannot be null*

 

> LDAP OU or Group Based granting connections on guacamole web ui.
> ----------------------------------------------------------------
>
>                 Key: GUACAMOLE-1476
>                 URL: https://issues.apache.org/jira/browse/GUACAMOLE-1476
>             Project: Guacamole
>          Issue Type: Improvement
>          Components: guacamole
>    Affects Versions: 1.3.0
>         Environment: Web Gui
>            Reporter: Murat BÜLBÜL
>            Priority: Major
>
>  Ldap group-based or ou-based authorization should be applied on web ui. In 
> the current version, we must create all users one by one. 



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

Reply via email to