Not able to login to flowable-modeler

Hi,

I am new in flowable. I am using LDAP in flowable-idm. When i gave privileges to access modeler in flowable-idm to user ankit, then modeler not login.

Below is my configuration:

docker-compose.yml:
environment:

  • SERVER_PORT=9090
  • SPRING_DATASOURCE_DRIVER-CLASS-NAME=org.postgresql.Driver
  • SPRING_DATASOURCE_URL=<>
  • SPRING_DATASOURCE_USERNAME=<>
  • SPRING_DATASOURCE_PASSWORD=<>
    #Default LDAP Admin User
  • FLOWABLE_IDM_APP_ADMIN_USER_ID=<>
  • FLOWABLE_IDM_APP_ADMIN_PASSWORD=<>
  • FLOWABLE_IDM_APP_ADMIN_FIRST_NAME=<>
  • FLOWABLE_COMMON_APP_IDM_ADMIN_USER=<>
  • FLOWABLE_COMMON_APP_IDM_ADMIN_PASSWORD=<>
    #FLowable-Ldap Configuration
  • FLOWABLE_IDM_LDAP_ENABLED=true
  • FLOWABLE_IDM_LDAP_SERVER=
  • FLOWABLE_IDM_LDAP_PORT=389
  • FLOWABLE_IDM_LDAP_USER=<>
  • FLOWABLE_IDM_LDAP_PASSWORD=<>
  • FLOWABLE_IDM_LDAP_BASE_DN=<>
    #Users
  • FLOWABLE_IDM_LDAP_USER_BASE_DN=<>
  • FLOWABLE_IDM_LDAP_QUERY_USER_BY_FULL_NAME_LIKE=(&(objectClass=inetOrgPerson)(|({0}= {1} )({2}= {3} )))
  • FLOWABLE_IDM_LDAP_QUERY_USER_BY_ID=(&(objectClass=inetOrgPerson)(uid={0}))
  • FLOWABLE_IDM_LDAP_QUERY_ALL_USERS=(objectClass=inetOrgPerson)
  • FLOWABLE_IDM_LDAP_ATTRIBUTE_USER_ID=uid
  • FLOWABLE_IDM_LDAP_ATTRIBUTE_FIRST_NAME=cn
  • FLOWABLE_IDM_LDAP_ATTRIBUTE_LAST_NAME=sn
    #Groups
  • FLOWABLE_IDM_LDAP_GROUP_BASE_DN=<>
  • FLOWABLE_IDM_LDAP_QUERY_GROUPS_FOR_USER=(&(objectClass=posixGroup)(gidNumber={0}))
  • FLOWABLE_IDM_LDAP_QUERY_ALL_GROUPS=(objectClass=posixGroup)
  • FLOWABLE_IDM_LDAP_QUERY_GROUP_BY_ID=(&(objectClass=posixGroup)(gidNumber={0}))
  • FLOWABLE_IDM_LDAP_ATTRIBUTE_GROUP_ID=gidNumber
  • FLOWABLE_IDM_LDAP_ATTRIBUTE_GROUP_NAME=cn
  • FLOWABLE_IDM_LDAP_CACHE_GROUP_SIZE=10000
  • FLOWABLE_IDM_LDAP_CACHE_GROUP_EXPIRATION=180000

Below is my logs of flowable-idm while login with flowable-modeler:

2020-03-31 04:58:46.510 DEBUG 1 — [nio-8080-exec-2] stomUsernamePasswordAuthenticationFilter : Request is to process authentication
2020-03-31 04:58:47.496 DEBUG 1 — [nio-8080-exec-2] o.f.c.e.i.i.LogInterceptor : — starting CreatePrivilegeQueryCmd --------------------------------------------------------
2020-03-31 04:58:47.496 DEBUG 1 — [nio-8080-exec-2] o.f.c.s.SpringTransactionInterceptor : Running command with propagation REQUIRED
2020-03-31 04:58:47.496 DEBUG 1 — [nio-8080-exec-2] o.f.c.e.i.i.LogInterceptor : — CreatePrivilegeQueryCmd finished --------------------------------------------------------
2020-03-31 04:58:47.496 DEBUG 1 — [nio-8080-exec-2] o.f.c.e.i.i.LogInterceptor : — starting PrivilegeQueryImpl --------------------------------------------------------
2020-03-31 04:58:47.496 DEBUG 1 — [nio-8080-exec-2] o.f.c.s.SpringTransactionInterceptor : Running command with propagation REQUIRED
2020-03-31 04:58:47.497 DEBUG 1 — [nio-8080-exec-2] e.i.p.e.P.selectPrivilegeByQueryCriteria : ==> Preparing: select RES.* from ACT_ID_PRIV RES WHERE exists(select 1 from ACT_ID_PRIV_MAPPING mapping where RES.ID_ = mapping.PRIV_ID_ and mapping.USER_ID_ = ?) order by RES.ID_ asc
2020-03-31 04:58:47.498 DEBUG 1 — [nio-8080-exec-2] e.i.p.e.P.selectPrivilegeByQueryCriteria : ==> Parameters: ankit(String)
2020-03-31 04:58:47.499 DEBUG 1 — [nio-8080-exec-2] e.i.p.e.P.selectPrivilegeByQueryCriteria : <== Total: 1
2020-03-31 04:58:47.499 DEBUG 1 — [nio-8080-exec-2] o.f.c.e.i.d.DbSqlSession : Flushing dbSqlSession
2020-03-31 04:58:47.500 DEBUG 1 — [nio-8080-exec-2] o.f.c.e.i.d.DbSqlSession : flush summary: 0 insert, 0 update, 0 delete.
2020-03-31 04:58:47.500 DEBUG 1 — [nio-8080-exec-2] o.f.c.e.i.d.DbSqlSession : now executing flush…
2020-03-31 04:58:47.500 DEBUG 1 — [nio-8080-exec-2] o.f.c.e.i.i.LogInterceptor : — PrivilegeQueryImpl finished --------------------------------------------------------
2020-03-31 04:58:47.501 DEBUG 1 — [nio-8080-exec-2] stomUsernamePasswordAuthenticationFilter : Authentication success. Updating SecurityContextHolder to contain: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@689e082e: Principal: org.flowable.ui.common.security.FlowableAppUser@58a8789: Username: ankit; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: access-modeler; Credentials: [PROTECTED]; Authenticated: true; Details: org.springframework.security.web.authentication.WebAuthenticationDetails@ffffa64e: RemoteIpAddress: 172.26.0.1; SessionId: null; Granted Authorities: access-modeler
2020-03-31 04:58:47.501 DEBUG 1 — [nio-8080-exec-2] u.i.s.CustomPersistentRememberMeServices : Creating new persistent login for user ankit
2020-03-31 04:58:47.502 DEBUG 1 — [nio-8080-exec-2] o.f.c.e.i.i.LogInterceptor : — starting CreateTokenCmd --------------------------------------------------------
2020-03-31 04:58:47.502 DEBUG 1 — [nio-8080-exec-2] o.f.c.s.SpringTransactionInterceptor : Running command with propagation REQUIRED
2020-03-31 04:58:47.502 DEBUG 1 — [nio-8080-exec-2] o.f.c.e.i.i.LogInterceptor : — CreateTokenCmd finished --------------------------------------------------------
2020-03-31 04:58:47.502 DEBUG 1 — [nio-8080-exec-2] o.f.c.e.i.i.LogInterceptor : — starting SaveTokenCmd --------------------------------------------------------
2020-03-31 04:58:47.502 DEBUG 1 — [nio-8080-exec-2] o.f.c.s.SpringTransactionInterceptor : Running command with propagation REQUIRED
2020-03-31 04:58:47.502 DEBUG 1 — [nio-8080-exec-2] o.f.c.e.i.d.DbSqlSession : Flushing dbSqlSession
2020-03-31 04:58:47.502 DEBUG 1 — [nio-8080-exec-2] o.f.c.e.i.d.DbSqlSession : insert TokenEntity[tokenValue=kqORMIbnLUCcoWiV4ihxRA==, userId=ankit]
2020-03-31 04:58:47.503 DEBUG 1 — [nio-8080-exec-2] o.f.c.e.i.d.DbSqlSession : flush summary: 1 insert, 0 update, 0 delete.
2020-03-31 04:58:47.503 DEBUG 1 — [nio-8080-exec-2] o.f.c.e.i.d.DbSqlSession : now executing flush…
2020-03-31 04:58:47.503 DEBUG 1 — [nio-8080-exec-2] o.f.c.e.i.d.DbSqlSession : inserting: TokenEntity[tokenValue=kqORMIbnLUCcoWiV4ihxRA==, userId=ankit]
2020-03-31 04:58:47.503 DEBUG 1 — [nio-8080-exec-2] o.f.i.e.i.p.e.T.insertToken : ==> Preparing: insert into ACT_ID_TOKEN ( ID_, REV_, TOKEN_VALUE_, TOKEN_DATE_, IP_ADDRESS_, USER_AGENT_, USER_ID_, TOKEN_DATA_ ) values ( ?, 1, ?, ?, ?, ?, ?, ? )
2020-03-31 04:58:47.503 DEBUG 1 — [nio-8080-exec-2] o.f.i.e.i.p.e.T.insertToken : ==> Parameters: y8lhVr2aTGrMYzf5jj26CQ==(String), kqORMIbnLUCcoWiV4ihxRA==(String), 2020-03-31 04:58:47.502(Timestamp), 172.26.0.1(String), Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.149 Safari/537.36(String), ankit(String), null
2020-03-31 04:58:47.504 DEBUG 1 — [nio-8080-exec-2] o.f.i.e.i.p.e.T.insertToken : <== Updates: 1
2020-03-31 04:58:47.504 DEBUG 1 — [nio-8080-exec-2] o.f.c.e.i.i.LogInterceptor : — SaveTokenCmd finished --------------------------------------------------------
2020-03-31 04:58:47.520 DEBUG 1 — [nio-8080-exec-8] u.i.s.CustomPersistentRememberMeServices : Remember-me cookie detected
2020-03-31 04:58:47.521 DEBUG 1 — [nio-8080-exec-8] o.f.c.e.i.i.LogInterceptor : — starting CreateTokenQueryCmd --------------------------------------------------------
2020-03-31 04:58:47.521 DEBUG 1 — [nio-8080-exec-8] o.f.c.s.SpringTransactionInterceptor : Running command with propagation REQUIRED
2020-03-31 04:58:47.521 DEBUG 1 — [nio-8080-exec-8] o.f.c.e.i.i.LogInterceptor : — CreateTokenQueryCmd finished --------------------------------------------------------
2020-03-31 04:58:47.521 DEBUG 1 — [nio-8080-exec-8] o.f.c.e.i.i.LogInterceptor : — starting TokenQueryImpl --------------------------------------------------------
2020-03-31 04:58:47.521 DEBUG 1 — [nio-8080-exec-8] o.f.c.s.SpringTransactionInterceptor : Running command with propagation REQUIRED
2020-03-31 04:58:47.522 DEBUG 1 — [nio-8080-exec-8] f.i.e.i.p.e.T.selectTokenByQueryCriteria : ==> Preparing: select RES.* from ACT_ID_TOKEN RES WHERE RES.ID_ = ? order by RES.ID_ asc
2020-03-31 04:58:47.522 DEBUG 1 — [nio-8080-exec-8] f.i.e.i.p.e.T.selectTokenByQueryCriteria : ==> Parameters: y8lhVr2aTGrMYzf5jj26CQ==(String)
2020-03-31 04:58:47.531 DEBUG 1 — [nio-8080-exec-8] f.i.e.i.p.e.T.selectTokenByQueryCriteria : <== Total: 1
2020-03-31 04:58:47.531 DEBUG 1 — [nio-8080-exec-8] o.f.c.e.i.d.DbSqlSession : Flushing dbSqlSession
2020-03-31 04:58:47.532 DEBUG 1 — [nio-8080-exec-8] o.f.c.e.i.d.DbSqlSession : flush summary: 0 insert, 0 update, 0 delete.
2020-03-31 04:58:47.532 DEBUG 1 — [nio-8080-exec-8] o.f.c.e.i.d.DbSqlSession : now executing flush…
2020-03-31 04:58:47.532 DEBUG 1 — [nio-8080-exec-8] o.f.c.e.i.i.LogInterceptor : — TokenQueryImpl finished --------------------------------------------------------

Kindly help me to find issue. Thanks

Hey @ankit45621,

Please stop creating duplicate questions. You created this and User not able to login flowable-modeler in almost the exact same time. Please be patient and provide more information as a reply to a post, not a new question.

Cheers,
Filip