Hi Dimitris, It's not a SSL problem. Normaly, you can use PostgreSQL without SSL. The error message says that you must add your client device in the pg_hba.conf file. This file lists all the devices that are authorized to connect to the PostgreSQL server.
https://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html At work, I use the postgreSQL V2 protocol without problem with Pharo but I have not yet tested with Pharo 6. With Garage, it's a cool solution to build database applications. Best regards Olivier :) 2017-04-18 9:07 GMT+02:00 Dimitris Chloupis <kilon.al...@gmail.com>: > I adjusted it for my database and gives me error > > EFATAL: no pg_hba.conf entry for host "", user "", database "", SSL off > > any way to resolved this ? > > On Tue, Apr 18, 2017 at 1:24 AM Benoit St-Jean <bstj...@yahoo.com> wrote: > >> Try this: >> >> | sql conn connectionSpec result | >> sql := 'SELECT * FROM search_terms'. >> conn := GAConnection new. >> connectionSpec := GAConnectionArgs >> hostname: 'localhost' >> portno: 5432 >> databaseName: 'sodbxtest' >> userName: 'sodbxtest' >> password: 'sodbxtest'. >> conn connectionArgs: connectionSpec. >> >> "Connect to the server" >> result := conn startup. >> (result errorResponse isKindOf: GAErrorResponse) ifTrue: [ self halt ]. >> >> "Execute your SQL stuff" >> result := conn execute: sql. >> (result errorResponse isKindOf: GAErrorResponse) ifTrue: [ self halt ] >> ifFalse: [result inspect]. >> >> "Disconnect from the server" >> conn close. >> >> >> ----------------- >> Benoît St-Jean >> Yahoo! Messenger: bstjean >> Twitter: @BenLeChialeux >> Pinterest: benoitstjean >> Instagram: Chef_Benito >> IRC: lamneth >> Blogue: endormitoire.wordpress.com >> "A standpoint is an intellectual horizon of radius zero". (A. Einstein) >> >> >> ------------------------------ >> *From:* Dimitris Chloupis <kilon.al...@gmail.com> >> *To:* Benoit St-Jean <bstj...@yahoo.com>; Any question about pharo is >> welcome <pharo-users@lists.pharo.org> >> *Sent:* Monday, April 17, 2017 5:24 PM >> >> *Subject:* Re: [Pharo-users] PostgreSQL and Pharo 6 >> >> Following the instructions here >> >> http://guillep.github.io/DBXTalk/garage/installation.html >> >> I did >> >> Gofer it >> smalltalkhubUser: 'DBXTalk' project: 'Garage'; >> configurationOf: 'Garage'; >> load. >> >> >> (ConfigurationOfGarage project version: '0.5') >> load: 'postgresV2'. >> >> And it did install >> >> >> On Tue, 18 Apr 2017 at 00:02, Benoit St-Jean <bstj...@yahoo.com> wrote: >> >> Tell me which exact package you loaded (or even better, the exact to load >> it) and I will test some code against my PostgreSQL server... >> >> >> ----------------- >> Benoît St-Jean >> Yahoo! Messenger: bstjean >> Twitter: @BenLeChialeux >> Pinterest: benoitstjean >> Instagram: Chef_Benito >> IRC: lamneth >> Blogue: endormitoire.wordpress.com >> "A standpoint is an intellectual horizon of radius zero". (A. Einstein) >> >> >> ------------------------------ >> *From:* Dimitris Chloupis <kilon.al...@gmail.com> >> *To:* Benoit St-Jean <bstj...@yahoo.com>; Any question about pharo is >> welcome <pharo-users@lists.pharo.org> >> *Sent:* Monday, April 17, 2017 4:55 PM >> >> *Subject:* Re: [Pharo-users] PostgreSQL and Pharo 6 >> >> no conn connect does not work because GAConnection has no such method. >> #connect exist in GAPostgresDrive but even if I go that route I get error >> #OptionAt:IfAbsent: was sent to nil . With this code >> >> conn2 := GAPostgresDriver new . >> conn2 host: 'ec2-**-***-***-185.eu-west-1.compute.amazonaws.com' >> port: '****' >> database:'*******' >> user: '*****' >> password:''***'. >> conn2 connect. >> >> Is there sample code that connects to online databases ? >> >> >> >> On Mon, Apr 17, 2017 at 11:18 PM Benoit St-Jean <bstj...@yahoo.com> >> wrote: >> >> You have to #connect before executing SQL statements! >> >> Something like (in your code): >> >> conn connect. >> >> ----------------- >> Benoît St-Jean >> Yahoo! Messenger: bstjean >> Twitter: @BenLeChialeux >> Pinterest: benoitstjean >> Instagram: Chef_Benito >> IRC: lamneth >> Blogue: endormitoire.wordpress.com >> "A standpoint is an intellectual horizon of radius zero". (A. Einstein) >> >> >> ------------------------------ >> *From:* Dimitris Chloupis <kilon.al...@gmail.com> >> *To:* Benoit St-Jean <bstj...@yahoo.com>; Any question about pharo is >> welcome <pharo-users@lists.pharo.org> >> *Sent:* Monday, April 17, 2017 3:54 PM >> *Subject:* Re: [Pharo-users] PostgreSQL and Pharo 6 >> >> Installing from Catalog Browser fails >> >> I installed it via the the website instructions, it installs fine >> >> But if I use it this way >> >> conn := GAConnection new. >> ca := GAConnectionArgs hostname: 'ec2-**-***-***-185.eu-west-1. >> compute.amazonaws.com' >> portno: '****' >> databaseName:'*******' >> userName: '*****' >> password:''***'. >> conn connectionArgs: ca. >> conn execute: 'select * from search_terms'. >> >> it fails with no connection, is there anything else i need to do ? >> is there a guide for how to use this ? >> >> >> >> On Mon, Apr 17, 2017 at 7:30 PM Dimitris Chloupis <kilon.al...@gmail.com> >> wrote: >> >> thank you Benoit >> >> On Mon, Apr 17, 2017 at 4:23 AM Benoit St-Jean via Pharo-users < >> pharo-users@lists.pharo.org> wrote: >> >> ODBC worked fine as well if you don't need native driver access >> >> ----------------- >> Benoît St-Jean >> Yahoo! Messenger: bstjean >> Twitter: @BenLeChialeux >> Pinterest: benoitstjean >> Instagram: Chef_Benito >> IRC: lamneth >> Blogue: endormitoire.wordpress.com >> "A standpoint is an intellectual horizon of radius zero". (A. Einstein) >> >> >> ------------------------------ >> *From:* Dimitris Chloupis <kilon.al...@gmail.com> >> *To:* Any question about pharo is welcome <pharo-users@lists.pharo.org> >> *Sent:* Sunday, April 16, 2017 4:37 AM >> *Subject:* [Pharo-users] PostgreSQL and Pharo 6 >> >> Hey guys , I play with PostgreSQL and I really like it, sorry Esteban :D >> >> I am using Python for it but I would like to give access also to Pharo to >> my database. I was informed that Garage has a driver for PostgreSQL , is >> there any other candidate ? Any advice ? >> >> >> >> >> >> >> >> >>
