Python: No module named 'secrets' - oracledb module

Question

I get the following error when running an executable created with PyInstaller. It relates to the module oracledb.

Traceback (most recent call last): File "my_script.py", line 1, in
File "PyInstaller/loader/pyimod03_importers.py", line 495, in exec_module File "oracledb/init.py", line 38, in
File "PyInstaller/loader/pyimod03_importers.py", line 495, in exec_module File "oracledb/connection.py", line 45, in
File "src/oracledb/base_impl.pyx", line 47, in init oracledb.base_impl ModuleNotFoundError: No module named 'secrets' [23464] Failed to execute script 'my_script' due to unhandled exception!

Python 3.6

From this post I understand that Python 3.6 is a dependency.

In our environment we have both Python 3.6.8 and Python 2.7

Build with Python3

Based on comments from this post, I then tried the following command to build my executable:

python3 -m PyInstaller -F my_script.py

I still get the same error.

I suspect it has something to do with the 2 versions of Python, but I do not know how to get around it. Does anyone have some advise for me please?

Anthony Tuininga · Accepted Answer · 2023-03-01 04:58:28Z

2

The oracledb module uses Cython for its base layer, which means that the modules it imports are not going to be known to PyInstaller. These modules can be found in src/oracledb/*.pyx. You can tell PyInstaller about them, or you can also just copy/paste the imports into a Python module that you include in my_script.py. I don't know PyInstaller well enough to be able to tell you how to do the first option, but I'm sure its documentation will get you going!

answered Mar 1, 2023 at 4:58

Anthony Tuininga

7,2162 gold badges17 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Christopher Jones Over a year ago

Also checkout github.com/oracle/python-oracledb/…

knittl · Accepted Answer · 2024-01-03 12:19:49Z

2

I had the same problem and found this helped a lot:

Execute pyinstaller so you have a .spec file. Then edit the spec file with hidden_imports:

hiddenimports=['secrets','getpass','ssl','cryptography.hazmat.primitives.kdf.pbkdf2'],

Then execute as follows:

PyInstaller my_script.spec

This gave me an .exe file that works

edited Jan 3, 2024 at 12:19

knittl

269k59 gold badges339 silver badges405 bronze badges

answered Jan 3, 2024 at 9:48

nightfox79

2,1393 gold badges30 silver badges46 bronze badges

1 Comment

Christopher Jones Over a year ago

With Cryptography 43, 'cryptography.x509 ' was also found to be needed. See github.com/oracle/python-oracledb/issues/401

Collectives™ on Stack Overflow

Python: No module named 'secrets' - oracledb module

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related