Re: Unable to connect to the database: TypeError: net.Socket is not a constructor

2020-04-21 Thread Marco Ippolito
Thank you very much Tim and Adrian for your very kind and valuable information and suggestions. Marco Il giorno mar 21 apr 2020 alle ore 00:47 Tim Cross ha scritto: > > Marco Ippolito writes: > > > I'm trying to connect to a postgres database (Postgresql-11) within my &

Re: Unable to connect to the database: TypeError: net.Socket is not a constructor

2020-04-20 Thread Marco Ippolito
Il giorno lun 20 apr 2020 alle ore 20:11 Adrian Klaver < adrian.kla...@aklaver.com> ha scritto: > On 4/20/20 10:50 AM, Marco Ippolito wrote: > > I'm trying to connect to a postgres database (Postgresql-11) within my > > nodejs-vue.js app, but in console I'm gettin

Unable to connect to the database: TypeError: net.Socket is not a constructor

2020-04-20 Thread Marco Ippolito
I'm trying to connect to a postgres database (Postgresql-11) within my nodejs-vue.js app, but in console I'm getting this error: [HMR] Waiting for update signal from WDS... pg.js?c8c2:27 Unable to connect to the database: TypeError: net.Socket is not a constructor at new Connection

Re: Error retrieving PostgreSQL DB information with Coturn

2020-01-14 Thread Marco Ippolito
. CLI listener opened on : 127.0.0.1:5766 1: PostgreSQL DB connection success: host=localhost dbname=coturn user=turn password=turn connect_timeout=30 Marco Il giorno mar 14 gen 2020 alle ore 17:53 Adrian Klaver < adrian.kla...@aklaver.com> ha scritto: > On 1/14/20 8:33 AM, Marco Ippol

Error retrieving PostgreSQL DB information with Coturn

2020-01-14 Thread Marco Ippolito
In order to understand how to use Postgresql-11 with Coturn, https://github.com/coturn/coturn , I created a postgresql-11 dabatase using /usr/local/share/turnserver/schema.sql : CREATE TABLE turnusers_lt ( realm varchar(127) default '', name varchar(512), hmackey char(

Re: "Failed to connect to Postgres database" : No usage specified for certificate (update)

2019-09-30 Thread Marco Ippolito
/fabric_ca.pem: -BEGIN CERTIFICATE- MIIDlTCCAn2gAwIBAgIUCm243lybs0PNfAEdgbuw0chmjWkwDQYJKoZIhvcNAQEL and this is its end: xNItFJulgsA1 -END CERTIFICATE- What does it mean "No usage specified for certificate" ? Il giorno lun 30 set 2019 alle ore 18:01 Marco Ippolito < ippolito.

Re: "Failed to connect to Postgres database"

2019-09-30 Thread Marco Ippolito
[10650] [unknown]@[unknown] LOG: incomplete startup packet 2019-09-30 17:56:22.760 CEST [10649] [unknown]@[unknown] LOG: incomplete startup packet What could it mean? Marco Il giorno sab 28 set 2019 alle ore 23:49 Adrian Klaver < adrian.kla...@aklaver.com> ha scritto: > On 9/28/19 12:

Re: "Failed to connect to Postgres database"

2019-09-28 Thread Marco Ippolito
Hi Adrian, Il giorno ven 27 set 2019 alle ore 21:39 Adrian Klaver < adrian.kla...@aklaver.com> ha scritto: > On 9/27/19 11:02 AM, Marco Ippolito wrote: > > Thank you very much Adrian. > > Two things: > > > > 1) > > Why if I just specify through port th

Re: "Failed to connect to Postgres database"

2019-09-27 Thread Marco Ippolito
tions (name, prekey, level) VALUES ($1, $2, $3) What do these continuous attempts to duplicate key value mean? It doesn't look so good this fabric-ca-server connection with postgresql-11 's db ... Marco Il giorno ven 27 set 2019 alle ore 20:02 Marco Ippolito <

Re: "Failed to connect to Postgres database"

2019-09-27 Thread Marco Ippolito
2019/09/27 19:57:58 [INFO] Listening on http://0.0.0.0:7054 Does it mean that in order to use postgresql-11 with fabric-ca I have to use only socket connection? And if this is the case, why? Marco Il giorno ven 27 set 2019 alle ore 18:37 Adrian Klaver < adrian.kla...@aklaver.com> ha scrit

Re: "Failed to connect to Postgres database"

2019-09-27 Thread Marco Ippolito
n was successful /var/log/postgresql/postgresql-11-fabmnet.log : 2019-09-27 17:07:27.159 CEST [6626] [unknown]@[unknown] LOG: could not accept SSL connection: sslv3 alert bad certificate Why it says "sslv3 alert bad certificate" if it's exactly the same certificate used when c

Re: "Failed to connect to Postgres database"

2019-09-27 Thread Marco Ippolito
says "sslv3 alert bad certificate" if it's exactly the same certificate used when connecting to the same database with ssl in postgres environment as shown above? Marco Il giorno ven 27 set 2019 alle ore 16:38 Adrian Klaver < adrian.kla...@aklaver.com> ha scritto: > On

Re: "Failed to connect to Postgres database"

2019-09-27 Thread Marco Ippolito
fabmnet_ca=> Now I have to fix the interface between fabric-ca and postgresql-11 on both sides. And I will let you know how it is going Marco Il giorno ven 27 set 2019 alle ore 13:34 Daniel Verite < dan...@manitou-mail.org> ha scritto: > Marco Ippolito wrote: > > > (

Re: "Failed to connect to Postgres database"

2019-09-27 Thread Marco Ippolito
stgres" FATAL: password authentication failed for user "postgres" So, before passing to the fabric-ca side , I need to solve this aspect. Marco Il giorno ven 27 set 2019 alle ore 04:28 rob stone ha scritto: > Hi, > > On Thu, 2019-09-26 at 16:21 +0200, Marco Ippolito wrote: &

Re: "Failed to connect to Postgres database"

2019-09-26 Thread Marco Ippolito
.com> ha scritto: > On 9/26/19 7:21 AM, Marco Ippolito wrote: > > In order to restart from a clean situation and configuration, I removed > > the previous fabric-ca folder, created a new one, and then initiated the > > fabric-ca-server. With the default SQLite everything seem

"Failed to connect to Postgres database"

2019-09-26 Thread Marco Ippolito
r-config.yaml, in postgresql.conf, in both or somewhere else. Il giorno gio 26 set 2019 alle ore 12:05 Marco Ippolito < ippolito.ma...@gmail.com> ha scritto: > Affer removing the previous cert and key files, I started again the > fabric-ca server discovering that new cert a

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

2019-09-26 Thread Marco Ippolito
er to push your cert and key into stores > (identified by BCCSP config) > > if that doesnt work I would disable hardcoded BCCSP Provider then manually > import your certs and keys into your truststore > > YMMV > martin > -- > *From:* Marco I

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

2019-09-26 Thread Marco Ippolito
s > (identified by BCCSP config) > > if that doesnt work I would disable hardcoded BCCSP Provider then manually > import your certs and keys into your truststore > > YMMV > martin > -- > *From:* Marco Ippolito > *Sent:* Wednesday, September 25,

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

2019-09-26 Thread Marco Ippolito
: permission denied to create database 2019-09-26 10:08:27.947 CEST [3728] fabmnet_admin@fabmnetdb STATEMENT: CREATE DATABASE fabmnetdb I do not undertand... Marco Il giorno gio 26 set 2019 alle ore 02:07 Adrian Klaver < adrian.kla...@aklaver.com> ha scritto: > On 9/25/19 12

could not accept SSL connection: sslv3 alert bad certificate

2019-09-25 Thread Marco Ippolito
Following the indications here: https://hyperledger-fabric-ca.readthedocs.io/en/release-1.4/users-guide.html#configuring-the-database I'm trying to understand how to correctly set Fabric-CA with a PostgreSQL-11 database in Ubuntu 18.04.02 Server Edition. I created a postgresql-11 db to which I can

Re: How to safely remove a corrupted cluster?

2019-09-19 Thread Marco Ippolito
Solved by repeating the execution of (base) postgres@pc:~$ pg_dropcluster --stop 11 fabmnet : (base) postgres@pc:~$ pg_dropcluster --stop 11 fabmnet Error: specified cluster does not exist Marco Il giorno gio 19 set 2019 alle ore 13:02 Marco Ippolito < ippolito.ma...@gmail.com> ha s

How to safely remove a corrupted cluster?

2019-09-19 Thread Marco Ippolito
If the saying "to learn you have to make mistakes", I'm "learning"...: I removed a cluster's folder without using pg_dropcluster... sio now I have a corrupted cluster. How can I safely remove it? (base) marco@pc:~$ pg_lsclusters Ver Cluster Port Status Owner Data directory Log

Re: Installed PostgreSQL-11 in Ubuntu 18.04.02 Server Edition: No existing local cluster is suitable as a default target

2019-09-18 Thread Marco Ippolito
Klaver < adrian.kla...@aklaver.com> ha scritto: > On 9/18/19 6:13 AM, Marco Ippolito wrote: > > Thanks Matthias, > > very kind. Hopefully I will get some hints on how to solve my problem. > > You should probably take a look at: > > https://help.ubuntu.com/lts/se

Re: Installed PostgreSQL-11 in Ubuntu 18.04.02 Server Edition: No existing local cluster is suitable as a default target

2019-09-18 Thread Marco Ippolito
Thanks Matthias, very kind. Hopefully I will get some hints on how to solve my problem. Marco Il giorno mer 18 set 2019 alle ore 15:11 Matthias Apitz ha scritto: > El día Wednesday, September 18, 2019 a las 12:44:20PM +0200, Marco > Ippolito escribió: > > > thanks Andreas

Re: Installed PostgreSQL-11 in Ubuntu 18.04.02 Server Edition: No existing local cluster is suitable as a default target

2019-09-18 Thread Marco Ippolito
ssing something... Il giorno mer 18 set 2019 alle ore 12:28 Andreas Joseph Krogh < andr...@visena.com> ha scritto: > På onsdag 18. september 2019 kl. 12:25:05, skrev Marco Ippolito < > ippolito.ma...@gmail.com>: > > Hi Andreas, > if I understand correctly, this is what I

Re: Installed PostgreSQL-11 in Ubuntu 18.04.02 Server Edition: No existing local cluster is suitable as a default target

2019-09-18 Thread Marco Ippolito
d not start server Examine the log output. postgres@pc:/home/marco$ What am I doing wrong? Il giorno mer 18 set 2019 alle ore 12:22 Andreas Joseph Krogh < andr...@visena.com> ha scritto: > På onsdag 18. september 2019 kl. 12:13:24, skrev Marco Ippolito < > ippolito.ma...@gmail.com&g

Re: Installed PostgreSQL-11 in Ubuntu 18.04.02 Server Edition: No existing local cluster is suitable as a default target

2019-09-18 Thread Marco Ippolito
t 2019 alle ore 12:03 Matthias Apitz ha scritto: > El día Wednesday, September 18, 2019 a las 11:50:45AM +0200, Marco > Ippolito escribió: > > > I installed PostgreSQL-11 in Ubuntu 18.04.02 Server Edition using package > > manager: sudo apt-get install postgresql-11. But n

Installed PostgreSQL-11 in Ubuntu 18.04.02 Server Edition: No existing local cluster is suitable as a default target

2019-09-18 Thread Marco Ippolito
I installed PostgreSQL-11 in Ubuntu 18.04.02 Server Edition using package manager: sudo apt-get install postgresql-11. But now I'm not able to call psql: (base) marco@pc:~$ sudo su -l postgres [sudo] password for marco: No directory, logging in with HOME=/ postgres@pc:/$ psql W