CODEWITHSUNDEEP
pythonpostgresqlpython-2.7psycopg2
qua
qua

Reputation: 992

Opening a postgres connection in psycopg2 causes python to crash

I'm getting the following error message when I try to open up a connection to a postgres database. Perhaps it's related to OpenSSL, but I can't understand the error message. Can anyone help?

>>> import psycopg2
>>> conn = psycopg2.connect(host = '', port = , dbname
 = '', user = '', password = '')
Auto configuration failed
12848:error:02001015:system library:fopen:Is a directory:.\crypto\bio\bss_file.c
:169:fopen('D:/Build/OpenSSL/openssl-1.0.1h-vc9-x64/ssl/openssl.cnf','rb')
12848:error:2006D002:BIO routines:BIO_new_file:system lib:.\crypto\bio\bss_file.
c:174:
12848:error:0E078002:configuration file routines:DEF_LOAD:system lib:.\crypto\co
nf\conf_def.c:199:

Upvotes: 7

Views: 1656

Answers (2)

user3911479
user3911479

Reputation: 83

I was seeing a similar issue on MacOSX v14.1.1:

>>> import psycopg2
>>> conn = psycopg2.connect(database="my-db",
...                         host="32.170.20.160",
...                         user="postgres",
...                         password="pass")

Python(16348,0x7ff8454d8b40) malloc: double free for ptr 0x7fcab3811c00
Python(16348,0x7ff8454d8b40) malloc: *** set a breakpoint in malloc_error_break to debug
Abort trap: 6

Installing psycopg2-binary solved it:

python3 -m pip install psycopg2-binary

Upvotes: 0

dnozay
dnozay

Reputation: 24314

One problem that I can think of is that your installation may not have been linked/built properly to use openssl. If you haven't tried the packages listed in the docs yet, maybe you could give it a try.

When I look at the docs:

Microsoft Windows:

Jason Erickson maintains a packaged Windows port of Psycopg with installation executable. Download. Double click. Done.

So you could try to install it from there. Or you can try the pip-friendly windows-friendly (note: I didn't try it myself) psycopg2-windows package.

Upvotes: 2

Related Questions