> On 18 Apr 2017, at 16:49, Esteban A. Maringolo <[hidden email]> 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 <[hidden email]>: >> 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 <[hidden email]> >> 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 <[hidden email]>: >>>> 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 <[hidden email]> >>>> 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 <[hidden email]> >>>>> 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 <[hidden email]> >>>>>> To: Benoit St-Jean <[hidden email]>; Any question about pharo is >>>>>> welcome <[hidden email]> >>>>>> 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 <[hidden email]> >>>>>> 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 <[hidden email]> >>>>>> To: Benoit St-Jean <[hidden email]>; Any question about pharo is >>>>>> welcome <[hidden email]> >>>>>> 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 <[hidden email]> >>>>>> 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 <[hidden email]> >>>>>> To: Benoit St-Jean <[hidden email]>; Any question about pharo is >>>>>> welcome <[hidden email]> >>>>>> 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 >>>>>> <[hidden email]> >>>>>> wrote: >>>>>> >>>>>> thank you Benoit >>>>>> >>>>>> On Mon, Apr 17, 2017 at 4:23 AM Benoit St-Jean via Pharo-users >>>>>> <[hidden email]> 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 <[hidden email]> >>>>>> To: Any question about pharo is welcome <[hidden email]> >>>>>> 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 <[hidden email]> wrote:
|
In reply to this post by kilon.alios
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. 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 <[hidden email]>:
|
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 <[hidden email]> wrote:
|
Free forum by Nabble | Edit this page |