Difference between revisions of "Postgrest row level security via postgres"
Jump to navigation
Jump to search
Line 46: | Line 46: | ||
/usr/bin/install -c -m 644 .//pgjwt.control '/opt/bitnami/postgresql/share/extension/' | /usr/bin/install -c -m 644 .//pgjwt.control '/opt/bitnami/postgresql/share/extension/' | ||
/usr/bin/install -c -m 644 .//pgjwt--0.1.1.sql .//pgjwt--0.1.0--0.1.1.sql .//pgjwt--0.1.1--0.2.0.sql '/opt/bitnami/postgresql/share/extension/' | /usr/bin/install -c -m 644 .//pgjwt--0.1.1.sql .//pgjwt--0.1.0--0.1.1.sql .//pgjwt--0.1.1--0.2.0.sql '/opt/bitnami/postgresql/share/extension/' | ||
+ | ``` | ||
+ | |||
+ | |||
+ | ``` | ||
+ | postgresql 22:07:45.71 INFO ==> Configuring TLS | ||
+ | chmod: changing permissions of '/opt/bitnami/postgresql/certs/tls.key': Read-only file system | ||
+ | postgresql 22:07:45.71 WARN ==> Could not set compulsory permissions (600) on file /opt/bitnami/postgresql/certs/tls.key | ||
+ | postgresql 22:07:45.73 INFO ==> Configuring synchronous_replication | ||
+ | postgresql 22:07:45.77 INFO ==> Loading custom scripts... | ||
+ | postgresql 22:07:45.77 INFO ==> Enabling remote connections | ||
+ | postgresql 22:07:45.78 INFO ==> ** PostgreSQL setup finished! ** | ||
+ | |||
+ | postgresql 22:07:45.80 INFO ==> ** Starting PostgreSQL ** | ||
+ | 2023-04-27 22:07:45.853 GMT [1] LOG: pgaudit extension initialized | ||
+ | 2023-04-27 22:07:45.855 GMT [1] FATAL: could not load private key file "/opt/bitnami/postgresql/certs/tls.key": Permission denied | ||
+ | 2023-04-27 22:07:45.855 GMT [1] LOG: database system is shut down | ||
``` | ``` |
Revision as of 22:09, 27 April 2023
postgres=# CREATE EXTENSION IF NOT EXISTS pgjwt WITH SCHEMA ext_pgjwt; ERROR: extension "pgjwt" is not available DETAIL: Could not open extension control file "/opt/bitnami/postgresql/share/extension/pgjwt.control": No such file or directory. HINT: The extension must first be installed on the system where PostgreSQL is running.
Let's enable debug and go in as root to add extension
postgresql.values.yaml
tls: enabled: true autoGenerated: true primary: containerSecurityContext: enabled: true # runAsUser: 1001 runAsUser: 0 service: type: LoadBalancer annotations: metallb.universe.tf/address-pool: pool1 diagnosticMode: enabled: true
helm upgrade --install postgresql bitnami/postgresql -f postgresql.values.yaml --set audit.pgAuditLog=all
# apt-get install postgresql-server-dev-all # cd /root/ /root # git clone https://github.com/michelp/pgjwt.git cd pgjwt /root/pgjwt# make install
output
/bin/mkdir -p '/opt/bitnami/postgresql/share/extension' /bin/mkdir -p '/opt/bitnami/postgresql/share/extension' /usr/bin/install -c -m 644 .//pgjwt.control '/opt/bitnami/postgresql/share/extension/' /usr/bin/install -c -m 644 .//pgjwt--0.1.1.sql .//pgjwt--0.1.0--0.1.1.sql .//pgjwt--0.1.1--0.2.0.sql '/opt/bitnami/postgresql/share/extension/'
postgresql 22:07:45.71 INFO ==> Configuring TLS chmod: changing permissions of '/opt/bitnami/postgresql/certs/tls.key': Read-only file system postgresql 22:07:45.71 WARN ==> Could not set compulsory permissions (600) on file /opt/bitnami/postgresql/certs/tls.key postgresql 22:07:45.73 INFO ==> Configuring synchronous_replication postgresql 22:07:45.77 INFO ==> Loading custom scripts... postgresql 22:07:45.77 INFO ==> Enabling remote connections postgresql 22:07:45.78 INFO ==> ** PostgreSQL setup finished! ** postgresql 22:07:45.80 INFO ==> ** Starting PostgreSQL ** 2023-04-27 22:07:45.853 GMT [1] LOG: pgaudit extension initialized 2023-04-27 22:07:45.855 GMT [1] FATAL: could not load private key file "/opt/bitnami/postgresql/certs/tls.key": Permission denied 2023-04-27 22:07:45.855 GMT [1] LOG: database system is shut down