Errors during run .exe file generated with Pyinstaller

[BushyAxis793]

Hello,

I'm just starting my adventure with Python, so please bear with me.

I wrote a script that deletes a database.

I wanted the script to be run using batch. That's why I decided to generate an .exe file using Pyinstaller.

Unfortunately, when I try to run the .exe I get errors.

My code below:

delete_orpheus_db.py

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

import mysql.connector from mysql.connector import Error from config import get_config   def delete_orpheus_database():     try:         connection = mysql.connector.connect(             host= get_config()['host'],             user= get_config()['user'],             password= get_config()['password']         )           if connection.is_connected():             cursor = connection.cursor()             cursor.execute("DROP DATABASE orpheus")             print("Database 'orpheus' successfully deleted.")       except Error as e:         print(f"Test connection failed. Error: {e}")               finally:         if connection.is_connected():             cursor.close()             connection.close()             print("Database connection closed.")

config.py

1 2 3 4 5 6 7

import json   def get_config():     with open('C:/Repositories/ORPHEUS/DB/CONFIG/config.json',"r") as config_file:         config  = json.load(config_file)       return config

config.json

1 2 3 4 5 6

{     "host":"localhost",     "user":"root",     "password":"11111111",     "database": "orpheus" }

I call this line in CMD in folder with my delete_orpheus_db.py

1	pyinstaller --onefile delete_orpheus_db.py

And here is error which I got after run .exe file

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

C:\Users\mnawr>delete_orpheus_db.bat Traceback (most recent call last):   File "delete_orpheus_db.py", line 9, in delete_orpheus_database   File "mysql\connector\pooling.py", line 322, in connect   File "mysql\connector\connection_cext.py", line 153, in __init__   File "mysql\connector\abstracts.py", line 1529, in connect   File "mysql\connector\connection_cext.py", line 365, in _open_connection RuntimeError: Failed raising error.   During handling of the above exception, another exception occurred:   Traceback (most recent call last):   File "delete_orpheus_db.py", line 29, in <module>   File "delete_orpheus_db.py", line 24, in delete_orpheus_database UnboundLocalError: cannot access local variable 'connection' where it is not associated with a value [PYI-27856:ERROR] Failed to execute script 'delete_orpheus_db' due to unhandled exception!

I think that I forgot about something but I have no idea what it is.
Thanks a lot for any help!
Have a good day

[snippsat]

Initialize connection outside the try block.
In the finally block, check if connection is not None before attempting to access its methods.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

import mysql.connector from mysql.connector import Error from config import get_config   def delete_orpheus_database():     connection = None  # Initialize connection     try:         connection = mysql.connector.connect(             host=get_config()['host'],             user=get_config()['user'],             password=get_config()['password']         )           if connection.is_connected():             cursor = connection.cursor()             cursor.execute("DROP DATABASE orpheus")             print("Database 'orpheus' successfully deleted.")     except Error as e:         print(f"Test connection failed. Error: {e}")     finally:         if connection is not None and connection.is_connected():             cursor.close()             connection.close()             print("Database connection closed.")   if __name__ == "__main__":     delete_orpheus_database()

You most bundled config.json with the executable.

1	pyinstaller --onefile --add-data "C:/Repositories/ORPHEUS/DB/CONFIG/config.json;." delete_orpheus_db.py

[BushyAxis793]

Initialize connection outside the try block.
In the finally block, check if connection is not None before attempting to access its methods.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

import mysql.connector from mysql.connector import Error from config import get_config   def delete_orpheus_database():     connection = None  # Initialize connection     try:         connection = mysql.connector.connect(             host=get_config()['host'],             user=get_config()['user'],             password=get_config()['password']         )           if connection.is_connected():             cursor = connection.cursor()             cursor.execute("DROP DATABASE orpheus")             print("Database 'orpheus' successfully deleted.")     except Error as e:         print(f"Test connection failed. Error: {e}")     finally:         if connection is not None and connection.is_connected():             cursor.close()             connection.close()             print("Database connection closed.")   if __name__ == "__main__":     delete_orpheus_database()

You most bundled config.json with the executable.

1	pyinstaller --onefile --add-data "C:/Repositories/ORPHEUS/DB/CONFIG/config.json;." delete_orpheus_db.py

Thank you very much for reply! I added validation to my code and now my code is:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

import mysql.connector from mysql.connector import Error from config import get_config   def delete_orpheus_database():     connection = None     try:         connection = mysql.connector.connect(             host= get_config()['host'],             user= get_config()['user'],             password= get_config()['password']         )           if connection.is_connected():             cursor = connection.cursor()             cursor.execute("DROP DATABASE orpheus")             print("Database 'orpheus' successfully deleted.")       except Error as e:         print(f"Test connection failed. Error: {e}")               finally:         if connection is not None and connection.is_connected():             cursor.close()             connection.close()             print("Database connection closed.")

But I still get the error

1 2 3 4 5 6 7 8 9

Traceback (most recent call last):   File "delete_orpheus_db.py", line 28, in <module>   File "delete_orpheus_db.py", line 8, in delete_orpheus_database   File "mysql\connector\pooling.py", line 322, in connect   File "mysql\connector\connection_cext.py", line 153, in __init__   File "mysql\connector\abstracts.py", line 1529, in connect   File "mysql\connector\connection_cext.py", line 365, in _open_connection RuntimeError: Failed raising error. [PYI-5084:ERROR] Failed to execute script 'delete_orpheus_db' due to unhandled exception!

[snippsat]

The error can comes from MySQL Connector’s C extension,C extension often isn’t bundled correctly leading to the “Failed raising error”.
One workaround is to force MySQL Connector to use its pure-Python implementation rather than the C extension.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

import mysql.connector from mysql.connector import Error from config import get_config   def delete_orpheus_database():     connection = None     try:         config = get_config()         connection = mysql.connector.connect(             host=config['host'],             user=config['user'],             password=config['password'],             use_pure=True   # Force pure Python implementation         )           if connection.is_connected():             cursor = connection.cursor()             cursor.execute("DROP DATABASE orpheus")             print("Database 'orpheus' successfully deleted.")     except Error as e:         print(f"Test connection failed. Error: {e}")     finally:         if connection is not None and connection.is_connected():             cursor.close()             connection.close()             print("Database connection closed.")   if __name__ == "__main__":     delete_orpheus_database()

[BushyAxis793]

The error can comes from MySQL Connector’s C extension,C extension often isn’t bundled correctly leading to the “Failed raising error”.
One workaround is to force MySQL Connector to use its pure-Python implementation rather than the C extension.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

import mysql.connector from mysql.connector import Error from config import get_config   def delete_orpheus_database():     connection = None     try:         config = get_config()         connection = mysql.connector.connect(             host=config['host'],             user=config['user'],             password=config['password'],             use_pure=True   # Force pure Python implementation         )           if connection.is_connected():             cursor = connection.cursor()             cursor.execute("DROP DATABASE orpheus")             print("Database 'orpheus' successfully deleted.")     except Error as e:         print(f"Test connection failed. Error: {e}")     finally:         if connection is not None and connection.is_connected():             cursor.close()             connection.close()             print("Database connection closed.")   if __name__ == "__main__":     delete_orpheus_database()

Thanks for reply! I found one more error:

1 2 3 4 5 6 7 8 9 10 11 12

C:\Users\mnawr>delete_orpheus_db.bat Requested Module was not found: No module named 'mysql.connector.plugins.mysql_native_password' Traceback (most recent call last): File "delete_orpheus_db.py", line 29, in <module> File "delete_orpheus_db.py", line 8, in delete_orpheus_database File "mysql\connector\pooling.py", line 323, in connect File "mysql\connector\connection.py", line 187, in init File "mysql\connector\connection.py", line 459, in close File "mysql\connector\connection.py", line 1060, in cmd_quit File "mysql\connector\network.py", line 651, in send File "mysql\connector\network.py", line 224, in send File "mysql\connector\network.py", line 170, in send_pkt File "mysql\connector\errors.py", line 60, in init File "mysql\connector\locales_init.py", line 62, in get_client_error ImportError: No localization support for language 'eng' [PYI-17668:ERROR] Failed to execute script 'delete_orpheus_db' due to unhandled exception!

And I found a solution:

1	pyinstaller --onefile --hidden-import=mysql.connector.plugins.mysql_native_password delete_orpheus_db.py

It seems to be working fine! Thank you very much for your help!