Re: [OpenXPKI-users] openxpkiadm Unable to access table 'certificate'

2024-02-07 Thread James B. Byrne via OpenXPKI-users
On Tue, February 6, 2024 16:52, Sergei Vyshenski wrote: > James , > > Seems you make a number of strange moves. > Yes, I did. I deleted the user and database, cleaned out /etc/openxpki, and restarted from scratch. The issue was the lack of permissions on the table for the user openxpki. I

Re: [OpenXPKI-users] openxpkiadm Unable to access table 'certificate'

2024-02-06 Thread Sergei Vyshenski
James , Seems you make a number of strange moves. Move 1. You create pg-user "openxpki" at pg-server without a password. Even if later you configure openxpki server with some password for this pg-user, ANY password (including empty password) will be accepted for any operation on behalf of

Re: [OpenXPKI-users] openxpkiadm Unable to access table 'certificate'

2024-02-06 Thread James B. Byrne via OpenXPKI-users
On Tue, February 6, 2024 13:29, Lixin Liu wrote: > Hi James, > > I am using "peer" instead of "trust" in my pg_hba.conf. You may want to try > this. > Thanks, but changing this made no difference. Regards, -- *** e-Mail is NOT a SECURE channel *** Do NOT transmit

Re: [OpenXPKI-users] openxpkiadm Unable to access table 'certificate'

2024-02-06 Thread Lixin Liu
Hi James, I am using "peer" instead of "trust" in my pg_hba.conf. You may want to try this. Cheers, Lixin. On 2024-02-06, 10:21 AM, "James B. Byrne via OpenXPKI-users" mailto:openxpki-users@lists.sourceforge.net>> wrote: PostgreSQL-16 FreeBSd-13.2p9 I am trying to setup openxpki using

[OpenXPKI-users] openxpkiadm Unable to access table 'certificate'

2024-02-06 Thread James B. Byrne via OpenXPKI-users
PostgreSQL-16 FreeBSd-13.2p9 I am trying to setup openxpki using PostgreSQL as the data store. After installing both postgresql16 and openxpki I completed the following steps successfully using psql: psql -U postgres -d postgres CREATE USER openxpki; CREATE DATABASE openxpki; GRANT ALL