On 9/26/19 1:10 AM, Marco Ippolito wrote:
Hi Adrian,
putting in /fabric/fabric-ca/fabric-ca-server-config.yaml :
db:
type: postgres
datasource: host=localhost port=5433 user=fabmnet_admin
password=fabmnet1971 dbname=fabmnetdb sslmode=verify-ca
and the corresponding portion of the log file:
2019-09-26 10:08:27.947 CEST [3728] fabmnet_admin@fabmnetdb ERROR:
permission denied to create database
2019-09-26 10:08:27.947 CEST [3728] fabmnet_admin@fabmnetdb STATEMENT:
CREATE DATABASE fabmnetdb
User fabmnet_admin does not have CREATE DATABASE privileges. In a psql
session do:
\du fabmnet_admin
If the results do not include Create DB or Superuser then you need to
ALTER ROLE fabmnet_admin to have CREATEDB:
https://www.postgresql.org/docs/11/sql-alterrole.html
NOTE: You will need to above as ROLE that has privileges. Easiest if you
have a SUPERUSER role you can log in as.
I do not undertand...
Marco
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
