[Pypgsql-users] SSL support on windows

[Kirill L. <ki...@la...>]

Hello,

I am trying to use pyPgSQL from windows to reach SSL-only postgre 
server, and I am getting following error:

Traceback (most recent call last):
   File "test.py", line 3, in ?
     con = PgSQL.connect(user='***', password='***', host='***', 
database='***')
   File "C:\bin\Python23\Lib\site-packages\pyPgSQL\PgSQL.py", line 2211, 
in connect
     return Connection(connInfo, client_encoding, unicode_results)
   File "C:\bin\Python23\Lib\site-packages\pyPgSQL\PgSQL.py", line 2331, 
in __init__
     raise DatabaseError, m
libpq.DatabaseError: FATAL:  no pg_hba.conf entry for host "***", user 
"***", database "***", SSL off

The very same test works just fine on Linux. If I turn off SSL on 
server, then I can connect from both Win and Linux. I thought windows 
version of Python missing SSL, but that's not the case from what I view:

C:\work\pgtest>python
Python 2.3.3 (#51, Dec 18 2003, 20:22:39) [MSC v.1200 32 bit (Intel)] on 
win32
Type "help", "copyright", "credits" or "license" for more information.
 >>> import socket
 >>> socket.ssl
<function ssl at 0x008F1770>
 >>> ^Z

Any ideas? Thanks.

--Kirill