SSL support on windows

Kirill Lapshin <[email protected]> Wed, 12 May 2004 17:29:25 -0400
Newsgroups gmane.comp.python.db.pypgsql.user
Message-ID <[email protected]>
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



-------------------------------------------------------
This SF.Net email is sponsored by: SourceForge.net Broadband
Sign-up now for SourceForge Broadband and get the fastest
6.0/768 connection for only $19.95/mo for the first 3 months!
http://ads.osdn.com/?ad_id=2562&alloc_id=6184&op=click