Yubico/yubikey-ksm

Postgres support is broken with the addition of Oracle support

Closed this issue · 0 comments

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)