May 2021 - Pharo-users - lists.pharo.org

Re: New VM, how do I get it

by Sven Van Caekenberghe

You start an image by typing the following in the Terminal ./pharo-ui Pharo.image > On 21 May 2021, at 16:31, David Pennington <david(a)totallyobjects.com> wrote: > > This is a bit like pulling teeth. > > I have done what you said. I now have the following in Terminal > > davidpennington@Davids-Air ~ % wget -O - https://get.pharo.org/vmLatest90 | bash > --2021-05-21 15:24:47-- https://get.pharo.org/vmLatest90 > Resolving get.pharo.org (get.pharo.org) 2001:41d0:301::23, 164.132.235.17 > Connecting to get.pharo.org (get.pharo.org)|2001:41d0:301::23|:443... connected. > HTTP request sent, awaiting response... 200 OK > Length: 5177 (5.1K) > Saving to: âSTDOUTâ > > - 100%[===================>] 5.06K --.-KB/s in 0s > > 2021-05-21 15:24:47 (823 MB/s) - written to stdout [5177/5177] > > Downloading the latest pharoVM: > http://files.pharo.org/get-files/90/pharo-vm-Darwin-arm64-latest.zip > pharo-vm/Pharo.app/Contents/MacOS/Pharo > Creating starter scripts pharo and pharo-ui > > Where do I go next? > > >> On 21 May 2021, at 12:31, StÃ©phane Ducasse <stephane.ducasse(a)inria.fr> wrote: >> >> you execute on a unix shell >> >> wget -O - https://get.pharo.org/vmLatest90 | bash >> >> S >> >>> On 21 May 2021, at 13:16, David Pennington <david(a)totallyobjects.com> wrote: >>> >>> I am sorry but, being a newbie to Pharo, a lot of what you say goes over my head. >>> >>> How do I use Zero Conf? >>> >>> I have loaded up the latest 9.0 from Pharo launcher. How do I get the <1 VM for that? >>> >>> Sorry for being stupid. >>> >>> David >>> P.S. 31 years a Smalltalker so its just the underlying bits that pass over me - smile. >>> >>>> On 19 May 2021, at 08:38, tesonep(a)gmail.com wrote: >>>> >>>> Hi David, >>>> >>>> for M1 we have Pharo 9 compatible VMs, you can download them using Zero Conf or directly. >>>> >>>> For the latest: >>>> - wget -O - https://get.pharo.org/vmLatest90 | bash >>>> - http://files.pharo.org/get-files/90/pharo-vm-Darwin-arm64-latest.zip >>>> >>>> For the stable: >>>> - wget -O - https://get.pharo.org/vm90 | bash >>>> - http://files.pharo.org/get-files/90/pharo-vm-Darwin-arm64-stable.zip >>>> >>>> If you are scripting the download I recommend using ZeroConf. >>>> >>>> For Pharo 8, we don't have a M1 native version, because Pharo 8 requires changes in the image to support the newer VMs. We have plans to backport the changes in the future, now we are putting all efforts in the release of Pharo 9. However, if the community consider it, we can switch priorities but it is not magical; we will need to leave something aside. Also, future versions of the Pharo Launcher will have support for detecting the architecture. >>>> >>>> In the meantime, Pharo 8 / 9 can be used without a problem with Rossetta, although the performance is not ideal. >>>> >>>> Tell me if you have any problem. >>>> Cheers, >>>> Pablo >>>> >>>> >>>> On Tue, May 18, 2021 at 3:54 PM David Pennington <david(a)totallyobjects.com> wrote: >>>> Hi there. I am currently using v8.0 on a new M1 MacBookAir. When I save the image I keep getting a message telling me that my VM is too old and to download a new one. I have looked in my Pharo Launcher but there is no new one there. What do I do please? >>>> >>>> David >>>> >>>> >>>> -- >>>> Pablo Tesone. >>>> tesonep(a)gmail.com >>> >> >> -------------------------------------------- >> StÃ©phane Ducasse >> http://stephane.ducasse.free.fr / http://www.pharo.org >> 03 59 35 87 52 >> Assistant: Aurore Dalle >> FAX 03 59 57 78 50 >> TEL 03 59 35 86 16 >> S. Ducasse - Inria >> 40, avenue Halley, >> Parc Scientifique de la Haute Borne, BÃ¢t.A, Park Plaza >> Villeneuve d'Ascq 59650 >> France >> >

May 21, 2021

Re: New VM, how do I get it

by David Pennington

This is a bit like pulling teeth. I have done what you said. I now have the following in Terminal davidpennington@Davids-Air ~ % wget -O - https://get.pharo.org/vmLatest90 | bash --2021-05-21 15:24:47-- https://get.pharo.org/vmLatest90 Resolving get.pharo.org (get.pharo.org) 2001:41d0:301::23, 164.132.235.17 Connecting to get.pharo.org (get.pharo.org)|2001:41d0:301::23|:443... connected. HTTP request sent, awaiting response... 200 OK Length: 5177 (5.1K) Saving to: âSTDOUTâ - 100%[===================>] 5.06K --.-KB/s in 0s 2021-05-21 15:24:47 (823 MB/s) - written to stdout [5177/5177] Downloading the latest pharoVM: http://files.pharo.org/get-files/90/pharo-vm-Darwin-arm64-latest.zip pharo-vm/Pharo.app/Contents/MacOS/Pharo Creating starter scripts pharo and pharo-ui Where do I go next? > On 21 May 2021, at 12:31, StÃ©phane Ducasse <stephane.ducasse(a)inria.fr> wrote: > > you execute on a unix shell > > wget -O - https://get.pharo.org/vmLatest90 <https://get.pharo.org/vmLatest90> | bash > > S > >> On 21 May 2021, at 13:16, David Pennington <david(a)totallyobjects.com <mailto:david@totallyobjects.com>> wrote: >> >> I am sorry but, being a newbie to Pharo, a lot of what you say goes over my head. >> >> How do I use Zero Conf? >> >> I have loaded up the latest 9.0 from Pharo launcher. How do I get the <1 VM for that? >> >> Sorry for being stupid. >> >> David >> P.S. 31 years a Smalltalker so its just the underlying bits that pass over me - smile. >> >>> On 19 May 2021, at 08:38, tesonep(a)gmail.com <mailto:tesonep@gmail.com> wrote: >>> >>> Hi David, >>> >>> for M1 we have Pharo 9 compatible VMs, you can download them using Zero Conf or directly. >>> >>> For the latest: >>> - wget -O - https://get.pharo.org/vmLatest90 <https://get.pharo.org/vmLatest90> | bash >>> - http://files.pharo.org/get-files/90/pharo-vm-Darwin-arm64-latest.zip <http://files.pharo.org/get-files/90/pharo-vm-Darwin-arm64-latest.zip> >>> >>> For the stable: >>> - wget -O - https://get.pharo.org/vm90 <https://get.pharo.org/vm90> | bash >>> - http://files.pharo.org/get-files/90/pharo-vm-Darwin-arm64-stable.zip <http://files.pharo.org/get-files/90/pharo-vm-Darwin-arm64-stable.zip> >>> >>> If you are scripting the download I recommend using ZeroConf. >>> >>> For Pharo 8, we don't have a M1 native version, because Pharo 8 requires changes in the image to support the newer VMs. We have plans to backport the changes in the future, now we are putting all efforts in the release of Pharo 9. However, if the community consider it, we can switch priorities but it is not magical; we will need to leave something aside. Also, future versions of the Pharo Launcher will have support for detecting the architecture. >>> >>> In the meantime, Pharo 8 / 9 can be used without a problem with Rossetta, although the performance is not ideal. >>> >>> Tell me if you have any problem. >>> Cheers, >>> Pablo >>> >>> >>> On Tue, May 18, 2021 at 3:54 PM David Pennington <david(a)totallyobjects.com <mailto:david@totallyobjects.com>> wrote: >>> Hi there. I am currently using v8.0 on a new M1 MacBookAir. When I save the image I keep getting a message telling me that my VM is too old and to download a new one. I have looked in my Pharo Launcher but there is no new one there. What do I do please? >>> >>> David >>> >>> >>> -- >>> Pablo Tesone. >>> tesonep(a)gmail.com <mailto:tesonep@gmail.com> > > -------------------------------------------- > StÃ©phane Ducasse > http://stephane.ducasse.free.fr <http://stephane.ducasse.free.fr/> / http://www.pharo.org <http://www.pharo.org/> > 03 59 35 87 52 > Assistant: Aurore Dalle > FAX 03 59 57 78 50 > TEL 03 59 35 86 16 > S. Ducasse - Inria > 40, avenue Halley, > Parc Scientifique de la Haute Borne, BÃ¢t.A, Park Plaza > Villeneuve d'Ascq 59650 > France >

May 21, 2021

Re: New VM, how do I get it

by StÃ©phane Ducasse

you execute on a unix shell wget -O - https://get.pharo.org/vmLatest90 <https://get.pharo.org/vmLatest90> | bash S > On 21 May 2021, at 13:16, David Pennington <david(a)totallyobjects.com> wrote: > > I am sorry but, being a newbie to Pharo, a lot of what you say goes over my head. > > How do I use Zero Conf? > > I have loaded up the latest 9.0 from Pharo launcher. How do I get the <1 VM for that? > > Sorry for being stupid. > > David > P.S. 31 years a Smalltalker so its just the underlying bits that pass over me - smile. > >> On 19 May 2021, at 08:38, tesonep(a)gmail.com <mailto:tesonep@gmail.com> wrote: >> >> Hi David, >> >> for M1 we have Pharo 9 compatible VMs, you can download them using Zero Conf or directly. >> >> For the latest: >> - wget -O - https://get.pharo.org/vmLatest90 <https://get.pharo.org/vmLatest90> | bash >> - http://files.pharo.org/get-files/90/pharo-vm-Darwin-arm64-latest.zip <http://files.pharo.org/get-files/90/pharo-vm-Darwin-arm64-latest.zip> >> >> For the stable: >> - wget -O - https://get.pharo.org/vm90 <https://get.pharo.org/vm90> | bash >> - http://files.pharo.org/get-files/90/pharo-vm-Darwin-arm64-stable.zip <http://files.pharo.org/get-files/90/pharo-vm-Darwin-arm64-stable.zip> >> >> If you are scripting the download I recommend using ZeroConf. >> >> For Pharo 8, we don't have a M1 native version, because Pharo 8 requires changes in the image to support the newer VMs. We have plans to backport the changes in the future, now we are putting all efforts in the release of Pharo 9. However, if the community consider it, we can switch priorities but it is not magical; we will need to leave something aside. Also, future versions of the Pharo Launcher will have support for detecting the architecture. >> >> In the meantime, Pharo 8 / 9 can be used without a problem with Rossetta, although the performance is not ideal. >> >> Tell me if you have any problem. >> Cheers, >> Pablo >> >> >> On Tue, May 18, 2021 at 3:54 PM David Pennington <david(a)totallyobjects.com <mailto:david@totallyobjects.com>> wrote: >> Hi there. I am currently using v8.0 on a new M1 MacBookAir. When I save the image I keep getting a message telling me that my VM is too old and to download a new one. I have looked in my Pharo Launcher but there is no new one there. What do I do please? >> >> David >> >> >> -- >> Pablo Tesone. >> tesonep(a)gmail.com <mailto:tesonep@gmail.com> -------------------------------------------- StÃ©phane Ducasse http://stephane.ducasse.free.fr / http://www.pharo.org 03 59 35 87 52 Assistant: Aurore Dalle FAX 03 59 57 78 50 TEL 03 59 35 86 16 S. Ducasse - Inria 40, avenue Halley, Parc Scientifique de la Haute Borne, BÃ¢t.A, Park Plaza Villeneuve d'Ascq 59650 France

May 21, 2021

Re: New VM, how do I get it

by David Pennington

I am sorry but, being a newbie to Pharo, a lot of what you say goes over my head. How do I use Zero Conf? I have loaded up the latest 9.0 from Pharo launcher. How do I get the <1 VM for that? Sorry for being stupid. David P.S. 31 years a Smalltalker so its just the underlying bits that pass over me - smile. > On 19 May 2021, at 08:38, tesonep(a)gmail.com wrote: > > Hi David, > > for M1 we have Pharo 9 compatible VMs, you can download them using Zero Conf or directly. > > For the latest: > - wget -O - https://get.pharo.org/vmLatest90 <https://get.pharo.org/vmLatest90> | bash > - http://files.pharo.org/get-files/90/pharo-vm-Darwin-arm64-latest.zip <http://files.pharo.org/get-files/90/pharo-vm-Darwin-arm64-latest.zip> > > For the stable: > - wget -O - https://get.pharo.org/vm90 <https://get.pharo.org/vm90> | bash > - http://files.pharo.org/get-files/90/pharo-vm-Darwin-arm64-stable.zip <http://files.pharo.org/get-files/90/pharo-vm-Darwin-arm64-stable.zip> > > If you are scripting the download I recommend using ZeroConf. > > For Pharo 8, we don't have a M1 native version, because Pharo 8 requires changes in the image to support the newer VMs. We have plans to backport the changes in the future, now we are putting all efforts in the release of Pharo 9. However, if the community consider it, we can switch priorities but it is not magical; we will need to leave something aside. Also, future versions of the Pharo Launcher will have support for detecting the architecture. > > In the meantime, Pharo 8 / 9 can be used without a problem with Rossetta, although the performance is not ideal. > > Tell me if you have any problem. > Cheers, > Pablo > > > On Tue, May 18, 2021 at 3:54 PM David Pennington <david(a)totallyobjects.com <mailto:david@totallyobjects.com>> wrote: > Hi there. I am currently using v8.0 on a new M1 MacBookAir. When I save the image I keep getting a message telling me that my VM is too old and to download a new one. I have looked in my Pharo Launcher but there is no new one there. What do I do please? > > David > > > -- > Pablo Tesone. > tesonep(a)gmail.com <mailto:tesonep@gmail.com>

May 21, 2021

UK Smalltalk User Group meeting - Wednesday May 26th

by Giovanni Corriga

The next meeting of the UK Smalltalk User Group will be on Wednesday, May 26th. Caffeine ( https://caffeine.js.org ) is a livecoded integration of the SqueakJS Smalltalkvirtual machine with the Web platform and its many frameworks. Craig Latta will show the current state of Caffeine development through live manipulation and combination of those frameworks. The primary vehicle is a Caffeine app called Worldly, combining the A-Frame VR framework, screen-sharing, and the Chrome Debugging Protocol into an immersive virtual-reality workspace. Craig Latta ( https://blackpagedigital.com ) is a livecoding composer from California. He studied music at Berkeley, where he learned Smalltalk as an improvisation practice. He has worked as a research computer scientist at Atari Games, IBM's Watson lab, and Lam Research. In 2016 he began combining Smalltalk technologies with the Web platform, with an emphasis on spatial computing. He is currently exploring spatial audio for immersive workspaces. Given the current COVID-19 restrictions, this will be an online meeting from home. If you'd like to join us, please sign up in advance on the meeting's Meetup page ( https://www.meetup.com/UKSTUG/events/cbklbrycchbjc/ ) to receive the meeting details. Donât forget to bring your laptop and drinks!

May 19, 2021

Re: P3 connection error

by Sven Van Caekenberghe

Bernard, > On 18 May 2021, at 22:23, Sven Van Caekenberghe <sven(a)stfx.eu> 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 servers). >From a high level (P3, Pharo 7, macOS), I can do the following for a plain connection: P3LogEvent logToTranscript. (P3Client new url: 'psql://sven@localhost') in: [ :client | [ client isWorking ] ensure: [ client close ] ]. This returns true and shows the following in the Transcript: 2021-05-19 13:06:44 001 [P3] 68689 #Connect psql://sven@localhost:5432 Trust 2021-05-19 13:06:44 002 [P3] 68689 #Query SELECT 721 AS N 2021-05-19 13:06:44 003 [P3] 68689 #Result SELECT 1, 1 record, 1 colum, 0 ms 2021-05-19 13:06:44 004 [P3] 68689 #Close For a secure connection, either of the following work: (P3Client new url: 'psql://sven@localhost?sslmode=require') in: [ :client | [ client isWorking ] ensure: [ client close ] ]. (P3Client new url: 'psql://sven@localhost') in: [ :client | [ client connectSSL; isWorking ] ensure: [ client close ] ]. These both return true and give the same output: 2021-05-19 13:07:39 005 [P3] 68701 #Connect psql://sven@localhost:5432?sslmode=require Trust 2021-05-19 13:07:39 006 [P3] 68701 #Query SELECT 316 AS N 2021-05-19 13:07:39 007 [P3] 68701 #Result SELECT 1, 1 record, 1 colum, 0 ms 2021-05-19 13:07:39 008 [P3] 68701 #Close This is a local login without a password. Now, since you both got plain and secure connections working, there is no fundamental problem for either type, or the rest of your setup/situation. You seem to have hit some edge, resulting from a small configuration difference in one of the server you are trying to log in to. You say you get a "SSL Exception: connect failed [code:-5]" - we have to find out what the -5 means. As you can see in ZdcPluginSSLSession>>#primitiveSSL:connect:startingAt:count:into: these errors are not specified or explained. We will have to look into the SSL plugin C code for that, and maybe/probably consult the Windows documentation for the system calls used. Apart from certificate issues, it could also be a cipher issue (as in something specific is required but not available). Sven PS: to configure the server (version 13.2), I added the following to postgres.conf ssl = on ssl_cert_file = '/Users/sven/.ssh/ssl-cert-snakeoil.pem' ssl_key_file = '/Users/sven/.ssh/ssl-cert-snakeoil.key' the ssl-cert-snakeoil I took from a standard Ubuntu postgreSQL installation. In pg_hba.conf the first field allows you to control access over different connection types: - host = both plain & secure - hostssl = only secure - hostnossl = only plain

May 19, 2021

Re: New VM, how do I get it

by tesonep＠gmail.com

Hi David, for M1 we have Pharo 9 compatible VMs, you can download them using Zero Conf or directly. For the latest: - wget -O - https://get.pharo.org/vmLatest90 | bash - http://files.pharo.org/get-files/90/pharo-vm-Darwin-arm64-latest.zip For the stable: - wget -O - https://get.pharo.org/vm90 | bash - http://files.pharo.org/get-files/90/pharo-vm-Darwin-arm64-stable.zip If you are scripting the download I recommend using ZeroConf. For Pharo 8, we don't have a M1 native version, because Pharo 8 requires changes in the image to support the newer VMs. We have plans to backport the changes in the future, now we are putting all efforts in the release of Pharo 9. However, if the community consider it, we can switch priorities but it is not magical; we will need to leave something aside. Also, future versions of the Pharo Launcher will have support for detecting the architecture. In the meantime, Pharo 8 / 9 can be used without a problem with Rossetta, although the performance is not ideal. Tell me if you have any problem. Cheers, Pablo On Tue, May 18, 2021 at 3:54 PM David Pennington <david(a)totallyobjects.com> wrote: > Hi there. I am currently using v8.0 on a new M1 MacBookAir. When I save > the image I keep getting a message telling me that my VM is too old and to > download a new one. I have looked in my Pharo Launcher but there is no new > one there. What do I do please? > > David -- Pablo Tesone. tesonep(a)gmail.com

May 19, 2021

Re: New VM, how do I get it

by Harald VICAIRE

Hi David, I do not own a M1 macBook but I read on discord that people are successfully using it. You might to take a look at : https://thepharo.dev/2021/02/16/first-apple-m1-pharo-version/ I think that you can download the last version here (instead ot the one given in the link above) : http://files.pharo.org/vm/pharo-spur64-headless/Darwin-arm64/ I'm afraid you'll need to find a M1 user if these links do not help you (come on discord <https://discord.gg/QewZMZa> to find some) Cheers, Harald Le mer. 19 mai 2021 Ã 01:54, David Pennington <david(a)totallyobjects.com> a Ã©crit : > Hi there. I am currently using v8.0 on a new M1 MacBookAir. When I save > the image I keep getting a message telling me that my VM is too old and to > download a new one. I have looked in my Pharo Launcher but there is no new > one there. What do I do please? > > David

May 19, 2021

Re: P3 connection error

by Bernhard Pieber

Yes, I am on Windows 10. Thanks! Bernhard > Am 18.05.2021 um 22:23 schrieb Sven Van Caekenberghe <sven(a)stfx.eu>: > > > 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 will try to test plain and tls connections on my machine. > > Sven > >> On 18 May 2021, at 21:22, Bernhard Pieber <bernhard(a)pieber.com> wrote: >> >> 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 the settings after all. >> >> I noticed that the error message ends with "SSL offâ. So maybe the problem is related to SSL after all. Just calling #setSSL does not help, though. I get SSL Exception: connect failed [code:-5]. Maybe I am missing some certificates? >> >> When I connect with psql, three of the four hosts show this message: >> psql (12.5, Server 12.6) >> SSL-Verbindung (Protokoll: TLSv1.2, VerschlÃ¼sselungsmethode: ECDHE-ECDSA-AES128-GCM-SHA256, Bits: 128, Komprimierung: aus) >> >> The fourth does not mention SSL. >> >> However, only one of the three hosts that show SSL does not work. Really strange. >> >> (All of the four hosts work with psql, SQuirreL and DBeaver.) >> >> Thanks for your support! >> >> Bernhard >> >>> Am 18.05.2021 um 20:16 schrieb Sven Van Caekenberghe <sven(a)stfx.eu>: >>> >>> >>> (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 May 2021, at 19:47, Bernhard Pieber <bernhard(a)pieber.com> wrote: >>>> >>>> Hi Sven, >>>> >>>> Thank you for the fast response. >>>> >>>> Yes, I can connect using the psql client using this command line: >>>> C:\PostgreSQL\12\bin\psql.exe -h host -U user -d database -p 5432 >>>> >>>> I have to enter the password in the command prompt. >>>> >>>> The driver URL in SQuirreL is: >>>> jdbc:postgresql://host:5432/database >>>> >>>> User name and password are separate text fields. >>>> >>>> pgAdmin also works, by the way. >>>> >>>> In P3 I use the long form: >>>> P3Client new url: 'psql://user:password@host:5432/database'. >>>> >>>> Cheers, >>>> Bernhard >>>> >>>>> Am 18.05.2021 um 19:16 schrieb Sven Van Caekenberghe <sven(a)stfx.eu>: >>>>> >>>>> >>>>> Hi Bernard, >>>>> >>>>>> On 18 May 2021, at 18:40, Bernhard Pieber <bernhard(a)pieber.com> 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 via Pharo and P3 I get the infamous "no pg_hba.conf entry for host <my IP address>â error. The thing is that I cannot change the pg_hba.conf file as the server does not belong to me. I wonder why the JDBC driver does not run into this problem when connecting from my IP address? It must do something differently. >>>>>> >>>>>> As I have just started playing with P3 (and PostgreSQL to be honest) I may be missing something fundamental. Using #setSSL did not help, by the way. Any other ideas I could try? >>>>>> >>>>>> Cheers, >>>>>> Bernhard >>>>> >>>>> This is an interesting problem: to do a remote, over the network, connection this has to be enabled in PostegreSQL in the pg_hba.conf. But since other clients can connect, it would help if you could give me more details regarding their connection settings. I know this could include confidential information, so be careful what you post. >>>>> >>>>> You could also try to connect using the command line psql client, from your machine. >>>>> >>>>> Sven >>>> >>> >> >> >

May 18, 2021

Re: P3 connection error

by 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 will try to test plain and tls connections on my machine. Sven > On 18 May 2021, at 21:22, Bernhard Pieber <bernhard(a)pieber.com> wrote: > > 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 the settings after all. > > I noticed that the error message ends with "SSL offâ. So maybe the problem is related to SSL after all. Just calling #setSSL does not help, though. I get SSL Exception: connect failed [code:-5]. Maybe I am missing some certificates? > > When I connect with psql, three of the four hosts show this message: > psql (12.5, Server 12.6) > SSL-Verbindung (Protokoll: TLSv1.2, VerschlÃ¼sselungsmethode: ECDHE-ECDSA-AES128-GCM-SHA256, Bits: 128, Komprimierung: aus) > > The fourth does not mention SSL. > > However, only one of the three hosts that show SSL does not work. Really strange. > > (All of the four hosts work with psql, SQuirreL and DBeaver.) > > Thanks for your support! > > Bernhard > >> Am 18.05.2021 um 20:16 schrieb Sven Van Caekenberghe <sven(a)stfx.eu>: >> >> >> (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 May 2021, at 19:47, Bernhard Pieber <bernhard(a)pieber.com> wrote: >>> >>> Hi Sven, >>> >>> Thank you for the fast response. >>> >>> Yes, I can connect using the psql client using this command line: >>> C:\PostgreSQL\12\bin\psql.exe -h host -U user -d database -p 5432 >>> >>> I have to enter the password in the command prompt. >>> >>> The driver URL in SQuirreL is: >>> jdbc:postgresql://host:5432/database >>> >>> User name and password are separate text fields. >>> >>> pgAdmin also works, by the way. >>> >>> In P3 I use the long form: >>> P3Client new url: 'psql://user:password@host:5432/database'. >>> >>> Cheers, >>> Bernhard >>> >>>> Am 18.05.2021 um 19:16 schrieb Sven Van Caekenberghe <sven(a)stfx.eu>: >>>> >>>> >>>> Hi Bernard, >>>> >>>>> On 18 May 2021, at 18:40, Bernhard Pieber <bernhard(a)pieber.com> 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 via Pharo and P3 I get the infamous "no pg_hba.conf entry for host <my IP address>â error. The thing is that I cannot change the pg_hba.conf file as the server does not belong to me. I wonder why the JDBC driver does not run into this problem when connecting from my IP address? It must do something differently. >>>>> >>>>> As I have just started playing with P3 (and PostgreSQL to be honest) I may be missing something fundamental. Using #setSSL did not help, by the way. Any other ideas I could try? >>>>> >>>>> Cheers, >>>>> Bernhard >>>> >>>> This is an interesting problem: to do a remote, over the network, connection this has to be enabled in PostegreSQL in the pg_hba.conf. But since other clients can connect, it would help if you could give me more details regarding their connection settings. I know this could include confidential information, so be careful what you post. >>>> >>>> You could also try to connect using the command line psql client, from your machine. >>>> >>>> Sven >>> >> > >

May 18, 2021