Hi, I having trouble creating a Windows executable (I'm doing this on Windows XP) that requires SQLAlchemy. The executable is created, but when I invoke the program, I get the following:
PS C:\ddt\tools> python .\retrieve_sample_data.py --host 10.202.13.61 1 test_db15 PS C:\ddt\tools> copy C:\pyinstaller\retrieve_sample_data\dist \retrieve_sample_data.exe PS C:\ddt\tools> .\retrieve_sample_data.exe --help Traceback (most recent call last): File "<string>", line 7, in <module> File "C:\tmp\pyinstaller-1.5\iu.py", line 455, in importHook ImportError: No module named sqlalchemy PS C:\ddt\tools> .\retrieve_sample_data.exe --help Traceback (most recent call last): File "<string>", line 7, in <module> File "C:\tmp\pyinstaller-1.5\iu.py", line 455, in importHook ImportError: No module named sqlalchemy There is a warnings file produced (below) that lists 203 warnings, may of which are complaints that various sqlalchemy modules cannot be found. Note that the python program runs just fine when executed by the Python interpreter (2.7.1). Any suggestions? Thanks, Roger Alexander. ------- W: no module named org (delayed import by xml.sax) W: no module named sqlalchemy.sql.type_coerce (top-level import by sqlalchemy) W: no module named sqlalchemy.databases.mssql (top-level import by sqlalchemy) W: no module named pyodbc (delayed import by sqlalchemy.dialects.access.base) W: no module named sqlalchemy.engine.Engine (delayed import by sqlalchemy.events) W: no module named pwd (delayed, conditional import by distutils.util) W: no module named sqlalchemy.databases.sqlite (top-level import by sqlalchemy) W: no module named Carbon (delayed import by plistlib) W: no module named sqlalchemy.sql.join (top-level import by sqlalchemy) W: no module named sqlalchemy.databases.oracle (top-level import by sqlalchemy) W: no module named pwd (top-level import by shutil) W: no module named java (conditional import by xml.sax._exceptions) W: no module named pwd (top-level import by tarfile) W: no module named sqlalchemy.sql.literal (top-level import by sqlalchemy) W: no module named readline (delayed import by pdb) W: no module named sqlalchemy.engine.create_engine (top-level import by sqlalchemy) W: no module named sqlalchemy.sql.asc (top-level import by sqlalchemy) W: no module named sqlalchemy.databases.drizzle (top-level import by sqlalchemy) W: no module named grp (top-level import by tarfile) W: no module named termios (top-level import by getpass) W: no module named sqlalchemy.databases.maxdb (top-level import by sqlalchemy) W: no module named java (delayed import by platform) W: no module named sqlalchemy.sql.between (top-level import by sqlalchemy) W: no module named rourl2path (conditional import by urllib) W: no module named Sybase (delayed import by sqlalchemy.dialects.sybase.pysybase) W: no module named sqlalchemy.util.threading (top-level import by sqlalchemy.util.queue) W: no module named com (delayed import by sqlalchemy.dialects.oracle.zxjdbc) W: no module named sqlalchemy.sql.tuple_ (top-level import by sqlalchemy) W: no module named cx_Oracle (delayed import by sqlalchemy.dialects.oracle.cx_oracle) W: no module named _dummy_threading (top-level import by dummy_threading) W: no module named sqlalchemy.create_engine (delayed, conditional import by sqlalchemy.schema) W: no module named sqlalchemy.sql.union_all (top-level import by sqlalchemy) W: no module named fcntl (conditional import by subprocess) W: no module named sqlalchemy.databases.access (top-level import by sqlalchemy) W: no module named sqlalchemy.databases.sybase (top-level import by sqlalchemy) W: no module named AES (delayed, conditional import by archive) W: no module named sqlalchemy.databases.mysql (top-level import by sqlalchemy) W: no module named org (top-level import by copy) W: no module named fcntl (top-level import by tempfile) W: no module named sqlalchemy.sql.union (top-level import by sqlalchemy) W: no module named readline (delayed, conditional import by cmd) W: no module named sqlalchemy.MetaData (top-level import by sqlalchemy.dialects.mssql.information_schema) W: no module named sqlalchemy.sql.bindparam (top-level import by sqlalchemy.dialects.sybase.base) W: no module named sqlalchemy.util.threading (top-level import by sqlalchemy.pool) W: no module named sqlalchemy.sql.desc (top-level import by sqlalchemy) W: no module named sqlalchemy.util.symbol (top-level import by sqlalchemy.sql.operators) W: no module named mysql (delayed, conditional import by sqlalchemy.dialects.mysql.mysqlconnector) W: no module named sqlalchemy.sql.modifier (top-level import by sqlalchemy) W: no module named sqlalchemy.Column (top-level import by sqlalchemy.dialects.mssql.information_schema) W: no module named sqlalchemy.connectors.Connector (top-level import by sqlalchemy.connectors.zxJDBC) W: no module named _xmlplus (top-level import by xml) W: no module named sqlalchemy.util.pickle (top-level import by sqlalchemy.types) W: no module named sqlalchemy.util.asbool (top-level import by sqlalchemy.connectors.pyodbc) W: no module named sqlalchemy.sql.and_ (top-level import by sqlalchemy) W: no module named sqlalchemy.sql.or_ (top-level import by sqlalchemy) W: no module named java (delayed import by sqlalchemy.dialects.oracle.zxjdbc) W: no module named mx (delayed import by sqlalchemy.connectors.mxodbc) W: no module named ctypes.cdll (delayed import by ctypes.util) W: no module named sqlalchemy.sql.insert (top-level import by sqlalchemy) W: no module named sqlalchemy.util.chop_traceback (top-level import by sqlalchemy.pool) W: no module named sqlalchemy.databases.postgresql (top-level import by sqlalchemy) W: no module named sqlalchemy.sql.text (top-level import by sqlalchemy) W: no module named sqlalchemy.sql.text (top-level import by sqlalchemy.dialects.sybase.base) W: no module named MacOS (delayed import by platform) W: no module named sqlalchemy.sql.except_ (top-level import by sqlalchemy) W: no module named pwd (delayed import by getpass) W: no module named sqlalchemy.sql.not_ (top-level import by sqlalchemy) W: no module named EasyDialogs (conditional import by getpass) W: no module named gestalt (delayed import by platform) W: no module named sqlalchemy.sql.subquery (top-level import by sqlalchemy) W: no module named sqlalchemy.sql.select (top-level import by sqlalchemy.dialects.mssql.base) W: no module named sqlalchemy.sql.distinct (top-level import by sqlalchemy) W: no module named sqlalchemy.sql.func (top-level import by sqlalchemy) W: no module named xmlparse (top-level import by pyexpat) W: no module named sqlalchemy.sql.extract (top-level import by sqlalchemy) W: no module named sqlalchemy.sql.exists (top-level import by sqlalchemy) W: no module named posix (conditional import by os) W: no module named sqlalchemy.sql.text (top-level import by sqlalchemy.dialects.informix.base) W: no module named sqlalchemy.sql.outerjoin (top-level import by sqlalchemy) W: no module named sqlalchemy.sql.bindparam (top-level import by sqlalchemy) W: no module named sqlalchemy.connectors.Connector (top-level import by sqlalchemy.connectors.mysqldb) W: no module named vms_lib (delayed, conditional import by platform) W: no module named sqlalchemy.util.memoized_property (top-level import by sqlalchemy.pool) W: no module named sqlalchemy.databases.informix (top-level import by sqlalchemy) W: no module named grp (top-level import by shutil) W: no module named pwd (delayed, conditional import by posixpath) W: no module named org (top-level import by pickle) W: no module named sqlalchemy.connectors.Connector (top-level import by sqlalchemy.connectors.mxodbc) W: no module named sqlalchemy.sql.except_all (top-level import by sqlalchemy) W: no module named sqlalchemy.connectors.Connector (top-level import by sqlalchemy.connectors.pyodbc) W: no module named sqlalchemy.sql.alias (top-level import by sqlalchemy) W: no module named sqlalchemy.sql.literal_column (top-level import by sqlalchemy) W: no module named sqlalchemy.sql.cast (top-level import by sqlalchemy) W: no module named _scproxy (conditional import by urllib) W: no module named mysql (delayed import by sqlalchemy.dialects.mysql.mysqlconnector) W: no module named posix (delayed, conditional import by iu) W: no module named win32com.gen_py (conditional import by win32com) W: no module named sqlalchemy.sql.over (top-level import by sqlalchemy) W: no module named sqlalchemy.sql.intersect (top-level import by sqlalchemy) W: no module named pysqlite2 (delayed import by sqlalchemy.dialects.sqlite.pysqlite) W: no module named sqlalchemy.sql.select (top-level import by sqlalchemy) W: no module named win32com.client._get_good_object_ (top-level import by win32com.client.util) W: no module named xmltok (top-level import by pyexpat) W: no module named sqlalchemy.sql.delete (top-level import by sqlalchemy) W: no module named sqlalchemy.databases.firebird (top-level import by sqlalchemy) W: no module named postgresql (delayed import by sqlalchemy.dialects.postgresql.pypostgresql) W: no module named _emx_link (conditional import by os) W: no module named mx (top-level import by psycopg2) W: no module named sqlalchemy.sql.case (top-level import by sqlalchemy) W: no module named sqlalchemy.sql.update (top-level import by sqlalchemy) W: no module named com (delayed import by sqlalchemy.connectors.zxJDBC) W: no module named sqlalchemy.engine.engine_from_config (top-level import by sqlalchemy) W: no module named mx (delayed, conditional import by sqlalchemy.connectors.mxodbc) W: no module named SOCKS (top-level import by ftplib) W: no module named sqlalchemy.sql.null (top-level import by sqlalchemy) W: no module named sqlalchemy.Table (top-level import by sqlalchemy.dialects.mssql.information_schema) W: no module named sqlalchemy.sql.collate (top-level import by sqlalchemy) W: no module named sqlalchemy.sql.intersect_all (top-level import by sqlalchemy) W: no module named sqlalchemy.sql.outparam (top-level import by sqlalchemy) W: delayed exec statement detected at line 0 - bdb (c:\Python27\lib \bdb.pyc) W: delayed eval hack detected at line 0 - bdb (c:\Python27\lib \bdb.pyc) W: delayed eval hack detected at line 0 - bdb (c:\Python27\lib \bdb.pyc) W: delayed __import__ hack detected at line 0 - optparse (c: \Python27\lib\optparse.pyc) W: delayed __import__ hack detected at line 0 - sqlalchemy.dialects.postgresql.pg8000 (c:\Python27\lib\site-packages \sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\postgresql \pg8000.pyc) W: delayed conditional __import__ hack detected at line 0 - pkg_resources (c:\Python27\lib\site-packages\pkg_resources.pyc) W: delayed conditional exec statement detected at line 0 - pkg_resources (c:\Python27\lib\site-packages\pkg_resources.pyc) W: delayed conditional __import__ hack detected at line 0 - pkg_resources (c:\Python27\lib\site-packages\pkg_resources.pyc) W: delayed __import__ hack detected at line 0 - pkg_resources (c: \Python27\lib\site-packages\pkg_resources.pyc) W: delayed conditional __import__ hack detected at line 0 - doctest (c: \Python27\lib\doctest.pyc) W: delayed exec statement detected at line 0 - doctest (c: \Python27\lib\doctest.pyc) W: delayed conditional __import__ hack detected at line 0 - doctest (c: \Python27\lib\doctest.pyc) W: __all__ is built strangely at line 0 - sqlalchemy.dialects.oracle (c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg \sqlalchemy\dialects\oracle\__init__.pyc) W: delayed __import__ hack detected at line 0 - sqlalchemy.dialects.informix.informixdb (c:\Python27\lib\site-packages \sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\informix \informixdb.pyc) W: __all__ is built strangely at line 0 - tokenize (c:\Python27\lib \tokenize.pyc) W: __all__ is built strangely at line 0 - tokenize (c:\Python27\lib \tokenize.pyc) W: delayed __import__ hack detected at line 0 - sqlalchemy.dialects.mysql.pymysql (c:\Python27\lib\site-packages \sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\mysql \pymysql.pyc) W: delayed __import__ hack detected at line 0 - pickle (c: \Python27\lib\pickle.pyc) W: delayed __import__ hack detected at line 0 - pickle (c: \Python27\lib\pickle.pyc) W: top-level exec statement detected at line 0 - sqlalchemy.sql.util (c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg \sqlalchemy\sql\util.pyc) W: top-level exec statement detected at line 0 - sqlalchemy.sql.util (c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg \sqlalchemy\sql\util.pyc) W: __all__ is built strangely at line 0 - sqlalchemy.dialects.sybase (c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg \sqlalchemy\dialects\sybase\__init__.pyc) W: delayed __import__ hack detected at line 0 - encodings (c: \Python27\lib\encodings\__init__.pyc) W: __all__ is built strangely at line 0 - sqlalchemy.dialects.postgresql (c:\Python27\lib\site-packages \sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\postgresql \__init__.pyc) W: __all__ is built strangely at line 0 - sqlalchemy.dialects.mssql (c: \Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy \dialects\mssql\__init__.pyc) W: __all__ is built strangely at line 0 - dummy_threading (c: \Python27\lib\dummy_threading.pyc) W: __all__ is built strangely at line 0 - dis (c:\Python27\lib \dis.pyc) W: __all__ is built strangely at line 0 - sqlalchemy.dialects.firebird (c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg \sqlalchemy\dialects\firebird\__init__.pyc) W: __all__ is built strangely at line 0 - sqlalchemy.databases (c: \Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy \databases\__init__.pyc) W: delayed __import__ hack detected at line 0 - win32com.server.policy (c:\Python27\lib\site-packages\win32com\server \policy.pyc) W: __all__ is built strangely at line 0 - sqlalchemy.dialects.drizzle (c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg \sqlalchemy\dialects\drizzle\__init__.pyc) W: __all__ is built strangely at line 0 - hashlib (c:\Python27\lib \hashlib.pyc) W: __all__ is built strangely at line 0 - __main__ (c:\Python27\lib \site-packages\psycopg2\__init__.py) W: __all__ is built strangely at line 0 - sqlalchemy.engine (c: \Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy \engine\__init__.pyc) W: delayed exec statement detected at line 0 - win32com.client.dynamic (c:\Python27\lib\site-packages\win32com\client \dynamic.pyc) W: delayed conditional eval hack detected at line 0 - warnings (c: \Python27\lib\warnings.pyc) W: delayed conditional __import__ hack detected at line 0 - warnings (c:\Python27\lib\warnings.pyc) W: delayed __import__ hack detected at line 0 - sqlalchemy.dialects.postgresql.psycopg2 (c:\Python27\lib\site-packages \sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\postgresql \psycopg2.pyc) W: delayed __import__ hack detected at line 0 - sqlalchemy.dialects.postgresql.psycopg2 (c:\Python27\lib\site-packages \sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\postgresql \psycopg2.pyc) W: delayed conditional __import__ hack detected at line 0 - sqlalchemy.dialects.postgresql.psycopg2 (c:\Python27\lib\site-packages \sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\postgresql \psycopg2.pyc) W: delayed __import__ hack detected at line 0 - email (c:\Python27\lib \email\__init__.pyc) W: delayed __import__ hack detected at line 0 - sqlalchemy.connectors.mysqldb (c:\Python27\lib\site-packages \sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\connectors\mysqldb.pyc) W: delayed conditional __import__ hack detected at line 0 - sqlalchemy.connectors.mysqldb (c:\Python27\lib\site-packages \sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\connectors\mysqldb.pyc) W: delayed __import__ hack detected at line 0 - ctypes (c: \Python27\lib\ctypes\__init__.pyc) W: delayed __import__ hack detected at line 0 - ctypes (c: \Python27\lib\ctypes\__init__.pyc) W: __all__ is built strangely at line 0 - sqlalchemy.dialects.mysql (c: \Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy \dialects\mysql\__init__.pyc) W: __all__ is built strangely at line 0 - psycopg2 (c:\Python27\lib \site-packages\psycopg2\__init__.pyc) W: __all__ is built strangely at line 0 - sqlalchemy.sql (c: \Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy \sql\__init__.pyc) W: delayed __import__ hack detected at line 0 - pkgutil (c: \Python27\lib\pkgutil.pyc) W: delayed conditional __import__ hack detected at line 0 - pkgutil (c: \Python27\lib\pkgutil.pyc) W: delayed conditional exec statement detected at line 0 - iu (C: \pyinstaller\iu.pyc) W: delayed conditional exec statement detected at line 0 - iu (C: \pyinstaller\iu.pyc) W: delayed exec statement detected at line 0 - pdb (c:\Python27\lib \pdb.pyc) W: delayed conditional eval hack detected at line 0 - pdb (c: \Python27\lib\pdb.pyc) W: delayed eval hack detected at line 0 - pdb (c:\Python27\lib \pdb.pyc) W: delayed conditional eval hack detected at line 0 - pdb (c: \Python27\lib\pdb.pyc) W: delayed eval hack detected at line 0 - pdb (c:\Python27\lib \pdb.pyc) W: delayed eval hack detected at line 0 - sqlalchemy.util.langhelpers (c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg \sqlalchemy\util\langhelpers.pyc) W: delayed exec statement detected at line 0 - sqlalchemy.util.langhelpers (c:\Python27\lib\site-packages \sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\util\langhelpers.pyc) W: delayed conditional __import__ hack detected at line 0 - sqlalchemy.util.langhelpers (c:\Python27\lib\site-packages \sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\util\langhelpers.pyc) W: delayed conditional __import__ hack detected at line 0 - sqlalchemy.util.langhelpers (c:\Python27\lib\site-packages \sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\util\langhelpers.pyc) W: __all__ is built strangely at line 0 - collections (c:\Python27\lib \collections.pyc) W: delayed exec statement detected at line 0 - collections (c: \Python27\lib\collections.pyc) W: delayed conditional __import__ hack detected at line 0 - unittest.main (c:\Python27\lib\unittest\main.pyc) W: delayed __import__ hack detected at line 0 - sqlalchemy.dialects.firebird.kinterbasdb (c:\Python27\lib\site-packages \sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\firebird \kinterbasdb.pyc) W: delayed __import__ hack detected at line 0 - sqlalchemy.engine.url (c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg \sqlalchemy\engine\url.pyc) W: __all__ is built strangely at line 0 - sqlalchemy.dialects (c: \Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy \dialects\__init__.pyc) W: delayed exec statement detected at line 0 - cgi (c:\Python27\lib \cgi.pyc) W: delayed __import__ hack detected at line 0 - sqlalchemy.dialects.mysql.oursql (c:\Python27\lib\site-packages \sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\mysql \oursql.pyc) W: delayed conditional __import__ hack detected at line 0 - unittest.loader (c:\Python27\lib\unittest\loader.pyc) W: delayed conditional __import__ hack detected at line 0 - unittest.loader (c:\Python27\lib\unittest\loader.pyc) W: delayed __import__ hack detected at line 0 - unittest.loader (c: \Python27\lib\unittest\loader.pyc) W: delayed conditional __import__ hack detected at line 0 - sqlalchemy.types (c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7- win32.egg\sqlalchemy\types.pyc) W: delayed conditional __import__ hack detected at line 0 - win32com.client.gencache (c:\Python27\lib\site-packages\win32com\client \gencache.pyc) W: delayed __import__ hack detected at line 0 - win32com.client.gencache (c:\Python27\lib\site-packages\win32com\client \gencache.pyc) W: __all__ is built strangely at line 0 - __future__ (c:\Python27\lib \__future__.pyc) W: delayed __import__ hack detected at line 0 - win32com.client.makepy (c:\Python27\lib\site-packages\win32com\client \makepy.pyc) W: delayed __import__ hack detected at line 0 - sqlalchemy.dialects.mssql.pymssql (c:\Python27\lib\site-packages \sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\dialects\mssql \pymssql.pyc) W: delayed __import__ hack detected at line 0 - sqlalchemy.connectors.pyodbc (c:\Python27\lib\site-packages \sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy\connectors\pyodbc.pyc) W: __all__ is built strangely at line 0 - sqlalchemy (c:\Python27\lib \site-packages\sqlalchemy-0.7b4-py2.7-win32.egg\sqlalchemy \__init__.pyc) W: delayed __import__ hack detected at line 0 - xml.sax (c: \Python27\lib\xml\sax\__init__.pyc) W: __all__ is built strangely at line 0 - psycopg2.extensions (c: \Python27\lib\site-packages\psycopg2\extensions.pyc) W: delayed eval hack detected at line 0 - gettext (c:\Python27\lib \gettext.pyc) W: __all__ is built strangely at line 0 - sqlalchemy.dialects.sqlite (c:\Python27\lib\site-packages\sqlalchemy-0.7b4-py2.7-win32.egg \sqlalchemy\dialects\sqlite\__init__.pyc) -- You received this message because you are subscribed to the Google Groups "PyInstaller" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/pyinstaller?hl=en.
