You say its not an SSL problem and then you say I should not use SSL and it will work :D
yes I know it would work without SSL but I want to use SSL. Hence my problem. SSL support is pretty standards nowdays anyway. On Sat, Apr 22, 2017 at 11:13 PM olivier auverlot < olivier.auver...@gmail.com> wrote: > 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 ? >>> >>> >>> >>> >>> >>> >>> >>> >>> >
