Re: could not accept SSL connection: sslv3 alert bad certificate

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(at)fabmnetdb ERROR:
>  permission denied to create database
> 2019-09-26 10:08:27.947 CEST [3728] fabmnet_admin(at)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(dot)klaver(at)aklaver(dot)com