The alteration of the query with the where clause in ykksm-decrypt.php that was simply 'AND active' to 'AND active = 1' works on MySQL but not Postgres.
ykksm[4356]: Database query error. Query: SELECT aeskey, internalname FROM yubikeys WHERE publicname = 'dteffuje' AND active = 1 Error: Array#012(#012 [0] => 42883#012 [1] => 7#012 [2] => ERROR: operator does not exist: boolean = integer#012LINE 1: ...e FROM yubikeys WHERE publicname = 'dteffuje' AND active = 1#012 ^#012HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.#012)
The alteration of the query with the where clause in ykksm-decrypt.php that was simply 'AND active' to 'AND active = 1' works on MySQL but not Postgres.