[Zope-DB] Re: ZPyscopgDA for Windows XP

[Infor Gates]

My apologies. Actually, you are receiving  resend of
an earlier email when I received a rejected reply from
the mail host server.

I have downloaded psycopg-2.0b2-win32-py23.exe.
python2.3 (windows versin) and Zope2.7.6 (windows
binaries). I had installed it. However, I had this
error message - MSVCR71.dll not found.  I do not have
MSVC++ compiler.


I had attempted to compiled a version of my own by
downloading the source copy psycopg-2.0b3. I tried to
compiled as instructed using MingGW/Msys. I am still
not successful. I suspect that the postgresql
headers/includes are missing. However, I  do not know
to confirm this when I look into Postgresql8.0
directories.

Your advice is much needed.

Thank you.

The error message:
-----------------
F:\>path
PATH=f:\Python23;f:\MinGW;f:\MinGW\bin;F:\MinGW\mingw32;F:\MinGW\mingw32\bin;F:\
MinGW\mingw32\lib;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;

F:\psycopg-2.0b3>python setup.py build_ext
--compiler=mingw32 install >log
In file included from psycopg\cursor_type.c:27:
./psycopg/config.h:81: warning: static declaration of
'round' follows non-static
 declaration
./psycopg/config.h:63: warning: 'pthread_mutex_init'
defined but not used
./psycopg/config.h:70: warning: 'gmtime_r' defined but
not used
In file included from psycopg\adapter_binary.c:30:
./psycopg/config.h:81: warning: static declaration of
'round' follows non-static
 declaration
./psycopg/config.h:63: warning: 'pthread_mutex_init'
defined but not used
./psycopg/config.h:70: warning: 'gmtime_r' defined but
not used
In file included from psycopg\connection_int.c:26:
./psycopg/config.h:81: warning: static declaration of
'round' follows non-static
 declaration
./psycopg/config.h:63: warning: 'pthread_mutex_init'
defined but not used
./psycopg/config.h:70: warning: 'gmtime_r' defined but
not used
In file included from
psycopg\microprotocols_proto.c:29:
./psycopg/config.h:81: warning: static declaration of
'round' follows non-static
 declaration
./psycopg/config.h:63: warning: 'pthread_mutex_init'
defined but not used
./psycopg/config.h:70: warning: 'gmtime_r' defined but
not used
In file included from psycopg\cursor_int.c:26:
./psycopg/config.h:81: warning: static declaration of
'round' follows non-static
 declaration
./psycopg/config.h:63: warning: 'pthread_mutex_init'
defined but not used
./psycopg/config.h:70: warning: 'gmtime_r' defined but
not used
In file included from psycopg\microprotocols.c:26:
./psycopg/config.h:81: warning: static declaration of
'round' follows non-static
 declaration
./psycopg/config.h:63: warning: 'pthread_mutex_init'
defined but not used
./psycopg/config.h:70: warning: 'gmtime_r' defined but
not used
In file included from psycopg\adapter_datetime.c:31:
./psycopg/config.h:81: warning: static declaration of
'round' follows non-static
 declaration
./psycopg/config.h:63: warning: 'pthread_mutex_init'
defined but not used
In file included from psycopg\connection_type.c:29:
./psycopg/config.h:81: warning: static declaration of
'round' follows non-static
 declaration
./psycopg/config.h:70: warning: 'gmtime_r' defined but
not used
In file included from psycopg\pqpath.c:32:
./psycopg/config.h:81: warning: static declaration of
'round' follows non-static
 declaration
./psycopg/config.h:63: warning: 'pthread_mutex_init'
defined but not used
./psycopg/config.h:70: warning: 'gmtime_r' defined but
not used
In file included from psycopg\adapter_pboolean.c:28:
./psycopg/config.h:81: warning: static declaration of
'round' follows non-static
 declaration
./psycopg/config.h:63: warning: 'pthread_mutex_init'
defined but not used
./psycopg/config.h:70: warning: 'gmtime_r' defined but
not used
In file included from psycopg\adapter_qstring.c:30:
./psycopg/config.h:81: warning: static declaration of
'round' follows non-static
 declaration
./psycopg/config.h:63: warning: 'pthread_mutex_init'
defined but not used
./psycopg/config.h:70: warning: 'gmtime_r' defined but
not used
In file included from psycopg\adapter_list.c:27:
./psycopg/config.h:81: warning: static declaration of
'round' follows non-static
 declaration
./psycopg/config.h:63: warning: 'pthread_mutex_init'
defined but not used
./psycopg/config.h:70: warning: 'gmtime_r' defined but
not used
In file included from psycopg\adapter_asis.c:28:
./psycopg/config.h:81: warning: static declaration of
'round' follows non-static
 declaration
./psycopg/config.h:63: warning: 'pthread_mutex_init'
defined but not used
./psycopg/config.h:70: warning: 'gmtime_r' defined but
not used
In file included from psycopg\typecast.c:26:
./psycopg/config.h:81: warning: static declaration of
'round' follows non-static
 declaration
./psycopg/config.h:63: warning: 'pthread_mutex_init'
defined but not used
./psycopg/config.h:70: warning: 'gmtime_r' defined but
not used
In file included from psycopg\psycopgmodule.c:25:
./psycopg/config.h:81: warning: static declaration of
'round' follows non-static
 declaration
./psycopg/config.h:63: warning: 'pthread_mutex_init'
defined but not used
./psycopg/config.h:70: warning: 'gmtime_r' defined but
not used
f:\MinGW\bin\..\lib\gcc\mingw32\3.4.2\..\..\..\..\mingw32\bin\ld.exe:
cannot fin
d -lpython23
collect2: ld returned 1 exit status
error: command 'gcc' failed with exit status 1

F:\psycopg-2.0b3>


--- Josef Meile <jmeile at hotmail.com> wrote:
> Hi Infor,
> 
> please post your replies to the list as well, so
> other can also help /
> take advantage of this thread.
> 
>  >Your best guest is correct (1st alternative).
>  >I had tried as suggested. However, it did not
> work.
>  >My best guess is that the psycopg binaries is
> compiled
>  >with PostgreSQL 7.x headers/lib for (cgywin). I am
>  >using PosgreSQL 8.0 for (native) windows. This is
>  >cause of it.
> Yes, actually in the website I gave you there is a
> table, where the only
> binaries for zope 2.6.4 you can download are the
> ones for python 2.1,
> which were compiled for postgreSQL 7.3. So, you have
> to update your zope
> to 2.7.x if you want to use binaries that work with
> postgreSQL 8. Now
> I remmebered that was the version of zope I used.
> 
> But before installing psycopg you also need the
> egenix mx extensions:
> 
>
http://www.egenix.com/files/python/eGenix-mx-Extensions.html
> 
> The link is now is broken I don't know if they are
> going to fix it. To
> install this binaries, you can follow the procedure
> I indicated in my
> previous reply.
> 
>  >Is there psycopg (with ZpsycopgDA) compiled with
> Zope
>  >2.6.3(python2.1.3)/PostgreSQL8.0 headers/lib or do
> I
>  >need to make one myself. If so, how I can do it? I
> do
>  >not have MSVC++ compiler but have download
> Bloodshed
>  >C++.
> I think there isn't such psycopg for the windows
> Zope binaries. The
> problem is that what you need is Zope 2.6.4 compiled
> with a python that
> has the psycopg module preinstalled on it. In fact,
> what you need to do
> is:
> 
> 1) Build python 2.1.3 from source
> 2) Build the genix mx extenssions from source using
> the python you
>     built
> 3) Build postgresql from source??? -> I'm not sure
> if psycopg needs
>     it, you have to check the readme and/or install
> files.
> 3) Build psycopg from source using the python of
> step 1
> 4) Build Zope 2.6.4 from source using the python you
> built.
> 
> Unfortunatelly, I haven't done this under windows,
> so, I can't help
> you there. Anyway, the binaries worked for me once,
> but I haven't them
> anymore and it was on zope 2.7, which uses python
> 2.3
> 
> Regards,
> Josef Meile
> 
> 


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new Resources site
http://smallbusiness.yahoo.com/resources/