And nope it does not allow for disabling SSL , time to use old reliable Python and make my life a ton easier :D On Tue, 18 Apr 2017 at 18:29, Dimitris Chloupis <kilon.al...@gmail.com> wrote:
> If I disable ssl I would make database insecure, but yeah it would not > matter so much as the data is not sensitive in any way. I will try that, > good idea. > On Tue, 18 Apr 2017 at 18:22, Benoit St-Jean via Pharo-users < > pharo-users@lists.pharo.org> wrote: > >> Do you absolutely need SSL or you can connect to this server without it? >> >> Esteban is right : writing a driver from scratch takes quite some time! >> It would be way easier to add SSL support to the existing one. >> >> >> >> ----------------- >> 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:* Tuesday, April 18, 2017 11:02 AM >> >> *Subject:* Re: [Pharo-users] PostgreSQL and Pharo 6 >> >> Sure but most probably I won't do either and abandon the effort. By API I >> did not mean to wrap the entire thing only a dozen of functions, the bare >> minimum I want to make this work. Including SSL. Will give a try at some >> point in the future and if it's easy will do. If not , no big deal. >> >> There is also the possibility of using the Python library for PostgreSQL >> from inside Pharo via my Python IPC API, Atlas. I just did not want to add >> Python as dependency for a Pharo library. But for now is the easiest >> solution . >> On Tue, 18 Apr 2017 at 17:51, 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 :) >> >> 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 ? >> >> >>> >> >> >>> >> >> >>> >> >> >>> >> >> >>> >> >> >>> >> >> >>> >> >> >>> >> >> > >> >> >> > >> >> >> >>
