ERROR: column "issued_at" of relation "certificates" does not exist at character 121

[rbuffi]

Hello,

When requesting certificate with CSR with CFSSL plugin we receive the following error:

ERROR: column "issued_at" of relation "certificates" does not exist at character 121

When looking at the database records we see the column "issued_at" does not exist:

lemur=# table certificates; id | external_id | owner | name | description | notify | body | chain | csr | private_key | issuer | serial | cn | deleted | dns_provider_id | not_before | not_after | date_created | signing_algorithm | status | bits | san | rotation | user_id | authority_id | root_authority_id | rotation_policy_id | key_type

Recreating the database does not resolve this. What are we doing wrong?

Regards,

Ronald

[hosseinsh]

Hi @rbuffi,

I am not familiar with the CFSSL plugin, but noticing that issued_at is used as part of the API key data model. Wondering if you have already tried upgrading the DB, ensuring all tables are up to date: https://lemur.readthedocs.io/en/latest/administration.html?highlight=db%20upgrade#upgrading-lemur

Best of luck, Hossein