Python Trouble - Your Freelancer Wants to Use a Module Without Telling You 😊

Suddenly, sqlalchemy holds your script hostage.

    from sqlalchemy import false

ModuleNotFoundError: No module named 'sqlalchemy'

Try:

pip3 install sqlalchemy

  WARNING: Retrying (Retry(total=0, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate is not yet valid (_ssl.c:997)'))': /packages/cc/c2/d3ee8842450ad01a8128e8fcb66947ab39b02a31e6d75205374c2439a606/SQLAlchemy-2.0.18-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl

ERROR: Could not install packages due to an OSError: HTTPSConnectionPool(host='files.pythonhosted.org', port=443): Max retries exceeded with url: /packages/cc/c2/d3ee8842450ad01a8128e8fcb66947ab39b02a31e6d75205374c2439a606/SQLAlchemy-2.0.18-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate is not yet valid (_ssl.c:997)')))

Does sudo help? No.

Who cracked it? Not chatGPT surely! 

Yes chatGPT!

If you encounter an error message stating that the certificate is not yet valid while trying to install a package using pip3, it typically indicates an issue with the system clock on your computer. The error message indicates that the SSL certificate used to verify the authenticity of the package repository has an expiration date in the future, which conflicts with your system's current date.

Linux: The process varies depending on the Linux distribution you're using. Generally, you can use the ntpdate command to synchronize the system clock with an NTP (Network Time Protocol) server. For example: sudo ntpdate pool.ntp.org

Worked, but needed a sudo apt-get update, upgrade and then sudo apt install ntpdate

And then the pip3 install sqlalchemy worked.