Thanks I will give it a try though I am very bad at understanding code without documentation. I also know close to nothing about SSL . If that fails I will then use the Python library for accessing my PostgreSQL database from Pharo image. On Tue, 18 Apr 2017 at 19:18, Sven Van Caekenberghe <s...@stfx.eu> wrote:
> > > On 18 Apr 2017, at 16:49, Esteban A. Maringolo <emaring...@gmail.com> > wrote: > > > > All current PostgreSQL drivers are 100% written in Smalltalk, I > > haven't used the V3 version (binary), but the V2 is more than good > > enough even for production systems. > > > > Writing a new driver using the libpq shared library might be a fun > > project, but a lot of work; maybe it will be more fun adding the > > SSL/TLS to the current Smalltalk implementation :) > > That is probably not so difficult. > > For inspiration, take a look at ZdcSecurePOP3Client and > ZdcSecureSMTPClient, which are both SSL variants of their respective > superclasses. Once set up, an SSL stream acts the same as a normal socket > stream. Methods to look at are #setupStreamForSSL or > #setupStreamForStartTLS. > > > Regards, > > > > Esteban A. Maringolo > > > > > > 2017-04-18 11:19 GMT-03:00 Dimitris Chloupis <kilon.al...@gmail.com>: > >> 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 ? > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>> > >>> > >> > > > > >
