Обсуждение: Postgres ODBC Windows 7 x64 SSL not working!
-----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-----
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@gmail.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-----
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Sorry for the last typos on the mail, I sent this at a very late time -.-' Anyway I'd like to add to the report that although I couldn't get the 64driver to work with SSL, I was able to workaround the issue by installing and using the 32bit version! Notde: I had to reboot the machine to be able to see the driver on ODBC 32bit after install, but from that all worked has expected! For those who don't know how to open the 32bit verion of ODBC on a 64bit machine I suggest the following MS KB: http://support.microsoft.com/kb/942976 Short version: Open odbc32 from --> %windir%\SysWOW64\odbcad32.exe this will enable you to add dsn using 32bit ODBC drivers, so Postgres Driver (non 64) should show up! The rest is the same, and I also noticed that if one selects verify-full but not certs have been placed in the correct dirs, the error message actually points to the dir where the driver expects the files to be, which is in fact the same dir has it would be for pgadmin (%APPDATA%) I would still like to know If anyone had success with using the 64-bit driver with SSL... or help get it fixed by testing a bit more! But for now this is a working alternative so its nothing high priority! Thanks! -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.20 (FreeBSD) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBAgAGBQJSJf0WAAoJEGKyFhaKt9g39okQAKIiY48B0t9hLdDZ5X0MoGCq dedGNL60wBEc6NKWjCIeCHnIjckvF3PhnF/SncD4bnYhMpxBFl3ZjwhArZeB9jxY vphvJeDp1LF9RfL3MV2NsmgEQew242NRtTPfAHrmpIbSFnGN7kKeq2EjbAEZ+t0A xhRPKFpUsowG6p8j1gEIQIge3N6Me5e57YSyDVdlgGXZ0UfHNPFCFU7wXrbPvzZf gUGtcgvapKvi4ywXfISNzoyHjAbQOEc8h5Pxxtm/VBcylpPa64FTanSq5mcTFrJk b6ljxvOTXOoxZJ/X0gv9UvYAEvNFIzuJC/e2L7V486JyDS6qaWJFEg/PjvE91q+i 2wTSfhdYE+m6j6LkWd1ZfOkMJpz5vOCvLMk7BCd6F0Kn5f8mGVrnNYPEjLrXBo6d bXIk6YabO33vZevbGHJ9gpyphGzowFWmXZL0k/Gp04EnLBvLbBtEAx9eeb0oENnW l+xjC4yQWlk/p7Ugjvsuw/Ym5JD6Ghv4IuP6vc2s/666E/tIuux82/ACVAcNS5bd o7UUkp+CQ0k1b/I/j4PvlVN8Ds7+UjJG9Cke62FuWhGj9nmfyFkG7Nhy/M/AKW5V +t0J7FUwwu7xJ43YxYF8Bnwvp6nrd22o+kqNxf76n73E1GpInWyeU3BPHjCuyhVG 5+X2YYis4OXkSNy7hEI9 =QxrE -----END PGP SIGNATURE-----