pywin32 ImportError for win32files on Windows7

[wb8tyw]

I am trying to port the d-rats applications from python2 to python3, etc.

My test system is frozen at Windows 7 since Windows 10 is not supported by the hardware vendor.

I thought that msys2 mingw-64 would make the easiest deployment for end users for the python packages that are available, but have hit an issue with the mingw-w64-x86_64-python-pywin32 package.

$ python d_rats/dplatform.py
dPlatform  : Config dir: C:/Users/malmberg/AppData/Roaming/D-RATS-EV
dPlatform  : Default dir: C:/Users/malmberg/Desktop
dPlatform  : Log file (foo): C:/Users/malmberg/AppData/Roaming/D-RATS-EV/logs/foo.txt
Traceback (most recent call last):
  File "\\aviary\home\work\d-rats\D-Rats\d_rats\dplatform.py", line 787, in <module>
    do_test()
  File "\\aviary\home\work\d-rats\D-Rats\d_rats\dplatform.py", line 777, in do_test
    printlog("dPlatform", " : Serial ports: %s" % __pform.list_serial_ports())
  File "\\aviary\home\work\d-rats\D-Rats\d_rats\dplatform.py", line 617, in list_serial_ports
    import win32file # type: ignore
ImportError: DLL load failed while importing win32file: The specified module could not be found.

Any help would be appreciated.

OS is windows 7 64 bit.
msys2 was installed and packages were installed today.

[jeremyd2019]

It actually only just got built/uploaded

[Biswa96]

In Process Monitor, python can't find pywintypes39.dll. It lives under pywin32_system32 folder. Found similar issue mhammond/pywin32#1431

[lazka]

The problem is msys2-contrib/cpython-mingw#48 and https://github.com/mhammond/pywin32/blob/70ddf693927fa1635f15e9ef41eb1aea37fdf32a/win32/Lib/pywin32_bootstrap.py#L22

We can patch this for now

[lazka]

See #9752

[raedrizqie]

Chris, what does options=(staticlibs) in PKGBUILD do? Linking with static (gcc, stdc++ & winpthread)?

[Biswa96]

From PKGBUILD(5) man page:

staticlibs: Leave static library (.a) files in packages. Specify !staticlibs to remove them (if they have a shared counterpart).

[raedrizqie]

ah ok..

I built my pywin32 locally with -static-libgcc -static-libstdc++ -static -lwinpthread

I didn't put pywintypesXX.dll and pythoncomXX.dll in System32 folder. I never had import error like the one reported here.

[ZachBacon]

ah ok..

I built my pywin32 locally with -static-libgcc -static-libstdc++ -static -lwinpthread

I didn't put pywintypesXX.dll and pythoncomXX.dll in System32 folder. I never had import error like the one reported here.

I'm glad you didn't put anything in the system32 folder, you should never put anything in the system32 folder in my opinion.

[raedrizqie]

i think, the only way to fix pywin32 missing dll is to put pythoncom and pywintypes dll in %SYSTEM32% folder (like upstream does)

[ZachBacon]

Absolutely not. Never put anything in system32. Just adjust your system path to point to those dll's if you must, but do not put dll's into system32 folder.

…

On Thu., Mar. 10, 2022, 2:59 a.m. Raed Rizqie, ***@***.***> wrote: i think, the only way to fix pywin32 missing dll is to put pythoncom and pywintypes dll in %SYSTEM32% folder (like upstream does) — Reply to this email directly, view it on GitHub <#9751 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACEIXRFCS7766T5SUHYXUUDU7GTWTANCNFSM5FWZTCTA> . You are receiving this because you commented.Message ID: ***@***.***>

[ZachBacon]

In practice, it's still a bad idea. Even if you have to put them in a separate folder, add that to the path, it's still better than to put it in system32.

…

On Thu., Mar. 10, 2022, 4:21 a.m. مهدي شينون (Mehdi Chinoune), < ***@***.***> wrote: Those libraries are not built with mingw, They are not part of any package. If they could be built on mingw then we could just solve the problem by installing them in ${MINGW_PREFIX}/bin — Reply to this email directly, view it on GitHub <#9751 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACEIXRCXIN4IYXPAED5JAEDU7G5LJANCNFSM5FWZTCTA> . You are receiving this because you commented.Message ID: ***@***.***>

[ZachBacon]

You didn't, but I'm still reiterating for those contemplating it.

…

On Thu., Mar. 10, 2022, 5:53 a.m. مهدي شينون (Mehdi Chinoune), < ***@***.***> wrote: In practice, it's still a bad idea. Even if you have to put them in a separate folder, add that to the path, it's still better than to put it in system32. Did I say something about putting them in system32?! — Reply to this email directly, view it on GitHub <#9751 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACEIXRC2VLN246MN5FSNWBLU7HIBXANCNFSM5FWZTCTA> . You are receiving this because you commented.Message ID: ***@***.***>

[lazka]

We currently patch this here: https://github.com/msys2/MINGW-packages/blob/master/mingw-w64-python-pywin32/010-workaround-broken-add-dll-dir.patch

Because our Python doesn't support add_dll_directory() yet, see msys2-contrib/cpython-mingw#48

[MehdiChinoune]

Sorry, I found them under ${MINGW_PREFIX}/lib/python3.9/site-packages/pywin32_system32.
I think somehow I executed the wrong command to search for them.

$ pacman -Fx pythoncom39\.dll
mingw64/mingw-w64-x86_64-python-pywin32 302-5
    mingw64/lib/python3.9/site-packages/pywin32_system32/pythoncom39.dll
ucrt64/mingw-w64-ucrt-x86_64-python-pywin32 302-5 [installed]
    ucrt64/lib/python3.9/site-packages/pywin32_system32/pythoncom39.dll
clang64/mingw-w64-clang-x86_64-python-pywin32 302-5 [installed]
    clang64/lib/python3.9/site-packages/pywin32_system32/pythoncom39.dll
$ pacman -Fx pywintypes39\.dll
mingw64/mingw-w64-x86_64-python-pywin32 302-5
    mingw64/lib/python3.9/site-packages/pywin32_system32/pywintypes39.dll
ucrt64/mingw-w64-ucrt-x86_64-python-pywin32 302-5 [installed]
    ucrt64/lib/python3.9/site-packages/pywin32_system32/pywintypes39.dll
clang64/mingw-w64-clang-x86_64-python-pywin32 302-5 [installed]
    clang64/lib/python3.9/site-packages/pywin32_system32/pywintypes39.dll