Rank: Advanced Member
Groups: Authorized User, Developers, Registered
Joined: 4/17/2019(UTC)
Posts: 80
|
After the GoldR12 site was upgraded to AC9.0.2 and moved to a new server I can't restore the Encryption Key.
It is stuck at
Your key is being updated...
Remaining Workload: 15 records
I tried Restart and Cancel but neither will respond. It's been stuck for 2 days.
Please advise.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Admin, Administrators, Developers, Registered, HelpDesk, Authorized User
Joined: 7/31/2019(UTC)
Posts: 77
Was thanked: 8 time(s) in 8 post(s)
|
Please check the error log from admin. Also check the error log in log file (App_Data/Logs/app.log)for any clue. If nothing works, try restart the IIS and retry the encryption key restore. Check this link for details about backing up and restoring encryption key: http://help.ablecommerce...urity/Encryption_Key.htmThanks. |
|
|
|
|
|
|
Rank: Advanced Member
Groups: HelpDesk, Developers
Joined: 11/9/2018(UTC)
Posts: 564
Thanks: 122 times
Was thanked: 26 time(s) in 25 post(s)
|
That page needs updated Quote:Whenever you change your key, download the key backup files and store them in a physically secure location. You need both backup files to restore the key. Only Able 7.x used multiple backup keys. Gold and v9 utilize a single key file.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Authorized User, Developers, Registered
Joined: 4/17/2019(UTC)
Posts: 80
|
It is still stuck and showing the same screen. Restarting IIS did not work and I see nothing in the app.log. Admin log has " Error recrypting data, could not find valid keys; Recryption cancelled." What else can I try? Edited by user Wednesday, July 29, 2020 1:49:21 PM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Advanced Member
Groups: Authorized User, Developers, Registered
Joined: 4/17/2019(UTC)
Posts: 80
|
I'm still needing help with this. After restarting IIS the page is still stuck and the restart and cancel buttons can't be clicked. I see in the SecurityController: Quote:
encryptionModel.ChangePanel = "none";
encryptionModel.ChangeProgressPanel = "block";
encryptionModel.trRestartCancel = ((encryptionModel.RemainingWorkLoad == remaining.ToString())) ? "block" : "none";
So I took the "block" styles off of the ChangeProgressPanel and the trRestartCancel, Then I added "block" to changePanel. This allowed me to click "Cancel" but it still seems stuck. Please advise. 
|
|
|
|
|
|
Rank: Administration
Groups: Admin, Administrators, HelpDesk, System, Authorized User, Developers, Registered
Joined: 10/5/2018(UTC)
Posts: 175
Thanks: 8 times
Was thanked: 17 time(s) in 15 post(s)
|
When you are trying to restore the encryption key, does /app_data/encryption.config have any key for example I wonder if its copied from previous install? Make sure that it should be default file the one available in AC9. The restore should create the key entry in after success.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Authorized User, Developers, Registered
Joined: 4/17/2019(UTC)
Posts: 80
|
No, there's not any encryption key in the encryption.config.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Authorized User, Developers, Registered
Joined: 4/17/2019(UTC)
Posts: 80
|
I can't enter anything in the textbox to try to Change the Key.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Authorized User, Developers, Registered
Joined: 4/17/2019(UTC)
Posts: 80
|
I manipulated the Encryption.cshtml file so that I could attempt to create a new key. Doesn't Work. When creating a new key it acts like it's processing and gets stuck at 15 records to go.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Developers
Joined: 11/7/2018(UTC)
Posts: 303
Thanks: 21 times
Was thanked: 5 time(s) in 5 post(s)
|
I've been testing on my local site. I tried creating and encryption key and it said 7 records to go. It's an hour later and it's still not done.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Authorized User, Developers, Registered
Joined: 4/17/2019(UTC)
Posts: 80
|
We found the problem by running some queries:
select * from ac_payments where ReCrypt = 1 and EncryptedAccountData is NULL
This returned 15 records, the same number that the progress was stuck on. Can't encrypt null, right?
This was the fix:
update ac_payments set ReCrypt = 0 where ReCrypt = 1
Other tables to check:
ac_PaymentGateways
ac_ShipGateways
ac_TaxGateways
example query:
select * from ac_paymentgateways where recrypt = 1 and configdata is null
|
|
|
|
|
|
Rank: Advanced Member
Groups: Admin, Administrators, Developers, Registered, HelpDesk, Authorized User
Joined: 7/31/2019(UTC)
Posts: 77
Was thanked: 8 time(s) in 8 post(s)
|
Thanks for reporting the issue. I investigated the related implementation, we actually only set the ReCrypt flag if the EncryptedAccountData is NOT NULL. The update is performed while setting up encryption key, but it seems that the EncryptedAccountData is cleared and updated to NULL by some maintenance routines, and resulted in this issue. So, as discussed above, that running the following query before restoring or updating/changing the encryption key will save you from the trouble. Quote:update ac_payments set ReCrypt = 0 where EncryptedAccountData is NULL AND ReCrypt = 1 Edited by user Monday, September 14, 2020 8:01:30 AM(UTC)
| Reason: Not specified |
|
 1 user thanked Naveed Ashraf for this useful post.
|
|
|
|
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
