I have this problem when using pyhive, I am using anaconda3. I have checked many posts but I can’t solve it.

At first I found out that sasl needs to use some dll files in the E:\YingYongRJ\Anaconda\Lib\site-packages\sasl\sasl2 directory.

Finally found that anaconda3 moved this folder sasl2 at the end of the address to E:\YingYongRJ\Anaconda\Library\bin, resulting in the program not reading the location.

Use the following code: administrator console paste code.

FOR /F "usebackq delims=" %A IN (`python -c "from importlib import util;import os;print(os.path.join(os.path.dirname(util.find_spec('sasl'). origin),'sasl2'))"`) DO (
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\Carnegie Mellon\Project Cyrus\SASL Library" /v SearchPath /t REG_SZ /d "%A"
)

The above code is creating a search path for lib in the registry. But it still doesn’t work, we need to change it a bit more.

win+R and type regedit

regedit and click on the path: HKEY_LOCAL_MACHINE\SOFTWARE\Carnegie Mellon\Project Cyrus\SASL Library

Change the value of SearchPath to E:\YingYongRJ\Anaconda\Library\bin\sasl2 on it (pay attention to change to the address of their anaconda)

Then it’s fine

Read More:

• [Solved] PyCharm Error: Cannot open Local Terminal Failed to start [powershell.exe] in C:\Users\…….
• Django CSV file Error: UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0xb5 in position 0: invalid start
• [Solved] weditor Plug-in Dump Hierarchy Error: Local server not started, start with $ python -m weditor
• [Solved] UnicodeDecodeError: ‘utf-8‘ codec can‘t decode byte 0xbf in position 7: invalid start byte
• [Solved] Jupyter Notebook Start Error: Fatal error in launcher: Unable to create process using
• [Solved] HTTPError: 404 Client Error: Not Found for url: https://huggingface.co/saved_model
• Chromdriver Install error: File “C:\python37\lib\site-packages\selenium\webdriver\common\service.py”, line 76, in start stdin=PIPE) File…
• [Solved] AttributeError: module ‘thread‘ has no attribute ‘start_new_thread‘
• [Solved] unknown error: Chrome failed to start: exited abnormally (Driver info: chromedriver=2.36.540471
• [Solved] RuntimeError An attempt has been made to start a new process
• [Solved] Spyder Start Error: “An error occurred while starting the kernel“
• [Solved] IDA Start Error: Unexcepted fatal error while intitailizing Python runtime…
• [Solved] mindinsight modelart Error: RuntimeError: An attempt has been made to start a new process before…
• [Solved] ssl_client_socket_impl.cc handshake failed (Same Codes in Different Environments)
• [Solved] Python Error: An attempt has been made to start a new process before the current process has finished …
• python minio client Error: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certific
• Vscode Tensorboard Error: We failed to start a TensorBoard session due to the following error: Command fa
• [Solved] PyCharm Failed to Start Error: failed to create jvm.jvm path…
• “EncoderDecoder: ‘mit_b1 is not in the backbone registry‘“ [How to Solve]
• [Solved] Nebula executes Algorithm Error: Error scanvertexresultiterator: get storage client error