Passkeys implementation: problem storing webauthn.SessionData as JSON

[andrewah64]

Hi

I'm implementing passkeys using webauthn

I have to store information provided by the library in the form of a webauthn.SessionData struct. However, when I try to insert it into a database-column with a datatype of "json" I get this error:

failed to encode args[2]: unable to encode webauthn.SessionData{Challenge:"A1uBMoXsCQcse0G0obLW7NmkA-WHGfPy4wv3B_fT7mI", RelyingPartyID:"localhost", UserID:[]uint8{0x74, 0x34}, AllowedCredentialIDs:[][]uint8(nil), Expires:time.Date(1, time.January, 1, 0, 0, 0, 0, time.UTC), UserVerification:"", Extensions:protocol.AuthenticationExtensions(nil), CredParams:[]protocol.CredentialParameter{protocol.CredentialParameter{Type:"public-key", Algorithm:-7}, protocol.CredentialParameter{Type:"public-key", Algorithm:-35}, protocol.CredentialParameter{Type:"public-key", Algorithm:-36}, protocol.CredentialParameter{Type:"public-key", Algorithm:-257}, protocol.CredentialParameter{Type:"public-key", Algorithm:-258}, protocol.CredentialParameter{Type:"public-key", Algorithm:-259}, protocol.CredentialParameter{Type:"public-key", Algorithm:-37}, protocol.CredentialParameter{Type:"public-key", Algorithm:-38}, protocol.CredentialParameter{Type:"public-key", Algorithm:-39}, protocol.CredentialParameter{Type:"public-key", Algorithm:-8}}, Mediation:""} into text format for unknown type (OID 0): cannot find encode plan

As things stand, I'm just passing a pointer to an instance of the SessionData struct to pgx's NamedArgs function, e.g.:

params = pgx.NamedArgs{"json_param" : SessionDataStruct }

Does anyone know if what I'm attempting to do is feasible, and if it is what I need to do to make it work?

Thanks,

Andrew.

[jackc]

The key part of the error is text format for unknown type (OID 0). Automatic json encoding only works when pgx knows the PostgreSQL type. My guess is you are using QueryExecModeExec or QueryExecModeSimpleProtocol. You would need to use another query exec mode for this to work.