[CONPY-154] Plugin caching_sha2_password could not be loaded Created: 2021-05-26  Updated: 2021-06-08

Status: Open
Project: MariaDB Connector/Python
Component/s: Generic
Affects Version/s: 1.0.6
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: François Chareyron Assignee: Georg Richter
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Windows


 Description   

The following code yields an error: mariadb.OperationalError: Plugin caching_sha2_password could not be loaded: The specified module could not be found. Library path is 'c:/Program Files/MariaDB/MariaDB Connector C 64-bit/lib/plugin/caching_sha2_password.dll'

The issue seems to be that the MariaDB server installs itself in 'C:\Program Files\MariaDB 10.5' and the DLL seems to be located here instead: 'C:\Program Files\MariaDB 10.5\lib\plugin'

import mariadb
 
 
 
mydb = mariadb.connect(
 
        host="localhost",
 
        user="root",
 
        password="password",
 
        database="master"
 
    )



 Comments   
Comment by Georg Richter [ 2021-06-08 ]

As a workaround please either specify the environment variable MARIADB_PLUGIN_DIR (MARIADB_PLUGIN_DIR=C:\Program Files\MariaDB 10.5\lib\plugin) or put this directory in your PATH variadble.

Generated at Thu Feb 08 03:30:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.