Looks like I will have to make my own PostgreSQL API . Nice excuse to test my UFFI skills once more :) On Tue, 18 Apr 2017 at 16:17, Esteban A. Maringolo <emaring...@gmail.com> wrote:
> Not that I'm aware of. > > You can create a ssh tunnel that ciphers the data between your host > and the remote server, but you'd need a ssh daemon running in the > server host. > > Regards, > > Esteban A. Maringolo > > > 2017-04-18 5:09 GMT-03:00 Dimitris Chloupis <kilon.al...@gmail.com>: > > After some investigation in Heroku documentation, the database expects a > SSL > > connection but it seems the driver does not use SSL , any way to force > > Garage to use SSL ? > > > > On Tue, 18 Apr 2017 at 10:07, Dimitris Chloupis <kilon.al...@gmail.com> > > wrote: > >> > >> 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 ? > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > > > >
