sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:myslq

[rosti76]

The problem

I have fresh installed HAOS in vmWare ESX 7.0, installed from haos_ova-9.5.ova After addin official MariaDB addon, configuring it, Recorder fails to start with:

File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 343, in load raise exc.NoSuchModuleError( sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:myslq

Official phpMyAdmin can access MariaDB without anz issu

What version of Home Assistant Core has the issue?

haos_ova-9.5.ova - 2023.2.4

What was the last working version of Home Assistant Core?

haos_ova-9.4.ova - 2023.2.4

What type of installation are you running?

Home Assistant OS

Integration causing the issue

recorder

Link to integration documentation on our website

No response

Diagnostics information

No response

Example YAML snippet

recorder:
  db_url: !secret mariadb_url
  purge_keep_days: 90
  commit_interval: 20

mariadb_url: 'myslq://xxx:*****@localhost/homeassistant?charset=utf8mb4'

Anything in the logs that might be useful for us?

Logger: homeassistant.components.recorder.core
Source: components/recorder/core.py:1171
Integration: recorder (documentation, issues)
First occurred: 8:12:29 PM (10 occurrences)
Last logged: 8:12:56 PM

Error during connection setup: Can't load plugin: sqlalchemy.dialects:myslq (retrying in 3 seconds)
Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 704, in _setup_recorder
    self._setup_connection()
  File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 1171, in _setup_connection
    self.engine = create_engine(self.db_url, **kwargs, future=True)
  File "<string>", line 2, in create_engine
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/deprecations.py", line 309, in warned
    return fn(*args, **kwargs)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 522, in create_engine
    entrypoint = u._get_entrypoint()
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/url.py", line 662, in _get_entrypoint
    cls = registry.load(name)
  File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 343, in load
    raise exc.NoSuchModuleError(
sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:myslq

Additional information

No response

[issue-triage-workflows[bot]]

There hasn't been any activity on this issue recently. Due to the high number of incoming GitHub notifications, we have to clean some of the old issues, as many of them have already been resolved with the latest updates. Please make sure to update to the latest Home Assistant version and check if that solves the issue. Let us know if that works for you by adding a comment 👍 This issue has now been marked as stale and will be closed if no further activity occurs. Thank you for your contributions.

[bdraco]

You have misspelled mysql as myslq