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@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@aklaver.com