New Employee Username must be Lowercase

Topics brought up by the TimeTrex open source community.
Post Reply
bgrorud
Posts: 6
Joined: Thu Mar 31, 2016 12:20 pm

New Employee Username must be Lowercase

Post by bgrorud » Tue May 10, 2016 4:43 pm

I could not find this addressed in another post. Recently we tried to add a new employuee to our system (Community Edition v9.0.12) and after creating the employee they were unable to log in. We have out of habit always created all our usernames in Uppercase and that is how the employee logged in. I have found that all employees, the username is shown in lowercase, but employees that were previously entered can log in with either uppercase or lowercase on the username.

Additionally I was told, that someone else when they were a new employee a couple years ago, that also HAD to use lowercase to login, but now it works either way.

Is it something where a new employee can only have a lowercase username? I do know that if you try to save it as uppercase, it changes it to lower when you go to view that employee, but just find it odd that existing users can login with uppercase usernames, but new ones cannot.

-Brad

shaunw
Posts: 7360
Joined: Tue Sep 19, 2006 2:22 pm

Re: New Employee Username must be Lowercase

Post by shaunw » Wed May 11, 2016 8:25 am

usernames have always been case insensitive (upper or lower case doesn't matter), however passwords used to be case insensitive 1-2 years ago or so but now they are case sensitive.

Also keep in mind that if an employee makes too many failed login attempts their IP address is locked out for a period of time so no password will ever work until the lock has expired.

bgrorud
Posts: 6
Joined: Thu Mar 31, 2016 12:20 pm

Re: New Employee Username must be Lowercase

Post by bgrorud » Wed May 11, 2016 8:40 am

So the fact that a new user setup on our system could ONLY log in if they used all lowercase was an anomaly? I will have to see if I can reproduce with another new user. I will also check if now that they have gone through the initial "change password" prompt if it will now allow you to log in if you type uppercase.

-Brad

shaunw
Posts: 7360
Joined: Tue Sep 19, 2006 2:22 pm

Re: New Employee Username must be Lowercase

Post by shaunw » Wed May 11, 2016 8:56 am

Check the "users" table in the database, are the usernames uppercase?

They should all be lower case, as TimeTrex forces them to lowercase unless you have manually modified the database yourself, in which case all bets are off.

bgrorud
Posts: 6
Joined: Thu Mar 31, 2016 12:20 pm

Re: New Employee Username must be Lowercase

Post by bgrorud » Wed May 11, 2016 9:15 am

That part I checked and it does force to lowercase. If you type in the Username as upper, save, then go back into it, it is switched to lower. I'll test the rest the next time I am on that system later this week.

Post Reply