Thread: ODBC 7.03.02 on Windows connecting to PostgreSQL 7.4 using SSL
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.
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
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)