[Libreoffice-bugs] [Bug 140279] New: Embedded Python install missing 6 Windows DLL files (LO 7.1.0.3, Python 3.8.4)

Mon Feb 8 21:49:46 UTC 2021

https://bugs.documentfoundation.org/show_bug.cgi?id=140279

            Bug ID: 140279
           Summary: Embedded Python install missing 6 Windows DLL files
                    (LO 7.1.0.3, Python 3.8.4)
           Product: LibreOffice
           Version: 7.1.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Installation
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: gaxonegaxone at hotmail.com

Description:
After upgrading from LO 7.0 to 7.1.0.3, I am unable to install "pip" using
"get-pip.py" on a Windows 10 PC. Traceback from get-pip shows error
  FileNotFoundError: [WinError 2] The system cannot find the file specified 
However, as explained below, the error / traceback are a bit of a red herring.
I think the real issue is that 6 DLL files are missing from the embedded python
installation delivered with LO 7.1.0.3.

There is a workaround, but it would not be easy for non-technical users.

Steps to Reproduce:
1. Perform standard upgrade installation of LO 7.1.0.3 on Windows 10 PC
2. Open administrator powershell
2a. cd 'C:\Program Files\LibreOffice\program\'
2b. curl https://bootstrap.pypa.io/get-pip.py -o get-pip.py
2c. .\python.exe .\get-pip.p

Actual Results:
PS C:\Program Files\LibreOffice\program> .\python  .\get-pip.py

Traceback (most recent call last):
  File "C:\Program Files\LibreOffice\program\get-pip.py", line 24244, in
<module>
    main()
  File "C:\Program Files\LibreOffice\program\get-pip.py", line 199, in main
    bootstrap(tmpdir=tmpdir)
  File "C:\Program Files\LibreOffice\program\get-pip.py", line 177, in
bootstrap
    sys.exit(pip_entry_point(args))
  File
"C:\Users\xxx\AppData\Local\Temp\tmp7utwaimk\pip.zip\pip\_internal\cli\main.py",
line 58, in main
  File
"C:\Users\xxx\AppData\Local\Temp\tmp7utwaimk\pip.zip\pip\_internal\cli\main_parser.py",
line 67, in parse_command
  File "C:\Program
Files\LibreOffice\program\python-core-3.8.4\lib\optparse.py", line 1371, in
parse_args
    values = self.get_default_values()
  File
"C:\Users\xxx\AppData\Local\Temp\tmp7utwaimk\pip.zip\pip\_internal\cli\parser.py",
line 267, in get_default_values
  File
"C:\Users\xxx\AppData\Local\Temp\tmp7utwaimk\pip.zip\pip\_internal\configuration.py",
line 137, in load
  File
"C:\Users\xxx\AppData\Local\Temp\tmp7utwaimk\pip.zip\pip\_internal\configuration.py",
line 259, in _load_config_files
  File
"C:\Users\xxx\AppData\Local\Temp\tmp7utwaimk\pip.zip\pip\_internal\configuration.py",
line 362, in iter_config_files
  File
"C:\Users\xxx\AppData\Local\Temp\tmp7utwaimk\pip.zip\pip\_internal\configuration.py",
line 78, in get_configuration_files
  File
"C:\Users\xxx\AppData\Local\Temp\tmp7utwaimk\pip.zip\pip\_internal\utils\appdirs.py",
line 38, in site_config_dirs
  File
"C:\Users\xxx\AppData\Local\Temp\tmp7utwaimk\pip.zip\pip\_vendor\appdirs.py",
line 243, in site_config_dir
  File
"C:\Users\xxx\AppData\Local\Temp\tmp7utwaimk\pip.zip\pip\_vendor\appdirs.py",
line 138, in site_data_dir
  File
"C:\Users\xxx\AppData\Local\Temp\tmp7utwaimk\pip.zip\pip\_vendor\appdirs.py",
line 486, in _get_win_folder_from_registry
FileNotFoundError: [WinError 2] The system cannot find the file specified

Expected Results:
PS C:\Program Files\LibreOffice\program> .\python  .\get-pip.py
Collecting pip
  Using cached pip-21.0.1-py3-none-any.whl (1.5 MB)
Collecting setuptools
  Downloading setuptools-53.0.0-py3-none-any.whl (784 kB)
     |████████████████████████████████| 784 kB 85 kB/s
Collecting wheel
  Using cached wheel-0.36.2-py2.py3-none-any.whl (35 kB)
Installing collected packages: wheel, setuptools, pip
  WARNING: The script wheel.exe is installed in 'C:\Program
Files\LibreOffice\program\python-core-3.8.4\Scripts' which is not on PATH.
  Consider adding this directory to PATH or, if you prefer to suppress this
warning, use --no-warn-script-location.
  WARNING: The scripts pip.exe, pip3.8.exe and pip3.exe are installed in
'C:\Program Files\LibreOffice\program\python-core-3.8.4\Scripts' which is not
on PATH.
  Consider adding this directory to PATH or, if you prefer to suppress this
warning, use --no-warn-script-location.
Successfully installed pip-21.0.1 setuptools-53.0.0 wheel-0.36.2
PS C:\Program Files\LibreOffice\program>

Reproducible: Always

User Profile Reset: No

OpenGL enabled: Yes

Additional Info:
Possible workaround:
I suspected that some Windows-specific files might be missing from the embedded
python distribution included with LO 7.1.0.3. Using source from
https://www.python.org/ftp/python/3.8.4, I first checked *.pyd files, but they
all seemed to be present (though I only spot-checked, did not exhaustively
compare).  Next I checked *.DLL files and found only 2 on the target PC, but 8
in the master ZIP file.  See list below:

 Status                 Name
 ------                 ----
 present                libcrypto-1_1.dll
 present                libssl-1_1.dll

 Missing                libffi-7.dll
 Missing                python3.dll
 Missing                python38.dll
 Missing                sqlite3.dll
 Missing                vcruntime140.dll
 Missing                vcruntime140_1.dll

After copying the 6 missing DLL files to: 
    C:\Program Files\LibreOffice\program\python-core-3.8.4\lib\
I re-ran step 2c above and succeeded in installing pip.  I was also able to
install other packages using pip.  I have not done any further testing, but it
seems this might be a workaround until the problem is resolved (though not
suitable for non-technical users).

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210208/c8739ac1/attachment-0001.htm>