login problems

[Ivona]

I can't seem to figure out why a particular user cannot login. I've changed his password, I've checked his permissions..I don't know what else to try.

The error that keeps on coming up is this:

Livelink Error:
Error logging in.

[Invalid username/password specified.]

 

[VOLFONI]

Hi,
We do have some problems with Dircetory Service + LDAP
indeed, LDAP does not check case sensistivity of the *login* while LL does.
Users understand password is case sensitive but not that login coud be too...

 

[Ivona]

I've tried logging in using this person's login and changed password. I keep getting the same message...

No other user login seems to be having this problem...

 

[appnair]

have you checked a space after the user id.Common mistake
when cutting and pasting from excel ?.You can run this query to rule out that what livelink has in its database.

select length(name) as my_length,name ,id  from kuaf where name like 'nairkn'

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

 

[Ivona]

Already tried that..I retyped the user login name..

I am at my wit's end..

 

[Ivona]

Thanks for the script! I ran it with the user's login name..and guess what! He's in there twice!

How is that even possible??

Confused...

 

[appnair]

what that means is one is a deleted guy.The code to show active users will be like this

select * from kuaf where name like 'the suspected username'
and deleted=0 and type=0

Explanation if you do not know this already
like means anything that is like the name
if the user name is 'sally' like 'sally' will bring up sally
if you say 'sall%' in oracle it means that I am looking for
anything that has 'sall' as well as anything after that.Wildcard in oracle sql
deleted=0 flag used in livelink to say an active user
type=0 flag used in livelink to say it is a user rather than a group

select * from kuaf where deleted <> 0 and type = 0

The above sql will give you all users in your database
that was deleted.You will find the second of your entry there

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

 

[appnair]

If it is still not resolved make sure the client computer from which the ll call is issued does not have a cached password in them(clear them)

If it is IE then it is
Tools->Internet options->Content->Autocomplete

On an XP client computer
Start->Settings->User accounts->Advanced->Manage Passwords
Clear any entries relevent to livelink there.

These should really fix most client connectivity issues.
If you want to approach with an axe you can start up Builder and actually look at the userid coming into livelink also.


Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

 

[Ivona]

I ran the suggested scripts...and I think we're on to something...

The username appears on the deleted userid report, but without the associated delete code...

Now I just have to figure out if it's safe to simply go into the table and blow this record away...

Thanks for all your help everybody!!!!!!

 

[appnair]

do not do any direct table updates to any livelink tables.You will end up ruining the referential integrity of the schema..It is perfectly normal for this scenario

User was originally created with loginname 'nairkn'.For all practical purposes if you look at the table you will see that 'nairkn' and a id number for eg "34559870"
If you now try to create a login name "nairkn" livelink will report that user already exists.
If "nairkn" left the org then you will delete "nairkn" thru the GUI in this case it puts a deletion marker(1)against the userid 34559870.Livelink never deletes a row form its tables
Now you can reuse the loginname "nairkn" one more time.

In your case all you have to do is delete the userid's thru the livelink gui and re-create them.NEVER THROUGH ORACLE OR AN ADHOC TOOL.




Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

 

[Ivona]

Here is the problem...

I ran the script (thanks!) to list all deleted users...

check this out:

bsmith (Delete) 38939
bryan smith (Delete) 39054
bsmith

It's 'bsmith' that is the problematic user login...

 

[appnair]

the last entry should not be coming in the deleted users report.What happens when you run this

select name,id from kuaf where deleted=0 
and type=0 and name='bsmith'

This query should return the id,name of the real 'bsmith' in your installation.What good will checking deleted users do.You should never be concerned about deleted users in livelink.They do not participate in anything

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

 

[appnair]

I meant to type a little more.At this point what I think is happening is the real,undeleted username that starts with
'bsmith' has a 'login enabled' flag off.To check that open that bsmith's record and see if the 'login Enabled' is checked or not.Maybe you should have done this the first time.Sorry for driving you up the bend

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

 

[Ivona]

Yes, that's what I was trying to say..
that 'bsmith' is showing up on a deleted user list, even though he is not truly 'deleted' (ie: his login name still shows up when I use the app to list all users).

How do I fix his login enabled flag??

Thx,
ivona

 

[ggriffit]

If you find the user via the User & Groups option and then open their profile, the 'login enabled' checkbox is at the bottom of that screen.

 

[appnair]

Here's a general way to access a deleted user's record in livelink
This is available in the livelink knowledge base also

Prep work
a)Write down the id for the 'bsmith' thru
a database query let's assume that bsmith has

select id,name as "loginname" from kuaf where deleted <>0 and type=0 and  name like 'bsmit%'

Let's assume that the query results in something like this

34580 bsmith

b)Login to livelink as Admin
c)Pull a user record that you know that works
click EDIT and copy the resultant URL somewhere convenient

http://<myserver>/Livelink.exe?func...ral&nextURL=/Livelink.exe?func=user.listusers

d)Substitute the userID=34868647 with the ID that you
got from step A
d)Run the URL.Now you are accessing a deleted user thru the
livelink GUI
e)Check and update the user record appropriately.Especially the privileges to the user like 'Login' Public access etc.
If it is certainly a delted user you may have to clear the 'johnsonda (Delete) 28834441' in the name field

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

 

[appnair]

Was this ever resolved? What did you do to resolve this?Just curious and good etiquette demands feedback from users.Then only this site can be used for knowledge sharing

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937