search

chtd / psycopg2cffi

Port to cffi with some speed improvements
Other
177 stars 43 forks source link

Build error on Windows10 and need wheel #96

Open scphantm opened 6 years ago

scphantm commented 6 years ago

This is being used as a dependency of another library i am using. can i PLEASE get a py36-win32 wheel for this as i have to figure out how to install this thing on 1800 laptops and installing VC++ on 1800 machines just simply isnt going to happen.

I could care less if its on pypi or not, email it to me, ftp it to me, carrier pigeon, i don't care. I just simply can't be doing compile installs on my winblows machines. I've wasted 2 days and broke about half a dozen corporate policies trying to get this thing to compile to redistribute as it is.

Processing c:\users\lid4ec9\.gradle\caches\modules-2\files-2.1\pypi\psycopg2cffi\2.7.7\ff0beb00e7b30d6935a39dd35044b090cc125d4c\psycopg2cffi-2.7.7.tar.gz
    Complete output from command python setup.py egg_info:
    _cffi__xd0f55f83xcd0f2155.c
       Creating library C:\Users\lid4ec9\AppData\Local\Temp\pip-x57qsnc4-build\psycopg2cffi\_impl\__pycache__\Release\psycopg2cffi\_impl\__pycache__\_cffi__xd0f55f83xcd0f2155.cp36-win32.lib and object C:\Users\lid4ec9\AppData\Local\Temp\pip-x57qsnc4-build\psycopg2cffi\_impl\__pycache__\Release\psycopg2cffi\_impl\__pycache__\_cffi__xd0f55f83xcd0f2155.cp36-win32.exp
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQescapeString
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _lo_truncate
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQfreemem
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _lo_write
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _lo_export
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQsetnonblocking
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQunescapeBytea
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQgetvalue
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQconnectPoll
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQresultStatus
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _lo_import
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQoidValue
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQcmdStatus
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQsocket
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQputCopyData
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQstatus
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQisBusy
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQconsumeInput
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQresultErrorField
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQfsize
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQserverVersion
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQnotifies
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQfname
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQsendQuery
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQgetCopyData
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQsetNoticeProcessor
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQerrorMessage
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQflush
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQgetisnull
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQftype
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _lo_read
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQnfields
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQescapeLiteral
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQgetCancel
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _lo_tell
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQfinish
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQrequestCancel
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQresultErrorMessage
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQexec
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _lo_create
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQescapeByteaConn
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _lo_lseek
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQescapeStringConn
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQprotocolVersion
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQcancel
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQtransactionStatus
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQgetlength
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQfreeCancel
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _lo_unlink
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQbackendPID
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQclear
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQfmod
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _lo_open
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQcmdTuples
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQconnectdb
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQntuples
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQescapeBytea
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQputCopyEnd
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQgetResult
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQconnectStart
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _lo_close
    _cffi__xd0f55f83xcd0f2155.obj : error LNK2001: unresolved external symbol _PQparameterStatus
    C:\Users\lid4ec9\AppData\Local\Temp\pip-x57qsnc4-build\psycopg2cffi\_impl\__pycache__\_cffi__xd0f55f83xcd0f2155.cp36-win32.pyd : fatal error LNK1120: 62 unresolved externals
    Traceback (most recent call last):
      File "C:\Users\lid4ec9\AppData\Local\Temp\pip-x57qsnc4-build\psycopg2cffi\_impl\libpq.py", line 2, in <module>
        from psycopg2cffi._impl._libpq import ffi, lib as libpq
    ModuleNotFoundError: No module named 'psycopg2cffi._impl._libpq'

    During handling of the above exception, another exception occurred:

    Traceback (most recent call last):
      File "C:\highmarkapps\Python\Python36-32\lib\distutils\_msvccompiler.py", line 478, in link
        self.spawn([self.linker] + ld_args)
      File "C:\highmarkapps\Python\Python36-32\lib\distutils\_msvccompiler.py", line 501, in spawn
        return super().spawn(cmd)
      File "C:\highmarkapps\Python\Python36-32\lib\distutils\ccompiler.py", line 909, in spawn
        spawn(cmd, dry_run=self.dry_run)
      File "C:\highmarkapps\Python\Python36-32\lib\distutils\spawn.py", line 38, in spawn
        _spawn_nt(cmd, search_path, dry_run=dry_run)
      File "C:\highmarkapps\Python\Python36-32\lib\distutils\spawn.py", line 81, in _spawn_nt
        "command %r failed with exit status %d" % (cmd, rc))
    distutils.errors.DistutilsExecError: command 'C:\\Program Files (x86)\\Microsoft Visual Studio 14.0\\VC\\BIN\\link.exe' failed with exit status 1120

    During handling of the above exception, another exception occurred:

    Traceback (most recent call last):
      File "C:\HighmarkApps\Willie\code\frameworks\syzygy\syzygy_gradle\build\venv\lib\site-packages\cffi\ffiplatform.py", line 51, in _build
        dist.run_command('build_ext')
      File "C:\highmarkapps\Python\Python36-32\lib\distutils\dist.py", line 974, in run_command
        cmd_obj.run()
      File "C:\HighmarkApps\Willie\code\frameworks\syzygy\syzygy_gradle\build\venv\lib\site-packages\setuptools\command\build_ext.py", line 75, in run
        _build_ext.run(self)
      File "C:\HighmarkApps\Willie\code\frameworks\syzygy\syzygy_gradle\build\venv\lib\site-packages\Cython\Distutils\old_build_ext.py", line 186, in run
        _build_ext.build_ext.run(self)
      File "C:\highmarkapps\Python\Python36-32\lib\distutils\command\build_ext.py", line 339, in run
        self.build_extensions()
      File "C:\HighmarkApps\Willie\code\frameworks\syzygy\syzygy_gradle\build\venv\lib\site-packages\Cython\Distutils\old_build_ext.py", line 194, in build_extensions
        self.build_extension(ext)
      File "C:\HighmarkApps\Willie\code\frameworks\syzygy\syzygy_gradle\build\venv\lib\site-packages\setuptools\command\build_ext.py", line 196, in build_extension
        _build_ext.build_extension(self, ext)
      File "C:\highmarkapps\Python\Python36-32\lib\distutils\command\build_ext.py", line 558, in build_extension
        target_lang=language)
      File "C:\highmarkapps\Python\Python36-32\lib\distutils\ccompiler.py", line 717, in link_shared_object
        extra_preargs, extra_postargs, build_temp, target_lang)
      File "C:\highmarkapps\Python\Python36-32\lib\distutils\_msvccompiler.py", line 481, in link
        raise LinkError(msg)
    distutils.errors.LinkError: command 'C:\\Program Files (x86)\\Microsoft Visual Studio 14.0\\VC\\BIN\\link.exe' failed with exit status 1120

    During handling of the above exception, another exception occurred:

    Traceback (most recent call last):
      File "<string>", line 1, in <module>
      File "C:\Users\lid4ec9\AppData\Local\Temp\pip-x57qsnc4-build\setup.py", line 126, in <module>
        setup(**setup_kwargs)
      File "C:\highmarkapps\Python\Python36-32\lib\distutils\core.py", line 108, in setup
        _setup_distribution = dist = klass(attrs)
      File "C:\HighmarkApps\Willie\code\frameworks\syzygy\syzygy_gradle\build\venv\lib\site-packages\setuptools\dist.py", line 339, in __init__
        _Distribution.__init__(self, attrs)
      File "C:\highmarkapps\Python\Python36-32\lib\distutils\dist.py", line 281, in __init__
        self.finalize_options()
      File "C:\HighmarkApps\Willie\code\frameworks\syzygy\syzygy_gradle\build\venv\lib\site-packages\setuptools\dist.py", line 434, in finalize_options
        ep.load()(self, ep.name, value)
      File "C:\HighmarkApps\Willie\code\frameworks\syzygy\syzygy_gradle\build\venv\lib\site-packages\cffi\setuptools_ext.py", line 193, in cffi_modules
        add_cffi_module(dist, cffi_module)
      File "C:\HighmarkApps\Willie\code\frameworks\syzygy\syzygy_gradle\build\venv\lib\site-packages\cffi\setuptools_ext.py", line 49, in add_cffi_module
        execfile(build_file_name, mod_vars)
      File "C:\HighmarkApps\Willie\code\frameworks\syzygy\syzygy_gradle\build\venv\lib\site-packages\cffi\setuptools_ext.py", line 25, in execfile
        exec(code, glob, glob)
      File "psycopg2cffi/_impl/_build_libpq.py", line 171, in <module>
        _config = PostgresConfig()
      File "psycopg2cffi/_impl/_build_libpq.py", line 22, in __init__
        from psycopg2cffi import _config
      File "C:\Users\lid4ec9\AppData\Local\Temp\pip-x57qsnc4-build\psycopg2cffi\__init__.py", line 4, in <module>
        from psycopg2cffi import extensions
      File "C:\Users\lid4ec9\AppData\Local\Temp\pip-x57qsnc4-build\psycopg2cffi\extensions.py", line 39, in <module>
        from psycopg2cffi._impl import connection as _connection
      File "C:\Users\lid4ec9\AppData\Local\Temp\pip-x57qsnc4-build\psycopg2cffi\_impl\connection.py", line 10, in <module>
        from psycopg2cffi._impl import exceptions
      File "C:\Users\lid4ec9\AppData\Local\Temp\pip-x57qsnc4-build\psycopg2cffi\_impl\exceptions.py", line 12, in <module>
        from psycopg2cffi._impl.libpq import libpq, ffi
      File "C:\Users\lid4ec9\AppData\Local\Temp\pip-x57qsnc4-build\psycopg2cffi\_impl\libpq.py", line 5, in <module>
        libpq = ffi.verify(C_SOURCE, **C_SOURCE_KWARGS)
      File "C:\HighmarkApps\Willie\code\frameworks\syzygy\syzygy_gradle\build\venv\lib\site-packages\cffi\api.py", line 444, in verify
        lib = self.verifier.load_library()
      File "C:\HighmarkApps\Willie\code\frameworks\syzygy\syzygy_gradle\build\venv\lib\site-packages\cffi\verifier.py", line 104, in load_library
        self._compile_module()
      File "C:\HighmarkApps\Willie\code\frameworks\syzygy\syzygy_gradle\build\venv\lib\site-packages\cffi\verifier.py", line 201, in _compile_module
        outputfilename = ffiplatform.compile(tmpdir, self.get_extension())
      File "C:\HighmarkApps\Willie\code\frameworks\syzygy\syzygy_gradle\build\venv\lib\site-packages\cffi\ffiplatform.py", line 22, in compile
        outputfilename = _build(tmpdir, ext, compiler_verbose, debug)
      File "C:\HighmarkApps\Willie\code\frameworks\syzygy\syzygy_gradle\build\venv\lib\site-packages\cffi\ffiplatform.py", line 58, in _build
        raise VerificationError('%s: %s' % (e.__class__.__name__, e))
    cffi.error.VerificationError: LinkError: command 'C:\\Program Files (x86)\\Microsoft Visual Studio 14.0\\VC\\BIN\\link.exe' failed with exit status 1120

    ----------------------------------------
willredington commented 5 years ago

same issue

jeremylcarter commented 3 years ago

Any resolution on this? Looks like it can't find libpq.

ExtReMLapin commented 2 years ago

has this error because of missing build tools

sudo apt-get install build-essential plus pip install psycopg2-binary