Duplicate user profiles

Carsten Lempert shared this problem 6 days ago
In Progress

Hi,

when a new user login in YF, two user profiles where created! I see in the DB also two entries. So whats wrong?


/wfCLwSBypjKMQAAAABJRU5ErkJggg==

Comments (11)

photo
1

Here the database entries:

photo
1

Hi Carsten,

sounds like it might be bug, but I will need some more information so I can try and replicate it over here.

Are the new users LDAP users?

If so, are you using LDAP groups? Are you mapping them to Yellowfin client orgs?

Are you using "User Name" or "Email Address" as your Logon ID?

Is there a new account created for the same user every time they log back in? (e.g. if they log in 4 times, then they will have 4 profiles)

Are you using Active Directory or some other LDAP server such as Apache?

Which build of 7.4 are you using (e.g. 20150515)?

thanks,

David

photo
1

Actually there's one more thing that could be helpful to me.

Could you please turn on DEBUG logging and then get a user to to log in, and if that creates a duplicate account then please send me the yellowfin debug log.

thanks,

David

photo
1

HI,

ok I had enable the debug mode. Yes they are all ldap user. What do you mean with " Are you mapping them to Yellowfin client orgs?"

We are using the build number 20180104 and Version 7.4. Our LoginID is the username.

No I see only duplicate user entries when they only login the first time. The LDAP is a lightweight Server.

photo
1

Hi today we had the Problem again with an other user. But the yellowfin.log grows to fast. The 9 files are new every 10 Seconds...so this doesn't work ;)

photo
1

So now i have the logs. The user is called Markus Reeb. I also see two entries in the Person table

photo
1

Hi, our Administrators says it is Active Directory and not lightweight.

photo
1

Hi Christian,

thanks for the debug logs, and I can clearly see that Yellowfin is creating 2 entries:


YF:2018-06-14 13:34:48:DEBUG (IpClassManager:debug) - IpClass INSERT SQL: 
INSERT INTO  IpClass (  EmailRight, EmailLeft, IpId, Password, CRC, PasswordExpired, StartDate, EndDate, AccessAttempts ) VALUES (N'provinzial.de',N'markus.reeb',14722,N'sCN1YCcYxgijNIOKi4ktunPrgBQ=',null,1,'20180614','99991231',0)
and then again 5 seconds later:


YF:2018-06-14 13:34:53:DEBUG (IpClassManager:debug) - IpClass INSERT SQL: 
INSERT INTO  IpClass (  EmailRight, EmailLeft, IpId, Password, CRC, PasswordExpired, StartDate, EndDate, AccessAttempts ) VALUES (N'provinzial.de',N'markus.reeb',14723,N'6u4urVCxuOThdgarbYgQXbg+1NM=',null,1,'20180614','99991231',0)

So far unfortunately I have not been able to replicate this issue. I have used the same build of 7.4 as you, and am using Active Directory.

Could you please send me a screenshot of your LDAP Configuration screen so I can make sure I am doing the same as you, here is mine:

/Kmh0HT5YnWkAAAAASUVORK5CYIIA


And don't worry about my question about client orgs because I can see from your debug logs that you aren't using them, the users are logging into the Default Org (also known as Primary Org).


thanks,

David

photo
1

Hi,

we have configured AccessFilter...is it possible that this entries from there?


Here are our config:

photo
1

Hi Carsten,

unfortunately that config screenshot didn't come through, could you please try attaching it instead of pasting it?

Regarding the Access Filter, who knows, it could be possible that it is somehow caught up with the duplication bug. I would certainly like to test it out.

Please tell me know some more about your Access Filter, which type is it?

/EFAOUDQi9HFCr0CCHkfDImFB5ewROzoKwTF07CECZQb4DQyxEFC30t0fV3Hu1Qd19bhK5toM4AoQcAAFA4IPQAAAAKB4QeAABA4YDQAwAAKBwQegAAAIUDQg8AAKBwQOgBAAAUDgg9AACAwgGhBwAAUDgg9AAAAAoHhB4AAEDhgNADAAAonOHh4f8PnhRO4bvfsH8AAAAASUVORK5CYIIA

Do you have "New User Auto Refresh" switched on?

Do you have "Append" or "Overwrite" new values configured?

Do you have "Refresh Schedule" turned on?

thanks,

David

photo
1

Hi,

I use "SQL Query" You can see my config in the screenshot.