Thread: ODBC 7.03.02 on Windows connecting to PostgreSQL 7.4 using SSL

ODBC 7.03.02 on Windows connecting to PostgreSQL 7.4 using SSL

From
"Sydney Delieu"
Date:
Hello,

I installed PostgreSQL 7.4 with openssl option on SuSE 9.0. I created
the server.crt and server.key certificates as outlined in the online
PostgreSQL manual, and placed these certificates in the
/usr/local/pgsql/data directory. I then changed the 'ssl = false' to
'ssl = true' in postgresql.conf, and also added to pg_hba.conf:

hostssl TempDB testssluser 0.0.0.0 0.0.0.0 md5

Trying to connect from Windows using the PG ODBC 7.03.02 driver fails.

If I change my pg_hba.conf file to:

host TempDB testssluser 0.0.0.0 0.0.0.0 md5

then all works fine.

This is the first time I've used PostgreSQL, so any help/pointers would
really be appreciated.

Regards,
Sydney Delieu.

Re: ODBC 7.03.02 on Windows connecting to PostgreSQL 7.4 using SSL

From
Chris Gamache
Date:
The OpenSource ODBC driver doesn't support SSL. Try
http://www.commandprompt.com/ ... Mammoth S/ODBC 7.3.4 does support SSL.

CG

--- Sydney Delieu <syddel@hotmail.com> wrote:
> Hello,
>
> I installed PostgreSQL 7.4 with openssl option on SuSE 9.0. I created
> the server.crt and server.key certificates as outlined in the online
> PostgreSQL manual, and placed these certificates in the
> /usr/local/pgsql/data directory. I then changed the 'ssl = false' to
> 'ssl = true' in postgresql.conf, and also added to pg_hba.conf:
>
> hostssl TempDB testssluser 0.0.0.0 0.0.0.0 md5
>
> Trying to connect from Windows using the PG ODBC 7.03.02 driver fails.
>
> If I change my pg_hba.conf file to:
>
> host TempDB testssluser 0.0.0.0 0.0.0.0 md5
>
> then all works fine.
>
> This is the first time I've used PostgreSQL, so any help/pointers would
> really be appreciated.
>
> Regards,
> Sydney Delieu.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings





__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover

Re: ODBC 7.03.02 on Windows connecting to PostgreSQL 7.4 using SSL

From
"Sydney Delieu"
Date:
Hi Chris,

Thanks for the info, I will give Command Prompt Inc. a try.

Regards,
Sydney Delieu.


Chris Gamache wrote:

>
> The OpenSource ODBC driver doesn't support SSL. Try
> http://www.commandprompt.com/ ... Mammoth S/ODBC 7.3.4 does support
> SSL.
>
> CG
>
> --- Sydney Delieu <syddel@hotmail.com> wrote:
> > Hello,
> >
> > I installed PostgreSQL 7.4 with openssl option on SuSE 9.0. I
> > created the server.crt and server.key certificates as outlined in
> > the online PostgreSQL manual, and placed these certificates in the
> > /usr/local/pgsql/data directory. I then changed the 'ssl = false' to
> > 'ssl = true' in postgresql.conf, and also added to pg_hba.conf:
> >
> > hostssl TempDB testssluser 0.0.0.0 0.0.0.0 md5
> >
> > Trying to connect from Windows using the PG ODBC 7.03.02 driver
> > fails.
> >
> > If I change my pg_hba.conf file to:
> >
> > host TempDB testssluser 0.0.0.0 0.0.0.0 md5
> >
> > then all works fine.
> >
> > This is the first time I've used PostgreSQL, so any help/pointers
> > would really be appreciated.
> >


> > Regards,
> > Sydney Delieu.
> >
> > ---------------------------(end of
> > broadcast)--------------------------- TIP 7: don't forget to
> > increase your free space map settings
>
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Win a $20,000 Career Makeover at Yahoo! HotJobs
> http://hotjobs.sweepstakes.yahoo.com/careermakeover
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 2: you can get off all
> lists at once with the unregister command     (send "unregister
> YourEmailAddressHere" to majordomo@postgresql.org)