logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error

Options
Go to last post Go to first unread
brant25348293  
#1 Posted : Thursday, August 22, 2024 11:15:32 AM(UTC)
brant25348293

Rank: Advanced Member

Groups: HelpDesk
Joined: 1/20/2020(UTC)
Posts: 43

I had to change my server's IP address and now admins cannot login. We get the error "The security token has expired. Please login again."
What can we do to fix this? I think it has to do with the Captcha.

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.

ray22901031  
#2 Posted : Thursday, August 22, 2024 12:17:57 PM(UTC)
ray22901031

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 909

Thanks: 3 times
Was thanked: 15 time(s) in 15 post(s)
Without having more specifics, the first thing I would do is make sure that all the caches are reset.

Next, I will remove the Captcha by making the change at the database level. Since you don't offer much information, it could also be a firewall setting that prevents admin people from logging in.

I hope some of this helps,
-Ray
brant25348293  
#3 Posted : Thursday, August 22, 2024 1:17:50 PM(UTC)
brant25348293

Rank: Advanced Member

Groups: HelpDesk
Joined: 1/20/2020(UTC)
Posts: 43

How is it possible to remove the Captcha for Admin access? Please provide a step-by-step procedure because I am not that good with databases.
ray22901031  
#4 Posted : Thursday, August 22, 2024 1:23:22 PM(UTC)
ray22901031

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 909

Thanks: 3 times
Was thanked: 15 time(s) in 15 post(s)
You can go to your database and execute the following script:

UPDATE ac_StoreSettings
SET FieldValue = 'False'
WHERE FieldName = 'GoogleReCaptchaEnabled' OR FieldName = 'MerchantPasswordImageCaptcha';

If not, go into your database and look for the table called "ac_StoreSettings." Then, go to the field called "GoogleReCaptchaEnabled" and set it to False.

If you're unsure how to work with databases, you must get a developer involved.

-Ray
brant25348293  
#5 Posted : Thursday, August 22, 2024 1:58:45 PM(UTC)
brant25348293

Rank: Advanced Member

Groups: HelpDesk
Joined: 1/20/2020(UTC)
Posts: 43

How can I do this in the database? I don't have a DB developer. Please provide the steps.
ray22901031  
#6 Posted : Thursday, August 22, 2024 2:08:53 PM(UTC)
ray22901031

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 909

Thanks: 3 times
Was thanked: 15 time(s) in 15 post(s)
No, You need a developer.
brant25348293  
#7 Posted : Friday, August 23, 2024 2:48:03 PM(UTC)
brant25348293

Rank: Advanced Member

Groups: HelpDesk
Joined: 1/20/2020(UTC)
Posts: 43

Is it possible to do this at the file level by modifying a config file?

If not, how do you "go into the database"
ray22901031  
#8 Posted : Friday, August 23, 2024 3:01:39 PM(UTC)
ray22901031

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 909

Thanks: 3 times
Was thanked: 15 time(s) in 15 post(s)
This is basic stuff; if you don't know how to manipulate your own database, you need to get a professional. If you make a mistake, your entire site can crash.

To answer your question, here are the following steps:

#1. Access the back-end database using your favorite database tool. You will need to know your database location, probably using ODBC, the database password, and the username. The user should be an admin or be able to write to the database.

Examples:

  • SQL Management Console
    Microsoft Access
    Navicat etc..


#2. After logging into the backend database using your database software, open your database. I'm not sure what name you gave your database, so each one will be different.

#3. Find the table called "ac_StoreSettings" and open this table.

#4. Find the "GoogleReCaptchaEnabled " column and set it to "False."

#5. Save your settings.

If any of these steps seem unfamiliar or if you're unsure about any part of the process, it's crucial to seek professional help. Making a mistake could lead to a system crash, so it's better to be safe than sorry.

PS: I'm unsure if a configuration file can overwrite the setting in the database.
brant25348293  
#9 Posted : Sunday, August 25, 2024 8:34:19 AM(UTC)
brant25348293

Rank: Advanced Member

Groups: HelpDesk
Joined: 1/20/2020(UTC)
Posts: 43

Instead of completely disabling CAPTCHA, we would like to know how to disable reCAPTCHA and enable the standard image CAPTCHA. I know how to do this in the store, but how is it done in the database? This is in case the admins cannot login again because of the reCAPTCHA issue.
ray22901031  
#10 Posted : Sunday, August 25, 2024 6:52:02 PM(UTC)
ray22901031

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 909

Thanks: 3 times
Was thanked: 15 time(s) in 15 post(s)
Hi Katie,

It would definitely help if he were more specific. He's using version 9.0.10.8121, which, of course, has the new Google reCAPTCHA type v3.

I was able to go to his site, register, and log in as a regular user with no problems. But he's complaining about admins not being able to log in. Since I'm still on version 9.0.9, I'm not sure if you made any changes to the back-end database.

I still think this is a Website or browser cache issue.

It would help if he would answer the following questions.

#1. Have you tried logging in using a different computer?
#2. Have you tried logging in using a freshly downloaded browser?
#3. Have you tried logging in using the /Admin page, not the /Login page?
#4. Did you have your website reset under IIS?

See if he's willing to share an admin login with you guys and see what happens on your end.

I hope this helps him.
-Ray
judy at Web2Market  
#11 Posted : Monday, August 26, 2024 7:23:46 AM(UTC)
judy at Web2Market

Rank: Advanced Member

Groups: Developers
Joined: 11/7/2018(UTC)
Posts: 303

Thanks: 21 times
Was thanked: 5 time(s) in 5 post(s)
Does this happen repeatedly or are you able to login after the first message?
We saw it happen repeatedly on some sites in development and I can't say I remember for sure, but I think it had to do with the site web.config being set to use secure cookies, but the url not being https.
If that isn't the issue, try clearing your cookies.
Also, try logging in from the store side to see if that works.
Katie S  
#12 Posted : Monday, August 26, 2024 1:59:15 PM(UTC)
Katie S

Rank: Advanced Member

Groups: System, Administrators, Developers, Registered, HelpDesk
Joined: 10/29/2018(UTC)
Posts: 471

Thanks: 4 times
Was thanked: 34 time(s) in 33 post(s)
Hi Brant,

Is this still happening? I have another work-around if you can't get into the database.

Also, the ac_StoreSettings table is cached, so if you make any changes, you will need to recycle the application from IIS.

PS. Thank you Ray and Judy for your help!
Thanks for your support!

Katie
Secure eCommerce Software and Hosting
Users browsing this topic
Guest (3)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.