psycopg - PostGreSQL libraries (not) missing

[bayerj]

Hello,

I know that this is a django group but due to the fact that everybody
here must- at one point - have installed psycopg and on that nobody
answers me on the psycopg list, i'm asking here again. ;)

I am running:
- Mac OS X 10.4
- Python 2.3.5 (shipped with Mac OS X)
- PostgreSQL 7.4.3 via Darwin Ports

I am trying to install psycopg. I run:

% sudo /Users/bayerj/Desktop/psycopg-1.1.19/configure \
-with-postgres-includes=/opt/local/include \

-with-mxdatetime-includes=/Library/Python/2.3/site-packages/mx/DateTime/mxDateTime
\
-with-postgres-libraries=/opt/local/postgresql

But I get the error:

configure: error: can't build without PostgreSQL libraries

The listing:

/opt/local/lib/postgresql $ ls
scii_and_mic.so this_config.sh utf8_and_iso8859.so
config.log tsearch2.so
utf8_and_iso8859_1.so
cyrillic_and_mic.so utf8_and_ascii.so utf8_and_johab.so
euc_cn_and_mic.so utf8_and_big5.so utf8_and_sjis.so
euc_jp_and_sjis.so utf8_and_cyrillic.so utf8_and_tcvn.so
euc_kr_and_mic.so utf8_and_euc_cn.so utf8_and_uhc.so
euc_tw_and_big5.so utf8_and_euc_jp.so utf8_and_win1250.so
latin2_and_win1250.so utf8_and_euc_kr.so utf8_and_win1256.so
latin_and_mic.so utf8_and_euc_tw.so utf8_and_win874.so
lib utf8_and_gb18030.so
plpgsql.so utf8_and_gbk.so

(lib is a symbolic link that points at /opt/local/lib/postgresql)

The config log:

configure: failed program was:
| /* confdefs.h. */
|
| #define PACKAGE_NAME "psycopg"
| #define PACKAGE_TARNAME "psycopg"
| #define PACKAGE_VERSION "1.1.19"
| #define PACKAGE_STRING "psycopg 1.1.19"
| #define PACKAGE_BUGREPORT "psy...@lists.initd.org"
|
| #define HAVE_LIBCRYPTO 1
| /* end confdefs.h. */
|
| /* Override any gcc2 internal prototype to avoid an error. */
| #ifdef __cplusplus
| extern "C"
| #endif
| /* We use char because int might match the return type of a gcc2
| builtin and then its argument prototype would still apply. */
| char PQconnectStart ();
| int
| main ()
| {
| PQconnectStart ();
| ;
| return 0;
| }
configure:3249: result: no
configure:3254: error: can't build without PostgreSQL libraries

Can anyone help me out with this? I googled and all but haven't found a
solution.

Thanks,
-Justin

[Sokolov Yura]

May by
-with-postgres-libraries=/opt/local/lib/postgresql
Or -with-postgres-libraries=/opt/local/lib
And why not using psycopg2?
It is beta, but i not has a proplem with it. Just edit django's
postgresql module to import psycopg2 and comment register-type
(psycopg2 use datetime.datetime internally - not mxDateTime)

[bayerj]

I have tried a lot of different paths, but neither is working. I'm
going to have a look into psycopg2, though.