Can't Login to admincp and user account

[fxdigi-cash]

I have a persistent issue with attempting to login to both user account as well as Admin cp. I found similar issue someone had https://vborg.vbsupport.ru/showthrea...=287312&page=2, but didn't find good solution to this problem.

I did these steps many times, but nothing worked for me... I use vb.4.2.2 pl1
-------------------
1- clear browser cache, but still get this issue whenever I try to login after 15 minutes and more " Wrong username or password. You have used up your failed login quota! Please wait 15 minutes before trying again. Don't forget that the password is case sensitive. Forgotten your password? Click here[color=Red]!"

2- used tools.php and executed the query TRUNCATE strikes;

3- reset the cache

and repeated the same steps on and one, but nothing worked...!!

any idea??

[Dave]

Are you using Cloudflare by any chance?

[fxdigi-cash]

Originally Posted by Dave

Are you using Cloudflare by any chance?

No, I'm not...

no other CDN as well...

[Dave]

Can you query the database? Check the session table and check the IP address column, does every result have the same IP or are the IP addresses different?

[fxdigi-cash]

Originally Posted by Dave

Can you query the database? Check the session table and check the IP address column, does every result have the same IP or are the IP addresses different?

I'm not sure how to query teh database...

The IP addresses for main forum, forum.php, admincp and login.php is the same, others are not.

do I have to change anything here?

[Dave]

Either upload something like PHPMyAdmin to your server or execute the query directly on your server under a SSH connection. First option would probably be easier for you. When did this issue start happening by the way?

[fxdigi-cash]

Originally Posted by Dave

Either upload something like PHPMyAdmin to your server or execute the query directly on your server under a SSH connection. First option would probably be easier for you. When did this issue start happening by the way?

I have phpmyadmin on my server installed!!

and have SSH connection as well..

This issue has started 2 days ago. I changed the cookie prefix in config.php and then removed the browser cache and could login without any issues. 1 day after that, I can't seem to login anymore... and till now the issue is on...

--------------- Added [DATE]1405348232[/DATE] at [TIME]1405348232[/TIME] ---------------

I could solve the issue myself...

I believe I had a hash issue so that's why it wouldn't let me to login...

I replaced the user table with previous one I have as a backup and now works fine.

Thanks for trying to help

Great health to everyone

[TheLastSuperman]

Remember everyone, when you change anything related to cookies its a good idea to clear your cookies (or in the least the cookies for said site). Using tools.php was a good idea if you're ever unsure but if all else fails you can run a query to reset any users password:

UPDATE `user`
SET `password` = MD5(CONCAT(MD5('newpassword'), `user`.`salt`))
WHERE `userid` = 1

Of course change newpassword to the actual password they wish to use and the 1 to the userid of the user in question. If your database uses a prefix then include the prefix.