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

Re: P3 connection error

by 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 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

(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 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

P3 connection error

by Bernhard Pieber

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

May 18, 2021

New VM, how do I get it

by David Pennington

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 18, 2021

Re: ODBCDriver adapted to uFFI

by StÃ©phane Ducasse

This is cool that you added some tests. I cannot work with system without tests. So I end up always adding some. S. > On 13 May 2021, at 21:46, TomaÅ¾ Turk <tomaz.turk(a)ef.uni-lj.si> wrote: > > Dear all, > > I solved a couple of issues in https://github.com/apiorno/ODBCDriver <https://github.com/apiorno/ODBCDriver>. Until Alvaro finds the time to check the proposed PR, you can play with my clone: https://github.com/eftomi/ODBCDriver <https://github.com/eftomi/ODBCDriver>. A simple example of connecting to the data source is in ODBC-Tests. It connects and returns data on Pharo 8.0 32 and 64 on Win10 64 bit with remote SQL Server. More extensive tests are to be done. > > Best wishes, > Tomaz -------------------------------------------- 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 14, 2021

Re: ODBCDriver adapted to uFFI

by StÃ©phane Ducasse

+ 1 > On 14 May 2021, at 15:32, Sean P. DeNigris <sean(a)clipperadams.com> wrote: > > eftomi wrote >> I solved a couple of issues... > > Thanks, Tomaz! DB access is so important for many business uses... > > > > ----- > Cheers, > Sean > -- > Sent from: http://forum.world.st/Pharo-Smalltalk-Users-f1310670.html -------------------------------------------- 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 14, 2021

Re: ODBCDriver adapted to uFFI

by Sean P. DeNigris

eftomi wrote > I solved a couple of issues... Thanks, Tomaz! DB access is so important for many business uses... ----- Cheers, Sean -- Sent from: http://forum.world.st/Pharo-Smalltalk-Users-f1310670.html

May 14, 2021

ODBCDriver adapted to uFFI

by TomaÅ¾ Turk

Dear all, I solved a couple of issues in https://github.com/apiorno/ODBCDriver. Until Alvaro finds the time to check the proposed PR, you can play with my clone: https://github.com/eftomi/ODBCDriver. A simple example of connecting to the data source is in ODBC-Tests. It connects and returns data on Pharo 8.0 32 and 64 on Win10 64 bit with remote SQL Server. More extensive tests are to be done. Best wishes, Tomaz

May 13, 2021

Re: NeoCSVReader and wrong number of fieldAccessors

by Sven Van Caekenberghe

There is now the following commit: https://github.com/svenvc/NeoCSV/commit/0acc2270b382f52533c478f2f1585341e39… which should address a couple of issues. > On 22 Jan 2021, at 12:15, jtuchel(a)objektfabrik.de wrote: > > Tim, > > > > > Am 22.01.21 um 10:22 schrieb Tim Mackinnon: >> Iâm not doing any CSV processing at the moment, but have in the past - so was interested in this thread. >> >> @Kasper, canât you just use #readHeader upfront, and do the assertion yourself, and then proceed to loop through your records? It would seem that the Neo caters for what you are suggesting - and if you want to add a helper method extension you have the building blocks to already do this? >> > This is a good idea. One caveat, however: #readHeader in its current implementation does 2 things: > > â¢ read the line respecting each field (thereby, respect line breaks within quoted fields - perfect for this purpose) > â¢ update the number of Columns for further reading (assuming #readHeader's purpose is to interpret the header line) > This second thing is in our way, because it may influence the way the following lines will be interpreted. That is ecactly why I created an issue on github (https://github.com/svenvc/NeoCSV/issues/20) > A method that reads a line without any side effects (other than pushing the position pointer forward to the next line) would come in handy for such scenarios. But you can always argue that this has nothing to do with CSV, because in CSV all lines have the same number of columns, each of them containing the same kind of information, and there may be exactly one header line. Anything else is just some file that may contain CSV-y stuff in it. So I am really not sure if NeoCSV should build lots of stuff for such files. I'd love to have this, but I'd understand if Sven refused to integrate it.... ;-) > > >> The only flaw I can think of, is if there is no header present then I canât recall what Neo does - ideally throws an exception so you can decide what to do - potentially continue if the number of columns is what you expect and the data matches the columns - or you fail with an error that a header is required. But I think you would always need to do some basic initial checks when processing CSV due to the nature of the format? > Right. You'd always have to write some specific logic for this particular file format and make NeoCSV ignore the right stuff... > > > > Joachim > > > > > >> >> Tim >> >> On Fri, 22 Jan 2021, at 6:42 AM, Kasper Osterbye wrote: >>> As it happened, I ran into the exact same scenario as Joachim just the other day, >>> that is, the external provider of my csv had added some new columns. In my case >>> manifested itself in an error that an integer field was not an integer (because new >>> columns were added in the middle). >>> >>> Reading through this whole thread leaves me with the feeling that no matter what Sven >>> adds, there is still a risk for error. Nevertheless, my suggestion would be to add a >>> functionality to #skipHeaders, or make a sister method: >>> #assertAndSkipHeaders: numberOfColumns onFailDo: aBlock given the actual number of headers >>> That would give me a way to handle the error up front. >>> >>> This will only be interesting if your data has headers of cause. >>> >>> Thanks for NeoCSV which I use all the time! >>> >>> Best, >>> >>> Kasper >> > > > -- > ----------------------------------------------------------------------- > Objektfabrik Joachim Tuchel > mailto:jtuchel@objektfabrik.de > > Fliederweg 1 > http://www.objektfabrik.de > > D-71640 Ludwigsburg > http://joachimtuchel.wordpress.com > > Telefon: +49 7141 56 10 86 0 Fax: +49 7141 56 10 86 1 > > > >

May 13, 2021