Previous Thread
Next Thread
Print Thread
Hop To
#219688 11/26/2008 11:39 PM
Joined: Oct 2007
Posts: 354
Likes: 8
Enthusiast
Enthusiast
Joined: Oct 2007
Posts: 354
Likes: 8
We have a user on our board who cannot login. Even with me taking control of his account, changing the password (so I know what it is), logging out and then attempting to login, the login fails.

Here's the error message: Username/Password not found.

I thought at first that it might be related to his login name having spaces in it (xxx xx xxxxx), but we have other login names with similar patterns and spaces in the name, and they are not having this problem.

If I attempt to login using my login name and an incorrect password, I get this error message: Incorrect password for that username. If I do exactly the same thing with his account, I get the same error I wrote above when I type in the correct password.

Any idea what where to go to fix this would be appreciated.


The Stovebolt Geek
https://www.stovebolt.com/ubbthreads/ubbthreads.php

Server Information
UBB.threads Version 7.7.5
Release 20201027
Server OS Linux
Server Load 0.16
Web Server Apache/2.4.6
PHP Version 7.4.33
MYSQL Version 5.7.43
Database Size 1.85 GB
Joined: Apr 2007
Posts: 120
member
member
Joined: Apr 2007
Posts: 120
Is it possible the username has a space at the end? Would UBB allow that to happen?


Joined: Oct 2007
Posts: 354
Likes: 8
Enthusiast
Enthusiast
Joined: Oct 2007
Posts: 354
Likes: 8
I think it's possible, but I tested for that and got the same result.


The Stovebolt Geek
https://www.stovebolt.com/ubbthreads/ubbthreads.php

Server Information
UBB.threads Version 7.7.5
Release 20201027
Server OS Linux
Server Load 0.16
Web Server Apache/2.4.6
PHP Version 7.4.33
MYSQL Version 5.7.43
Database Size 1.85 GB
Joined: Jun 2006
Posts: 811
old hand
old hand
Joined: Jun 2006
Posts: 811
Sounds like something funky from the log-in name that is messing it up.

Joined: Feb 2007
Posts: 1,294
Likes: 2
Veteran
Veteran
Joined: Feb 2007
Posts: 1,294
Likes: 2
I would edit the user account using PHPMyAdmin and make sure everything is ok in the database, manually change the password and then try logging in again to his account to see if that fixes the problem.

This sounds like a corruption in he member file in the data base.

Joined: Oct 2007
Posts: 354
Likes: 8
Enthusiast
Enthusiast
Joined: Oct 2007
Posts: 354
Likes: 8
Originally Posted by Mitch P.
Sounds like something funky from the log-in name that is messing it up.
That was my first thought, but, as I stated in the original post, we have other accounts with similar patterns that work fine. So, I doubt the problem is the login name. It's something unique to this account. I just don't know what it would be.


The Stovebolt Geek
https://www.stovebolt.com/ubbthreads/ubbthreads.php

Server Information
UBB.threads Version 7.7.5
Release 20201027
Server OS Linux
Server Load 0.16
Web Server Apache/2.4.6
PHP Version 7.4.33
MYSQL Version 5.7.43
Database Size 1.85 GB
Joined: Oct 2007
Posts: 354
Likes: 8
Enthusiast
Enthusiast
Joined: Oct 2007
Posts: 354
Likes: 8
Originally Posted by Thelockman
I would edit the user account using PHPMyAdmin and make sure everything is ok in the database, manually change the password and then try logging in again to his account to see if that fixes the problem.

This sounds like a corruption in he member file in the data base.
Yes, but what to edit? And where would the corruption be? Is there a way to identify it? I don't need phpmyadmin (and don't have it installed) to edit the db, but I do need to have some idea of where to look.

I assume the problem is going to be in the _USERS table. When I look at the columns in that table and compare his information, it all looks quite normal.


The Stovebolt Geek
https://www.stovebolt.com/ubbthreads/ubbthreads.php

Server Information
UBB.threads Version 7.7.5
Release 20201027
Server OS Linux
Server Load 0.16
Web Server Apache/2.4.6
PHP Version 7.4.33
MYSQL Version 5.7.43
Database Size 1.85 GB
Joined: Oct 2007
Posts: 354
Likes: 8
Enthusiast
Enthusiast
Joined: Oct 2007
Posts: 354
Likes: 8
Here's something strange. When I run the following command, I get a return for my account but not for his.

select * from xxx_USERS where USER_LOGIN_NAME='mine'

select * from xxx_USERS where USER_LOGIN_NAME='his'

(I've munged the three letter prefix that I use and replaced the actual user login names with mine and his.)

That indicates that there is something wrong with his account but what?


The Stovebolt Geek
https://www.stovebolt.com/ubbthreads/ubbthreads.php

Server Information
UBB.threads Version 7.7.5
Release 20201027
Server OS Linux
Server Load 0.16
Web Server Apache/2.4.6
PHP Version 7.4.33
MYSQL Version 5.7.43
Database Size 1.85 GB
Joined: Oct 2007
Posts: 354
Likes: 8
Enthusiast
Enthusiast
Joined: Oct 2007
Posts: 354
Likes: 8
I logged in to the db and ran some commands. I found the problem. His user login name is not "xxx xx xxxxx", it's " xxx xx xxxxx". IOW, there's a space before the first character. Sheesh.


The Stovebolt Geek
https://www.stovebolt.com/ubbthreads/ubbthreads.php

Server Information
UBB.threads Version 7.7.5
Release 20201027
Server OS Linux
Server Load 0.16
Web Server Apache/2.4.6
PHP Version 7.4.33
MYSQL Version 5.7.43
Database Size 1.85 GB
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
This is why I say we get the "admin" ability to edit usernames :/...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Feb 2007
Posts: 1,294
Likes: 2
Veteran
Veteran
Joined: Feb 2007
Posts: 1,294
Likes: 2
I agree there totally Gizmo.

Joined: Apr 2007
Posts: 120
member
member
Joined: Apr 2007
Posts: 120
Originally Posted by Baldeagle
I logged in to the db and ran some commands. I found the problem. His user login name is not "xxx xx xxxxx", it's " xxx xx xxxxx". IOW, there's a space before the first character. Sheesh.


I think it would be worth the coding effort to not allow spaces before or after the login or password.


Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Yes to what Gizmo said, that's coming in the control panel update. And yes, to what Piper said is I need to edit the code so it doesn't allow spaces at the beginning/end even when special characters are turned on.

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
I'm totally for "no space before and after" the pdn and username; but I do know several users who casually use spaces in their passwords (in fact, one of them is wheelchair bound and hardly has use of her hands and has to enter numerous spaces in her password)


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
2 members (Havenofsobriety, rootman), 624 guests, and 106 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)