Re: [Pharo-users] PostgreSQL and Pharo 6
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.alios@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 ?
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.alios@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.alios@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 ?
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.alios@gmail.com> To: Benoit St-Jean <bstjean@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.alios@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.alios@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 ?Â
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 <bstjean@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.alios@gmail.com> *To:* Benoit St-Jean <bstjean@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.alios@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.alios@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 ?
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.alios@gmail.com> To: Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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.alios@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.alios@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 ?Â
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 <bstjean@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.alios@gmail.com> *To:* Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> *To:* Benoit St-Jean <bstjean@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.alios@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.alios@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 ?
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.alios@gmail.com> To: Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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.alios@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.alios@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 ?Â
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 <bstjean@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.alios@gmail.com> *To:* Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> *To:* Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> *To:* Benoit St-Jean <bstjean@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.alios@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.alios@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 ?
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.alios@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 <bstjean@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.alios@gmail.com> *To:* Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> *To:* Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> *To:* Benoit St-Jean <bstjean@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.alios@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.alios@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 ?
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.alios@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.alios@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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.alios@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.alios@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 ?
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 <emaringolo@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.alios@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.alios@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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.alios@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.alios@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 ?
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.alios@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 <emaringolo@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.alios@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.alios@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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.alios@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.alios@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 ?
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 <emaringolo@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.alios@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 <emaringolo@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.alios@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.alios@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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.alios@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.alios@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 ?
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.alios@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 <emaringolo@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.alios@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 <emaringolo@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.alios@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.alios@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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.alios@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.alios@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 ?
On 18 Apr 2017, at 16:49, Esteban A. Maringolo <emaringolo@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.alios@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 <emaringolo@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.alios@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.alios@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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.alios@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.alios@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 ?
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 <sven@stfx.eu> wrote:
On 18 Apr 2017, at 16:49, Esteban A. Maringolo <emaringolo@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.alios@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 < emaringolo@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.alios@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.alios@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> To: Benoit St-Jean <bstjean@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.alios@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.alios@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 ?
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.alios@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 <bstjean@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.alios@gmail.com> *To:* Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> *To:* Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> *To:* Benoit St-Jean <bstjean@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.alios@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.alios@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 ?
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.auverlot@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.alios@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 <bstjean@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.alios@gmail.com> *To:* Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> *To:* Benoit St-Jean <bstjean@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 <bstjean@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.alios@gmail.com> *To:* Benoit St-Jean <bstjean@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.alios@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.alios@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 ?
participants (5)
-
Benoit St-Jean -
Dimitris Chloupis -
Esteban A. Maringolo -
olivier auverlot -
Sven Van Caekenberghe