Post by Loady » 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.

Active Member

Posts

Joined
Sun Oct 07, 2018 10:47 pm
Location - UK

Post by JNeuhoff » 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.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by Loady » Sun May 19, 2024 9:48 pm

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)

Active Member

Posts

Joined
Sun Oct 07, 2018 10:47 pm
Location - UK

Post by Johnathan » 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.

Image Image Image Image Image


User avatar
Administrator

Posts

Joined
Fri Dec 18, 2009 3:08 am


Post by JNeuhoff » 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.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by Loady » Sun May 19, 2024 11:28 pm

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.

Active Member

Posts

Joined
Sun Oct 07, 2018 10:47 pm
Location - UK

Post by Loady » 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?

Active Member

Posts

Joined
Sun Oct 07, 2018 10:47 pm
Location - UK

Post by straightlight » Sun May 19, 2024 11:48 pm

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.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by Loady » Mon May 20, 2024 4:39 pm

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

Active Member

Posts

Joined
Sun Oct 07, 2018 10:47 pm
Location - UK

Post by Loady » Mon May 20, 2024 5:09 pm

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

Active Member

Posts

Joined
Sun Oct 07, 2018 10:47 pm
Location - UK

Post by Loady » Mon May 20, 2024 6:09 pm

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

Active Member

Posts

Joined
Sun Oct 07, 2018 10:47 pm
Location - UK

Post by ADD Creative » Mon May 20, 2024 7:12 pm

Are you using Cloudflare or any other sort of proxy?

www.add-creative.co.uk


Guru Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by Loady » 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

Active Member

Posts

Joined
Sun Oct 07, 2018 10:47 pm
Location - UK

Post by straightlight » 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)?

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by ADD Creative » 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.

www.add-creative.co.uk


Guru Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by Loady » Mon May 20, 2024 8:13 pm

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

Active Member

Posts

Joined
Sun Oct 07, 2018 10:47 pm
Location - UK

Post by Loady » Mon May 20, 2024 8:15 pm

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

Active Member

Posts

Joined
Sun Oct 07, 2018 10:47 pm
Location - UK

Post by Loady » Mon May 20, 2024 8:51 pm

should i be wary of PM's soliciting ?

Active Member

Posts

Joined
Sun Oct 07, 2018 10:47 pm
Location - UK

Post by ADD Creative » Mon May 20, 2024 9:55 pm

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.

www.add-creative.co.uk


Guru Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by JNeuhoff » Mon May 20, 2024 9:57 pm

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.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am

Who is online

Users browsing this forum: No registered users and 68 guests