Couldn't install packages for DMView

asked 2023-10-02 18:36:39 -0500

LSilv
11 ●6 ●7 ●8

I'm trying to use the DMView for the first time for an ERCOT project and I'm not able to install openpyxl. I get the following error messages when I try. I've experimented with using pip, pip3, and pip3.7. The issue is the same using pip as opposed to pip3. The last one is not recognized.

I set the python path in the 'run3x.bat' file explicitly. Does 'openpyxl-3.1.2-py2.py3-none-any.whl' have to be somewhere specific? After I downloaded it, I put a copy in my DMView folder and another copy in "C:\Python37\Lib\ensurepip_bundled" Does it need to be somewhere else?

Mon 10/02/2023 18:28:41.93 PATHs set: python 37

C:\Users...\DMView 3.0>pip3 install openpyxl Collecting openpyxl Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATEVERIFYFAILED] certificate verify failed: self signed certificate in certificate chain (ssl.c:1056)'))': /packages/6a/94/a59521de836ef0da54aaf50da6c4da8fb4072fb3053fa71f052fd9399e7a/openpyxl-3.1.2-py2.py3-none-any.whl ... Could not install packages due to an EnvironmentError: HTTPSConnectionPool(host='files.pythonhosted.org', port=443): Max retries exceeded with url: /packages/6a/94/a59521de836ef0da54aaf50da6c4da8fb4072fb3053fa71f052fd9399e7a/openpyxl-3.1.2-py2.py3-none-any.whl (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATEVERIFYFAILED] certificate verify failed: self signed certificate in certificate chain (ssl.c:1056)')))

edit retag flag offensive close merge delete

add a comment

3 answers

Sort by » oldest newest most voted

answered 2023-10-11 09:31:34 -0500

LSilv
11 ●6 ●7 ●8

After reaching out to ERCOT, I needed to install python 39 and used that instead of python 37. (No idea how PSS/e 35 could be installed on my machine without python 39.) Then there were several iterations of getting the necessary permissions from IT to run 'pip' and also had to add 'trusted host' to the command when downloading openpyxl and matplotlib. But finally, was able to run the program.

edit flag offensive delete link

add a comment

answered 2023-10-03 19:44:52 -0500

jconto
2701 ●10 ●30 ●41

Confim the following: could it be your pc requires Admin rights to install python modules? Has other python modules installed ok?

is the python37 installed at the c:\ root directory, a 32-bit version?

I did install openpyxl for python 39, 32-bit, with pip, using the following command in a DOS window (open at 'any' directory):

c:\..>pip install openpyxl

edit flag offensive delete link

Comments

I asked IT to give my full access for python 3.7 folders on my machine. The error is now slightly different. (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1091)')))

LSilv ( 2023-10-04 12:11:09 -0500 )edit

you can try this for your certificate issue $ pip install --trusted-host pypi.org --trusted-host pypi.python.org --trusted-host files.pythonhosted.org <package_name> see: https://stackoverflow.com/questions/25981703/pip-install-fails-with-connection-error-ssl-certificate-verify-failed-certi

Mohamed_M ( 2023-10-04 12:51:07 -0500 )edit

add a comment

answered 2023-10-03 21:37:53 -0500

Alex P
46 ●4

This is most reliable way that I've found to install python modules:

open a command prompt with admin privileges

change to the scripts folder (where pip.exe is) inside the main folder of the python version you want to install the module for, e.g.
C:\Python27\Scripts

install the module using pip:
pip install pandas

Done. In my experience this is best way to ensure that the module will be found when trying to import. It also avoids conflicts between 32 bit and 64 bit versions when they are installed in the user profile folder.

Your error is strange, but this might still be helpful.

edit flag offensive delete link

add a comment

Couldn't install packages for DMView

3 answers

Comments

Your Answer

Question Tools

Stats

Related questions