2 Replies Latest reply: Mar 22, 2017 9:31 AM by Ismail Baygin RSS

    Qlik Sense Custom ODBC User Directory inactivates users during login

    Ismail Baygin

      Hi all,

       

      I have configured a custom ODBC User Directory which fetches users from a Postgresql database.

      It successfully managed to populate Users list with the users in these tables.

      No problem so far.

      Then, I generate a ticket for one of these custom users (DIR\user1 for example) and consume it with the link below to open a new session :

       

      https://qlikserver.domain.local/vp/hub?qlikTicket=kd_K_69s6QX_.3M-

       

      These attempt immidiately throws an error below:

      "Your account is inactive. Contact your administrator to activate it."

       

      If I "sync" the user directory, the user becomes active again and I proceed to log him in with the same ticket without error.

      But it is annoying that i need to sync user directory so often.

       

      The documentation indicates that if the user was removed from the source database, it may block or inactivate the user for security reasons but my users still exist in the db. Link : Inactivating users ‒ Qlik Sense

       

       

      By the way Repository Logs says:

       

      System.Repository.Repository.Core.Security.UserManagement.TransientUserCache

      QLIKSERVER\Administrator

      Denying access for user DIR\user1 which is marked as inactive