[Bug]: cannot use a mySQL database source, error message ''Error: Driver not loaded Driver not loaded" #2946
Description
JASP Version
0.19.0
Commit ID
No response
JASP Module
Unrelated
What analysis are you seeing the problem on?
none
What OS are you seeing the problem on?
Flatpak
Bug Description
Similar to the PostgreSQL issues listed in bugs #2199 and #2209, I cannot connect to a mySQL database.
I was testing, having never used database connections to jasp, so set up access on my local server, with a dedicated username and password, granting access only from my desktop's IP address. When clicking on the "Connect to database" button, the error reported in the other two reports is returned.
(Note that the hostname was correct when tested ("192.168.2.42").
I can connect to mySQL using the CLI interface using these credentials on the specified desktop.
Expected Behaviour
Database connection should be attempted.
Steps to Reproduce
- Setup mySQL with database table with user having access permissions for the desired schema.
- Enter details in database connection window
- Click on "Connect to database" button.
Log (if any)
No mySQL log entries generated.
More Debug Information
No response
Final Checklist
- I have included a screenshot showcasing the issue, if possible.
- I have included a JASP file (zipped) or data file that causes the crash/bug, if applicable.
- I have accurately described the bug, and steps to reproduce it.