AbleCommerce Forums
»
AbleCommerce
»
AbleCommerce 9 Bug Reports
»
The security token has expired. Please login again.
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.
|
|
|
|
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
|
|
|
|
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.
|
|
|
|
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
|
|
|
|
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.
|
|
|
|
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.
|
|
|
|
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"
|
|
|
|
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.
|
|
|
|
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.
|
|
|
|
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
|
|
|
|
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.
|
|
|
|
Rank: Advanced Member
Groups: System, Administrators, Developers, Registered, HelpDesk Joined: 10/29/2018(UTC) Posts: 472
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 |
|
|
|
AbleCommerce Forums
»
AbleCommerce
»
AbleCommerce 9 Bug Reports
»
The security token has expired. Please login again.
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.
Important Information:
The AbleCommerce Forums uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
More Details
Close