Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
Now, who can help me with this challenge?
Setup
We have one Qlik Sense (Nov 2017) server, but have users in two different AD-servers.
The Qlik server belongs to the AD-1 domain, but is set up with 2 User Directory Connectors:
Currently, none of them have any LDAP filters, so we get all the users in both directories.
Both are running (we have traced the network traffic) and they are both importing users, which we can see in QMC under Users:
Logging in
When User Ada goes to https://qlik.company.com/, she gets redirected to https://qlik.company.com:4244/windows_authentication/?targetId=....and gets the popup login box. Ada can log in by using both 'userA' and 'AD-1\UserA'.
When User Bob goes to the same address: https://qlik.company.com/, he too gets redirected to https://qlik.company.com:4244/windows_authentication/?... and gets the password box.
But when entering a user and password, the login box just reappears.
To verify, we have cross-checked where the user is sitting when logging in, with what domain he/she is using:
Logging from a PC in: Logging in as: | Domain 1 | Domain 2 |
---|---|---|
AD-1\UserA | Works | Works |
AD-2\UserB | Doesn't work | Doesn't work |
LDAP verification
Using powershell ´System.DirectoryServicees.Protocols.LdapConnection.Bind´ on the Qlik Sense server, I have tested users and passwords.
Both users return success, so I cannot see that there is any network, firewall etc issues.
Qlik Sense and multiple LDAP servers
Can Qlik Sense have more than one LDAP server?
Where do I look? I cannot find any traces of UserB in any logfiles.
I have tried changing 'Windows authentication pattern' from 'Windows' to 'webforms'.
Then I get the following in the log files. It sort of reports 'wrong password', but I am using the same passwords that works when testing the password by powershell. So I believe this is a false error message. Sense is checking the wrong LDAP controller?
Anyone know how I can check this?
Audit\QLIK_AuditSecurity_Proxy.txt
ProductVersion | 11.28.4.0 |
Timestamp | 20180928T151051.938+0200 |
Hostname | QLIK |
Id | bdf90a0d-0515-4cc7-944e-a28b6f609459 |
Description | Command=Login;Result=403;ResultText=Error: Access Denied |
ProxySessionId | 0 |
ProxyPackageId | 0 |
RequestSequenceId | 0 |
UserDirectory | INTERNAL |
UserId | sa_proxy |
ObjectId | 0 |
ObjectName | Not available |
SecurityClass | Security |
ClientHostAddress | Not available |
Service | Proxy |
Origin | Not available |
Context | Not available |
Command | Login:TryLogin |
Result | 403 |
Message | Login failed for user 'AD-2\userb' wrong credentials? |
Checksum | 8138b5be236446cab5a21c20515d94980799a9b4 |
System\QLIK_Service_Proxy.txt
ProductVersion | 11.28.4.0 |
Timestamp | 20180928T151051.939+0200 |
Severity | WARN |
Hostname | QLIK |
Id | 4c678dba-f2ed-4ebb-9ea4-147e4f1a8789 |
Description | Command=Login;Result=403;ResultText=Error: Access Denied. 'TryLogin' |
ProxySessionId | 0 |
ProxyPackageId | 0 |
RequestSequenceId | 0 |
UserDirectory | INTERNAL |
UserId | sa_proxy |
ObjectId | 0 |
ObjectName | Not available |
Service | Proxy |
Origin | Not available |
Context | Not available |
Command | Login |
Result | 403 |
Message | Login failed for user 'AD-2\userb' wrong credentials? |
Id2 | 4c678dba-f2ed-4ebb-9ea4-147e4f1a8789 |
Trace\QLIK_Audit_Proxy.txt
Timestamp | 20180928T151051.940+0200 |
Level | WARN |
Hostname | QLIK |
Logger | Audit.Proxy.Proxy.DefaultModules.Authentication.FormAuthenticationRequestHandler |
Thread | 63 |
Id | 908011f7-5216-4c46-a06c-05266309692d |
ServiceUser | AD-1\svc_qlik |
Message | Login: failed. |
ProxySessionId | 0 |
ConnectionId | ConnectionId |
ActiveUserDirectory | AD-2 |
ActiveUserId | userb |
TicketId | - |
IpAddress | - |
AppId | - |
TargetHost | - |
VirtualProxy | - |
Checksum | ea7520116fc6b03d4e49cf73eeb46ae00f92deb4 |
Hi,
We are encountering the same issue where two user directories are configured and only one of the AD login is working. Could you please let me know how this was resolved?