Re: Getting psycopg2 to work in cygwin on Windows Vista

Thanks for the reply, Daniele.  Yes, I did.  Looking at the output that I
sent before I did notice that it had a dlopen() call, but the dll does
exist at that path.  I have tried playing around with the permissions in
both Vista and cygwin, but with no luck.

dlopen("/usr/lib/python2.5/site-packages/psycopg2/_psycopg.dll", 2);
Traceback (most recent call last):
  File "<string>", line 1, in <module>
  File "/usr/lib/python2.5/site-packages/psycopg2/__init__.py", line 60, in
<module>
    from _psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID
ImportError: No such file or directory

Here are the contents of that directory.

509 psycopg2 $ pwd
/usr/lib/python2.5/site-packages/psycopg2
510 TheBitGuru@visionary psycopg2 $ ll
total 416
-rw-r--r-- 1 TheBitGuru None   2774 Jul 13 00:38 __init__.py
-rw-r--r-- 1 TheBitGuru None   2379 Jul 13 12:59 __init__.pyc
-rwxrwxrwx 1 TheBitGuru None 315420 Jul 13 13:17 _psycopg.dll
-rw-r--r-- 1 TheBitGuru None  10138 Jul 13 00:38 errorcodes.py
-rw-r--r-- 1 TheBitGuru None  10511 Jul 13 12:59 errorcodes.pyc
-rw-r--r-- 1 TheBitGuru None   2487 Jul 13 00:38 extensions.py
-rw-r--r-- 1 TheBitGuru None   2410 Jul 13 12:59 extensions.pyc
-rw-r--r-- 1 TheBitGuru None   7396 Jul 13 00:38 extras.py
-rw-r--r-- 1 TheBitGuru None  11038 Jul 13 12:59 extras.pyc
-rw-r--r-- 1 TheBitGuru None   6031 Jul 13 13:42 output.txt
-rw-r--r-- 1 TheBitGuru None   7847 Jul 13 00:38 pool.py
-rw-r--r-- 1 TheBitGuru None   8808 Jul 13 12:59 pool.pyc
-rw-r--r-- 1 TheBitGuru None   2804 Jul 13 00:38 psycopg1.py
-rw-r--r-- 1 TheBitGuru None   3370 Jul 13 12:59 psycopg1.pyc
-rw-r--r-- 1 TheBitGuru None   2973 Jul 13 00:38 tz.py
-rw-r--r-- 1 TheBitGuru None   3502 Jul 13 12:59 tz.pyc
511 psycopg2 $ 


Thanks,
Farhan

On Mon, 14 Jul 2008 01:50:35 +0100, Daniele Varrazzo
<[email protected]> wrote:
> Farhan Ahmad ha scritto:
> 
>> I am trying to get psycopg2 to work on Windows Vista through cygwin.
>> Everything compiles fine, but when I import it python says that it can't
>> findany module by that name.  I have attached the output from a "python
>> -v" session.  Does anyone have any ideas why the system cannot find the
>> _psycopg?  Everything compiled and installed without any issues.
> 
> Did you issue "python setup.py install" in the psycopg directory?
> 
> If everything compiled fine, you should have a "_psycopg.dll" in a
> subdirectory under "build", which is not included in the pythonpath. The
> above
> command should put all the pieces in the proper place.
> 
> -- Daniele