[Pharo-users] Re: P3 connection error

2021-05-19 Thread Sven Van Caekenberghe
Bernard, > On 18 May 2021, at 22:23, Sven Van Caekenberghe wrote: > > Tomorrow I will try to test plain and tls connections on my machine. It took some trial & error with my local PostgreSQL server (on my mac I use https://postgresapp.com although I normally use the regular Ubuntu versions on

[Pharo-users] Re: P3 connection error

2021-05-18 Thread Bernhard Pieber
Yes, I am on Windows 10. Thanks! Bernhard > Am 18.05.2021 um 22:23 schrieb Sven Van Caekenberghe : > > > Hi, > > Since you can connect to 3 of the 4 machines, both over plain and tls, it > basically works. > > You will have to find out what is different in the host configurations of the > serv

[Pharo-users] Re: P3 connection error

2021-05-18 Thread Sven Van Caekenberghe
Hi, Since you can connect to 3 of the 4 machines, both over plain and tls, it basically works. You will have to find out what is different in the host configurations of the servers. It could be a certificate issue like you suggest, I don't know. I am guessing you are on Windows ? Tomorrow I

[Pharo-users] Re: P3 connection error

2021-05-18 Thread Bernhard Pieber
Hi Sven, The explicit form does not work either. All the fields contain safe characters. However, I just found out that I can connect to three other hosts. All four hosts should have the same settings (databases and users), and just one of them does not work. So there must be a difference in th

[Pharo-users] Re: P3 connection error

2021-05-18 Thread Sven Van Caekenberghe
(CC-ing the list) Hmm, that should just work. Are there any special characters in the username, password or host (non-ascii, URL unsafe characters) ? You could try the explicit init form P3Client new host: 'host'; user: 'user'; password: 'password'; database: 'database'; yourself. > On 18 M

[Pharo-users] Re: P3 connection error

2021-05-18 Thread Sven Van Caekenberghe
Hi Bernard, > On 18 May 2021, at 18:40, Bernhard Pieber wrote: > > Hi, > > I have a PostgreSQL database on a remote host which I want to access using > P3. I do have a username and a password and can connect via SQuirreL and > DBeaver. Both use a JDBC driver. However, when I try to access it