Page 1 of 2

[SOLVED] password reset not taking

Posted: Sun May 19, 2024 9:00 pm
by Loady
I am pretty much locked out of my account, i use a password manager and log in on two devices, it just randomly say user/pass incorrect and then after the second failed attempt i am locked out for one hour with an offer to reset password, i do this and the password stills says it is wrong.

Re: password reset not taking

Posted: Sun May 19, 2024 9:14 pm
by JNeuhoff
Loady wrote:
Sun May 19, 2024 9:00 pm
I am pretty much locked out of my account, i use a password manager and log in on two devices, it just randomly say user/pass incorrect and then after the second failed attempt i am locked out for one hour with an offer to reset password, i do this and the password stills says it is wrong.
At the danger of repeating myself here: If you really want help then you have to provide more details, see forum rules.

Re: password reset not taking

Posted: Sun May 19, 2024 9:48 pm
by Loady
JNeuhoff wrote:
Sun May 19, 2024 9:14 pm
Loady wrote:
Sun May 19, 2024 9:00 pm
I am pretty much locked out of my account, i use a password manager and log in on two devices, it just randomly say user/pass incorrect and then after the second failed attempt i am locked out for one hour with an offer to reset password, i do this and the password stills says it is wrong.
At the danger of repeating myself here: If you really want help then you have to provide more details, see forum rules.
Sorry, my account was hacked on here and loads of stuff got changed.

Version 3.0.3.8
PHP ver not sure because i cant get in, think it is 8 or one before
Extensions, bulk order processing, royal mail click and drop
browser, Chome as i always have done
browser extensions, Bitwarden ( been using it to access without isses untill now), ublock origin (always had it without issues)

Re: password reset not taking

Posted: Sun May 19, 2024 10:24 pm
by Johnathan
Which account? Your forum account? Your OpenCart marketplace account? Your store?

If it's your store, then you can temporarily allow yourself to log in with any username/password by making this edit:

------------------------------------------------------------------------------
IN:
/system/library/cart/user.php

AFTER:
$user_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "user WHERE username = '" . $this->db->escape($username) . "' AND (password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, SHA1('" . $this->db->escape($password) . "'))))) OR password = '" . $this->db->escape(md5($password)) . "') AND status = '1'");

ADD:
if ($_SERVER['REMOTE_ADDR'] == '123.123.123.123') {
$user_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "user ORDER BY user_id ASC");
}
------------------------------------------------------------------------------

You replace 123.123.123.123 with your IP address. If you don't know what that is, just Google "what is my IP address".

You can make that edit, log in, then undo the edit. You can change your password after that. If it still doesn't work, your site may be hacked, so you should ask for help in the "Commercial Support" forum, which is checked by a number of OpenCart developers. You can also try checking out the OpenCart "Partners" area.

Re: password reset not taking

Posted: Sun May 19, 2024 10:34 pm
by JNeuhoff
If it is an OpenCart customer account, then do this via PHPMyAdmin:
DELETE FROM oc_customer_login WHERE email='your-customer-account-email';

Now you can immediately try the password reset again.

Re: password reset not taking

Posted: Sun May 19, 2024 11:28 pm
by Loady
Johnathan wrote:
Sun May 19, 2024 10:24 pm
Which account? Your forum account? Your OpenCart marketplace account? Your store?

If it's your store, then you can temporarily allow yourself to log in with any username/password by making this edit:

------------------------------------------------------------------------------
IN:
/system/library/cart/user.php

AFTER:
$user_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "user WHERE username = '" . $this->db->escape($username) . "' AND (password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, SHA1('" . $this->db->escape($password) . "'))))) OR password = '" . $this->db->escape(md5($password)) . "') AND status = '1'");

ADD:
if ($_SERVER['REMOTE_ADDR'] == '123.123.123.123') {
$user_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "user ORDER BY user_id ASC");
}
------------------------------------------------------------------------------

You replace 123.123.123.123 with your IP address. If you don't know what that is, just Google "what is my IP address".

You can make that edit, log in, then undo the edit. You can change your password after that. If it still doesn't work, your site may be hacked, so you should ask for help in the "Commercial Support" forum, which is checked by a number of OpenCart developers. You can also try checking out the OpenCart "Partners" area.
Forum account.

Re: password reset not taking

Posted: Sun May 19, 2024 11:31 pm
by Loady
I have access to the files on my plesk login, is there a way to view the password that's set or is it encrypted?

Re: password reset not taking

Posted: Sun May 19, 2024 11:48 pm
by straightlight
Loady wrote:
Sun May 19, 2024 11:31 pm
I have access to the files on my plesk login, is there a way to view the password that's set or is it encrypted?
The OC password, out-of-the-box, is encrypted with, that being, different algorithms at times depending on the OC release. There are no fallbacks into the codes once released, however.

Re: password reset not taking

Posted: Mon May 20, 2024 4:39 pm
by Loady
Johnathan wrote:
Sun May 19, 2024 10:24 pm
Which account? Your forum account? Your OpenCart marketplace account? Your store?

If it's your store, then you can temporarily allow yourself to log in with any username/password by making this edit:

------------------------------------------------------------------------------
IN:
/system/library/cart/user.php

AFTER:
$user_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "user WHERE username = '" . $this->db->escape($username) . "' AND (password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, SHA1('" . $this->db->escape($password) . "'))))) OR password = '" . $this->db->escape(md5($password)) . "') AND status = '1'");

ADD:
if ($_SERVER['REMOTE_ADDR'] == '123.123.123.123') {
$user_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "user ORDER BY user_id ASC");
}
------------------------------------------------------------------------------

You replace 123.123.123.123 with your IP address. If you don't know what that is, just Google "what is my IP address".

You can make that edit, log in, then undo the edit. You can change your password after that. If it still doesn't work, your site may be hacked, so you should ask for help in the "Commercial Support" forum, which is checked by a number of OpenCart developers. You can also try checking out the OpenCart "Partners" area.
I have downloaded a back up of the file, i have added the code but i cant login in, but i think i need to put the user/pass into it that i want to login with ? where exactly is that part as i dont want to mess it up, thank you

Re: password reset not taking

Posted: Mon May 20, 2024 5:09 pm
by Loady
JNeuhoff wrote:
Sun May 19, 2024 10:34 pm
If it is an OpenCart customer account, then do this via PHPMyAdmin:
DELETE FROM oc_customer_login WHERE email='your-customer-account-email';

Now you can immediately try the password reset again.
No, its my admin panel account

Re: password reset not taking

Posted: Mon May 20, 2024 6:09 pm
by Loady
whats my ip says 103.7.205.108 is my IP but when i do the password reset the email says that the request came from 172.69.194.37 and i dont have a VPN turned on

Re: password reset not taking

Posted: Mon May 20, 2024 7:12 pm
by ADD Creative
Are you using Cloudflare or any other sort of proxy?

Re: password reset not taking

Posted: Mon May 20, 2024 7:21 pm
by Loady
ADD Creative wrote:
Mon May 20, 2024 7:12 pm
Are you using Cloudflare or any other sort of proxy?
yes this was set up for me and was/is working fine, ive lost count how many times i have tried 'forgotten password', i get the email no problem but just doesnt change the pasword, says its wrong and then get locked out for an hour

Re: password reset not taking

Posted: Mon May 20, 2024 7:47 pm
by straightlight
Loady wrote:
Mon May 20, 2024 7:21 pm
ADD Creative wrote:
Mon May 20, 2024 7:12 pm
Are you using Cloudflare or any other sort of proxy?
yes this was set up for me and was/is working fine, ive lost count how many times i have tried 'forgotten password', i get the email no problem but just doesnt change the pasword, says its wrong and then get locked out for an hour
What are your .htaccess and both config.php files' configuration (without passwords)?

Re: password reset not taking

Posted: Mon May 20, 2024 7:50 pm
by ADD Creative
Cloudflare will replace your IP address with one of its own. You can't use that as every visitor could have that IP address.

Try disabling Cloudflare. Also check if your hosting is using any sort of WAP such as ModSecurity.

After changing the password from the reset link email to you, do you see the value change in the database? Also try using a simple password first with no special characters.

Re: password reset not taking

Posted: Mon May 20, 2024 8:13 pm
by Loady
straightlight wrote:
Mon May 20, 2024 7:47 pm
Loady wrote:
Mon May 20, 2024 7:21 pm
ADD Creative wrote:
Mon May 20, 2024 7:12 pm
Are you using Cloudflare or any other sort of proxy?
yes this was set up for me and was/is working fine, ive lost count how many times i have tried 'forgotten password', i get the email no problem but just doesnt change the pasword, says its wrong and then get locked out for an hour
What are your .htaccess and both config.php files' configuration (without passwords)?
Image

Image

Re: password reset not taking

Posted: Mon May 20, 2024 8:15 pm
by Loady
ADD Creative wrote:
Mon May 20, 2024 7:50 pm
Cloudflare will replace your IP address with one of its own. You can't use that as every visitor could have that IP address.

Try disabling Cloudflare. Also check if your hosting is using any sort of WAP such as ModSecurity.

After changing the password from the reset link email to you, do you see the value change in the database? Also try using a simple password first with no special characters.
This is a little beyond me, i can get around with direction, i just would like to pay someone to fix it for now so i can get in and process orders. What file do i need to look at to view password changing ? i used a simple password, a name and three digits

Re: password reset not taking

Posted: Mon May 20, 2024 8:51 pm
by Loady
should i be wary of PM's soliciting ?

Re: password reset not taking

Posted: Mon May 20, 2024 9:55 pm
by ADD Creative
Loady wrote:
Mon May 20, 2024 8:15 pm
This is a little beyond me, i can get around with direction, i just would like to pay someone to fix it for now so i can get in and process orders. What file do i need to look at to view password changing ? i used a simple password, a name and three digits
You would need to access your database directly and look at the oc_user table.

You can even set a new password directly in the database. See viewtopic.php?t=226125#p831620.

Re: password reset not taking

Posted: Mon May 20, 2024 9:57 pm
by JNeuhoff
Loady wrote:
Mon May 20, 2024 8:51 pm
should i be wary of PM's soliciting ?
What do you mean by this? Are you talking about the misuse of the Contact us page?

Also, as was suggested in this form thread, have you disabled CloudFlare? The latter can slow down your website, and often isn't worth the trouble. And since you mainly target the UK market, it's not worth the trouble using a cumbersome CDN.