Project

General

Profile

Actions
Copy link

Bug #22071

closed

wp_2fa_webauthn_users and wp_2fa_webauthn_credentials DB tables do not exist

Added by Raymond Hoh about 1 month ago. Updated about 1 month ago.

Status:
Resolved
Priority name:
Normal
Assignee:
Boone Gorges
Category name:
Server
Target version:
2.5.3
Start date:
2025-02-11
Due date:
% Done:

0%

Estimated time:
Deployment actions:

Description

Boone, can you import the wp_2fa_webauthn_users and wp_2fa_webauthn_credentials DB tables from the GC servers to the Reclaim servers?

Those tables do not exist on the Reclaim servers and is causing an issue with WebAuthn 2FA. See https://redmine.gc.cuny.edu/issues/22051#note-3.

Related issues

Related to CUNY Academic Commons - Feature #22051: Enable passkey authenticationResolved2025-02-11

Actions
Actions
Copy link
 #1

Updated by Boone Gorges about 1 month ago

  • Status changed from New to Testing Required

This is done.

Really sorry about this. When building my export tools, I used the following heuristic: for all blog_ids, export wp_{blog_id}_ tables; then, to get global tables, get all 'wp_[a-z]' tables. This didn't include the 2fa tables because of the number 2.

Actions
Copy link
 #2

Updated by Raymond Hoh about 1 month ago

Actions
Copy link
 #3

Updated by Raymond Hoh about 1 month ago

  • Category name set to Server
  • Status changed from Testing Required to Resolved
  • Target version set to 2.5.3

Thanks Boone! No worries about the script. It's hard to account for every single scenario!

I can confirm that the Webauthn DB error no longer shows up.

Actions
Copy link

Also available in: Atom PDF