Re: Postgres ODBC Windows 7 x64 SSL not working!

From: Miguel Clara <miguelmclara(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Postgres ODBC Windows 7 x64 SSL not working!
Date: 2013-09-03 02:04:37
Message-ID: CADGo8CUPc4WtikA2cgF4G+uTjK49b=zsb9+JZWW8mMTYrOq85A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Also I should add, than I enable debug/log to file and see this:

[4116-0.000]globals.extra_systable_prefixes = 'dd_;'
[4116-0.001]exe name=odbcad32 plaformId=2
[4116-0.002]aszKey='DSN', value='PostgreSQL35W'
[4116-0.002]copyAttributes:
DSN='PostgreSQL35W',server='',dbase='',user='',passwd='xxxxx',port='',onlyread='',protocol='',conn_settings='',disallow_premature=-1)
[4116-0.016]getDSNinfo: DSN=PostgreSQL35W overwrite=0
[4116-0.017]force_abbrev=0 bde=0 cvt_null_date=0
[4116-0.018]globals.extra_systable_prefixes = 'dd_;'
[4116-0.019]calling getDSNdefaults
[4116-0.019]checking libpq library
[4116-0.020]secur32 hmodule=000007FEFC7D0000
[4116-0.021]libpq_exist=1
[4116-2.337]EN_add_connection: self = 0000000003072450, conn =
0000000003074160
[4116-2.338] added at 0, conn->henv = 0000000003072450,
conns[0]->henv = 0000000003072450
[4116-2.339]CC_connect: entering...
[4116-2.339]sslmode=require
[4116-2.341]original_CC_connect: entering...
[4116-2.347]Driver Version='09.02.0100,201306020000' linking 1600 dynamic
Multithread library
[4116-2.357]original_CC_connect: DSN = 'PostgreSQL35W', server =
'testhost', port = '55432', database = '_', username = '_', password='xxxxx'
[4116-2.358]connecting to the server socket...
[4116-2.424](0)(null) ERRNO=0
[4116-2.424]connection to the server socket succeeded.
[4116-2.426]read -1, global_socket_buffersize=4096
[4116-2.426]Lasterror=10035
[4116-2.480]read 1, global_socket_buffersize=4096
[4116-2.481]nego got 'S'
[4116-2.492]48 bytes of handshake data sent
[4116-2.492]**** Error 10035 reading data from server
[4116-2.545]1448 bytes of handshake data received
[4116-2.548]227 bytes of handshake data received

On Tue, Sep 3, 2013 at 3:39 AM, Mike C. <miguelmclara(at)gmail(dot)com> wrote:

>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> We tried this is several computers, with windows 7 x64, we are able to
> "Test" the connection withoud SSL, but while using SSL the ODBC
> Administrator crashes!
>
> Note that we are able to save the "dsn" what fails is the test it self!
>
> On the server I see:
>
> LOG: could not accept SSL connection: EOF detected
>
>
> Also If this eventually works and I want to use certs for auth, where
> should I place them? I found nothing in the ODBC driver doc regarding this!
>
> Thanks!
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.20 (FreeBSD)
> Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
>
> iQIcBAEBAgAGBQJSJUvUAAoJEGKyFhaKt9g3Yg0P/2AdYb/68+OZ3c7++LiU00ml
> 70U4cUXPMRMYXPVEoZ8qG1kfWgr37txxFCZ3ECETv4ETL2ppgaONQf97puNmy4F5
> FBZYifkxbgZTwRoYUz/BZS/usDI4RhMjjU8vcgNL+SvDee8XgO3EOU5jy6hz3Sow
> HEUUgLhXjH2o/tyBMsCk5LDvMjbvErNX5g+k99JZby7BunQ2AyDaEtwUkIr4DwjT
> yzDy87b+qJnLx/SvQ0ZPDotJvj/X3vhKMdnoVjuixDHWWlEmgzHPoXM+dqdWPEJk
> WWGswgfLX9Mkqo6VQaqxx1c/MlNG9JiovbOkb359aYn5S+aknRQ8M6vbv10g0r13
> rkOSxWHuDv0ci0Q137C0FvZJldACDpZv4W1WMt45/5pkEaNuwMxSlZY4hv3TluMQ
> qhbAX1XZfPX7hO9excupV5XMCuT+VgJ+EDZwz2VbzJ1ZvB+KfbRPAeFFSVVW477h
> a9GzxQSaxzeR5hFpdwszdI1tGmiac0xo1uV/6Lf82mtkWWV/FjKErkH3V4QbuWID
> Nxa+lxj0uQ9t0gii3/I+WtOT/4UvzD0NNM9o9dgwqBv3LrG3uSm5BG6Ztg31aqpc
> 337dn4iK3tRxjhGHkA7tyulWwVP8sC+jIBAkb25+Q8tETfv4GoIQC/7PH06TWdBf
> j+Q1XUbwjJqRYBd3VaN4
> =hHv7
> -----END PGP SIGNATURE-----
>
>

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Mike C. 2013-09-03 02:39:18 Postgres ODBC Windows 7 x64 SSL not working!
Previous Message Heikki Linnakangas 2013-09-02 11:31:20 VACUUM cannot be run in a transaction block